public IHttpActionResult PutuserMaster(int id, userMaster userMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userMaster.userId)
{
return(BadRequest());
}
db.Entry(userMaster).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!userMasterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Register(userMaster obj)
{
try
{
if (ModelState.IsValid)
{
//string vPassword = CommonMethods.Encrypt(obj.PASSWORD);
//string vSvrKey = CommonMethods.Encrypt(DateTime.Now.Date.ToString(), "BICPRO");
//obj.PASSWORD = vPassword;
obj.SVRKEY = "abcd";
obj.ISADMIN = true;
objRes = obj.Save(obj, 0);
if (objRes.ResultId > 0)
{
return(RedirectToAction("Login", "Account"));
}
else
{
ModelState.AddModelError("ErrorMgr", objRes.Message);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(View(obj));
}
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");
* }
*
*/
}
//Method for Updating Employee record
public int Update(userMaster user)
{
int i;
using (SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=dbIOTReporting;Integrated Security=True"))
{
con.Open();
SqlCommand com = new SqlCommand("InsertUpdateUser", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@userID", user.userId);
com.Parameters.AddWithValue("@firstName", user.firstName);
com.Parameters.AddWithValue("@lastName", user.lastName);
com.Parameters.AddWithValue("@dob", user.dob);
com.Parameters.AddWithValue("@gender", user.gender);
com.Parameters.AddWithValue("@address", user.address);
com.Parameters.AddWithValue("@city", user.city);
com.Parameters.AddWithValue("@state", user.state);
com.Parameters.AddWithValue("@countryId", user.countryId);
com.Parameters.AddWithValue("@contactNo", user.contactNo);
com.Parameters.AddWithValue("@emailID", user.emailID);
com.Parameters.AddWithValue("@password", user.password);
com.Parameters.AddWithValue("@Action", "Update");
i = com.ExecuteNonQuery();
}
return(i);
}
public IHttpActionResult GetuserMaster(int id)
{
userMaster userMaster = db.userMasters.Find(id);
if (userMaster == null)
{
return(NotFound());
}
return(Ok(userMaster));
}
public IHttpActionResult PostuserMaster(userMaster userMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.userMasters.Add(userMaster);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = userMaster.userId }, userMaster));
}
public ActionResult Dashboard()
{
userMaster u = new userMaster();
clientMaster c = new clientMaster();
domainMaster d = new domainMaster();
ViewBag.usertotal = db.userMasters.Count();
ViewBag.domaintotal = db.domainMasters.Count();
var count = db.clientMasters.Select(p => p.companyName).Distinct().Count();
ViewBag.companyNametotal = count;
return(View());
}
public IHttpActionResult DeleteuserMaster(int id)
{
userMaster userMaster = db.userMasters.Find(id);
if (userMaster == null)
{
return(NotFound());
}
db.userMasters.Remove(userMaster);
db.SaveChanges();
return(Ok(userMaster));
}
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 JsonResult Update(userMaster ur)
{
return(Json(user.Update(ur), JsonRequestBehavior.AllowGet));
}
