示例#1
0
        public void UpdateLob(LineOfBusiness lineOfBusiness)
        {
            int    maxId;
            string query = string.Empty;

            switch (lineOfBusiness.Action.ToUpper())
            {
            case "I":
                maxId = GetMaxId("tblLineOfBusiness", "Id") + 1;
                query = "INSERT INTO [tblLineOfBusiness]([Id],[PicUrl],[Header],[ButtonLink])VALUES(" + maxId + ",'" + lineOfBusiness.PicUrl + "','" + lineOfBusiness.Header + "','" + lineOfBusiness.Link + "');";
                break;

            case "U":
                maxId = GetMaxId("tblLineOfBusiness", "Id") + 1;
                query = "UPDATE [tblLineOfBusiness] SET PicUrl = '" + lineOfBusiness.PicUrl + "',Header='" + lineOfBusiness.Header + "',ButtonLink='" + lineOfBusiness.Link + "' WHERE Id =" + lineOfBusiness.LobName;
                break;

            case "D":
                maxId = GetMaxId("tblLineOfBusiness", "Id") + 1;
                query = "INSERT INTO [tblLineOfBusiness]([Id],[PicUrl],[Header],[ButtonLink])VALUES(" + maxId + ",'" + lineOfBusiness.PicUrl + "','" + lineOfBusiness.Header + "','" + lineOfBusiness.Link + "');";
                break;

            default:
                break;
            }

            ExecuteNonQuery(query);
        }
示例#2
0
 public void Should_return_instance_of_LineOfBusiness_for_credit_balance()
 {
     LineOfBusiness lob = new LineOfBusiness(LineOfBusiness.Abbreviation.CB);
     Assert.IsNotNull(lob);
     Assert.AreEqual(lob.ShortName, "CB");
     Assert.AreEqual(lob.Name, "Credit Balance");
 }
示例#3
0
 public void Should_return_instance_of_LineOfBusiness_for_data_mining()
 {
     LineOfBusiness lob = new LineOfBusiness(LineOfBusiness.Abbreviation.DM);
     Assert.IsNotNull(lob);
     Assert.AreEqual(lob.ShortName, "DM");
     Assert.AreEqual(lob.Name, "Data Mining");
 }
示例#4
0
        public List <LineOfBusiness> LineOfBusiness()
        {
            List <LineOfBusiness> lstMSNews = new List <LineOfBusiness>();

            using (DataSet ds = dataAccess.LineOfBusiness())
            {
                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow dataRow in ds.Tables[0].Rows)
                    {
                        LineOfBusiness lineOfBusiness = new LineOfBusiness()
                        {
                            Header = Helper.GetDbValue(dataRow["Header"]),
                            Id     = Helper.ConvertToInt(dataRow["Id"]),
                            Link   = Helper.GetDbValue(dataRow["ButtonLink"]),
                            PicUrl = Helper.GetDbValue(dataRow["PicUrl"]),
                        };

                        lstMSNews.Add(lineOfBusiness);
                    }
                }
            }

            return(lstMSNews);
        }
示例#5
0
 public void Should_change_name_when_shortname_changes()
 {
     LineOfBusiness lob = new LineOfBusiness(LineOfBusiness.Abbreviation.CB);
     Assert.IsNotNull(lob);
     Assert.AreEqual(lob.ShortName, "CB");
     lob.ShortName = LineOfBusiness.Abbreviation.DM.ToString();
     Assert.AreEqual(lob.ShortName, "DM");
     Assert.AreEqual(lob.Name, "Data Mining");
 }
