public ActionResult editUser(userMaster ur)
{
if (ModelState.IsValid)
{
using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"))
{
if (ur.userId > 0)
{
var v = db.userMasters.Where(a => a.userId == ur.userId).FirstOrDefault();
if (v != null)
{
v.firstName = ur.firstName;
v.lastName = ur.lastName;
v.dob = ur.dob;
v.gender = ur.gender;
v.address = ur.address;
v.city = ur.city;
v.state = ur.state;
v.countryId = ur.countryId;
v.contactNo = ur.contactNo;
v.emailID = ur.emailID;
db.SubmitChanges();
}
}
else
{
}
db.SubmitChanges();
}
}
return(View());
}
public ActionResult addUser(userMaster ur)
{
if (!ModelState.IsValid)
{
ViewBag.error = "Invalid Request";
return(View(ur));
}
OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True");
userMaster um = new userMaster();
um.firstName = ur.firstName;
um.lastName = ur.lastName;
um.dob = ur.dob;
um.gender = ur.gender;
um.address = ur.address;
um.city = ur.city;
um.state = ur.state;
um.countryId = ur.countryId;
um.contactNo = ur.contactNo;
um.emailID = ur.emailID;
um.password = ur.password;
db.userMasters.InsertOnSubmit(um);
db.SubmitChanges();
ViewBag.success = "Successfully Added New User";
return(View());
}
public ActionResult delteUser(int id, userMaster ur)
{
using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"))
{
userMaster v = db.userMasters.Where(x => x.userId == ur.userId).Single <userMaster>();
db.userMasters.DeleteOnSubmit(ur);
db.SubmitChanges();
return(RedirectToAction("Index", "ManageUser"));
}
/* using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"))
* {
* var v = db.userMasters.Where(a => a.userId == id).FirstOrDefault();
* if (v != null)
* {
*
* db.userMasters.DeleteOnSubmit(v);
* db.SubmitChanges();
* RedirectToAction("Index");
* }
* else
* {
* return View("deleteUser");
* }
*
*/
}
// GET: ManageUser
public ActionResult Index()
{
OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True");
var user = db.userMasters.OrderBy(emp => emp.firstName).ToList();
return(View(user));
}
public ActionResult editUser(int id)
{
using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"))
{
var v = db.userMasters.Where(a => a.userId == id).FirstOrDefault();
return(View(v));
}
}
public ActionResult deleteUser(int id)
{
using (OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"))
{
userMaster user = db.userMasters.Where(a => a.userId == id).FirstOrDefault();
if (user != null)
{
return(View(user));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Login(string txtEmail, string txtPassword)
{
/*if (txtEmail == "admin" && txtPassword == "admin")
* {
*
*
* if (txtEmail != null && txtPassword != null)
* {
* ViewBag.user = "******";
* return RedirectToAction("Dashboard", "Home");
* }
* else
* {
* ViewBag.message = "Invalid Username and Password";
* return View("Login");
* }
* }
* else
* {*/
OITdataDataContext db = new OITdataDataContext(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True");
var loginresult = db.userMasters.Where(a => a.emailID == txtEmail && a.password == txtPassword).FirstOrDefault();
if (loginresult != null)
{
Session["UserProfile"] = loginresult;
ViewBag.user = "******";
return(RedirectToAction("Dashboard", "Home"));
}
else
{
ViewBag.message = "Invalid Username and Password";
return(View("Login"));
}
//}
//return Json("Invalid Data",JsonRequestBehavior.AllowGet);
}
