public void UpdateProfile(ProfileView PV) { using (CMSProjectEntities db = new CMSProjectEntities()) { User user = new User(); user.UserID = PV.UserID; user.Username = PV.Username; user.Password = PV.Password; db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); UserProfile UP = new UserProfile(); UP.UserProfileID = PV.UserProfileID; UP.UserID = PV.UserID; UP.RoleID = PV.RoleID; UP.FirstName = PV.FirstName; UP.LastName = PV.LastName; UP.Gender = PV.Gender; UP.BirthDate = Convert.ToDateTime(PV.BirthDate); UP.Email = PV.Email; UP.Mobile = PV.Mobile; db.Entry(UP).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); FormsAuthentication.SetAuthCookie(PV.Username, false); } }
public void AddEmployeeAccount(UserProfileView user) { using (CMSProjectEntities db = new CMSProjectEntities()) { //User Table User U = new User(); U.Username = user.Username; U.Password = user.Password; db.Users.Add(U); db.SaveChanges(); //UserProfile Table UserProfile UP = new UserProfile(); UP.UserID = U.UserID; UP.FirstName = user.FirstName; UP.LastName = user.LastName; UP.Gender = user.Gender; UP.BirthDate = Convert.ToDateTime(user.BirthDate); UP.Mobile = user.Mobile; UP.Email = user.Email; UP.RoleID = 2; db.UserProfiles.Add(UP); db.SaveChanges(); } }
public void AddUserAccount(UserSignUpView user) { using (CMSProjectEntities db = new CMSProjectEntities()) { //User Table User U = new User(); U.Username = user.Username; U.Password = user.Password; db.Users.Add(U); db.SaveChanges(); //UserProfile Table UserProfile UP = new UserProfile(); UP.UserID = U.UserID; UP.FirstName = user.FirstName; UP.LastName = user.LastName; UP.Gender = user.Gender; UP.BirthDate = user.BirthDate; UP.Mobile = user.Mobile; UP.Email = user.Email; UP.RoleID = 3; db.UserProfiles.Add(UP); db.SaveChanges(); CustomerUser CU = new CustomerUser(); CU.UserID = U.UserID; CU.Active = true; db.CustomerUsers.Add(CU); db.SaveChanges(); } }
public void UpdateUserAccount(UserProfileView user) { using (CMSProjectEntities db = new CMSProjectEntities()) { //User Table User U = new User(); U.UserID = user.UserID; U.Username = user.Username; U.Password = user.Password; db.Entry(U).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //UserProfile Table UserProfile UP = new UserProfile(); UP.UserProfileID = user.UserProfileID; UP.UserID = U.UserID; UP.FirstName = user.FirstName; UP.LastName = user.LastName; UP.Gender = user.Gender; UP.BirthDate = Convert.ToDateTime(user.BirthDate); UP.Mobile = user.Mobile; UP.Email = user.Email; UP.RoleID = user.RoleID; db.Entry(UP).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public ActionResult Delete(int id) { UserManager UM = new UserManager(); UserProfileView UPV = new UserProfileView(); UPV = UM.GetAllUserProfiles().Where(o => o.UserProfileID.Equals(id)).FirstOrDefault(); using (CMSProjectEntities db = new CMSProjectEntities()) { UserProfile userProfile = new UserProfile(); userProfile.UserProfileID = UPV.UserProfileID; userProfile.UserID = UPV.UserID; userProfile.FirstName = UPV.FirstName; userProfile.LastName = UPV.LastName; userProfile.Gender = UPV.Gender; userProfile.BirthDate = Convert.ToDateTime(UPV.BirthDate); userProfile.Email = UPV.Email; userProfile.Mobile = UPV.Mobile; userProfile.RoleID = UPV.RoleID; db.Entry(userProfile).State = EntityState.Deleted; db.SaveChanges(); CMSProject.Models.DB.User user = new User(); user.UserID = userProfile.UserID; user.Username = UPV.Username; user.Password = UPV.Password; db.Entry(user).State = EntityState.Deleted; db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public void UpdateOrder(OrderUpdateView OUV) { using (CMSProjectEntities db = new CMSProjectEntities()) { CustomerOrder CO = new CustomerOrder(); CO.OrderID = OUV.OrderID; CO.CustomerID = OUV.CustomerID; CO.OrderDate = OUV.OrderDate; if (OUV.ShippedDate.HasValue) { CO.ShippedDate = OUV.ShippedDate; } else { CO.ShippedDate = null; } CO.PickupAddressID = OUV.PickupAddressID; CO.ShippingAddressID = OUV.ShippingAddressID; CO.Weight = OUV.Weight; CO.OrderValue = OUV.OrderValue; db.Entry(CO).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); PaymentTBL pay = new PaymentTBL(); pay.PaymentID = OUV.PaymentID; pay.Value = CO.OrderValue; if (OUV.PaymentDate.HasValue) { pay.PaymentDate = OUV.PaymentDate; } else { pay.PaymentDate = null; } pay.PaymentStatusID = OUV.PaymentStatusID; pay.OrderID = CO.OrderID; db.Entry(pay).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TrackingTBL tracking = new TrackingTBL(); tracking.TrackingID = OUV.TrackingID; tracking.PickupBranchID = OUV.PickupBranchID; tracking.ShippingBranchID = OUV.ShippingBranchID; tracking.OrderStatusID = OUV.OrderStatusID; tracking.OrderID = CO.OrderID; db.Entry(tracking).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void PlaceOrder(PlaceOrderView POV) { Address paddr = new Address(); Address saddr = new Address(); using (CMSProjectEntities db = new CMSProjectEntities()) { paddr.StreetAddress = POV.PickupAddressSA; paddr.City = POV.PickupAddressCity; paddr.State = POV.PickupAddressState; paddr.Pincode = POV.PickupAddressPincode; saddr.StreetAddress = POV.ShippingAddressSA; saddr.City = POV.ShippingAddressCity; saddr.State = POV.ShippingAddressState; saddr.Pincode = POV.ShippingAddressPincode; db.Addresses.Add(paddr); db.SaveChanges(); db.Addresses.Add(saddr); db.SaveChanges(); User user = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault(); CustomerUser CU = db.CustomerUsers.Where(o => o.UserID.Equals(user.UserID)).FirstOrDefault(); CustomerOrder CO = new CustomerOrder(); CO.CustomerID = CU.CustomerID; CO.OrderDate = DateTime.Now; CO.ShippedDate = null; CO.PickupAddressID = db.Addresses.Where(o => o.StreetAddress.Equals(paddr.StreetAddress)).FirstOrDefault().AddressID; CO.ShippingAddressID = db.Addresses.Where(o => o.StreetAddress.Equals(saddr.StreetAddress)).FirstOrDefault().AddressID; CO.Weight = POV.Weight; CO.OrderValue = POV.OrderValue; db.CustomerOrders.Add(CO); db.SaveChanges(); TrackingTBL tracking = new TrackingTBL(); tracking.OrderStatusID = 0; tracking.OrderID = CO.OrderID; db.TrackingTBLs.Add(tracking); db.SaveChanges(); PaymentTBL pay = new PaymentTBL(); pay.Value = CO.OrderValue; pay.PaymentDate = null; pay.PaymentStatusID = 1; pay.OrderID = CO.OrderID; db.PaymentTBLs.Add(pay); db.SaveChanges(); } }
public ActionResult MakeComplaint(ComplaintView CV) { DataManager DM = new DataManager(); Complaint C = new Complaint(); C = DM.AddOrUpdateComplaint(CV, 1); using (CMSProjectEntities db = new CMSProjectEntities()) { db.Complaints.Add(C); db.SaveChanges(); } return(Json(new { success = true, message = "Added Successfully!" }, JsonRequestBehavior.AllowGet)); }
public void AddBranch(BranchesView BV) { using (CMSProjectEntities db = new CMSProjectEntities()) { BranchList branch = new BranchList(); branch.StreetAddress = BV.StreetAddress; branch.City = BV.City; branch.State = BV.State; branch.Pincode = BV.Pincode; branch.Active = true; db.BranchLists.Add(branch); db.SaveChanges(); } }
public ActionResult Feedback(FeedbackView FV) { using (CMSProjectEntities db = new CMSProjectEntities()) { CMSProject.Models.DB.Feedback FB = new Feedback(); FB.Description = FV.Description; UserManager UM = new UserManager(); var username = System.Web.HttpContext.Current.User.Identity.Name; CMSProject.Models.DB.User user = db.Users.Where(o => o.Username.Equals(username)).FirstOrDefault(); FB.CustomerID = db.CustomerUsers.Where(o => o.UserID.Equals(user.UserID)).FirstOrDefault().CustomerID; db.Feedbacks.Add(FB); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
public void UpdateComplaint(ComplaintView CV) { using (CMSProjectEntities db = new CMSProjectEntities()) { var emp = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault(); Complaint currComplaint = new Complaint(); currComplaint.ComplaintID = CV.ComplaintID; currComplaint.CustomerID = CV.CustomerID; currComplaint.Description = CV.Description; currComplaint.ComplaintStatusID = CV.ComplaintStatusID; currComplaint.EmployeeID = emp.UserID; db.Entry(currComplaint).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void UpdateBranch(BranchesView BV) { using (CMSProjectEntities db = new CMSProjectEntities()) { BranchList branch = new BranchList(); branch.BranchID = BV.BranchID; branch.StreetAddress = BV.StreetAddress; branch.City = BV.City; branch.State = BV.State; branch.Pincode = BV.Pincode; branch.Active = (bool)BV.Active; db.Entry(branch).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public ActionResult DeleteB(int id) { DataManager DM = new DataManager(); BranchesView BV = new BranchesView(); BV = DM.GetBranchView(id); using (CMSProjectEntities db = new CMSProjectEntities()) { BranchList branch = new BranchList(); branch.BranchID = BV.BranchID; branch.StreetAddress = BV.StreetAddress; branch.City = BV.City; branch.State = BV.State; branch.Pincode = BV.Pincode; branch.Active = (bool)BV.Active; db.Entry(branch).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }