public ActionResult Login(MemberUserObject user)
{
String message = "";
if (ModelState.IsValid)
{
if (c.IsUserExist(user) > 0)
{
message = "success";
}
else
{
message = "user name or password incorrect";
}
}
else
{
message = "All field require";
}
if(Request.IsAjaxRequest())
{
return Json(message, JsonRequestBehavior.AllowGet);
}
else
{
return RedirectToAction("Index","Home");
}
}
public String Login(MemberUserObject user)
{
String message = "";
if (ModelState.IsValid)
{
if (c.IsUserExist(user) > 0)
{
message = "success";
}
else
{
message = "user name or password incorrect";
}
}
else
{
message = "All field require";
}
return message;
}
public void AddEmpDetails(MemberUserObject EmpDetails)
{
try
{
con.Open();
SqlCommand command = new SqlCommand("INSERT INTO ShoppingCart.Users (u_name,u_adress,u_id,u_password,u_email) VALUES (" + EmpDetails.u_name + "," + EmpDetails.u_adress + ", " + EmpDetails.u_id + "," + EmpDetails.u_password + "," + EmpDetails.u_email + "); ", con);
flag = Convert.ToBoolean(command.ExecuteScalar());
if (flag)
{
Console.WriteLine("welcome");
}
}
catch
{
throw;
}
finally
{
con.Dispose();
con.Close();
}
}
public ActionResult Login(MemberUserObject user)
{
String message = "";
if (ModelState.IsValid)
{
if (c.IsUserExist(user) > 0)
{
message = "success";
}
else
{
message = "user name or password incorrect";
}
}
else
{
message = "All field require";
}
if (Request.IsAjaxRequest())
{
return(Json(message, JsonRequestBehavior.AllowGet));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public int IsUserExist(MemberUserObject user)
{
bool flag = false;
con.Open();
SqlCommand command = new SqlCommand("Select u_id From Users Where u_name='" + user.u_name + "' And u_password='******'", con);
return Convert.ToInt32(command.ExecuteScalar());
}
public void IsUserExist(MemberUserObject EmpDetails)
{
bool flag = false;
con.Open();
SqlCommand command = new SqlCommand("Select u_name From ShoppingCart Where u_name='" + EmpDetails.u_name + "' And u_password='******'", con);
flag = Convert.ToBoolean(command.ExecuteScalar());
con.Close();
}
public void InsertUserDetails(MemberUserObject EBO)
{
try
{
DAL.AddEmpDetails(EBO);
}
catch
{
throw;
}
}
public void AddEmpDetails(MemberUserObject EmpDetails)
{
try
{
bool flag = false;
con.Open();
SqlCommand command = new SqlCommand("INSERT INTO ShoppingCart.Users (u_name,u_adress,u_id,u_password) VALUES (" + EmpDetails.u_name + "," + EmpDetails.u_adress + ", " + EmpDetails.u_id + "," + EmpDetails.u_password + "); ", con);
flag = Convert.ToBoolean(command.ExecuteScalar());
}
catch
{
throw;
}
finally
{
con.Dispose();
con.Close();
}
}
public String Login(MemberUserObject user)
{
String message = "";
if (ModelState.IsValid)
{
if (c.IsUserExist(user) > 0)
{
message = "success";
}
else
{
message = "user name or password incorrect";
}
}
else
{
message = "All field require";
}
return(message);
}
public void SelectUserDetails(MemberUserObject EBO)
{
DAL.IsUserExist(EBO);
}
