Exemplo n.º 1
0
 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;
     }
 }
Exemplo n.º 2
0
 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;
     }
 }
Exemplo n.º 3
0
 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;
     }
 }
Exemplo n.º 4
0
 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);
     }
 }
Exemplo n.º 5
0
 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("");
     }
 }