public static bool UpdateCounselingStatus(int counselingID, bool processed)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_UpdateCounselingStatus";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CounselingID";
dbParam.Value = counselingID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@Processed";
dbParam.Value = processed;
dbParam.DbType = DbType.Boolean;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
int result = -1;
try
{
result = BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result != -1);
}
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 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 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 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 bool DeleteNews(int newsID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_DeleteNews";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@NewsID";
dbParam.Value = newsID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
int result = -1;
try
{
result = BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result != -1);
}
public static bool AddContentToCategory(int contentID, int categoryID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_AddContentToCategory";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@ContentID";
dbParam.Value = contentID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryID";
dbParam.Value = categoryID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
int result = -1;
try
{
result = BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result != -1);
}
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 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 bool UpdateCaseFileName(int caseID, string caseFileName)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_UpdateCaseFileName";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CaseID";
dbParam.Value = caseID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CaseFileName";
dbParam.Value = caseFileName;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
int result = -1;
try
{
result = BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result != -1);
}
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 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 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 bool CheckMemberID(string memberID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Admin_Members_CheckMemberID";
DbParameter param = dbComm.CreateParameter();
param.ParameterName = "@MemberID";
param.Value = memberID;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
int count;
try
{
count = int.Parse(BaseDB.ExecuteScalar(dbComm));
}
catch (Exception exc)
{
throw exc;
}
return(count > 0);
}
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 bool UpdateSectionDetails(int sectionID, string sectionName, bool sectionAvailable, string sectionDesc, int sectionorder)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_UpdateSection";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@SectionName";
dbParam.Value = sectionName;
dbParam.Size = 125;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@SectionDesc";
dbParam.Value = sectionDesc;
dbParam.Size = 255;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@SectionAvailable";
dbParam.Value = sectionAvailable;
dbParam.DbType = DbType.Boolean;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@SectionID";
dbParam.Value = sectionID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@sectionorder";
dbParam.Value = sectionorder;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
int result = -1;
try
{
result = BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(result != -1);
}
public static int AddNewCategory(string categoryName, string categoryDesc, int sectionID, int parentID)
{
int categoryID = 0;
//Add Section
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_AddNewCategory";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryName";
dbParam.Value = categoryName;
dbParam.Size = 125;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryDesc";
dbParam.Value = categoryDesc;
dbParam.Size = 255;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@SectionID";
dbParam.Value = sectionID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@ParentID";
dbParam.Value = parentID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
try
{
categoryID = int.Parse(BaseDB.ExecuteScalar(dbComm));
}
catch (Exception exc)
{
throw exc;
}
//bool urlUpdated = AdminURL.UpdateID(categoryURL, categoryID);
return(categoryID);
}
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 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 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 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 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 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 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 void DeleteMember(string memberID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Admin_Members_DeleteMember";
DbParameter param = dbComm.CreateParameter();
param.ParameterName = "@MemberID";
param.Value = memberID;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
try
{
BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
}
public static void DeleteCategory(int categoryID)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_DeleteCategory";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryID";
dbParam.Value = categoryID;
dbParam.DbType = DbType.Int32;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
try
{
BaseDB.ExecuteNonQuery(dbComm);
}
catch (Exception exc)
{
throw exc;
}
}
public static int AddNewSection(string sectionName, string sectionDesc)
{
int sectionID = 0;
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_AddNewSection";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryName";
dbParam.Value = sectionName;
dbParam.Size = 125;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@CategoryDesc";
dbParam.Value = sectionDesc;
dbParam.Size = 255;
dbParam.DbType = DbType.String;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
try
{
sectionID = int.Parse(BaseDB.ExecuteScalar(dbComm));
}
catch (Exception exc)
{
throw exc;
}
//bool urlUpdated = AdminURL.UpdateID(sectionURL, sectionID);
return(sectionID);
}
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);
}
public static int UpdateMemberInfo(string memberID, string password, string email, string fname, string lname,
string korName, string phone, string address, string address2, string city,
string state, string zip, string progressStatus, bool activeStatus, DateTime joined)
{
DbCommand dbComm = BaseDB.CreateCommand();
dbComm.CommandText = "E_Admin_Members_UpdateMemberInfo";
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);
param = dbComm.CreateParameter();
param.ParameterName = "@Email";
param.Value = email;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@FName";
param.Value = fname;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@LName";
param.Value = lname;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@KorName";
param.Value = korName;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@Phone";
param.Value = phone;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@Address";
param.Value = address;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@Address2";
param.Value = address2;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@City";
param.Value = city;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@State";
param.Value = state;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@Zip";
param.Value = zip;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@ProgressStatus";
param.Value = progressStatus;
param.DbType = DbType.String;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@ActiveStatus";
param.Value = activeStatus;
param.DbType = DbType.Boolean;
dbComm.Parameters.Add(param);
param = dbComm.CreateParameter();
param.ParameterName = "@Joined";
param.Value = joined;
param.DbType = DbType.DateTime;
dbComm.Parameters.Add(param);
int id;
try
{
id = int.Parse(BaseDB.ExecuteScalar(dbComm));
}
catch (Exception exc)
{
throw exc;
}
return(id);
}
