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