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); }
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"); }
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"); }
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); }
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"); }
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); } }
//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; } } }
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)); }
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); } }
public int Edit(LineOfBusiness entity) { _context.SbEdit(entity); return(_context.SaveChanges()); }
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); }