public string TechAgencyDelete(techagency_prop techagencyprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_TechAgency_delete", new object[] { techagencyprop.TechAgencyName }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public DataTable TechAgencySelect(techagency_prop techagencyprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_TechAgency_Select", new object[] { techagencyprop.id }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public string TechAgencyUpdate(techagency_prop techagencyprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_TechAgency_Update", new object[] { techagencyprop.TechAgencyName, techagencyprop.Address, techagencyprop.Phone, techagencyprop.Fax, techagencyprop.Email }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}
public DataTable TechAgencySelect(techagency_prop techagencyprop)
{
try
{
techagencydal = new techagency_dal();
DataTable dt = techagencydal.TechAgencySelect(techagencyprop);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public string TechAgencyDelete(techagency_prop techagencyprop)
{
try
{
techagencydal = new techagency_dal();
string strMsg = techagencydal.TechAgencyDelete(techagencyprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
