public bool SaveEnterpriseType(EnterpriseTypeDTO _Enterprise)
{
try
{
return(obj.SaveAddressType(_Enterprise.pEnterpriseType));
}
catch (Exception)
{
throw;
}
}
public bool SaveEnterpriseType(EnterpriseTypeDTO _Enterprise)
{
try
{
return(obj.SaveEnterpriseType(_Enterprise, Con));
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
}
public bool SaveEnterpriseType(EnterpriseTypeDTO Enterprisetype, string ConnectionString)
{
bool isSaved = false;
try
{
NPGSqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, "insert into tblmstenterprisetypes(enterprisetype,statusid,createdby,createddate,entrytype)values('" + ManageQuote(Enterprisetype.pEnterpriseType.Trim()) + "'," + getStatusid(Enterprisetype.pStatusname, ConnectionString) + "," + Enterprisetype.pCreatedby + ",current_timestamp,'OTHER');");
isSaved = true;
}
catch (Exception)
{
throw;
}
return(isSaved);
}
public List <EnterpriseTypeDTO> GetEnterpriseType()
{
try
{
dr = NPGSqlHelper.ExecuteReader(NPGSqlHelper.SQLConnString, CommandType.Text, "select ENTERPRISETYPE from TBLMSTENTERPRISETYPES");
while (dr.Read())
{
EnterpriseTypeDTO objenterprise = new EnterpriseTypeDTO();
objenterprise.pEnterpriseType = dr["ENTERPRISETYPE"].ToString();
lstEnterpriseType.Add(objenterprise);
}
}
catch (Exception)
{
throw;
}
return(lstEnterpriseType);
}
public List <EnterpriseTypeDTO> GetEnterpriseType(string ConnectionString)
{
lstEnterpriseType = new List <EnterpriseTypeDTO>();
try
{
dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select enterprisetype from tblmstenterprisetypes");
while (dr.Read())
{
EnterpriseTypeDTO objenterprise = new EnterpriseTypeDTO();
objenterprise.pEnterpriseType = dr["enterprisetype"].ToString();
lstEnterpriseType.Add(objenterprise);
}
}
catch (Exception)
{
throw;
}
return(lstEnterpriseType);
}
