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