public static User GetUserLogin(string UserName, string InputPassword)
{
string commandText = string.Format("select * from user where UserName = @UserName;");
DataBaseHandler dbHandler = new DataBaseHandler();
MySqlCommand command = new MySqlCommand(commandText, dbHandler.conn);
command.Parameters.AddWithValue("@UserName", UserName);
//command.Parameters.AddWithValue("@InputPassword", InputPassword);
command.CommandText = commandText;
DataTable dt = dbHandler.SQLExecDataTable(dbHandler.conn, command);
if (dt.Rows.Count > 0)
{
if (InputPassword == Encryption.Decrypt(dt.Rows[0]["Password"].ToString()))
{
User user = new User();
user.UserID = (int)dt.Rows[0]["UserID"];
user.UserName = dt.Rows[0]["UserName"].ToString();
user.UserGroup = (int)dt.Rows[0]["UserGroup"];
user.LoginTime = System.DateTime.Now;
return user;
}
}
return null;
}
public static DataTable GetMember(int ID = 0)
{
System.Text.StringBuilder sb = new StringBuilder();
sb.Append("SELECT MemberID,MemberName,Nickname,Gender,f.Name as FellowShipName,Email,Facebook,Tel,Mobile from member m ");
sb.Append("inner join fellowship f ");
sb.Append("on f.fellowshipID = m.Fellowship ");
if (ID != 0) sb.Append(string.Format("where MemberID = {0}", ID.ToString()));
string commandText = sb.ToString();
DataBaseHandler dbHandler = new DataBaseHandler();
MySqlCommand command = new MySqlCommand(commandText, dbHandler.conn);
command.CommandText = commandText;
DataTable dt = dbHandler.SQLExecDataTable(dbHandler.conn, command);
return dt;
}
public static DataTable GetSpiritGrowPlan(int fellowshipID)
{
string sWhere = "where ";
sWhere += (fellowshipID == 0) ? "1 = 1" : "fellowshipID =" + fellowshipID.ToString();
System.Text.StringBuilder sb = new StringBuilder();
sb.Append("select m.MemberID, m.MemberName,f.Name,bp.BibleStudyPlan,sp.BibleStudy,sp.ChurchActivities,sp.Services,award.Award from member m ");
sb.Append("inner join spiritgrowplan sp on m.memberid = sp.memberid ");
sb.Append("inner join fellowship f on m.Fellowship = f.fellowshipid ");
sb.Append("inner join biblestudyplan bp on bp.BibleStudyPlanID = sp.BibleStudyPlanID ");
sb.Append("inner join award on award.AwardID = sp.AwardID ");
sb.Append(sWhere);
sb.Append(" order by 1");
string commandText = sb.ToString();
DataBaseHandler dbHandler = new DataBaseHandler();
MySqlCommand command = new MySqlCommand(commandText, dbHandler.conn);
command.CommandText = commandText;
DataTable dt = dbHandler.SQLExecDataTable(dbHandler.conn, command);
return dt;
}
public static DataTable GetFellowship()
{
System.Text.StringBuilder sb = new StringBuilder();
sb.Append("select * from fellowship ");
sb.Append("where FellowshipID <> 26 ");
sb.Append("order by 1");
string commandText = sb.ToString();
DataBaseHandler dbHandler = new DataBaseHandler();
MySqlCommand command = new MySqlCommand(commandText, dbHandler.conn);
command.CommandText = commandText;
DataTable dt = dbHandler.SQLExecDataTable(dbHandler.conn, command);
return dt;
}