public List <MasterTemplateDTO> GetListWithModel(MasterTemplateSearchDTO searchModel)
{
log.MethodStart();
List <MasterTemplateDTO> objList = new List <MasterTemplateDTO>();
//var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.TCMasterTemplates.FromSqlRaw <TCMasterTemplate>("sp_GET_TCMasterTemplate {0}, {1}, {2}, {3}", searchModel.mst_code, searchModel.mst_version, searchModel.mst_date_from, searchModel.mst_date_to).ToList();
objList = _mapper.Map <List <MasterTemplateDTO> >(objDataList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public async Task <MasterTemplateDTO> GetListByModelActiveAsync(MasterTemplateSearchDTO searchData)
{
MasterTemplateDTO objList = new MasterTemplateDTO();
objList = await _apiHelper.GetDataByModelAsync <MasterTemplateDTO, MasterTemplateSearchDTO>("mastertemplate_api/Get_List_Active_ByModel", searchData);
return(objList);
}
public async Task <List <MasterTemplateDTO> > GetListByModelAsync(MasterTemplateSearchDTO searchData)
{
List <MasterTemplateDTO> objList = new List <MasterTemplateDTO>();
objList = await _apiHelper.GetDataListByModelAsync <MasterTemplateDTO, MasterTemplateSearchDTO>("mastertemplate_api/Get_ListByModel", searchData);
return(objList);
}
public async Task <List <MasterTemplateDTO> > GetListByParamAsync(MasterTemplateSearchDTO searchData)
{
List <MasterTemplateDTO> objList = new List <MasterTemplateDTO>();
var searchJson = JsonSerializer.Serialize(searchData);
objList = await _apiHelper.GetDataListByParamsAsync <MasterTemplateDTO>("mastertemplate_api/Get_List", searchJson);
return(objList);
}
public MasterTemplateDTO GetList_Active_WithModel(MasterTemplateSearchDTO searchModel)
{
log.MethodStart();
MasterTemplateDTO objReturn = new MasterTemplateDTO();
//var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.TCMasterTemplates.FromSqlRaw <TCMasterTemplate>("sp_GET_TCMasterTemplate_Active {0}, {1}, {2}", searchModel.mst_code, searchModel.mst_date_from, searchModel.mst_date_to).ToList();
var objListMapping = _mapper.Map <List <MasterTemplateDTO> >(objDataList);
if (objListMapping.Count > 0)
{
objReturn = objListMapping.FirstOrDefault();
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public MasterTemplateDTO SaveCopyData(MasterTemplateDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
var new_mst_code = "";
MasterTemplateDTO objReturn = new MasterTemplateDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
MasterTemplateSearchDTO searchModel = new MasterTemplateSearchDTO();
var currentYearCode = $"MST_{DateTime.Now.ToString("yyyy")}";
var objDataList = _db.TCMasterTemplates.FromSqlRaw <TCMasterTemplate>("sp_GET_TCMasterTemplate {0}, {1}, {2}", currentYearCode, searchModel.mst_date_from, searchModel.mst_date_to).ToList();
if (objDataList.Count > 0)
{
var lastData = objDataList.LastOrDefault();
var lastCode = lastData.mst_code.Substring(7);
var newCodeInt = (Convert.ToInt32(lastCode) + 1);
new_mst_code = currentYearCode + newCodeInt.ToString("0000");
}
else
{
new_mst_code = currentYearCode + (1).ToString("0000");
}
var objCopyDataList = _db.TCMasterTemplates.FromSqlRaw <TCMasterTemplate>("sp_Copy_TCMasterTemplate {0}, {1}, {2}", model.mst_code, new_mst_code, model.mst_createuser).ToList();
if (objCopyDataList.Count > 0)
{
var objCopyData = objCopyDataList.FirstOrDefault();
objReturn = _mapper.Map <MasterTemplateDTO>(objCopyData);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "MasterTemplate",
log_tran_id = model.mst_code,
log_action = "New",
log_desc = "Copy MasterTemplate " + model.mst_code + " From " + new_mst_code,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public MasterTemplateDTO SaveData(MasterTemplateDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
MasterTemplateDTO objReturn = new MasterTemplateDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCMasterTemplate();
if (model.mst_status == "E")
{
objModel = _db.TCMasterTemplates.FirstOrDefault(x => x.mst_code == model.mst_code);
}
if (model.mst_status == "N")
{
var new_mst_code = "";
var currentYearCode = $"MST_{DateTime.Now.ToString("yyyy")}";
MasterTemplateSearchDTO searchModel = new MasterTemplateSearchDTO();
var objDataList = _db.TCMasterTemplates.FromSqlRaw <TCMasterTemplate>("sp_GET_TCMasterTemplate {0}, {1}, {2}", currentYearCode, searchModel.mst_date_from, searchModel.mst_date_to).ToList();
if (objDataList.Count > 0)
{
var lastData = objDataList.LastOrDefault();
var lastCode = lastData.mst_code.Substring(7);
var newCodeInt = (Convert.ToInt32(lastCode) + 1);
new_mst_code = currentYearCode + newCodeInt.ToString("0000");
}
else
{
new_mst_code = currentYearCode + (1).ToString("0000");
}
model.mst_code = new_mst_code;
objReturn.mst_code = new_mst_code;
objModel = _mapper.Map <TCMasterTemplate>(model);
objModel.mst_status = objModel.mst_active == true ? "A" : "I";
objModel.mst_createdate = currentDateTime;
currentUser = objModel.mst_createuser;
_db.TCMasterTemplates.Add(objModel);
}
else if (model.mst_status == "E")
{
//objModel.mst_name = model.mst_name;
objModel.mst_version = model.mst_version;
objModel.mst_date_from = model.mst_date_from;
objModel.mst_active = model.mst_active;
objModel.mst_status = objModel.mst_active == true ? "A" : "I";
objModel.mst_updateuser = model.mst_updateuser;
objModel.mst_updatedate = currentDateTime;
currentUser = objModel.mst_updateuser;
//_db.TCTemplates.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "MasterTemplate",
log_tran_id = model.mst_code.ToString(),
log_action = (model.mst_status == "N" ? "New" : "Update"),
log_desc = (model.mst_status == "N" ? "New" : "Update") + " MasterTemplate " + objModel.mst_code,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public MasterTemplateDTO Get_List_Active_ByModel([FromBody] MasterTemplateSearchDTO searchModel)
{
var objReturn = _service.GetList_Active_WithModel(searchModel);
return(objReturn);
}
public IEnumerable <MasterTemplateDTO> Get_ListByModel([FromBody] MasterTemplateSearchDTO searchModel)
{
var objReturn = _service.GetListWithModel(searchModel);
return(objReturn);
}
