public DataTable ImpAgencySearch(impagency_prop impagencyprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_ImpAgency_search", new object[] { impagencyprop.ImpAgencyName }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public string ImpAgencyDelete(impagency_prop impagencyprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_ImpAgency_delete", new object[] { impagencyprop.ImpAgencyName }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public string ImpAgencyUpdate(impagency_prop impagencyprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_ImpAgency_Update", new object[] { impagencyprop.ImpAgencyName, impagencyprop.Address, impagencyprop.Phone, impagencyprop.Fax, impagencyprop.Email, impagencyprop.ProductId, impagencyprop.ProductType }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public DataTable ImpAgencySearch(impagency_prop impagencyprop)
{
try
{
impagencydal = new impagency_dal();
DataTable dt = impagencydal.ImpAgencySearch(impagencyprop);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public string ImpAgencyDelete(impagency_prop impagencyprop)
{
try
{
impagencydal = new impagency_dal();
string strMsg = impagencydal.ImpAgencyDelete(impagencyprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}