protected void btnLogin_Click(object sender, EventArgs e)
{
if (txtEmail.Value.Trim() == "")
{
MSG("กรุณาป้อน Email !!!");
return;
}
if (txtPassword.Value.Trim() == "")
{
MSG("กรุณาป้อน Password !!!");
return;
}
MODEL.Criteria.reqLogin req = new MODEL.Criteria.reqLogin();
req.email = txtEmail.Value.Trim();
req.password = txtPassword.Value.Trim();
MODEL.ResultLogin res = new MODEL.ResultLogin();
res = svRestaurant.getLogin(req);
if (res.ResultOk == "true")
{
//HttpContext.Current.Application["app_memberID"] = res.memberID;
//HttpContext.Current.Application["app_restaurantID"] = res.restaurantID;
Session["memberID"] = res.memberID;
Session["restaurantID"] = res.restaurantID;
string URL = @"memberID=" + res.memberID + "&restaurantID=" + res.restaurantID;
URL = svEncrypt.Encrypt(URL, "r0b1nr0y");
Response.Redirect("~/Restaurant/DashboardCashier.aspx?" + URL);
}
else
{
MSG(res.ErroMessage);
}
}
public MODEL.ResultLogin getLogin(MODEL.Criteria.reqLogin req)
{
DAL.Restaurant svRestaurant = new Restaurant();
SqlConnection conn = new SqlConnection(DataHelper.GetConnectionString());
DataSet ds = new DataSet();
ResultLogin res = new ResultLogin();
try
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("select tb_Member.member_id,member_email,member_name,restaurant_id from tb_Member ");
sqlstr.Append(" inner join tb_restaurant on tb_Member.member_id = tb_restaurant.member_id");
sqlstr.Append(" where tb_Member.flag = '1'");
sqlstr.Append(" and member_email = '" + req.email + "'");
sqlstr.Append(" and member_activate = '1'");
sqlstr.Append(" and member_password = '******'");
SqlDataAdapter adp = new SqlDataAdapter(sqlstr.ToString(), conn);
adp.SelectCommand.CommandType = CommandType.Text;
adp.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
res.ResultOk = "true";
res.ReturnMessage = "";
res.ErroMessage = "";
res.memberID = Convert.ToInt32(dt.Rows[0]["member_id"].ToString().Trim());
res.userName = dt.Rows[0]["member_name"].ToString().Trim();
res.email = dt.Rows[0]["member_email"].ToString().Trim();
res.restaurantID = dt.Rows[0]["restaurant_id"].ToString().Trim();
}
else
{
res.ResultOk = "false";
res.ReturnMessage = req.email;
res.ErroMessage = "Not found member !!!";
res.memberID = 0;
res.userName = "";
res.email = "";
res.restaurantID = "";
}
}
catch (Exception ex)
{
res.ResultOk = "false";
res.ReturnMessage = "";
res.ErroMessage = ex.Message;
//throw ex;
}
finally
{
conn.Close();
}
return(res);
}
public Result insertMemberGuest(MODEL.Criteria.reqLogin req)
{
DAL.Restaurant svRestaurant = new Restaurant();
SqlConnection conn = new SqlConnection(DataHelper.GetConnectionString());
DataSet ds = new DataSet();
Result res = new Result();
try
{
Result resChkDupMenber = chkDupMemberGuest(req.email);
if (resChkDupMenber.ResultOk == "true")
{
res.ResultOk = "false";
res.ReturnMessage = "";
res.ErrorMessage = "Already Email Address !!!";
return(res);
}
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("INSERT INTO [tb_Member] (member_email,member_password,member_name,member_activate,member_permission,created_date,flag) values (");
sqlstr.Append("'" + req.email + "','" + req.password + "','" + req.username + "','1','2',getdate(),'1');");
//sqlstr.Append("INSERT INTO [tb_Restaurant] (restaurant_name,menber_id,created_date,flag) values (");
//sqlstr.Append("'" + req.MemberEmail + "','" + req.MemberPassword + "','" + req.MemberName + "','1','1',getdate(),'1');");
conn.Open();
SqlDataAdapter adp = new SqlDataAdapter();
adp.InsertCommand = new SqlCommand(sqlstr.ToString(), conn);
adp.InsertCommand.CommandType = CommandType.Text;
adp.InsertCommand.ExecuteNonQuery();
string MemberID = getLastMemberID();
//svRestaurant.InitialRestaurant(MemberID);
res.ResultOk = "true";
res.ReturnMessage = MemberID;
res.ErrorMessage = "";
}
catch (Exception ex)
{
res.ResultOk = "false";
res.ReturnMessage = "";
res.ErrorMessage = ex.Message;
//throw ex;
}
finally
{
conn.Close();
}
return(res);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (txtMemberName.Value.Trim() == "")
{
MSG("กรุณาป้อน ชื่อ !!!");
return;
}
if (txtEmail.Value.Trim() == "")
{
MSG("กรุณาป้อน Email !!!");
return;
}
if (txtPassword.Value.Trim() == "")
{
MSG("กรุณาป้อน Password !!!");
return;
}
if (txtRePassword.Value.Trim() == "")
{
MSG("กรุณาป้อน Re-Password !!!");
return;
}
if (txtPassword.Value.Trim() != txtRePassword.Value.Trim())
{
MSG("Password not match !!!");
return;
}
MODEL.Criteria.reqLogin model = new MODEL.Criteria.reqLogin();
model.username = txtMemberName.Value.Trim();
model.email = txtEmail.Value.Trim();
model.password = txtPassword.Value.Trim();
MODEL.ResultLogin res = new MODEL.ResultLogin();
res = svRestaurant.insertMember(model);
if (res.ResultOk == "true")
{
//Session["session_memberID"] = res.memberID;
//Session["session_restaurantID"] = res.restaurantID;
//MSG("Success");
//Response.Redirect("~/Restaurant/MemberDetail.aspx?memberID=" + res.ReturnMessage);
Response.Redirect("~/memberLogin.aspx", true);
}
else
{
MSG(res.ErroMessage);
}
}
public ResultLogin Login([FromBody] MODEL.Criteria.reqLogin req)
{
ResultLogin result = new ResultLogin();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.getLoginGuest(req);
}
catch (Exception e)
{
result.ErroMessage = e.Message;
result.ResultOk = "false";
result.ReturnMessage = "";
}
return(result);
}
public Result Register([FromBody] MODEL.Criteria.reqLogin req)
{
Result result = new Result();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.insertMemberGuest(req);
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
result.ReturnMessage = "";
}
return(result);
}
public Result insertMemberGuest(MODEL.Criteria.reqLogin req)
{
return(MemberDAL.insertMemberGuest(req));
}
public MODEL.ResultLogin getLoginGuest(MODEL.Criteria.reqLogin req)
{
return(MemberDAL.getLoginGuest(req));
}
public ResultLogin insertMember(MODEL.Criteria.reqLogin req)
{
return(MemberDAL.insertMember(req));
}
