public DataTable GetVendorCountById(int intVendorId)
{
try
{
DALComponent objDalComp = new DALComponent();
objDalComp.SetParameters("@vendorid", SqlDbType.Int, 4, intVendorId);
objDalComp.SqlCommandText = "[GetVendorCount]";
return objDalComp.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public DataTable SelectCityByStateId(int intStateId)
{
try
{
DALComponent objDalComp = new DALComponent();
objDalComp.SetParameters("@stateId", SqlDbType.Int, 4, intStateId);
objDalComp.SqlCommandText = "[SelectCityByStateId]";
return objDalComp.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public DataTable ForgotPasswordVen(string venEmail)
{
try
{
DALComponent objDALCon = new DALComponent();
objDALCon.SetParameters("@email", SqlDbType.VarChar, 50, venEmail);
objDALCon.SqlCommandText = "[SelectVendorByEmail]";
return objDALCon.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public DataTable AvailableVenMail(string strEmail)
{
try
{
DALComponent objDAL = new DALComponent();
objDAL.SetParameters("@email", SqlDbType.VarChar, 50, strEmail);
objDAL.SqlCommandText = "[AvailableVenMail]";
return (objDAL.SelectRecord());
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public DataTable AvailableCategory(string strCategoryName)
{
try
{
DALComponent objDalComp = new DALComponent();
objDalComp.SetParameters("@catname", SqlDbType.VarChar, 50, strCategoryName);
objDalComp.SqlCommandText = "[AvailableCategory]";
return objDalComp.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public DataTable SelectVenMessageById(int intMsgId)
{
try
{
DALComponent objDALVenMsg = new DALComponent();
objDALVenMsg.SetParameters("@msgid", SqlDbType.Int, 4, intMsgId);
objDALVenMsg.SqlCommandText = "SelectVenMessageById";
return objDALVenMsg.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public DataTable SelectVendorByCategory(int categoryId)
{
try
{
DALComponent objDalComp = new DALComponent();
objDalComp.SetParameters("@cateid", SqlDbType.Int, 4, categoryId);
objDalComp.SqlCommandText = "[SelectVendorByCatid]";
return objDalComp.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}