public static DataTable GetProgress(int progressID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Admin_Progress_GetProgress";
DbParameter param = dbComm.CreateParameter();
param.ParameterName = "@ProgressID";
param.Value = progressID;
param.DbType = DbType.Int32;
dbComm.Parameters.Add(param);
DataTable p;
try
{
p = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(p);
}
public static DataTable GetCounseling(int counselingID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetCounseling";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CounselingID";
dbParam.Value = counselingID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable result;
try
{
result = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result);
}
public static DataTable GetMemberInfo(string memberId, string password)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Admin_Members_GetMemberInfo";
DbParameter param = dbComm.CreateParameter();
param.ParameterName = "@MemberID";
param.Value = memberId;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@Password";
param.Value = password;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
DataTable states;
try
{
states = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(states);
}
public static DataTable SearchAdminUser(string userID, string password)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_SearchAdminUser";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@UserID";
dbParam.Value = userID;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@Password";
dbParam.Value = password;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable usertable;
try
{
usertable = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(usertable);
}
public static DataTable GetSubCategories(int categoryID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Front_Sections_GetSubSections";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryID";
dbParam.Value = categoryID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable fieldData;
try
{
fieldData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(fieldData);
}
public static DataTable GetSection(int sectionID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetSection";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@SectionID";
dbParam.Value = sectionID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable sectionData;
try
{
sectionData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(sectionData);
}
public static DataTable GetNews(int newsID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetNews";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@NewsID";
dbParam.Value = newsID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable content;
try
{
content = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(content);
}
public static DataTable GetProgressList(string memberID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Front_Progress_GetProgressList";
DbParameter param = dbComm.CreateParameter();
param.ParameterName = "@MemberID";
param.Value = memberID;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
DataTable p;
try
{
p = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(p);
}
public static DataTable GetFrontOtherList(int ordersNumber)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Front_Other_GetFrontOtherList";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@OrdersNumber";
dbParam.Value = ordersNumber;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable content;
try
{
content = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(content);
}
public static DataTable GetSucess(int ID, int Cat)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "up_board_retrieveby";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@UID";
dbParam.Value = ID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@BoardCatID";
dbParam.Value = Cat;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable content;
try
{
content = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(content);
}
public static DataTable GetsucessList(int aa, string fdate, string tdate, int bb)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "up_board_retrieve_list";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@UID";
dbParam.Value = "0";
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@DateFrom";
dbParam.Value = fdate;
dbParam.DbType = DbType.DateTime;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@DateTo";
dbParam.Value = tdate;
dbParam.DbType = DbType.DateTime;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@BoardCatID";
dbParam.Value = "0";
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable content;
try
{
content = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(content);
}
public static DataTable GetMembers()
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Admin_Members_GetMembers";
DataTable members;
try
{
members = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(members);
}
public static DataTable GetSections()
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetSections";
DataTable sectionData;
try
{
sectionData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(sectionData);
}
public static DataTable GetCategories()
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetAllCategories";
DataTable categoryData;
try
{
categoryData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(categoryData);
}
public static DataTable GetCaseList(int pageNumber, int casesPerPage, out int howManyPages)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Front_Case_GetFrontCaseList";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@PageNumber";
dbParam.Value = pageNumber;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CasesPerPage";
dbParam.Value = casesPerPage;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@HowManyCases";
dbParam.Direction = ParameterDirection.Output;
dbParam.DbType = DbType.Int32;
dbComm.Parameters.Add(dbParam);
DataTable fieldData;
try
{
fieldData = BaseDB.ExecuteSelect(dbComm);
int howManyCases = Int32.Parse(dbComm.Parameters["@HowManyCases"].Value.ToString());
howManyPages = (int)Math.Ceiling((double)howManyCases / (double)casesPerPage);
}
catch (Exception exc)
{
throw exc;
}
return(fieldData);
}
public static DataTable GetNewsList()
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetNewsList";
DataTable contents;
try
{
contents = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(contents);
}
public static DataTable GetCounselings()
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_GetCounselings";
DataTable result;
try
{
result = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result);
}
public static DataTable GetAllCategories()
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Front_Sections_GetAllCategories";
dbComm.CommandType = CommandType.StoredProcedure;
DataTable fieldData;
try
{
fieldData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(fieldData);
}
public static int CountSubCategoriesInCategory(int categoryID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Front_Categories_CountSubCategoriesInCategory";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryID";
dbParam.Value = categoryID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable fieldData;
try
{
fieldData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
if (fieldData.Rows.Count > 0)
{
int prodCount = 0;
int.TryParse(fieldData.Rows[0]["Total"].ToString(), out prodCount);
if (prodCount > 0)
{
return(prodCount);
}
}
return(0);
}