public ActionResult SaveChosenColumns(ChooseColumns value) { //var res1 = API_ChooseColumns.SaveChoosedColumns(value); //res.SystemMessages = res1.SystemMessages; //res.Message = res1.Message; res1 = API_ChooseColumns.SaveChoosedColumns(value); return(Json(res1)); //return PartialView("_Messages", res1); }
public Response <ChooseColumns> Post(ChooseColumns value) { try { value.ColUserId = (HttpContext.Current.Session[SessionNames.UserID] != null && Convert.ToInt32(HttpContext.Current.Session[SessionNames.UserID]) > 0) ? Convert.ToInt32(HttpContext.Current.Session[SessionNames.UserID]) : 0; var res = BAL_ChooseColumns.SaveChoosedColumns(value); List <disMessages> objmsg = BAL_SysMessages.GetSysMessagesTemplates(value.ColPageName); if (res > 0) { return new Response <ChooseColumns> { Status = true, MessageType = MessageTypes.Success, Message = DisplayMessages.SaveChooseColumns_Success, SystemMessages = objmsg[1] } } ; else { return new Response <ChooseColumns> { Status = false, MessageType = MessageTypes.Failure, Message = DisplayMessages.SaveChooseColumns_Failure, SystemMessages = objmsg[0] } }; } catch (SqlException ex) { if (ex.Errors.Count > 0) { switch (ex.Errors[0].Number) { case 2601: // Primary key violation return(new Response <ChooseColumns> { Status = false, MessageType = MessageTypes.Duplicate, Message = DisplayMessages.SaveChooseColumns_Duplicate }); default: return(new Response <ChooseColumns> { Status = false, MessageType = MessageTypes.Exception, Message = ex.Message }); } } else { return new Response <ChooseColumns> { Status = false, MessageType = MessageTypes.Exception, Message = ex.Message } }; } catch (Exception ex) { return(new Response <ChooseColumns> { Status = false, MessageType = MessageTypes.Exception, Message = ex.Message }); } }
/// <summary> /// Function to save all selected columns to display to grid. /// </summary> /// <param name="value"></param> /// <returns></returns> public static int SaveChoosedColumns(ChooseColumns obj) { DataTable dtColumnsList = SqlSerializer.Default.DeserializeDataTable <Columns>(obj.LstDisplayColumnName); dtColumnsList = dtColumnsList.DefaultView.ToTable("udtColumnOrdering", true, "ColColumnName", "ColSortOrder"); var parameters = new Parameter[] { new Parameter("@ColumnsList", dtColumnsList, "dbo.udtColumnOrdering"), new Parameter("@ColPageName", obj.ColPageName), new Parameter("@ColUserId", obj.ColUserId), new Parameter("@ColEnteredBy", ""), new Parameter("@ColDateChangedBy", "") }; return(SqlSerializer.Default.ExecuteRowCount(StoredProcedureNames.SaveChoosedColumns, parameters, true)); }
/// <summary> /// Function to save all selected columns to display to grid. /// </summary> /// <param name="obj"></param> /// <returns></returns> public static Response <ChooseColumns> SaveChoosedColumns(ChooseColumns obj) { RestClient _client = new RestClient { BaseUrl = new Uri(M4PL_Constants.M4PL_API) }; var request = new RestRequest("ChooseColumns", Method.POST) { RequestFormat = DataFormat.Json }; request.AddHeader("Content-Type", "application/json; charset=utf-8"); request.AddJsonBody(obj); var response = _client.Execute <Response <ChooseColumns> >(request); if (response.Data == null) { return new Response <ChooseColumns> { Status = false, MessageType = MessageTypes.Exception, Message = response.ErrorMessage } } ; return(response.Data); } }
/// <summary> /// Function to save all selected columns to display to grid. /// </summary> /// <param name="value"></param> /// <returns></returns> public static int SaveChoosedColumns(ChooseColumns value) { return(DAL_ChooseColumns.SaveChoosedColumns(value)); }