public HttpResponseMessage UpdateUser(String id, Entities.MstUser objUser) { try { var users = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d; if (users.Any()) { var updateUser = users.FirstOrDefault(); updateUser.FullName = objUser.FullName; updateUser.Address = objUser.Address; updateUser.ContactNumber = objUser.ContactNumber; updateUser.UserTypeId = objUser.UserTypeId; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage putUser(String id, Entities.MstUser user) { try { var users = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d; if (users.Any()) { var updateUser = users.FirstOrDefault(); updateUser.UserName = user.UserName; updateUser.Password = user.Password; updateUser.FullName = user.FullName; updateUser.UserCardNumber = user.UserName; updateUser.EntryUserId = UserId(); updateUser.EntryDateTime = DateTime.Today; updateUser.UpdateUserId = UserId(); updateUser.UpdateDateTime = DateTime.Today; updateUser.IsLocked = true; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception e) { // Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 postUser(Entities.MstUser user) { try { var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id; var id = User.Identity.GetUserId(); Data.MstUser newUser = new Data.MstUser(); newUser.UserName = "******"; newUser.Password = "******"; newUser.FullName = "n/a"; newUser.UserCardNumber = "n/a"; newUser.EntryUserId = userId; newUser.EntryDateTime = DateTime.Today; newUser.UpdateUserId = userId; newUser.UpdateDateTime = DateTime.Today; newUser.IsLocked = false; newUser.AspNetUserId = id; db.MstUsers.InsertOnSubmit(newUser); db.SubmitChanges(); return(newUser.Id); } catch (Exception e) { Debug.WriteLine(e); return(0); } }
public HttpResponseMessage UpdateUser(Entities.MstUser objUpdateUser, String id) { try { var UserTypeId = from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d.UserTypeId; var userId = User.Identity.GetUserId(); var currentUserType = UserTypeId.FirstOrDefault(); if (currentUserType == 1) { var isUserDetailExist = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d; if (isUserDetailExist.Any()) { var currentUserDetail = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d; var updateUser = currentUserDetail.FirstOrDefault(); updateUser.FirstName = objUpdateUser.FirstName; updateUser.LastName = objUpdateUser.LastName; updateUser.UserTypeId = objUpdateUser.UserTypeId; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Unauthorized")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage AddUser(Entities.MstUser objMstUser) { try { Data.MstUser mstUser = new Data.MstUser { FirstName = objMstUser.FirstName, LastName = objMstUser.LastName, Password = objMstUser.Password, UserTypeId = objMstUser.UserTypeId, }; db.MstUsers.InsertOnSubmit(mstUser); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage UpdateCurrentUser(Entities.MstUser objUser) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currenteAspNetUserId = User.Identity.GetUserId(); var currentUserId = currentUser.FirstOrDefault().Id; var user = from d in db.MstUsers where d.Id == currentUserId select d; if (user.Any()) { var branch = from d in db.MstBranches where d.Id == objUser.BranchId select d; if (branch.Any()) { var account = from d in db.MstAccounts select d; if (account.Any()) { var discounts = from d in db.MstDiscounts where d.Id == objUser.DefaultSalesInvoiceDiscountId select d; if (discounts.Any()) { var currentASPNetUser = from d in db.AspNetUsers where d.Id == currenteAspNetUserId select d; if (currentASPNetUser.Any()) { var updateCurrentASPNetUser = currentASPNetUser.FirstOrDefault(); updateCurrentASPNetUser.FullName = objUser.FullName; db.SubmitChanges(); var updateCurrentUser = user.FirstOrDefault(); updateCurrentUser.FullName = objUser.FullName; updateCurrentUser.CompanyId = objUser.CompanyId; updateCurrentUser.BranchId = objUser.BranchId; updateCurrentUser.IncomeAccountId = objUser.IncomeAccountId; updateCurrentUser.SupplierAdvancesAccountId = objUser.SupplierAdvancesAccountId; updateCurrentUser.CustomerAdvancesAccountId = objUser.CustomerAdvancesAccountId; updateCurrentUser.InventoryType = objUser.InventoryType; updateCurrentUser.DefaultSalesInvoiceDiscountId = objUser.DefaultSalesInvoiceDiscountId; updateCurrentUser.SalesInvoiceName = objUser.SalesInvoiceName; updateCurrentUser.SalesInvoiceCheckedById = objUser.SalesInvoiceCheckedById; updateCurrentUser.SalesInvoiceApprovedById = objUser.SalesInvoiceApprovedById; updateCurrentUser.OfficialReceiptName = objUser.OfficialReceiptName; updateCurrentUser.IsIncludeCostStockReports = objUser.IsIncludeCostStockReports; updateCurrentUser.UpdatedById = currentUserId; updateCurrentUser.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Current user not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Sales Invoice Discount not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Some Account data not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Branch not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These user details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage LockUser(Entities.MstUser objUser, String id) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("UserDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanLock) { var user = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d; if (user.Any()) { if (!user.FirstOrDefault().IsLocked) { var branch = from d in db.MstBranches where d.Id == objUser.BranchId select d; if (branch.Any()) { var account = from d in db.MstAccounts select d; if (account.Any()) { var discounts = from d in db.MstDiscounts where d.Id == objUser.DefaultSalesInvoiceDiscountId select d; if (discounts.Any()) { var lockUser = user.FirstOrDefault(); lockUser.FullName = objUser.FullName; lockUser.CompanyId = objUser.CompanyId; lockUser.BranchId = objUser.BranchId; lockUser.IncomeAccountId = objUser.IncomeAccountId; lockUser.SupplierAdvancesAccountId = objUser.SupplierAdvancesAccountId; lockUser.CustomerAdvancesAccountId = objUser.CustomerAdvancesAccountId; lockUser.InventoryType = objUser.InventoryType; lockUser.DefaultSalesInvoiceDiscountId = objUser.DefaultSalesInvoiceDiscountId; lockUser.SalesInvoiceName = objUser.SalesInvoiceName; lockUser.SalesInvoiceCheckedById = objUser.SalesInvoiceCheckedById; lockUser.SalesInvoiceApprovedById = objUser.SalesInvoiceApprovedById; lockUser.OfficialReceiptName = objUser.OfficialReceiptName; lockUser.IsIncludeCostStockReports = objUser.IsIncludeCostStockReports; lockUser.IsLocked = true; lockUser.UpdatedById = currentUserId; lockUser.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Sales Invoice Discount not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Some Account data not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Branch not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These user details are already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These user details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock user.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage SaveUser(Entities.MstUser objUser, String id) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var user = from d in db.MstUsers where d.Id == Convert.ToInt32(id) select d; if (user.Any()) { if (!user.FirstOrDefault().IsLocked) { var branch = from d in db.MstBranches where d.Id == objUser.BranchId select d; if (branch.Any()) { var account = from d in db.MstAccounts select d; if (account.Any()) { var discounts = from d in db.MstDiscounts where d.Id == objUser.DefaultSalesInvoiceDiscountId select d; if (discounts.Any()) { String oldObject = at.GetObjectString(user.FirstOrDefault()); var saveUser = user.FirstOrDefault(); saveUser.FullName = objUser.FullName; saveUser.CompanyId = objUser.CompanyId; saveUser.BranchId = objUser.BranchId; saveUser.IncomeAccountId = objUser.IncomeAccountId; saveUser.SupplierAdvancesAccountId = objUser.SupplierAdvancesAccountId; saveUser.CustomerAdvancesAccountId = objUser.CustomerAdvancesAccountId; saveUser.InventoryType = objUser.InventoryType; saveUser.DefaultSalesInvoiceDiscountId = objUser.DefaultSalesInvoiceDiscountId; saveUser.SalesInvoiceName = objUser.SalesInvoiceName; saveUser.SalesInvoiceCheckedById = objUser.SalesInvoiceCheckedById; saveUser.SalesInvoiceApprovedById = objUser.SalesInvoiceApprovedById; saveUser.OfficialReceiptName = objUser.OfficialReceiptName; saveUser.IsIncludeCostStockReports = objUser.IsIncludeCostStockReports; saveUser.ActivateAuditTrail = objUser.ActivateAuditTrail; saveUser.UpdatedById = currentUserId; saveUser.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); String newObject = at.GetObjectString(user.FirstOrDefault()); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Sales Invoice Discount not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Some Account data not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Branch not found.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Saving Error. These user details are already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These user details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }