public DataTable CounterSearch(counter_Prop counterprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Counter_Search", new object[] { counterprop.CounterName }).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
public string CounterUpdate(counter_Prop counterprop)
{
try
{
return(SqlHelper.ExecuteNonQuery(com.con, "usp_Counter_UPDATE", new object[] { counterprop.Counterid, counterprop.CounterName, counterprop.Address, counterprop.ContactPerson, counterprop.ContactNo }).ToString());
}
catch (Exception ex)
{
throw ex;
}
}
public string CounterInsert(counter_Prop counterprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Counter_INSERT", new object[] { counterprop.CounterName, counterprop.Address, counterprop.ContactPerson, counterprop.ContactNo }).Tables[0].Rows[0][0].ToString());
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable fillUser(counter_Prop counterprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_User_Select", new object[] { counterprop.Counterid }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable CounterSelect(counter_Prop counterprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Counter_select", new object[] { counterprop.Counterid }).Tables[0]);
}
catch (Exception Ex)
{
throw Ex;
}
}
public string CounterDelete(counter_Prop counterprop)
{
try
{
return(SqlHelper.ExecuteNonQuery(com.con, "usp_Counter_DELETE", new object[] { counterprop.Counterid }).ToString());
}
catch (Exception Ex)
{
throw Ex;
}
}
public DataTable fillUser(counter_Prop counterProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.fillUser(counterProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public string CounterDelete(counter_Prop counterprop)
{
try
{
counterdal = new counter_dal();
string strmsg = counterdal.CounterDelete(counterprop);
return(strmsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
public DataTable CounterSearch(counter_Prop counterprop)
{
try
{
counterdal = new counter_dal();
DataTable dt = counterdal.CounterSearch(counterprop);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}