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);
        }
Beispiel #3
0
        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);
                }
            }
        }
Beispiel #4
0
        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);
        }
Beispiel #6
0
        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;
            }
        }
Beispiel #7
0
        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));
 }
Beispiel #13
0
 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 = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType+"_"+cRMAgreementSpecsEntity.Item +"_IName"+ result.ToString() + "%&gt;";
                                //    ent.Value = cRMAgreementSpecsEntity.Item;
                                //    break;
                                //case 2:
                                //    ent.Name = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + ddlBrandID.SelectedItem + "_IBrand_" + result.ToString() + "%&gt;";
                                //    ent.Value = ddlBrandID.SelectedItem.ToString();
                                //    break;
                                //case 3:
                                //    ent.Name = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Item+"_IQty_"+ result.ToString()+ "%&gt;";
                                //    ent.Value = cRMAgreementSpecsEntity.BayQty.ToString();
                                //    break;
                                //case 4:
                                //    ent.Name = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Item+"_IPrice_"+ result.ToString()+"%&gt;";
                                //    ent.Value = cRMAgreementSpecsEntity.BayPrice.ToString();
                                //    break;
                                //case 5:
                                //    ent.Name = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_" + cRMAgreementSpecsEntity.Field1+ "_IUnit_"+ result.ToString() + "%&gt;";
                                //    ent.Value = cRMAgreementSpecsEntity.Field1.ToString();
                                //    break;

                                case 1:
                                    ent.Name  = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IName" + result.ToString() + "%&gt;";
                                    ent.Value = cRMAgreementSpecsEntity.Item;
                                    break;

                                case 2:
                                    ent.Name  = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IBrand_" + result.ToString() + "%&gt;";
                                    ent.Value = ddlBrandID.SelectedItem.ToString();
                                    break;

                                case 3:
                                    ent.Name  = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IQty_" + result.ToString() + "%&gt;";
                                    ent.Value = cRMAgreementSpecsEntity.BayQty.ToString();
                                    break;

                                case 4:
                                    ent.Name  = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IPrice_" + result.ToString() + "%&gt;";
                                    ent.Value = cRMAgreementSpecsEntity.BayPrice.ToString();
                                    break;

                                case 5:
                                    ent.Name  = "&lt;%$$" + cRMAgreementSpecsEntity.AgreementSpecsType + "_IUnit_" + result.ToString() + "%&gt;";
                                    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);
                }
            }
        }