public IList <CRMAgreementEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <CRMAgreementEntity> cRMAgreementEntityList = new List <CRMAgreementEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = CRMAgreementEntity.FLD_NAME_AgreementID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; cRMAgreementEntityList = FCCCRMAgreement.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (cRMAgreementEntityList != null && cRMAgreementEntityList.Count > 0) { totalRowCount = cRMAgreementEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cRMAgreementEntityList ?? new List <CRMAgreementEntity>()); }
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); } } } }
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); } } } }
public IList <CRMAgreementEntity> GetData() { IList <CRMAgreementEntity> cRMAgreementEntityList = new List <CRMAgreementEntity>(); try { cRMAgreementEntityList = FCCCRMAgreement.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (cRMAgreementEntityList != null && cRMAgreementEntityList.Count > 0) { totalRowCount = cRMAgreementEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cRMAgreementEntityList ?? new List <CRMAgreementEntity>()); }
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 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 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); } } }