public static int SaveAliasColumn(SaveColumnsAlias obj)
{
DataTable dtColumnsList = SqlSerializer.Default.DeserializeDataTable <ColumnsAlias>(obj.LstColumnsAlias);
dtColumnsList = dtColumnsList.DefaultView.ToTable("udtColumnAliases", true, "ColColumnName", "ColAliasName", "ColCaption", "ColDescription", "ColIsVisible", "ColIsDefault");
var parameters = new Parameter[]
{
new Parameter("@ColumnsList", dtColumnsList, "dbo.udtColumnAliases"),
new Parameter("@PageName", obj.ColPageName)
};
return(SqlSerializer.Default.ExecuteRowCount(StoredProcedureNames.SaveColumnsAlias, parameters, true));
}
public Response <SaveColumnsAlias> SaveAliasColumn(SaveColumnsAlias obj)
{
try
{
var res = BAL_RefOptions.SaveAliasColumn(obj);
if (res > 0)
{
return new Response <SaveColumnsAlias> {
Status = true, MessageType = MessageTypes.Success, Message = DisplayMessages.SaveColumnsAlias_Success
}
}
;
else
{
return new Response <SaveColumnsAlias> {
Status = false, MessageType = MessageTypes.Failure, Message = DisplayMessages.SaveColumnsAlias_Failure
}
};
}
catch (SqlException ex)
{
if (ex.Errors.Count > 0)
{
switch (ex.Errors[0].Number)
{
case 2601: // Primary key violation
return(new Response <SaveColumnsAlias> {
Status = false, MessageType = MessageTypes.Duplicate, Message = DisplayMessages.SaveColumnsAlias_Duplicate
});
default:
return(new Response <SaveColumnsAlias> {
Status = false, MessageType = MessageTypes.Exception, Message = ex.Message
});
}
}
else
{
return new Response <SaveColumnsAlias> {
Status = false, MessageType = MessageTypes.Exception, Message = ex.Message
}
};
}
catch (Exception ex)
{
return(new Response <SaveColumnsAlias> {
Status = false, MessageType = MessageTypes.Exception, Message = ex.Message
});
}
}
public static Response <SaveColumnsAlias> SaveAliasColumn(SaveColumnsAlias obj)
{
RestClient _client = new RestClient {
BaseUrl = new Uri(M4PL_Constants.M4PL_API)
};
var request = new RestRequest("RefOptions/SaveAliasColumn", Method.POST)
{
RequestFormat = DataFormat.Json
};
request.AddHeader("Content-Type", "application/json; charset=utf-8");
request.AddJsonBody(obj);
var response = _client.Execute <Response <SaveColumnsAlias> >(request);
if (response.Data == null)
{
throw new Exception(response.ErrorMessage);
}
return(response.Data);
}
public static int SaveAliasColumn(SaveColumnsAlias obj)
{
return(DAL_RefOptions.SaveAliasColumn(obj));
}
