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