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));
}
