public static List<Dictionary<string, object>> Fetch_Details(string imode, int NotificationID) { DataSet ds = new DataSet(); List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); Dictionary<string, object> row = new Dictionary<string, object>(); try { bel_Notification obj_bel_Notification = new bel_Notification(); dal_Notification obj_dal_Notificaion = new dal_Notification(); obj_bel_Notification._iMode = imode; obj_bel_Notification._NotificationID = NotificationID; obj_bel_Notification._BranchID = 1; using (ds = obj_dal_Notificaion.dal_NotificationHeader(obj_bel_Notification)) { if (ds.Tables.Count > 0) { return Json.getjson_(ds.Tables[0]); } else { row.Add("res", "No Data"); rows.Add(row); return rows; } } } catch (Exception ex) { row.Add("res", "exception"); rows.Add(row); return rows; } }
public DataSet dal_NotificationHeader(bel_Notification obj_bel_Notification) { DataSet ds = new DataSet(); try { SqlCommand sqlcmd = new SqlCommand("spu_NotificationHeader"); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); sqlcmd.Parameters.AddWithValue("@Notrification_ID", obj_bel_Notification._NotificationID); sqlcmd.Parameters.AddWithValue("@Type", obj_bel_Notification._Type); sqlcmd.Parameters.AddWithValue("@Date", obj_bel_Notification._NotificationDate); sqlcmd.Parameters.AddWithValue("@ShortDescription", obj_bel_Notification._shrtdescription); sqlcmd.Parameters.AddWithValue("@Description", obj_bel_Notification._description); sqlcmd.Parameters.AddWithValue("@UserGroupID", obj_bel_Notification._UsergroupID); sqlcmd.Parameters.AddWithValue("@UserID", obj_bel_Notification._UserID); sqlcmd.Parameters.AddWithValue("@Status", obj_bel_Notification._Status); sqlcmd.Parameters.AddWithValue("@BranchID", obj_bel_Notification._BranchID); sqlcmd.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"])); sqlcmd.Parameters.AddWithValue("@CreatedOn", obj_bel_Notification._CreatedOn); sqlcmd.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"])); sqlcmd.Parameters.AddWithValue("@ModifiedOn", obj_bel_Notification._ModifiedOn); sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_Notification._iMode); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }
public static List<Dictionary<string, object>> Save_Notifcaion(string imode, string userid, string type, DateTime date, string shrtdesc, string desc, int noticationid, string usergrpid) { DataSet ds = new DataSet(); List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); Dictionary<string, object> row = new Dictionary<string, object>(); try { bel_Notification obj_bel_Notification = new bel_Notification(); dal_Notification obj_dal_Notificaion = new dal_Notification(); obj_bel_Notification._iMode = imode; obj_bel_Notification._UserID = userid; obj_bel_Notification._Type = type; obj_bel_Notification._NotificationDate = date; obj_bel_Notification._shrtdescription = shrtdesc; obj_bel_Notification._description = desc; obj_bel_Notification._BranchID = 1; obj_bel_Notification._NotificationID = noticationid; obj_bel_Notification._UsergroupID = usergrpid; using (ds = obj_dal_Notificaion.dal_NotificationHeader(obj_bel_Notification)) { if (ds.Tables.Count > 0) { return Json.getjson_(ds.Tables[0]); } else { row.Add("res", "No Data"); rows.Add(row); return rows; } } } catch (Exception ex) { row.Add("res", "exception"); rows.Add(row); return rows; } }