protected void btnSave_Click(object sender, EventArgs e) { try { CustomList <CmnWorkFlowMaster> lstCmnWorkFlowMaster = CmnWorkFlowMasterList; if (lstCmnWorkFlowMaster.Count == 0) { CmnWorkFlowMaster newCmnWorkFlowMaster = new CmnWorkFlowMaster(); lstCmnWorkFlowMaster.Add(newCmnWorkFlowMaster); } SetDataFromControlToObj(ref lstCmnWorkFlowMaster); CustomList <CmnWorkFlowDetail> lstCmnWorkFlowDetail = (CustomList <CmnWorkFlowDetail>)CmnWorkFlowDetailList; if (!((PageBase)this.Page).CheckUserAuthentication(lstCmnWorkFlowMaster, lstCmnWorkFlowDetail)) { return; } _manager.SaveWorkFlow(ref lstCmnWorkFlowMaster, ref lstCmnWorkFlowDetail); txtWorkFlowID.Text = _manager.WorkFlowID.ToString(); ((PageBase)this.Page).SuccessMessage = (StaticInfo.SavedSuccessfullyMsg); } catch (SqlException ex) { ((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex)); } catch (Exception ex) { ((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getExceptionMessage(ex)); } }
protected void Page_Load(object sender, EventArgs e) { try { if (IsPostBack.IsFalse()) { InitializeCombo(); InitializeSession(); } else { Page.ClientScript.GetPostBackEventReference(this, String.Empty); String eventTarget = Request["__EVENTTARGET"].IsNullOrEmpty() ? String.Empty : Request["__EVENTTARGET"]; if (Request["__EVENTTARGET"] == "SearchWF") { CmnWorkFlowMasterList = new CustomList <CmnWorkFlowMaster>(); CmnWorkFlowMaster searchWorkFlowMaster = Session[STATIC.StaticInfo.SearchSessionVarName] as CmnWorkFlowMaster; CmnWorkFlowMasterList.Add(searchWorkFlowMaster); PopulateWorkFlowMaster(searchWorkFlowMaster); } } } catch (Exception ex) { throw ex; } }
private void PopulateWorkFlowMaster(CmnWorkFlowMaster objWF) { try { txtWorkFlowID.Text = objWF.WorkFlowID.ToString(); ddlCostCenter.SelectedValue = objWF.CostCenterID.ToString(); ddlDepartment.SelectedValue = objWF.DeptID.ToString(); ddlDocList.SelectedValue = objWF.DocListID.ToString(); txtSequence.Text = objWF.Sequence.ToString(); CmnWorkFlowDetailList = new CustomList <CmnWorkFlowDetail>(); CmnWorkFlowDetailList = _manager.GetAllCmnWorkFlowDetail(objWF.WorkFlowID); } catch (Exception ex) { throw (ex); } }
public HttpResponseMessage SaveUpdateApprovalSetup(object[] data) { CmnWorkFlowMaster workFlowMaster = JsonConvert.DeserializeObject <CmnWorkFlowMaster>(data[0].ToString()); List <CmnWorkFlowDetail> workFlowDetails = JsonConvert.DeserializeObject <List <CmnWorkFlowDetail> >(data[1].ToString()); string result = ""; try { if (ModelState.IsValid && workFlowMaster != null && workFlowMaster.CreateBy.ToString() != "" && workFlowDetails.Count > 0) { result = objApprovalSetupService.SaveUpdateApprovalSetup(workFlowMaster, workFlowDetails); } } catch (Exception e) { e.ToString(); result = ""; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
private void SetDataFromControlToObj(ref CustomList <CmnWorkFlowMaster> lstCmnWorkFlowMaster) { try { CmnWorkFlowMaster obj = lstCmnWorkFlowMaster[0]; if (ddlDocList.SelectedValue != "") { obj.DocListID = ddlDocList.SelectedValue.ToInt(); } if (ddlCostCenter.SelectedValue != "") { obj.CostCenterID = ddlCostCenter.SelectedValue.ToInt(); } if (ddlDepartment.SelectedValue != "") { obj.DeptID = ddlDepartment.SelectedValue.ToInt(); } obj.Sequence = txtSequence.Text.ToInt(); } catch (Exception ex) { throw (ex); } }
public CustomList <CmnWorkFlowMaster> GetAllCmnWorkFlowMasterFind() { return(CmnWorkFlowMaster.GetAllCmnWorkFlowMasterFind()); }
/// <summary> /// Save Data To Database /// <para>Use it when save data through ORM</para> /// </summary> public string SaveUpdateApprovalSetup(CmnWorkFlowMaster workFlowMaster, List <CmnWorkFlowDetail> workFlowDetail) { GenericFactory_EF_CmnWorkFlowMaster = new CmnWorkFlowMaster_EF(); GenericFactory_EF_CmnWorkFlowDetail = new CmnWorkFlowDetail_EF(); string result = string.Empty; if (workFlowMaster.WorkFlowID > 0) { using (TransactionScope transaction = new TransactionScope()) { try { //start for Update in CmnWorkFlowMaster int workFlowID = workFlowMaster.WorkFlowID; IEnumerable <CmnWorkFlowMaster> lstCmnWorkFlowMaster = GenericFactory_EF_CmnWorkFlowMaster.FindBy(m => m.WorkFlowID == workFlowID).ToList(); CmnWorkFlowMaster objCmnWorkFlowMaster = new CmnWorkFlowMaster(); foreach (CmnWorkFlowMaster wfm in lstCmnWorkFlowMaster) { wfm.MenuID = workFlowMaster.MenuID; wfm.IsActive = workFlowMaster.IsActive; wfm.BranchID = workFlowMaster.BranchID; wfm.CompanyID = workFlowMaster.CompanyID; wfm.UpdateOn = DateTime.Now; wfm.UpdatePc = HostService.GetIP(); objCmnWorkFlowMaster = wfm; } GenericFactory_EF_CmnWorkFlowMaster.Update(objCmnWorkFlowMaster); GenericFactory_EF_CmnWorkFlowMaster.Save(); // end for Update in CmnWorkFlowMaster List <CmnWorkFlowDetail> lstCmnWorkFlowDetail = new List <CmnWorkFlowDetail>(); foreach (CmnWorkFlowDetail wfd in workFlowDetail) { CmnWorkFlowDetail objCmnWorkFlowDetail = GenericFactory_EF_CmnWorkFlowDetail.FindBy(m => m.WorkFlowDetailID == wfd.WorkFlowDetailID).FirstOrDefault(); objCmnWorkFlowDetail.CompanyID = wfd.CompanyID; objCmnWorkFlowDetail.EmployeeID = wfd.EmployeeID; objCmnWorkFlowDetail.Sequence = wfd.Sequence; objCmnWorkFlowDetail.StatusID = wfd.StatusID; objCmnWorkFlowDetail.IsDeleted = false; objCmnWorkFlowDetail.UpdateOn = wfd.UpdateOn; objCmnWorkFlowDetail.UpdatePc = HostService.GetIP(); lstCmnWorkFlowDetail.Add(objCmnWorkFlowDetail); } GenericFactory_EF_CmnWorkFlowDetail.UpdateList(lstCmnWorkFlowDetail); GenericFactory_EF_CmnWorkFlowDetail.Save(); transaction.Complete(); result = workFlowMaster.WorkFlowID.ToString(); } catch (Exception e) { e.ToString(); result = ""; } } } else { using (TransactionScope transaction = new TransactionScope()) { //...........START new maxId........// //int NextId = Convert.ToInt16(GenericFactory_EF_CmnWorkFlowMaster.getMaxID("CmnWorkFlowMaster")); //int nextWorkFlowDetailID = Convert.ToInt16(GenericFactory_EF_CmnWorkFlowDetail.getMaxID("CmnWorkFlowDetail")); //...........START new maxId........// long NextId = Convert.ToInt64(GenericFactory_EF_CmnWorkFlowMaster.getMaxID("CmnWorkFlowMaster")); long FirstDigit = 0; long OtherDigits = 0; long nextDetailId = Convert.ToInt64(GenericFactory_EF_CmnWorkFlowDetail.getMaxID("CmnWorkFlowDetail")); FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1)); //..........END new maxId.........// //..........END new maxId.........// try { workFlowMaster.WorkFlowID = Convert.ToInt16(NextId); workFlowMaster.CreateOn = DateTime.Now; workFlowMaster.CreatePc = HostService.GetIP(); List <CmnWorkFlowDetail> lstWorkFlowDetail = new List <CmnWorkFlowDetail>(); foreach (CmnWorkFlowDetail wfd in workFlowDetail) { CmnWorkFlowDetail objCmnWorkFlowDetail = new CmnWorkFlowDetail(); objCmnWorkFlowDetail.WorkFlowDetailID = Convert.ToInt16(FirstDigit + "" + OtherDigits); //nextWorkFlowDetailID; objCmnWorkFlowDetail.WorkFlowID = Convert.ToInt16(NextId); //NextId; objCmnWorkFlowDetail.CompanyID = workFlowMaster.CompanyID ?? 0; objCmnWorkFlowDetail.DBID = wfd.DBID; objCmnWorkFlowDetail.EmployeeID = wfd.EmployeeID; objCmnWorkFlowDetail.Sequence = wfd.Sequence; objCmnWorkFlowDetail.StatusID = wfd.StatusID; objCmnWorkFlowDetail.IsDeleted = false; objCmnWorkFlowDetail.CreateBy = wfd.CreateBy; objCmnWorkFlowDetail.CreateOn = DateTime.Now; objCmnWorkFlowDetail.CreatePc = HostService.GetIP(); objCmnWorkFlowDetail.Transfer = false; lstWorkFlowDetail.Add(objCmnWorkFlowDetail); // nextWorkFlowDetailID++; OtherDigits++; } GenericFactory_EF_CmnWorkFlowMaster.Insert(workFlowMaster); GenericFactory_EF_CmnWorkFlowMaster.Save(); //............Update MaxID.................// GenericFactory_EF_CmnWorkFlowMaster.updateMaxID("CmnWorkFlowMaster", Convert.ToInt64(NextId)); GenericFactory_EF_CmnWorkFlowDetail.InsertList(lstWorkFlowDetail); GenericFactory_EF_CmnWorkFlowDetail.Save(); //............Update MaxID.................// GenericFactory_EF_CmnWorkFlowDetail.updateMaxID("CmnWorkFlowDetail", Convert.ToInt16(FirstDigit + "" + (OtherDigits - 1))); // GenericFactory_EF_SalPIDetail.updateMaxID("SalPIDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1))); transaction.Complete(); result = NextId.ToString(); } catch (Exception e) { e.ToString(); result = ""; } } } return(result); }