public ActionResult Login(LoginView Log, string returnUrl) { if(ModelState.IsValid) { fetchinset f = new fetchinset(); f.UserEmail=Log.UserName; f.Pass=Log.Password; var result = fetchinset.fetchPass(f); if (result.Tables[0].Rows.Count> 0) { return RedirectToAction("Contact","Home"); // return RedirectToAction("Contact"). } else { //return RedirectToAction("Manage", new { Message = ManageMessageId.Error }); ModelState.AddModelError("", "Invalid username or password."); } } else { ModelState.AddModelError("", "Invalid username or password."); } return View(Log); }
public static DataSet fetchPass(fetchinset fet) { DBConnection db = new DBConnection(); db.AddParameter("@Email", fet.UserEmail); db.AddParameter("@Pass", fet.Pass); return(db.ExecuteDataSet("UserLogin")); //if(o!=null) //{ // string x = o.ToString(); //} //return 1; }
public static int Insert(fetchinset f) { DBConnection db = new DBConnection(); db.AddParameter("@Email", f.UserEmail); db.AddParameter("@Pass", f.Pass); db.AddParameter("@CNFpass", f.confmPass); int v = db.ExecuteNonQuery("CreatePro"); if (v > 0) { return(1); } else { return(-1); } }
public static int Insert(fetchinset f) { DBConnection db = new DBConnection(); db.AddParameter("@Email",f.UserEmail); db.AddParameter("@Pass", f.Pass); db.AddParameter("@CNFpass", f.confmPass); int v = db.ExecuteNonQuery("CreatePro"); if(v > 0) { return 1; } else { return -1; } }
public static DataSet fetchPass(fetchinset fet) { DBConnection db = new DBConnection(); db.AddParameter("@Email",fet.UserEmail); db.AddParameter("@Pass", fet.Pass); return db.ExecuteDataSet("UserLogin"); //if(o!=null) //{ // string x = o.ToString(); //} //return 1; }