public ColumnConfigDTO GetData(string tbc_code)
{
log.MethodStart();
ColumnConfigDTO objModel = new ColumnConfigDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TBConfigs.FirstOrDefault(x => x.tbc_mnu_code == tbc_code);
if (objReturn1 != null)
{
objModel = _mapper.Map <ColumnConfigDTO>(objReturn1);
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public async Task <ColumnConfigDTO> GetDataAsync(string mnu_Id)
{
ColumnConfigDTO objModel = new ColumnConfigDTO();
objModel = await _apiHelper.GetDataByIdAsync <ColumnConfigDTO>("columnconfig_api/Get_Data", mnu_Id);
return(objModel);
}
public async Task <ColumnConfigDTO> SaveDataAsync(ColumnConfigDTO model)
{
ColumnConfigDTO objModel = new ColumnConfigDTO();
objModel = await _apiHelper.PostDataAsync <ColumnConfigDTO>("columnconfig_api/Post_SaveData", model);
return(objModel);
}
public ColumnConfigDTO SaveData(ColumnConfigDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
ColumnConfigDTO objReturn = new ColumnConfigDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TBConfig();
if (model.tbc_status == "E")
{
objModel = _db.TBConfigs.FirstOrDefault(x => x.tbc_id == model.tbc_id);
}
if (model.tbc_status == "N")
{
objModel = _mapper.Map <TBConfig>(model);
objModel.tbc_status = objModel.tbc_active == true ? "A" : "I";
objModel.tbc_createdate = currentDateTime;
currentUser = objModel.tbc_createuser;
_db.TBConfigs.Add(objModel);
}
else if (model.tbc_status == "E")
{
objModel.tbc_column_name = model.tbc_column_name;
objModel.tbc_column_label = model.tbc_column_label;
objModel.tbc_column_placeholder = model.tbc_column_placeholder;
objModel.tbc_required_field = model.tbc_required_field;
objModel.tbc_edit = model.tbc_edit;
objModel.tbc_active = model.tbc_active;
objModel.tbc_status = objModel.tbc_active == true ? "A" : "I";
objModel.tbc_updateuser = model.tbc_updateuser;
objModel.tbc_updatedate = currentDateTime;
currentUser = objModel.tbc_updateuser;
//_db.TCMenus.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "ColumnConfig",
log_tran_id = objModel.tbc_mnu_code,
log_action = (model.tbc_status == "N" ? "New" : "Update"),
log_desc = (model.tbc_status == "N" ? "New" : "Update") + " ColumnConfig " + objModel.tbc_mnu_code + ":" + objModel.tbc_column_name,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
log.Error(ex);
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public ColumnConfigDTO Post_SaveData([FromBody] ColumnConfigDTO model)
{
var objReturn = _service.SaveData(model);
return(objReturn);
}
