public UserInboxBEL DeleteUserNotification(string User_id, string notification_id) { UserInboxBEL UserInbox = new UserInboxBEL(); try { DataSet ds = null; SqlParameter[] SqlParms = new SqlParameter[3]; SqlParms[0] = new SqlParameter("@User_id", SqlDbType.NVarChar); SqlParms[0].Direction = ParameterDirection.Input; SqlParms[0].Value = User_id; SqlParms[1] = new SqlParameter("@Notification_id", SqlDbType.NVarChar); SqlParms[1].Direction = ParameterDirection.Input; SqlParms[1].Value = notification_id; SqlParms[2] = new SqlParameter("@Error", SqlDbType.NVarChar, 150); SqlParms[2].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "Delete_Notification", SqlParms); if (Convert.ToString(SqlParms[2].Value) == string.Empty) { UserInbox.Success = true; } else { UserInbox.Success = false; } return(UserInbox); } catch (Exception ex) { UserInbox.Success = false; UserInbox.ErrorMessage = Convert.ToString(ex.Message.ToString()); return(UserInbox); } }
public List <UserInboxBEL> GetUserInbox(string User_id) { List <UserInboxBEL> UserInboxList = new List <UserInboxBEL>(); try { DataSet ds = null; SqlParameter[] SqlParms = new SqlParameter[2]; SqlParms[0] = new SqlParameter("@User_id", SqlDbType.NVarChar); SqlParms[0].Direction = ParameterDirection.Input; SqlParms[0].Value = User_id; SqlParms[1] = new SqlParameter("@Error", SqlDbType.NVarChar, 150); SqlParms[1].Direction = ParameterDirection.Output; //SqlParms[7] = new SqlParameter("@UserId", SqlDbType.NVarChar, 20); //SqlParms[7].Direction = ParameterDirection.Output; //jfhjff ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "Get_Notifications", SqlParms); if (ds != null && ds.Tables[0].Rows.Count > 0 && Convert.ToString(SqlParms[1].Value) != "0") { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { UserInboxBEL UserInbox = new UserInboxBEL(); UserInbox.User_Id = Convert.ToInt32(ds.Tables[0].Rows[i]["User_id"]); UserInbox.Notification_ID = Convert.ToInt32(ds.Tables[0].Rows[i]["Notification_ID"]); UserInbox.Subject = ds.Tables[0].Rows[i]["Subject"].ToString(); UserInbox.Message = ds.Tables[0].Rows[i]["Message"].ToString(); if (ds.Tables[0].Rows[i]["Dt_Created"] != DBNull.Value) { UserInbox.Dt_Created = Convert.ToDateTime(ds.Tables[0].Rows[i]["Dt_Created"]); } UserInbox.READYN = Convert.ToChar(ds.Tables[0].Rows[i]["READYN"]); UserInbox.UserSpecific = Convert.ToChar(ds.Tables[0].Rows[i]["UserSpecific"]); UserInboxList.Add(UserInbox); } return(UserInboxList); } else { UserInboxBEL UserInbox = new UserInboxBEL(); UserInbox.Success = false; UserInbox.ErrorMessage = Convert.ToString(SqlParms[1].Value); UserInboxList.Add(UserInbox); return(UserInboxList); } } catch (Exception ex) { UserInboxBEL UserInbox = new UserInboxBEL(); UserInbox.Success = false; UserInbox.ErrorMessage = Convert.ToString(ex.Message.ToString()); UserInboxList.Add(UserInbox); return(UserInboxList); } // return AvailableParkings; }