public string SelectChargeDetailsByID(string strChargeId)
{
try
{
DALComponent objDAL = new DALComponent();
objDAL.SetParameters("@chargeId", SqlDbType.Int, 4, Convert.ToInt32(strChargeId));
objDAL.SqlCommandText = "SelectChargeDetailsByID";
return GetJson(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 GetAdDetailsDT(UserAdpost adpostDetails)
{
try
{
DALComponent objDALComponent1 = new DALComponent();
objDALComponent1.SetParameters("@adpostId", SqlDbType.Int, 4, adpostDetails.AdPostId);
objDALComponent1.SetParameters("@userId", SqlDbType.Int, 4, adpostDetails.UserId);
objDALComponent1.SqlCommandText = "[GetAdDetails]";
return objDALComponent1.SelectRecord();
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}
public string GetAdPurcDetails(string sAdPostID, string sAdUserID)
{
try
{
DALComponent objDAL = new DALComponent();
objDAL.SetParameters("@adpostId", SqlDbType.Int, 4, Convert.ToInt32(sAdPostID));
objDAL.SetParameters("@userId", SqlDbType.Int, 4, Convert.ToInt32(sAdUserID));
objDAL.SqlCommandText = "[GetAdPurcDetails]";
string s = GetJson(objDAL.SelectRecord());
return s;
}
catch (SqlException sqlEx)
{
return sqlEx.Message.ToString();
}
catch (Exception ex)
{
return ex.Message.ToString();
}
}
public string AvailableMail(string strEmail)
{
try
{
DALComponent objDAL = new DALComponent();
objDAL.SetParameters("@email", SqlDbType.VarChar, 50, strEmail);
objDAL.SqlCommandText = "[AvailableMail]";
return GetJson(objDAL.SelectRecord());
}
catch (SqlException sqlEx)
{
throw new ApplicationException("Data error=" + sqlEx.Message.ToString());
}
catch (Exception ex)
{
throw new ApplicationException("Error=" + ex.Message.ToString());
}
}