示例#6
0
 public string UpdateLob(LineOfBusiness lineOfBusiness)
 {
     try
     {
         dataAccess.UpdateLob(lineOfBusiness);
         return("OK");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        public string UpdateLineOfBusiness(LineOfBusiness lineOfBusiness)
        {
            try
            {
                //if (Helper.Encrypt("bhuvicare").Equals(lineOfBusiness.UserInfo.UserName) && Helper.Encrypt("BhuviCare@004").Equals(lineOfBusiness.UserInfo.Password))
                //{
                Business business = new Business();
                return(business.UpdateLob(lineOfBusiness));
                //}

                //return "Invalid Credentials";
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
示例#8
0
        //Add Data From Linked Tables for Display
        public void EditForDisplay(ClientSubUnitClientAccount clientSubUnitClientAccount)
        {
            ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
            ClientAccount           clientAccount           = new ClientAccount();

            clientAccount = clientAccountRepository.GetClientAccount(clientSubUnitClientAccount.ClientAccountNumber, clientSubUnitClientAccount.SourceSystemCode);
            if (clientAccount != null)
            {
                clientSubUnitClientAccount.ClientAccountName = clientAccount.ClientAccountName;
            }

            ClientSubUnitRepository clientSubUnitRepository = new ClientSubUnitRepository();
            ClientSubUnit           clientSubUnit           = new ClientSubUnit();

            clientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitClientAccount.ClientSubUnitGuid);
            if (clientSubUnit != null)
            {
                clientSubUnitClientAccount.ClientSubUnitName = clientSubUnit.ClientSubUnitName;
            }

            ConfidenceLevelForLoadRepository confidenceLevelForLoadRepository = new ConfidenceLevelForLoadRepository();
            ConfidenceLevelForLoad           confidenceLevelForLoad           = new ConfidenceLevelForLoad();

            if (clientSubUnitClientAccount.ConfidenceLevelForLoadId != null)
            {
                int confidenceLevelForLoadId = (int)clientSubUnitClientAccount.ConfidenceLevelForLoadId;
                confidenceLevelForLoad = confidenceLevelForLoadRepository.GetConfidenceLevelForLoad(confidenceLevelForLoadId);
                if (confidenceLevelForLoad != null)
                {
                    clientSubUnitClientAccount.ConfidenceLevelForLoadDescription = confidenceLevelForLoad.ConfidenceLevelForLoadDescription;
                }
            }

            LineOfBusinessRepository lineOfBusinessRepository = new LineOfBusinessRepository();
            LineOfBusiness           lineOfBusiness           = new LineOfBusiness();

            if (clientSubUnitClientAccount.ClientAccountLineOfBusinessId != null)
            {
                int lineOfBusinessId = (int)clientSubUnitClientAccount.ClientAccountLineOfBusinessId;
                lineOfBusiness = lineOfBusinessRepository.GetLineOfBusiness(lineOfBusinessId);
                if (lineOfBusiness != null)
                {
                    clientSubUnitClientAccount.LineOfBusiness = lineOfBusiness;
                }
            }
        }
示例#9
0
        public IActionResult Post([FromBody] CreateEditViewModel model)
        {
            var data = new LineOfBusiness();

            if (model is null)
            {
                return(BadRequest("Data is null."));
            }

            if (!ModelState.IsValid)
            {
                return(BadRequest());
            }
            _mapper.Map(model, data);
            _LineOfBusinessProvider.Add(data);
            return(Ok(data));
        }
示例#10
0
        public NewBudgetLine(ILogger logger, int companyId, LineOfBusiness lob, CostOrigin mpk, Project proj,
                             string description = null, int?year = null)
        {
            this._companyId   = companyId;
            this._description = description;
            this._year        = year;
            this._lob         = lob;
            this._mpk         = mpk;
            this._proj        = proj;

            _symbolName = string.Format("{0} {1} {2} {3}",
                                        _lob.CostType.ToString().Substring(0, 1),
                                        _mpk.Name,
                                        _lob.Name,
                                        _proj.Name);
            if (_symbolName.Length > 45)
            {
                logger?.LogWarning($"\nSymbol name \"{_symbolName}\" is longer than 45 characters - truncating...");
                _symbolName = _symbolName.Substring(0, 45);
            }
        }
示例#11
0
 public int Edit(LineOfBusiness entity)
 {
     _context.SbEdit(entity);
     return(_context.SaveChanges());
 }
示例#12
0
 public int Add(LineOfBusiness entity)
 {
     _context.SbAdd(entity);
     return(_context.SaveChanges());
 }
        //Get one Item
        public ClientSubUnit GetClientSubUnit(string id)
        {
            ClientSubUnit clientSubUnit = new ClientSubUnit();

            clientSubUnit = db.ClientSubUnits.SingleOrDefault(c => c.ClientSubUnitGuid == id);
            if (clientSubUnit != null)
            {
                //RestrictedClientFlag
                ClientSubUnitAttribute clientSubUnitAttributeRestrictedClient = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "RestrictedClientFlag");
                if (clientSubUnitAttributeRestrictedClient != null && clientSubUnitAttributeRestrictedClient.AttributeValue != null)
                {
                    //Attribute saved as a varchar
                    clientSubUnit.RestrictedClient = (clientSubUnitAttributeRestrictedClient.AttributeValue == "1");
                }

                //PrivateClientFlag
                ClientSubUnitAttribute clientSubUnitAttributePrivateClient = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "PrivateClientFlag");
                if (clientSubUnitAttributePrivateClient != null && clientSubUnitAttributePrivateClient.AttributeValue != null)
                {
                    //Attribute saved as a varchar
                    clientSubUnit.PrivateClient = (clientSubUnitAttributePrivateClient.AttributeValue == "1");
                }

                //CubaBookingAllowedFlag
                ClientSubUnitAttribute cubaBookingAllowedFlag = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "CubaBookingAllowedFlag");
                if (cubaBookingAllowedFlag != null && cubaBookingAllowedFlag.AttributeValue != null)
                {
                    //Attribute saved as a varchar
                    clientSubUnit.CubaBookingAllowed = (cubaBookingAllowedFlag.AttributeValue == "1");
                }

                //InCountryServiceOnlyFlag
                ClientSubUnitAttribute inCountryServiceOnlyFlag = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "InCountryServiceOnlyFlag");
                if (inCountryServiceOnlyFlag != null && inCountryServiceOnlyFlag.AttributeValue != null)
                {
                    //Attribute saved as a varchar
                    clientSubUnit.InCountryServiceOnly = (inCountryServiceOnlyFlag.AttributeValue == "1");
                }

                //24HourServiceCenterTelephoneNumber
                ClientSubUnitAttribute clientSubUnitAttribute24Hours = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "24HourServiceCenterTelephoneNumber");
                if (clientSubUnitAttribute24Hours != null && clientSubUnitAttribute24Hours.AttributeValue != null)
                {
                    clientSubUnit.DialledNumber24HSC = clientSubUnitAttribute24Hours.AttributeValue;
                }

                //Line of Business
                ClientSubUnitLineOfBusinessRepository clientSubUnitLineOfBusinessRepository = new ClientSubUnitLineOfBusinessRepository();
                ClientSubUnitLineOfBusiness           clientSubUnitLineOfBusiness           = clientSubUnitLineOfBusinessRepository.GetClientSubUnitLineOfBusiness(clientSubUnit.ClientSubUnitGuid);
                if (clientSubUnitLineOfBusiness != null)
                {
                    LineOfBusinessRepository lineOfBusinessRepository = new LineOfBusinessRepository();
                    LineOfBusiness           lineOfBusiness           = lineOfBusinessRepository.GetLineOfBusiness(clientSubUnitLineOfBusiness.LineOfBusinessId);
                    if (lineOfBusiness != null)
                    {
                        clientSubUnit.LineOfBusiness = lineOfBusiness;
                    }

                    clientSubUnit.LineOfBusinessId = clientSubUnitLineOfBusiness.LineOfBusinessId;
                }

                //BranchContactNumber
                ClientSubUnitAttribute clientSubUnitAttributeBranchContactNumber = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "BranchContactNumber");
                if (clientSubUnitAttributeBranchContactNumber != null && clientSubUnitAttributeBranchContactNumber.AttributeValue != null)
                {
                    clientSubUnit.BranchContactNumber = clientSubUnitAttributeBranchContactNumber.AttributeValue;
                }

                //BranchFaxNumber
                ClientSubUnitAttribute clientSubUnitAttributeBranchFaxNumber = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "BranchFaxNumber");
                if (clientSubUnitAttributeBranchFaxNumber != null && clientSubUnitAttributeBranchFaxNumber.AttributeValue != null)
                {
                    clientSubUnit.BranchFaxNumber = clientSubUnitAttributeBranchFaxNumber.AttributeValue;
                }

                //BranchEmail
                ClientSubUnitAttribute clientSubUnitAttributeBranchEmail = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "BranchEmail");
                if (clientSubUnitAttributeBranchEmail != null && clientSubUnitAttributeBranchEmail.AttributeValue != null)
                {
                    clientSubUnit.BranchEmail = clientSubUnitAttributeBranchEmail.AttributeValue;
                }

                //ClientIATA
                ClientSubUnitAttribute clientSubUnitAttributeClientIATA = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "ClientIATA");
                if (clientSubUnitAttributeClientIATA != null && clientSubUnitAttributeClientIATA.AttributeValue != null)
                {
                    clientSubUnit.ClientIATA = clientSubUnitAttributeClientIATA.AttributeValue;
                }

                //PortraitStatusDescription
                ClientSubUnitAttribute clientSubUnitAttributePortraitStatusDescription = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "PortraitStatusDescription");
                if (clientSubUnitAttributePortraitStatusDescription != null && clientSubUnitAttributePortraitStatusDescription.AttributeValue != null)
                {
                    clientSubUnit.PortraitStatusDescription = clientSubUnitAttributePortraitStatusDescription.AttributeValue;
                }

                //ClientBusinessDescription
                ClientSubUnitAttribute clientSubUnitAttributeClientBusinessDescription = clientSubUnitAttributeRepository.GetClientSubUnitAttributeByType(clientSubUnit.ClientSubUnitGuid, "ClientBusinessDescription");
                if (clientSubUnitAttributeClientBusinessDescription != null && clientSubUnitAttributeClientBusinessDescription.AttributeValue != null)
                {
                    clientSubUnit.ClientBusinessDescription = clientSubUnitAttributeClientBusinessDescription.AttributeValue;
                }
            }

            return(clientSubUnit);
        }