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