public void updateOrdeComplaintStatus(complaintsGridVM p) { MECProjectDBEntities t = new MECProjectDBEntities(); var dd = t.Complaints.First(x => x.complaint_ID == p.complaintId); dd.complaint_status = p.status; t.SaveChanges(); }
public Boolean deleteUser(User user) { MECProjectDBEntities t = new MECProjectDBEntities(); User userToDelete = t.Users.First(x => x.user_ID == user.user_ID); t.Users.Remove(userToDelete); t.SaveChanges(); return(true); }
public void updateOrder(OrderVM p) { MECProjectDBEntities t = new MECProjectDBEntities(); Order d = new Order(); var dd = t.Orders.First(x => x.order_ID == p.order_ID); dd.clint_address = p.clint_address; dd.clint_name = p.clint_name; dd.clint_phone = p.clint_phone; dd.order_amount = Convert.ToInt32(p.order_amount); dd.order_ID = p.order_ID; dd.service_ID = p.service_ID; t.SaveChanges(); }
public void Delete(OrderGridVM p) { MECProjectDBEntities t = new MECProjectDBEntities(); Order order = new Order(); order.dateOfOrder = p.dateOfOrder; order.order_amount = p.order_amount; order.order_status = p.order_status; order.trackingId = p.trackingId; order.order_ID = p.order_ID; t.Orders.Attach(order); t.Orders.Remove(order); t.SaveChanges(); }
public bool updateUserDetails(User userNewDetails) { MECProjectDBEntities t = new MECProjectDBEntities(); User userToUpdate = t.Users.First(x => x.user_ID == userNewDetails.user_ID); userToUpdate.shopkeeper_bank_account = userNewDetails.shopkeeper_bank_account.TrimEnd(); userToUpdate.shopkeeper_bank_branch = userNewDetails.shopkeeper_bank_branch.TrimEnd(); userToUpdate.shopkeeper_bank_name = userNewDetails.shopkeeper_bank_name.TrimEnd(); userToUpdate.shopkeeper_commission = userNewDetails.shopkeeper_commission.TrimEnd(); userToUpdate.user_phone = userNewDetails.user_phone.TrimEnd(); userToUpdate.shopkeeper_shopaddress = userNewDetails.shopkeeper_shopaddress.TrimEnd(); userToUpdate.shopkeeper_shopname = userNewDetails.shopkeeper_shopname.TrimEnd(); userToUpdate.user_name = userNewDetails.user_name.TrimEnd(); t.SaveChanges(); return(true); }
public void updateOrderStatus(OrderGridVM p) { MECProjectDBEntities t = new MECProjectDBEntities(); Order d = new Order(); var dd = t.Orders.First(x => x.order_ID == p.order_ID); var id = Convert.ToInt32(dd.user_ID); var user = t.Users.Where(x => x.user_ID == id).FirstOrDefault(); int commision = Convert.ToInt32(user.shopkeeper_commission); int totalAmount = Convert.ToInt32(dd.order_amount); int shopkeeperAmount = (totalAmount * commision) / 100; int adminAmout = totalAmount - shopkeeperAmount; dd.shopkeeper_amount = shopkeeperAmount; dd.Admin_amount = adminAmout; dd.order_status = p.order_status; t.SaveChanges(); }
public bool updateProfileDetails(addUserVM updatedUserProfile) { MECProjectDBEntities t = new MECProjectDBEntities(); addUserVM profileModel = new addUserVM(); User userProfileToUpdate = t.Users.First(x => x.user_ID == updatedUserProfile.userId); userProfileToUpdate.user_name = updatedUserProfile.username; userProfileToUpdate.user_name = updatedUserProfile.username; userProfileToUpdate.user_phone = updatedUserProfile.phone; userProfileToUpdate.user_password = updatedUserProfile.password; userProfileToUpdate.shopkeeper_shopname = updatedUserProfile.shopname; userProfileToUpdate.shopkeeper_shopaddress = updatedUserProfile.shopaddress; userProfileToUpdate.shopkeeper_bank_name = updatedUserProfile.bankname; userProfileToUpdate.shopkeeper_bank_branch = updatedUserProfile.bankbranch; userProfileToUpdate.shopkeeper_bank_account = updatedUserProfile.accountnumber; t.SaveChanges(); return(true); }
public void updateUserStatus(addUserVM p) { MECProjectDBEntities t = new MECProjectDBEntities(); User d = new User(); var dd = t.Users.First(x => x.user_ID == p.userId); dd.userStatus = p.status; t.SaveChanges(); //string url = "http://electricianpk.com"; //For to send an email at Gmail Starts: gmail ID: setting link: https://myaccount.google.com/lesssecureapps?pli=1 //var fromAddress = new MailAddress("*****@*****.**", "ElectricianPK"); //var toAddress = new MailAddress(dd.user_email, "ElectricianPK"); //const string fromPassword = "******"; //const string subject = "Your account has been Approved!"; //string body = "Dear " + dd.user_name + ", \r\n \r\n" + // "This is to inform you that your account has been approved! " + // "\r\n\r\nYour provided credentials are mentioned below:" + // "\r\nEmail: " + dd.user_email + // "\r\nPassword: "******"\r\n\r\nPlease signin with your given credentials at: " + url + // "\r\n \r\n \r\n \r\nBest Regards,\r\n ElectricianPK Team"; //var smtp = new SmtpClient //{ // Host = "smtp.gmail.com", // Port = 587, // EnableSsl = true, // DeliveryMethod = SmtpDeliveryMethod.Network, // Credentials = new NetworkCredential(fromAddress.Address, fromPassword), // Timeout = 20000 //}; //using (var message = new MailMessage(fromAddress, toAddress) //{ // Subject = subject, // Body = body //}) //{ // smtp.Send(message); //} //For to send an email at Gmail Ends }
public string addOrderCompaint(addcomplaintsVM p) { MECProjectDBEntities t = new MECProjectDBEntities(); var order = t.Orders.Where(x => x.trackingId == p.ordernumber).FirstOrDefault(); if (order != null) { Complaint d = new Complaint(); d.order_resson = p.reason; d.complaint_field1 = p.ordernumber;// complaint_field1 IS THE tracking id of Order d.order_ID = order.order_ID; d.complaint_status = "pending"; d.complaint_field2 = p.userId.ToString();// complaint_field2 is the userId t.Complaints.Add(d); t.SaveChanges(); return("found"); } else { return("notfound"); } }
public void registerUser(addUserVM user) { MECProjectDBEntities t = new MECProjectDBEntities(); User u = new User(); u.shopkeeper_bank_account = user.accountnumber; u.shopkeeper_bank_branch = user.bankbranch; u.shopkeeper_bank_name = user.bankname; u.shopkeeper_commission = user.commission.ToString(); u.shopkeeper_fname = user.username; u.shopkeeper_shopaddress = user.shopaddress; u.shopkeeper_shopname = user.shopname; u.user_email = user.email; u.user_name = user.username; u.user_password = user.password; u.user_phone = user.phone; u.cnic = user.cnic; u.city = user.city; u.role_ID = 3; u.userStatus = "pending"; t.Users.Add(u); t.SaveChanges(); }
public void addOrder(OrderVM user) { string trackingid = ""; string trackingNumber = ""; var ss = DateTime.Now; string year = ss.Year.ToString(); string month = ss.Month.ToString(); string day = ss.Day.ToString(); //string connectionString = "Data Source=(local);Initial Catalog=MECProjectDB;Integrated Security=true"; string connectionString = "data source=184.154.206.133; initial catalog=MECProjectDB;user id=MECProjectUser; password=$Default123"; using (SqlConnection connection = new SqlConnection(connectionString)) { // Create the Command and Parameter objects. SqlCommand command = new SqlCommand("OrdertrackingNumber", connection); command.CommandType = CommandType.StoredProcedure; //command.Parameters.AddWithValue("@date", DateTime.Now); command.Parameters.Add(new SqlParameter("@date", SqlDbType.Date)); command.Parameters["@date"].Value = DateTime.Now; try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); var comlumExist = HasColumn(reader, "order_ID"); if (comlumExist == true) { while (reader.Read()) { if (reader != null) { var sss = reader["order_ID"]; var trackingNumbers = Convert.ToInt32(reader["order_number"]); trackingNumbers = trackingNumbers + 1; trackingNumber = trackingNumbers.ToString(); } } var length = trackingNumber.Length; if (length == 1) { trackingNumber.Insert(0, "000"); trackingNumber = "000" + trackingNumber; } else if (length == 2) { trackingNumber.Insert(0, "00"); trackingNumber = "00" + trackingNumber; } else if (length == 3) { trackingNumber.Insert(0, "0"); trackingNumber = "0" + trackingNumber; } trackingid = year + "-" + month + "-" + day + "-" + trackingNumber; } else { trackingid = year + "-" + month + "-" + day + "-" + "0001"; trackingNumber = "0001"; } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } MECProjectDBEntities tt = new MECProjectDBEntities(); Order o = new Order(); o.clint_name = user.clint_name; o.clint_phone = user.clint_phone; o.clint_address = user.clint_address; o.order_amount = Convert.ToInt32(user.order_amount); o.service_ID = user.service_ID; o.dateOfOrder = DateTime.Now; o.order_number = trackingNumber; o.trackingId = trackingid; o.user_ID = user.userId; o.order_status = "pending"; tt.Orders.Add(o); tt.SaveChanges(); }