TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Prasad Bhagat
NA
516
226.2k
what is the return type for this method ?
Sep 16 2015 2:33 AM
Dear all ,
i have a two web methods and one is getting list of values and other one is deleting a record and fetching list of data from first method so please suggest me what is the return type here please ..
in my proc...
CREATE PROCEDURE [dbo].[DeleteFriend]
@FriendNumber VARCHAR(Max),
@DeviceId VARCHAR(Max)
AS
BEGIN
BEGIN TRY
DELETE FROM Friends
WHERE DeviceId = @DeviceId AND FriendNumber = @FriendNumber
DECLARE @Number VARCHAR(Max)
DECLARE @FriendDeviceId VARCHAR(Max)
SELECT @FriendDeviceId = DeviceId
FROM dbo.DeviceMaster
WHERE Number = @FriendNumber
SELECT @Number = Number FROM dbo.DeviceMaster WHERE DeviceId = @DeviceId
DELETE FROM Friends
WHERE DeviceId = @FriendDeviceId AND FriendNumber = @Number
EXEC GetFriendsList @DeviceId
END TRY
BEGIN CATCH
SELECT ERROR_MESSAGE() AS STATUSMSG, -1 AS STATUSIND
END CATCH
END
COMING TO MYSERVICE METHODS...
public List<Friends> GetFriendsList(string DeviceId)
{
List<Friends> listFriend = new List<Friends>();
SqlCommand cmd = null;
SqlDataReader reader = null;
Friends friend = new Friends();
try
{
cmd = new SqlCommand("GetFriendsList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DeviceId", DeviceId);
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
friend = new Friends();
friend.friendNumber = reader["FriendNumber"].ToString();
friend.name = reader["Name"].ToString();
friend.deviceId = reader["DeviceId"].ToString();
friend.isCheckedIn = reader["IsCheckedIn"].ToString();
friend.status = reader["STATUSMSG"].ToString();
friend.statuind = Convert.ToInt32(reader["STATUSIND"].ToString());
listFriend.Add(friend);
}
if (listFriend.Count == 0)
{
friend.status = "Record Not Found";
friend.statuind = -1;
listFriend.Add(friend);
}
conn.Close();
}
catch (Exception ex)
{
friend.status = ex.Message.ToString();
friend.statuind = -1;
}
return listFriend.ToList();
}
AND SECOND METHOD IS...
public void DeleteFriend(string DeviceId, string FriendNumber)
{
ResultSet resultSet = new ResultSet();
SqlCommand cmd = null;
SqlDataAdapter da = null;
DataSet ds = new DataSet();
try
{
cmd = new SqlCommand("DeleteFriend", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DeviceId", DeviceId);
cmd.Parameters.AddWithValue("@FriendNumber", FriendNumber);
conn.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
cmd.ExecuteNonQuery();
conn.Close();
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
resultSet.STATUSMSG = ds.Tables[0].Rows[0]["STATUSMSG"].ToString();
resultSet.STATUSIND = Convert.ToInt32(ds.Tables[0].Rows[0]["STATUSIND"].ToString());
}
else
{
GetFriendsList(DeviceId);
}
}
else
{
resultSet.STATUSMSG = "Error";
resultSet.STATUSIND = -1;
}
}
catch (Exception ex)
{
resultSet.STATUSMSG = ex.Message.ToString();
resultSet.STATUSIND = -1;
}
finally
{
ds = null;
da = null;
cmd = null;
}
}
PLEASE HELP AM TOTALLY CONFUSED HOW CAN I RETURN IF DELETED I NEED TO DISPLY LIST IF NOT DELETED NEED TO DISPLY ERROR MESSAGE PLEASE HELP ME...
Reply
Answers (
3
)
How to add image content in gridview
Error while getting Mails from indox using exchange dll