Int64 ICRMAgreementVariableMapDataAccess.Add(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(cRMAgreementVariableMapEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(cRMAgreementVariableMapEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 UpdateTran(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementVariableMap_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, "@AgreementVariableMapID", DbType.Int64, cRMAgreementVariableMapEntity.AgreementVariableMapID); db.AddInParameter(cmd, "@AgreementID", DbType.Int64, cRMAgreementVariableMapEntity.AgreementID); db.AddInParameter(cmd, "@Name", DbType.String, cRMAgreementVariableMapEntity.Name); db.AddInParameter(cmd, "@Value", DbType.String, cRMAgreementVariableMapEntity.Value); db.AddInParameter(cmd, "@Remarks", DbType.String, cRMAgreementVariableMapEntity.Remarks); db.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, cRMAgreementVariableMapEntity.CreatedByEmployeeID); db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, cRMAgreementVariableMapEntity.CreateDate); db.AddInParameter(cmd, "@IP", DbType.String, cRMAgreementVariableMapEntity.IP); 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); }
private void SaveCRMAgreementVariableMapEntity() { if (IsValid) { try { CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity = BuildCRMAgreementVariableMapEntity(); Int64 result = -1; if (cRMAgreementVariableMapEntity.IsNew) { result = FCCCRMAgreementVariableMap.GetFacadeCreate().Add(cRMAgreementVariableMapEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementVariableMapEntity.FLD_NAME_AgreementVariableMapID, cRMAgreementVariableMapEntity.AgreementVariableMapID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreementVariableMap.GetFacadeCreate().Update(cRMAgreementVariableMapEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _AgreementVariableMapID = 0; _CRMAgreementVariableMapEntity = new CRMAgreementVariableMapEntity(); PrepareInitialView(); BindCRMAgreementVariableMapList(); if (cRMAgreementVariableMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Agreement Variable Map Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Agreement Variable Map Information has been updated successfully.", false); } } else { if (cRMAgreementVariableMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Agreement Variable Map Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Agreement Variable Map Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvCRMAgreementVariableMap_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 AgreementVariableMapID; Int64.TryParse(e.CommandArgument.ToString(), out AgreementVariableMapID); if (AgreementVariableMapID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _AgreementVariableMapID = AgreementVariableMapID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementVariableMapEntity.FLD_NAME_AgreementVariableMapID, AgreementVariableMapID.ToString(), SQLMatchType.Equal); CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity = new CRMAgreementVariableMapEntity(); result = FCCCRMAgreementVariableMap.GetFacadeCreate().Delete(cRMAgreementVariableMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _AgreementVariableMapID = 0; _CRMAgreementVariableMapEntity = new CRMAgreementVariableMapEntity(); PrepareInitialView(); BindCRMAgreementVariableMapList(); MiscUtil.ShowMessage(lblMessage, "C RMAgreement Variable Map has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete C RMAgreement Variable Map.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementVariableMap_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); }
private void PrepareEditView() { CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity = CurrentCRMAgreementVariableMapEntity; if (!cRMAgreementVariableMapEntity.IsNew) { txtName.Text = cRMAgreementVariableMapEntity.Name.ToString(); txtValue.Text = cRMAgreementVariableMapEntity.Value.ToString(); txtRemarks.Text = cRMAgreementVariableMapEntity.Remarks.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private CRMAgreementVariableMapEntity BuildCRMAgreementVariableMapEntity() { CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity = CurrentCRMAgreementVariableMapEntity; cRMAgreementVariableMapEntity.AgreementID = OverviewAgreementID; txtName.Text = MiscUtil.DocumentVariableParsing(txtName.Text.ToString()); cRMAgreementVariableMapEntity.Name = txtName.Text.Trim(); cRMAgreementVariableMapEntity.Value = txtValue.Text.Trim(); cRMAgreementVariableMapEntity.Remarks = txtRemarks.Text.Trim(); cRMAgreementVariableMapEntity.CreatedByEmployeeID = CurrentemployeeID; cRMAgreementVariableMapEntity.CreateDate = System.DateTime.Now; cRMAgreementVariableMapEntity.IP = MiscUtil.GetLocalIP(); return(cRMAgreementVariableMapEntity); }
private Int64 Update(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementVariableMap_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@AgreementVariableMapID", DbType.Int64, cRMAgreementVariableMapEntity.AgreementVariableMapID); Database.AddInParameter(cmd, "@AgreementID", DbType.Int64, cRMAgreementVariableMapEntity.AgreementID); Database.AddInParameter(cmd, "@Name", DbType.String, cRMAgreementVariableMapEntity.Name); Database.AddInParameter(cmd, "@Value", DbType.String, cRMAgreementVariableMapEntity.Value); Database.AddInParameter(cmd, "@Remarks", DbType.String, cRMAgreementVariableMapEntity.Remarks); Database.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, cRMAgreementVariableMapEntity.CreatedByEmployeeID); Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, cRMAgreementVariableMapEntity.CreateDate); Database.AddInParameter(cmd, "@IP", DbType.String, cRMAgreementVariableMapEntity.IP); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CRMAgreementVariableMapEntity already exists. Please specify another CRMAgreementVariableMapEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CRMAgreementVariableMapEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CRMAgreementVariableMapEntity already exists. Please specify another CRMAgreementVariableMapEntity."); } } } } return(returnCode); }
private Int64 Delete(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CRMAgreementVariableMap_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("CRMAgreementVariableMapEntity already exists. Please specify another CRMAgreementVariableMapEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CRMAgreementVariableMapEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CRMAgreementVariableMapEntity already exists. Please specify another CRMAgreementVariableMapEntity."); } } } } 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); 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); } } }
Int64 ICRMAgreementVariableMapFacade.Delete(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCRMAgreementVariableMapDataAccess().Delete(cRMAgreementVariableMapEntity, filterExpression, option, reqTran)); }
Int64 ICRMAgreementVariableMapFacade.Add(CRMAgreementVariableMapEntity cRMAgreementVariableMapEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCRMAgreementVariableMapDataAccess().Add(cRMAgreementVariableMapEntity, option, reqTran)); }
protected void btnAddNew_Click(object sender, EventArgs e) { _AgreementVariableMapID = 0; _CRMAgreementVariableMapEntity = new CRMAgreementVariableMapEntity(); PrepareInitialView(); }
private void SaveCRMAgreementSpecsEntity() { if (IsValid) { try { CRMAgreementSpecsEntity cRMAgreementSpecsEntity = BuildCRMAgreementSpecsEntity(); Int64 result = -1; if (cRMAgreementSpecsEntity.IsNew) { result = FCCCRMAgreementSpecs.GetFacadeCreate().Add(cRMAgreementSpecsEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CRMAgreementSpecsEntity.FLD_NAME_AgreementSpecsID, cRMAgreementSpecsEntity.AgreementSpecsID.ToString(), SQLMatchType.Equal); result = FCCCRMAgreementSpecs.GetFacadeCreate().Update(cRMAgreementSpecsEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { if (cRMAgreementSpecsEntity.IsNew) { for (Int32 i = 1; i <= 5; i++) { CRMAgreementVariableMapEntity ent = new CRMAgreementVariableMapEntity(); switch (i) { //case 1: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType+"_"+cRMAgreementSpecsEntity.Item +"_IName"+ result.ToString() + "%>"; // ent.Value = cRMAgreementSpecsEntity.Item; // break; //case 2: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + ddlBrandID.SelectedItem + "_IBrand_" + result.ToString() + "%>"; // ent.Value = ddlBrandID.SelectedItem.ToString(); // break; //case 3: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Item+"_IQty_"+ result.ToString()+ "%>"; // ent.Value = cRMAgreementSpecsEntity.BayQty.ToString(); // break; //case 4: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Item+"_IPrice_"+ result.ToString()+"%>"; // ent.Value = cRMAgreementSpecsEntity.BayPrice.ToString(); // break; //case 5: // ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Field1+ "_IUnit_"+ result.ToString() + "%>"; // ent.Value = cRMAgreementSpecsEntity.Field1.ToString(); // break; case 1: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IName" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.Item; break; case 2: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IBrand_" + result.ToString() + "%>"; ent.Value = ddlBrandID.SelectedItem.ToString(); break; case 3: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IQty_" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.BayQty.ToString(); break; case 4: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IPrice_" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.BayPrice.ToString(); break; case 5: ent.Name = "<%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IUnit_" + result.ToString() + "%>"; ent.Value = cRMAgreementSpecsEntity.Field1.ToString(); break; } ent.CreateDate = System.DateTime.Now; ent.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); ent.IP = MiscUtil.GetLocalIP(); ent.Remarks = "Auto Generated"; ent.AgreementID = OverviewAgreementID; FCCCRMAgreementVariableMap.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } _AgreementSpecsID = 0; _CRMAgreementSpecsEntity = new CRMAgreementSpecsEntity(); PrepareInitialView(); BindCRMAgreementSpecsList(); if (cRMAgreementSpecsEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Agreement Specs Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Agreement Specs Information has been updated successfully.", false); } } else { if (cRMAgreementSpecsEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Agreement Specs Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Agreement Specs Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }