public IHttpActionResult PostUser(userdetail data)
{
string message = "";
if (data != null)
{
try
{
objEntity.userdetails.Add(data);
int result = objEntity.SaveChanges();
if (result > 0)
{
message = "User has been sussfully added";
}
else
{
message = "faild";
}
}
catch (Exception)
{
throw;
}
}
return(Ok(message));
}
public async Task <ActionResult <userdetail> > Postuserdetail(userdetail userdetail)
{
_context.userdetails.Add(userdetail);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getuserdetail", new { id = userdetail.userid }, userdetail));
}
public async Task <IActionResult> Putuserdetail(int id, userdetail userdetail)
{
if (id != userdetail.userid)
{
return(BadRequest());
}
_context.Entry(userdetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!userdetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
userdetail userdetail = db.userdetails.Find(id);
db.userdetails.Remove(userdetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Setup()
{
_shimsContext = ShimsContext.Create();
CommonShims();
_userDetail = new userdetail();
_userDetailPrivate = new PrivateObject(_userDetail);
InitializeFields();
}
public void Setup()
{
_queryString = new NameValueCollection();
_shimsContext = ShimsContext.Create();
CommonShims();
_userDetail = new userdetail();
_userDetailPrivate = new PrivateObject(_userDetail);
base.InitializeAllControls(_userDetail);
InitializeFields();
}
public void Setup()
{
_appSettings = new NameValueCollection();
_page = new userdetail();
_applicationLogCriticalErrorSourceMethod = null;
_validateUserResult = false;
_pagePrivate = new PrivateObject(_page);
InitializeAllControls(_page);
CommonShims();
}
public ActionResult Edit([Bind(Include = "u_id,u_name,u_password,u_type")] userdetail userdetail)
{
if (ModelState.IsValid)
{
db.Entry(userdetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userdetail));
}
public ActionResult Edit([Bind(Include = "userid,name,email,address,date_of_joining,contact,pass,roleid,isverified")] userdetail userdetail)
{
if (ModelState.IsValid)
{
db.Entry(userdetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.roleid = new SelectList(db.roles, "roleid", "rolename", userdetail.roleid);
return(View(userdetail));
}
public int DeleteUserById(int Id)
{
var db = new EModel();
userdetail ud = new userdetail();
ud.UserID = Id;
db.Entry(ud).State = EntityState.Deleted;
int retVal = db.SaveChanges();
return(retVal);
}
public ActionResult Create([Bind(Include = "u_id,u_name,u_password,u_type")] userdetail userdetail)
{
if (ModelState.IsValid)
{
userdetail.u_password = this.Hash(userdetail.u_password);
db.userdetails.Add(userdetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userdetail));
}
public int AddUser(string name, string email, int deptID)
{
var db = new EModel();
var ud = new userdetail();
ud.Name = name;
ud.email = email;
ud.Deptid = deptID;
db.userdetail.Add(ud);
int retval = db.SaveChanges();
return(retval);
}
// GET: user/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
userdetail userdetail = db.userdetails.Find(id);
if (userdetail == null)
{
return(HttpNotFound());
}
return(View(userdetail));
}
public int UpdateUser(int id, string name, string email)
{
var db = new EModel();
var ud = new userdetail();
ud.UserID = id;
ud.email = email;
ud.Name = name;
db.Entry(ud).State = EntityState.Modified;
int retVal = db.SaveChanges();
return(retVal);
}
public userdetail GetUserdetailbyId(int id)
{
var db = new EModel();
var usr = from k in db.userdetail where k.UserID == id select k;
var user = new userdetail();
foreach (var item in usr)
{
user.Name = item.Name;
user.email = item.email;
user.Deptid = item.Deptid;
}
return(user);
}
// GET: userdetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
userdetail userdetail = db.userdetails.Find(id);
if (userdetail == null)
{
return(HttpNotFound());
}
ViewBag.roleid = new SelectList(db.roles, "roleid", "rolename", userdetail.roleid);
return(View(userdetail));
}
public List <userdetail> GetAllUser()
{
List <userdetail> userList = new List <userdetail>();
EModel db = new EModel();
var urList = from k in db.userdetail select k;
foreach (var item in urList)
{
var usr = new userdetail();
usr.Name = item.Name;
usr.email = item.email;
usr.Deptid = item.Deptid;
userList.Add(usr);
}
return(userList);
}
protected void Button1_Click(object sender, EventArgs e)
{
userrequestEntities ctx = new userrequestEntities();
userdetail f = new userdetail();
f.fname = fname.Text;
f.age = int.Parse(age.Text);
f.lgnname = lgn.Text;
f.pwd = pwd.Text;
f.experience = int.Parse(exp.Text);
f.salexp = double.Parse(sal.Text);
ctx.userdetails.Add(f);
ctx.SaveChanges();
string strFname = lgn.Text;
Label1.Text = "User Created: " + strFname;
}
public IHttpActionResult GetUserById(string userId)
{
userdetail objUser = new userdetail();
int ID = Convert.ToInt32(userId);
try
{
objUser = objEntity.userdetails.Find(ID);
if (objUser == null)
{
return(NotFound());
}
}
catch (Exception)
{
throw;
}
return(Ok(objUser));
}
private void add_user_Click(object sender, RoutedEventArgs e)
{
C1.WPF.C1Window employeeswindow = new C1.WPF.C1Window();
employeeswindow.IsResizable = false;
employeeswindow.Name = "employeeswindow1";
employeeswindow.Width = 700;
employeeswindow.Height = 550;
employeeswindow.Header = "员工管理";
employeeswindow.Margin = new Thickness(SystemParameters.PrimaryScreenWidth / 2d - 250, SystemParameters.PrimaryScreenHeight / 2d - 250, 0, 0);
employeeswindow.ShowModal();
employeeswindow.ShowMaximizeButton = false;
employeeswindow.ShowMinimizeButton = false;
userdetail newemployees = new userdetail();
newemployees.Name = "newemployees1";
employeeswindow.Content = newemployees;
//newemployees.C1Window += new RoutedPropertyChangedEventHandler<object>(newemployees_C1Window);
//Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
//Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter();
//fixedDataSet.employees.AcceptChanges();
//fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees);
}
public bool SaveUserRegistration(userdetail objUserDetail, user objUser)
{
try
{
using (aicpdataEntities db = new aicpdataEntities())
{
db.users.Add(objUser);
db.SaveChanges();
int userID = objUser.UserID;
objUserDetail.UserID = userID;
db.userdetails.Add(objUserDetail);
db.SaveChanges();
//return RedirectToAction("Index", "Home");
return(true);
}
}
catch
{
return(false);
}
}
public ActionResult Index(userdetail usr)
{
//get username password from the user)
//check it with database user table
aanchalbookshop_Entities1 dbObject = new aanchalbookshop_Entities1();
var checkuser = dbObject.userdetails.Where(l => l.u_name.Equals(usr.u_name) && l.u_password.Equals(usr.u_password)).FirstOrDefault();
if (checkuser != null)
{
var loggeduser = dbObject.userdetails.Where(l => l.u_name.Equals(usr.u_name)).FirstOrDefault();
Session["u-name"] = loggeduser.u_name.ToString();
Session["u-id"] = loggeduser.u_id.ToString();
Session["u-type"] = loggeduser.u_type.ToString();
return(RedirectToAction("Dashboard"));
}
else
{
ViewBag.msg = "Invalid Username or Password";
}
return(View());
}
public IHttpActionResult DeleteEmaployeeDelete(int id)
{
try
{
string message = "";
userdetail user = objEntity.userdetails.Find(id);
objEntity.userdetails.Remove(user);
int result = objEntity.SaveChanges();
if (result > 0)
{
message = "User has been sussfully deleted";
}
else
{
message = "faild";
}
return(Ok(message));
}
catch (Exception ex)
{
throw;
}
}
public IHttpActionResult PutUserMaster(userdetail user)
{
string message = "";
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
userdetail objUser = new userdetail();
objUser = objEntity.userdetails.Find(user.userid);
if (objUser != null)
{
objUser.username = user.username;
objUser.emailid = user.emailid;
objUser.gender = user.gender;
objUser.address = user.address;
objUser.mobileno = user.mobileno;
objUser.pincode = user.pincode;
}
int result = objEntity.SaveChanges();
if (result > 0)
{
message = "User has been sussfully updated";
}
else
{
message = "faild";
}
}
catch (Exception)
{
throw;
}
return(Ok(message));
}
public IActionResult Login([FromBody] login info)
{
try {
if (!ModelState.IsValid)
{
re = new Resultmodel()
{
statuscode = (long)HttpStatusCode.Forbidden,
error_message = "Email & password parameters are mandatory."
};
return(new ObjectResult(re));
}
if (!CheckForMailExitance(info.email))
{
re = new Resultmodel()
{
statuscode = (long)HttpStatusCode.Forbidden,
error_message = "Email does not exist."
};
return(new ObjectResult(re));
}
var obj = __context.UsersDetailInfo.Where(xx => xx.email.Equals(info.email) &&
xx.active_status == false).FirstOrDefault();
if (obj != null)
{
re = new Resultmodel()
{
statuscode = (long)HttpStatusCode.Forbidden,
error_message = "Account is not activated yet."
};
return(new ObjectResult(re));
}
obj = __context.UsersDetailInfo.Where(xx => xx.email.Equals(info.email) &&
xx.password.Equals(info.password)).FirstOrDefault();
if (obj == null)
{
re = new Resultmodel()
{
statuscode = (long)HttpStatusCode.Forbidden,
error_message = "Password does not match."
};
return(new ObjectResult(re));
}
userdetail usrdata = (from ss in __context.UsersDetailInfo
where ss.email.Equals(info.email) &&
ss.password.Equals(info.password)
select new userdetail()
{
userid = ss.userid,
name = ss.firstname + '^' + ss.lastname,
contact = ss.mobileno,
cityname = (from xx in __context.CityDetails where xx.cityid == ss.cityidfk select xx.cityname).Single <string>(),
statename = (from xx in __context.StateDetails where xx.stateid == ss.stateidfk select xx.statename).Single <string>(),
countryname = (from xx in __context.CountryDetails where xx.countryid == ss.countryidfk select xx.countryname).Single <string>(),
userole = (from xx in __context.UserRoles where xx.roleid == ss.roleidfk select xx.rolename).Single <string>()
}).First <userdetail>();
re = new Resultmodel()
{
statuscode = (long)HttpStatusCode.OK,
info = usrdata
};
return(new ObjectResult(re));
}
catch (Exception e) {
re = new Resultmodel()
{
statuscode = (long)HttpStatusCode.InternalServerError,
error_message = "something went wrong."
};
return(new ObjectResult(re));
}
finally {
__context.Dispose();
}
}
private void edit_Click(object sender, RoutedEventArgs e)
{
var t = employeesDataGrid.SelectedItem;
var b = t as DataRowView;
int s = int.Parse(b.Row[0].ToString());
string edit_num = b.Row[1].ToString();
if (edit_num == "admin")
{
MessageBox.Show("无法编辑管理员", "提示");
}
else
{
C1.WPF.C1Window employeeswindow = new C1.WPF.C1Window();
employeeswindow.IsResizable = false;
employeeswindow.Name = "employeeswindow2";
employeeswindow.Width = 700;
employeeswindow.Height = 550;
employeeswindow.Header = "员工管理";
employeeswindow.Margin = new Thickness(SystemParameters.PrimaryScreenWidth / 2d - 250, SystemParameters.PrimaryScreenHeight / 2d - 250, 0, 0);
employeeswindow.Show();
employeeswindow.ShowMaximizeButton = false;
employeeswindow.ShowMinimizeButton = false;
userdetail newemployees = new userdetail();
newemployees.Name = "newemployees2";
//Public.user_id = s;
newemployees.u_id = s;
employeeswindow.Content = newemployees;
}
}
