public bool SaveAddressType(contactAddressDTO _address)
{
try
{
return(obj.SaveAddressType(_address.pAddressType));
}
catch (Exception)
{
throw;
}
}
public bool SaveAddressType(contactAddressDTO _address)
{
try
{
return(obj.SaveAddressType(_address, Con));
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
}
public bool SaveAddressType(contactAddressDTO addresstype, string ConnectionString)
{
bool isSaved = false;
try
{
NPGSqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, "insert into tblmstaddresstypes(contacttype,addresstype,statusid,createdby,createddate)values('" + ManageQuote(addresstype.pContactType) + "','" + ManageQuote(addresstype.pAddressType.Trim()) + "'," + getStatusid(addresstype.pStatusname, ConnectionString) + "," + addresstype.pCreatedby + ",current_timestamp);");
isSaved = true;
}
catch (Exception)
{
throw;
}
return(isSaved);
}
public List <contactAddressDTO> GetAddressType(string ConnectionString)
{
lstAddressDetails = new List <contactAddressDTO>();
try
{
dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select ADDRESSTYPE from TBLMSTADDRESSTYPES");
while (dr.Read())
{
contactAddressDTO objaddressdetails = new contactAddressDTO();
objaddressdetails.pAddressType = dr["ADDRESSTYPE"].ToString();
lstAddressDetails.Add(objaddressdetails);
}
}
catch (Exception)
{
throw;
}
return(lstAddressDetails);
}
public List <contactAddressDTO> GetAddressType(string contactype, string ConnectionString)
{
lstAddressDetails = new List <contactAddressDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select ADDRESSTYPE from TBLMSTADDRESSTYPES where upper(contacttype)='" + contactype.ToUpper() + "' order by ADDRESSTYPE"))
{
while (dr.Read())
{
contactAddressDTO objaddressdetails = new contactAddressDTO();
objaddressdetails.pAddressType = dr["ADDRESSTYPE"].ToString();
lstAddressDetails.Add(objaddressdetails);
}
}
}
catch (Exception)
{
throw;
}
return(lstAddressDetails);
}
