Int64 ICRMAgreementDataAccess.Add(CRMAgreementEntity cRMAgreementEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(cRMAgreementEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(cRMAgreementEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
Int64 ICRMAgreementDataAccess.Delete(CRMAgreementEntity cRMAgreementEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Delete(cRMAgreementEntity, filterExpression, option); break; } case TransactionRequired.Yes: { retValues = DeleteTran(cRMAgreementEntity, filterExpression, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void PrepareEditView() { CRMAgreementEntity cRMAgreementEntity = CurrentCRMAgreementEntity; if (!cRMAgreementEntity.IsNew) { } }
private Int64 Update(CRMAgreementEntity cRMAgreementEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreement_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@AgreementID", DbType.Int64, cRMAgreementEntity.AgreementID); Database.AddInParameter(cmd, "@PaymentScheduleID", DbType.Int64, cRMAgreementEntity.PaymentScheduleID); Database.AddInParameter(cmd, "@AgreementTypeID", DbType.Int64, cRMAgreementEntity.AgreementTypeID); Database.AddInParameter(cmd, "@BuyerBasicInfoID", DbType.Int64, cRMAgreementEntity.BuyerBasicInfoID); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, cRMAgreementEntity.ProjectID); Database.AddInParameter(cmd, "@ProjectFloorUnitID", DbType.Int64, cRMAgreementEntity.ProjectFloorUnitID); Database.AddInParameter(cmd, "@Text", DbType.String, cRMAgreementEntity.Text); Database.AddInParameter(cmd, "@AgreementDate", DbType.DateTime, cRMAgreementEntity.AgreementDate); Database.AddInParameter(cmd, "@SignDate", DbType.DateTime, cRMAgreementEntity.SignDate); Database.AddInParameter(cmd, "@ExecuteDate", DbType.DateTime, cRMAgreementEntity.ExecuteDate); Database.AddInParameter(cmd, "@Field1", DbType.String, cRMAgreementEntity.Field1); Database.AddInParameter(cmd, "@Field2", DbType.String, cRMAgreementEntity.Field2); Database.AddInParameter(cmd, "@Field3", DbType.String, cRMAgreementEntity.Field3); Database.AddInParameter(cmd, "@Field4", DbType.String, cRMAgreementEntity.Field4); Database.AddInParameter(cmd, "@Remarks", DbType.String, cRMAgreementEntity.Remarks); Database.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, cRMAgreementEntity.CreatedByEmployeeID); Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, cRMAgreementEntity.CreateDate); Database.AddInParameter(cmd, "@IP", DbType.String, cRMAgreementEntity.IP); Database.AddInParameter(cmd, "@AgreementApprovalStatusID", DbType.Int64, cRMAgreementEntity.AgreementApprovalStatusID); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CRMAgreementEntity already exists. Please specify another CRMAgreementEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CRMAgreementEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CRMAgreementEntity already exists. Please specify another CRMAgreementEntity."); } } } } return(returnCode); }
protected void lvCRMAgreement_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 AgreementID; Int64.TryParse(e.CommandArgument.ToString(), out AgreementID); if (AgreementID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _AgreementID = AgreementID; //PrepareEditView(); String navUrl = UrlHelper.BuildSecureUrl("~/CRM/CRMAgreement.aspx", String.Empty, UrlConstants.OVERVIEW_AGREEMENT_ID, AgreementID.ToString()).ToString(); Response.Redirect(navUrl); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { CRMAgreementEntity cRMAgreementEntity = FCCCRMAgreement.GetFacadeCreate().GetByID(AgreementID); if (cRMAgreementEntity.AgreementApprovalStatusID == MasterDataConstants.CRMMDAgreementApprovalStatus.INITIATED) { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementEntity.FLD_NAME_AgreementID, AgreementID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreement.GetFacadeCreate().Delete(cRMAgreementEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _AgreementID = 0; _CRMAgreementEntity = new CRMAgreementEntity(); PrepareInitialView(); BindCRMAgreementList(); MiscUtil.ShowMessage(lblMessage, "Agreement Successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Agreement.", true); } } else { MiscUtil.ShowMessage(lblMessage, "Agreement Can't be deleted expect 'Initiated' Status.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(CRMAgreementEntity cRMAgreementEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreement_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode >= 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
protected void lvCRMAgreement_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 AgreementID; Int64.TryParse(e.CommandArgument.ToString(), out AgreementID); if (AgreementID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _AgreementID = AgreementID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementEntity.FLD_NAME_AgreementID, AgreementID.ToString(), SQLMatchType.Equal); CRMAgreementEntity cRMAgreementEntity = new CRMAgreementEntity(); result = FCCCRMAgreement.GetFacadeCreate().Delete(cRMAgreementEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _AgreementID = 0; _CRMAgreementEntity = new CRMAgreementEntity(); PrepareInitialView(); BindCRMAgreementList(); MiscUtil.ShowMessage(lblMessage, "C RMAgreement has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete C RMAgreement.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private void PrepareEditView() { CRMAgreementEntity cRMAgreementEntity = CurrentCRMAgreementEntity; if (!cRMAgreementEntity.IsNew) { if (ddlPaymentScheduleID.Items.Count > 0 && cRMAgreementEntity.PaymentScheduleID != null) { ddlPaymentScheduleID.SelectedValue = cRMAgreementEntity.PaymentScheduleID.ToString(); } if (ddlAgreementTypeID.Items.Count > 0 && cRMAgreementEntity.AgreementTypeID != null) { ddlAgreementTypeID.SelectedValue = cRMAgreementEntity.AgreementTypeID.ToString(); } if (ddlBuyerBasicInfoID.Items.Count > 0 && cRMAgreementEntity.BuyerBasicInfoID != null) { ddlBuyerBasicInfoID.SelectedValue = cRMAgreementEntity.BuyerBasicInfoID.ToString(); } if (ddlProjectID.Items.Count > 0 && cRMAgreementEntity.ProjectID != null) { ddlProjectID.SelectedValue = cRMAgreementEntity.ProjectID.ToString(); } BuildProjectFloorUnitByProjectID(); if (ddlProjectFloorUnitID.Items.Count > 0 && cRMAgreementEntity.ProjectFloorUnitID != null) { ddlProjectFloorUnitID.SelectedValue = cRMAgreementEntity.ProjectFloorUnitID.ToString(); } txtText.Content = cRMAgreementEntity.Text.ToString(); txtAgreementDate.Text = cRMAgreementEntity.AgreementDate.ToStringDefault(); txtSignDate.Text = cRMAgreementEntity.SignDate.ToStringDefault(); txtExecuteDate.Text = cRMAgreementEntity.ExecuteDate.ToStringDefault(); txtRemarks.Text = cRMAgreementEntity.Remarks.ToString(); if (ddlAgreementApprovalStatusID.Items.Count > 0 && cRMAgreementEntity.AgreementApprovalStatusID != null) { ddlAgreementApprovalStatusID.SelectedValue = cRMAgreementEntity.AgreementApprovalStatusID.ToString(); } } }
protected void btnCancel_Click(object sender, EventArgs e) { CRMAgreementEntity cRMAgreementEntity = new CRMAgreementEntity(); Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementEntity.FLD_NAME_AgreementID, _AgreementID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreement.GetFacadeCreate().Delete(cRMAgreementEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { MiscUtil.ShowMessage(lblMessage, "Agreement Deleted Successfully", true); _AgreementID = result; _CRMAgreementEntity = new CRMAgreementEntity(); PrepareInitialView(); wizAgreement.ActiveStepIndex = 0; hypAgreementVariablePopup.Visible = false; hypAgreementSpec.Visible = false; } }
private Int64 Delete(CRMAgreementEntity cRMAgreementEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreement_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CRMAgreementEntity already exists. Please specify another CRMAgreementEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CRMAgreementEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CRMAgreementEntity already exists. Please specify another CRMAgreementEntity."); } } } } return(returnCode); }
private void SaveCRMAgreementEntity() { if (IsValid) { try { CRMAgreementEntity cRMAgreementEntity = BuildCRMAgreementEntity(); Int64 result = -1; if (cRMAgreementEntity.IsNew) { result = FCCCRMAgreement.GetFacadeCreate().Add(cRMAgreementEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementEntity.FLD_NAME_AgreementID, cRMAgreementEntity.AgreementID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreement.GetFacadeCreate().Update(cRMAgreementEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { //#region Update Agreement Variable Map //if (!cRMAgreementEntity.IsNew) //{ //// String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementVariableMapEntity.FLD_NAME_AgreementID, result.ToString(), SQLMatchType.Equal); //// CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity = new CRMAgreementVariableMapEntity(); //// FCCCRMAgreementVariableMap.GetFacadeCreate().Delete(cRMAgreementVariableMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); //// String input = txtText.Content.ToString(); //// String newOutPut = String.Empty; // //IList<CRMAgreementVariableMapEntity> cRMAgreementVariableList = FCCCRMAgreementVariableMap.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load); // //if (cRMAgreementVariableList != null && cRMAgreementVariableList.Count > 0) // //{ // //String fe_delete = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementVariableMapEntity.FLD_NAME_AgreementID, result.ToString(), SQLMatchType.Equal); // //IList<CRMAgreementVariableMapEntity> deleteList = FCCCRMAgreementVariableMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_delete, DatabaseOperationType.LoadWithFilterExpression); // //if (deleteList != null && deleteList.Count > 0) // //{ // // foreach (CRMAgreementVariableMapEntity ent in deleteList) // // { // // FCCCRMAgreementVariableMap.GetFacadeCreate().Delete(ent, fe_delete, DatabaseOperationType.Delete, TransactionRequired.No); // // } // //} // //foreach (CRMAgreementVariableMapEntity ent in cRMAgreementVariableList) // //{ // // if (input.Contains(ent.Name)) // // { // // CRMAgreementVariableMapEntity cRMAgreementVariableMap=new CRMAgreementVariableMapEntity(); // // cRMAgreementVariableMap.Name = ent.Name; // // cRMAgreementVariableMap.IP = MiscUtil.GetLocalIP(); // // cRMAgreementVariableMap.Value = ent.Value; // // cRMAgreementVariableMap.AgreementID = result; // // cRMAgreementVariableMap.CreateDate = System.DateTime.Now; // // cRMAgreementVariableMap.CreatedByEmployeeID = CurrentemployeeID; // // cRMAgreementVariableMap.Remarks = "Auto Generated"; // // FCCCRMAgreementVariableMap.GetFacadeCreate().Add(cRMAgreementVariableMap, DatabaseOperationType.Add, TransactionRequired.No); // // } // //} // //} //} //#endregion _AgreementID = result; PrepareEditView(); ProcessText(); BindCRMAgreementList(); if (cRMAgreementEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Agreement Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Agreement Information has been updated successfully.", false); } } else { if (cRMAgreementEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Agreement Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Agreement Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private CRMAgreementEntity BuildCRMAgreementEntity() { CRMAgreementEntity cRMAgreementEntity = CurrentCRMAgreementEntity; if (ddlPaymentScheduleID.Items.Count > 0) { if (ddlPaymentScheduleID.SelectedValue == "0") { } else { cRMAgreementEntity.PaymentScheduleID = Int64.Parse(ddlPaymentScheduleID.SelectedValue); } } if (ddlAgreementTypeID.Items.Count > 0) { if (ddlAgreementTypeID.SelectedValue == "0") { } else { cRMAgreementEntity.AgreementTypeID = Int64.Parse(ddlAgreementTypeID.SelectedValue); } } if (ddlBuyerBasicInfoID.Items.Count > 0) { if (ddlBuyerBasicInfoID.SelectedValue == "0") { } else { cRMAgreementEntity.BuyerBasicInfoID = Int64.Parse(ddlBuyerBasicInfoID.SelectedValue); } } if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { cRMAgreementEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } if (ddlProjectFloorUnitID.Items.Count > 0) { if (ddlProjectFloorUnitID.SelectedValue == "0") { } else { cRMAgreementEntity.ProjectFloorUnitID = Int64.Parse(ddlProjectFloorUnitID.SelectedValue); } } cRMAgreementEntity.Text = txtText.Content.Trim(); if (txtAgreementDate.Text.Trim().IsNotNullOrEmpty()) { cRMAgreementEntity.AgreementDate = MiscUtil.ParseToDateTime(txtAgreementDate.Text); } else { cRMAgreementEntity.AgreementDate = null; } if (txtSignDate.Text.Trim().IsNotNullOrEmpty()) { cRMAgreementEntity.SignDate = MiscUtil.ParseToDateTime(txtSignDate.Text); } else { cRMAgreementEntity.SignDate = null; } if (txtExecuteDate.Text.Trim().IsNotNullOrEmpty()) { cRMAgreementEntity.ExecuteDate = MiscUtil.ParseToDateTime(txtExecuteDate.Text); } else { cRMAgreementEntity.ExecuteDate = null; } cRMAgreementEntity.Field1 = "Not Implemented"; cRMAgreementEntity.Field2 = "Not Implemented"; cRMAgreementEntity.Field3 = "Not Implemented"; cRMAgreementEntity.Field4 = "Not Implemented"; cRMAgreementEntity.Remarks = "Not Implemented"; cRMAgreementEntity.CreatedByEmployeeID = CurrentemployeeID; cRMAgreementEntity.CreateDate = System.DateTime.Now; cRMAgreementEntity.IP = MiscUtil.GetLocalIP(); if (ddlAgreementApprovalStatusID.Items.Count > 0) { if (ddlAgreementApprovalStatusID.SelectedValue == "0") { } else { cRMAgreementEntity.AgreementApprovalStatusID = Int64.Parse(ddlAgreementApprovalStatusID.SelectedValue); } } return(cRMAgreementEntity); }
private void PrepareEditView() { CRMAgreementEntity cRMAgreementEntity = CurrentCRMAgreementEntity; if (!cRMAgreementEntity.IsNew) { if (ddlPaymentScheduleID.Items.Count > 0 && cRMAgreementEntity.PaymentScheduleID != null) { ddlPaymentScheduleID.SelectedValue = cRMAgreementEntity.PaymentScheduleID.ToString(); } if (ddlAgreementTypeID.Items.Count > 0 && cRMAgreementEntity.AgreementTypeID != null) { ddlAgreementTypeID.SelectedValue = cRMAgreementEntity.AgreementTypeID.ToString(); } if (ddlBuyerBasicInfoID.Items.Count > 0 && cRMAgreementEntity.BuyerBasicInfoID != null) { ddlBuyerBasicInfoID.SelectedValue = cRMAgreementEntity.BuyerBasicInfoID.ToString(); } if (ddlProjectID.Items.Count > 0 && cRMAgreementEntity.ProjectID != null) { ddlProjectID.SelectedValue = cRMAgreementEntity.ProjectID.ToString(); } BuildProjectFloorUnitByProjectID(); if (ddlProjectFloorUnitID.Items.Count > 0 && cRMAgreementEntity.ProjectFloorUnitID != null) { ddlProjectFloorUnitID.SelectedValue = cRMAgreementEntity.ProjectFloorUnitID.ToString(); } txtText.Content = cRMAgreementEntity.Text.ToString(); txtAgreementDate.Text = cRMAgreementEntity.AgreementDate.ToStringDefault(); txtSignDate.Text = cRMAgreementEntity.SignDate.ToStringDefault(); txtExecuteDate.Text = cRMAgreementEntity.ExecuteDate.ToStringDefault(); txtWizardRemarks.Text = cRMAgreementEntity.Remarks.ToString(); if (ddlAgreementApprovalStatusID.Items.Count > 0 && cRMAgreementEntity.AgreementApprovalStatusID != null) { ddlAgreementApprovalStatusID.SelectedValue = cRMAgreementEntity.AgreementApprovalStatusID.ToString(); } #region Process Your Data Here String input = cRMAgreementEntity.Text.ToString(); String newOutPut = String.Empty; IList <CRMAgreementVariableMapEntity> cRMAgreementVariableList = FCCCRMAgreementVariableMap.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load); if (cRMAgreementVariableList != null && cRMAgreementVariableList.Count > 0) { foreach (CRMAgreementVariableMapEntity ent in cRMAgreementVariableList) { if (input.Contains(ent.Name)) { newOutPut = MiscUtil.ReplaceFullWords(input, ent.Name, ent.Value.ToString()); input = newOutPut; } } } lblTextView.Text = newOutPut; #endregion } }
private void SaveCRMAgreementEntity() { if (IsValid) { try { CRMAgreementEntity cRMAgreementEntity = BuildCRMAgreementEntity(); Int64 result = -1; if (cRMAgreementEntity.IsNew) { result = FCCCRMAgreement.GetFacadeCreate().Add(cRMAgreementEntity, DatabaseOperationType.Add, TransactionRequired.No); String input = txtText.Content.ToString(); String newOutPut = String.Empty; IList <CRMMDAgreementVariableEntity> cRMAgreementVariableList = FCCCRMMDAgreementVariable.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load); if (cRMAgreementVariableList != null && cRMAgreementVariableList.Count > 0) { foreach (CRMMDAgreementVariableEntity ent in cRMAgreementVariableList) { if (input.Contains(ent.Name)) // AGR body matching { CRMAgreementVariableMapEntity cRMAgrementVariableMapEnt = new CRMAgreementVariableMapEntity(); cRMAgrementVariableMapEnt.Name = ent.Name; cRMAgrementVariableMapEnt.Value = ent.Value; cRMAgreementVariableMapEntityList.Add(cRMAgrementVariableMapEnt); newOutPut = MiscUtil.ReplaceFullWords(input, ent.Name, ent.Value.ToString()); input = newOutPut; } } } if (newOutPut.IsNotNullOrEmpty()) { lblTextView.Text = Server.HtmlDecode(newOutPut); } else { lblTextView.Text = Server.HtmlDecode(input); } } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementEntity.FLD_NAME_AgreementID, cRMAgreementEntity.AgreementID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreement.GetFacadeCreate().Update(cRMAgreementEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); String input = txtText.Content.ToString(); String newOutPut = String.Empty; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementVariableMapEntity.FLD_NAME_AgreementID, result.ToString(), SQLMatchType.Equal); IList <CRMAgreementVariableMapEntity> cRMAgreementVariableList = FCCCRMAgreementVariableMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (cRMAgreementVariableList != null && cRMAgreementVariableList.Count > 0) { cRMAgreementVariableMapEntityList = new List <CRMAgreementVariableMapEntity>(); foreach (CRMAgreementVariableMapEntity ent in cRMAgreementVariableList) { if (input.Contains(ent.Name)) { CRMAgreementVariableMapEntity cRMAgrementVariableMapEnt = new CRMAgreementVariableMapEntity(); cRMAgrementVariableMapEnt.Name = ent.Name; cRMAgrementVariableMapEnt.Value = ent.Value; //cRMAgreementVariableMapEntityList.Add(cRMAgrementVariableMapEnt); newOutPut = MiscUtil.ReplaceFullWords(input, ent.Name, ent.Value.ToString()); input = newOutPut; } } } if (newOutPut.IsNotNullOrEmpty()) { lblTextView.Text = Server.HtmlDecode(newOutPut); } else { lblTextView.Text = input; } } if (result > 0) { #region Agreement variable Map if (cRMAgreementEntity.IsNew) { if (cRMAgreementVariableMapEntityList != null && cRMAgreementVariableMapEntityList.Count > 0) { // Delete Variable Map Table //String fe_delete=SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementVariableMapEntity.FLD_NAME_AgreementID,result.ToString(),SQLMatchType.Equal); //IList<CRMAgreementVariableMapEntity> deleteList = FCCCRMAgreementVariableMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_delete, DatabaseOperationType.LoadWithFilterExpression); //if (deleteList != null && deleteList.Count > 0) //{ // foreach (CRMAgreementVariableMapEntity ent in cRMAgreementVariableMapEntityList) // { // FCCCRMAgreementVariableMap.GetFacadeCreate().Delete(ent, fe_delete, DatabaseOperationType.Delete, TransactionRequired.No); // } //} foreach (CRMAgreementVariableMapEntity ent in cRMAgreementVariableMapEntityList) { CRMAgreementVariableMapEntity cRMAgrementVariableMapEnt = new CRMAgreementVariableMapEntity(); cRMAgrementVariableMapEnt.Name = ent.Name; cRMAgrementVariableMapEnt.Value = ent.Value; cRMAgrementVariableMapEnt.IP = MiscUtil.GetLocalIP(); cRMAgrementVariableMapEnt.Remarks = "Auto Generated"; cRMAgrementVariableMapEnt.CreateDate = System.DateTime.Now; cRMAgrementVariableMapEnt.CreatedByEmployeeID = CurrentemployeeID; cRMAgrementVariableMapEnt.AgreementID = result; FCCCRMAgreementVariableMap.GetFacadeCreate().Add(cRMAgrementVariableMapEnt, DatabaseOperationType.Add, TransactionRequired.No); } } } #endregion if (cRMAgreementEntity.AgreementTypeID == MasterDataConstants.CRMMDAgreementType.SPECS) { hypAgreementSpec.NavigateUrl = UrlHelper.BuildSecureUrl("~/CRM/CRMAgreementSpecs.aspx", String.Empty, UrlConstants.OVERVIEW_AGREEMENT_ID, result.ToString()).ToString(); hypAgreementSpec.Target = "_blank"; hypAgreementSpec.Visible = true; } hypAgreementVariablePopup.NavigateUrl = UrlHelper.BuildSecureUrl("~/CRM/CRMAgreementVariableMap.aspx", String.Empty, UrlConstants.OVERVIEW_AGREEMENT_ID, result.ToString()).ToString(); hypAgreementVariablePopup.Target = "_blank"; hypAgreementVariablePopup.Visible = true; _AgreementID = result; //_CRMAgreementEntity = new CRMAgreementEntity(); PrepareEditView(); BindCRMAgreementList(); if (cRMAgreementEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Agreement Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Agreement Information has been updated successfully.", false); } } else { if (cRMAgreementEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Agreement Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Agreement Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 UpdateTran(CRMAgreementEntity cRMAgreementEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreement_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@AgreementID", DbType.Int64, cRMAgreementEntity.AgreementID); db.AddInParameter(cmd, "@PaymentScheduleID", DbType.Int64, cRMAgreementEntity.PaymentScheduleID); db.AddInParameter(cmd, "@AgreementTypeID", DbType.Int64, cRMAgreementEntity.AgreementTypeID); db.AddInParameter(cmd, "@BuyerBasicInfoID", DbType.Int64, cRMAgreementEntity.BuyerBasicInfoID); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, cRMAgreementEntity.ProjectID); db.AddInParameter(cmd, "@ProjectFloorUnitID", DbType.Int64, cRMAgreementEntity.ProjectFloorUnitID); db.AddInParameter(cmd, "@Text", DbType.String, cRMAgreementEntity.Text); db.AddInParameter(cmd, "@AgreementDate", DbType.DateTime, cRMAgreementEntity.AgreementDate); db.AddInParameter(cmd, "@SignDate", DbType.DateTime, cRMAgreementEntity.SignDate); db.AddInParameter(cmd, "@ExecuteDate", DbType.DateTime, cRMAgreementEntity.ExecuteDate); db.AddInParameter(cmd, "@Field1", DbType.String, cRMAgreementEntity.Field1); db.AddInParameter(cmd, "@Field2", DbType.String, cRMAgreementEntity.Field2); db.AddInParameter(cmd, "@Field3", DbType.String, cRMAgreementEntity.Field3); db.AddInParameter(cmd, "@Field4", DbType.String, cRMAgreementEntity.Field4); db.AddInParameter(cmd, "@Remarks", DbType.String, cRMAgreementEntity.Remarks); db.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, cRMAgreementEntity.CreatedByEmployeeID); db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, cRMAgreementEntity.CreateDate); db.AddInParameter(cmd, "@IP", DbType.String, cRMAgreementEntity.IP); db.AddInParameter(cmd, "@AgreementApprovalStatusID", DbType.Int64, cRMAgreementEntity.AgreementApprovalStatusID); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
Int64 ICRMAgreementFacade.Delete(CRMAgreementEntity cRMAgreementEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCRMAgreementDataAccess().Delete(cRMAgreementEntity, filterExpression, option, reqTran)); }
Int64 ICRMAgreementFacade.Add(CRMAgreementEntity cRMAgreementEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCRMAgreementDataAccess().Add(cRMAgreementEntity, option, reqTran)); }