public bool SaveNatureofbusiness(BusinessTypeDTO _type) { try { return(obj.SaveBusinessTypes(_type.pBusinesstype)); } catch (Exception) { throw; } }
public bool SaveNatureofbusiness(BusinessTypeDTO _type) { try { return(obj.SaveBusinessTypes(_type, Con)); } catch (Exception ex) { throw new FinstaAppException(ex.ToString()); } }
public bool SaveBusinessTypes(BusinessTypeDTO Businesstype, string ConnectionString) { bool isSaved = false; try { NPGSqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, "insert into tblmstbusinesstypes(businesstype,statusid,createdby,createddate,entrytype)values('" + ManageQuote(Businesstype.pBusinesstype.Trim()) + "'," + getStatusid(Businesstype.pStatusname, ConnectionString) + "," + Businesstype.pCreatedby + ",current_timestamp,'OTHER');"); isSaved = true; } catch (Exception) { throw; } return(isSaved); }
public IActionResult Details(int id) { var foundBusinessType = _db.BusinessTypes.Find(id); if (foundBusinessType == null) { return(NoContent()); } //map and return DTO BusinessTypeDTO businessTypeDTO = new BusinessTypeDTO(); businessTypeDTO.Description = foundBusinessType.Description; return(Ok(businessTypeDTO)); }
public List <BusinessTypeDTO> GetBusinessTypes(string ConnectionString) { lstBusinessType = new List <BusinessTypeDTO>(); try { dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select businesstype from tblmstbusinesstypes"); while (dr.Read()) { BusinessTypeDTO objbusinesstype = new BusinessTypeDTO(); objbusinesstype.pBusinesstype = dr["businesstype"].ToString(); lstBusinessType.Add(objbusinesstype); } } catch (Exception) { throw; } return(lstBusinessType); }