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