/// <summary> /// creates customer and adds to db + logging /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void createCustomerButton_Click(object sender, EventArgs e) { CUSTOMERS customer = new CUSTOMERS(); int newId = _controller.GetNextCustomerId(); customer.CS_STAMP = newId; customer.CS_CUSTNO = newId; customer.CS_CPRNO = cprBox.Text; customer.CS_FIRSTNAME = firstNameBox.Text; customer.CS_LASTNAME = LastNameBox.Text; customer.CS_ADRESS1 = adressBox.Text; customer.CS_EMAIL = emailBox.Text; customer.CS_PHONEMOBILE = phoneBox.Text; if (createCustomerButtonOK.Text == "Gem") { _controller.PutCustomer(customer); Trace.WriteLine($"\n Ny kunde med navn: {firstNameBox.Text} {LastNameBox.Text} er blevet oprettet d. {DateTime.Now}"); this.Close(); } if (createCustomerButtonOK.Text == "Opret") { _controller.PostCustomer(customer); Trace.WriteLine($"\n Ny kunde med navn: {firstNameBox.Text} {LastNameBox.Text} er blevet rettet i d. {DateTime.Now}"); this.Close(); } this.Close(); }
public ActionResult Login(CUSTOMERS user, string returnUrl) { { if (ModelState.IsValid) { CUSTOMERS cus = context.CUSTOMERS.SingleOrDefault(kh => kh.USERNAME == user.USERNAME); if (cus != null && cus.ROLE == 1) { if (BCrypt.Net.BCrypt.Verify(user.PASSWORD, cus.PASSWORD)) { Session.Add("ADMIN_SESSION", cus); return(RedirectToAction("TatCaSach", "AdminQuanLySach")); } else { ModelState.AddModelError("", "Mật khẩu sai"); } } else { ModelState.AddModelError("", "Tài khoản không tồn tại"); } } return(View("Index")); } }
/// <summary> /// Gets the last 2 appointments from specified customer /// </summary> /// <param name="customer"></param> /// <returns></returns> public List <APTDETAILS> GetPastAppointments(CUSTOMERS customer) { var allAppointments = GetAppointments(); List <APTDETAILS> pastAppointments = new List <APTDETAILS>(); List <APTDETAILS> twoLastAppointments = new List <APTDETAILS>(); var now = DateTime.Now; foreach (APTDETAILS a in allAppointments) { if (a.APD_CUSTOMER == customer.CS_STAMP && a.APD_DATE < now) { pastAppointments.Add(a); } } for (int i = 0; i < 2; i++) { try { twoLastAppointments.Add(pastAppointments[i]); } catch (ArgumentOutOfRangeException) { } } var sorted = (from a in twoLastAppointments orderby a.APD_DATE select a).ToList(); return(sorted); }
public static bool UpdateCustomer(CUSTOMERS customer) { bool status = false; try { using (OracleConnection connection = new OracleConnection(conlink)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } string query = "UPDATE CUSTOMERS SET EMAIL= :email ,FIRSTNAME= :fname,LASTNAME=:lname,PHONE=:phone where CUSTID = :custid"; OracleCommand cmd = new OracleCommand(query, connection); cmd.Parameters.Add(new OracleParameter(":custid", customer.CUSTID)); cmd.Parameters.Add(new OracleParameter(":email", customer.EMAIL)); cmd.Parameters.Add(new OracleParameter(":fname", customer.FIRSTNAME)); cmd.Parameters.Add(new OracleParameter(":lname", customer.LASTNAME)); cmd.Parameters.Add(new OracleParameter(":phone", customer.PHONE)); cmd.ExecuteNonQuery(); if (connection.State == ConnectionState.Open) { connection.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
public ActionResult DeleteConfirmed(int id) { CUSTOMERS cUSTOMERS = db.CUSTOMERS.Find(id); db.CUSTOMERS.Remove(cUSTOMERS); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult KullaniciSil(int id) { CUSTOMERS tempID = db.CUSTOMERS.Where(k => k.ID == id).FirstOrDefault(); db.CUSTOMERS.Remove(tempID); db.SaveChanges(); return(RedirectToAction("Kullanici", "Home")); }
public bool InsertCustomer(CUSTOMERS newCustomer) { using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities()) { dbContext.CUSTOMERS.Add(newCustomer); dbContext.SaveChanges(); } return(true); }
/// <summary> /// Create a new CUSTOMERS object. /// </summary> /// <param name="id">Initial value of ID.</param> /// <param name="cNAME">Initial value of CNAME.</param> /// <param name="cONTACT">Initial value of CONTACT.</param> public static CUSTOMERS CreateCUSTOMERS(int id, string cNAME, string cONTACT) { CUSTOMERS cUSTOMERS = new CUSTOMERS(); cUSTOMERS.ID = id; cUSTOMERS.CNAME = cNAME; cUSTOMERS.CONTACT = cONTACT; return(cUSTOMERS); }
public ActionResult Edit(int id, CUSTOMERS customer) { RetaDbEntities db = new RetaDbEntities(); var mus = db.CUSTOMERS.Find(id); mus.SURNAME = customer.SURNAME; db.SaveChanges(); return(RedirectToAction("index")); }
public ActionResult Edit([Bind(Include = "CUSTOMER_ID,CUSTOMER_NAME,CITY")] CUSTOMERS cUSTOMERS) { if (ModelState.IsValid) { db.Entry(cUSTOMERS).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cUSTOMERS)); }
public void UpdateCustomer(int degisken, CUSTOMERS customer) { CUSTOMERS customer_old = db.CUSTOMERS.Where(m => m.ID == degisken).FirstOrDefault(); customer_old.MAIL = customer.MAIL; customer_old.NAME = customer.NAME; customer_old.PHONE = customer.PHONE; customer_old.SURNAME = customer.SURNAME; db.SaveChanges(); }
public CUSTOMERS GetCustomerById(int id) { var customer = new CUSTOMERS(); using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities()) { customer = dbContext.CUSTOMERS.FirstOrDefault(x => x.client_id == id); } return(customer); }
public ActionResult Create([Bind(Include = "CUSTOMER_ID,CUSTOMER_NAME,CITY")] CUSTOMERS cUSTOMERS) { if (ModelState.IsValid) { db.CUSTOMERS.Add(cUSTOMERS); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cUSTOMERS)); }
public ActionResult KullaniciDuzenle(CUSTOMERS getUser) { CUSTOMERS tempID = db.CUSTOMERS.Where(k => k.ID == getUser.ID).SingleOrDefault(); tempID.CUSTOMERNAME = getUser.CUSTOMERNAME; tempID.AGE = getUser.AGE; tempID.GENDER = getUser.GENDER; tempID.EMAIL = getUser.EMAIL; tempID.PASSWORD = getUser.PASSWORD; db.SaveChanges(); return(RedirectToAction("Kullanici")); }
// GET: CUSTOMERS/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CUSTOMERS cUSTOMERS = db.CUSTOMERS.Find(id); if (cUSTOMERS == null) { return(HttpNotFound()); } return(View(cUSTOMERS)); }
private void ListViewBox_DoubleClick(object sender, EventArgs e) { CUSTOMERS selectedCustomer = (CUSTOMERS)ListViewBox.SelectedItems[0].Tag; if (FromAppointmentCreation) { CreateAppointment.SelectedCustomer = selectedCustomer; FromAppointmentCreation = false; this.Close(); } else if (ListViewBox.SelectedItems.Count == 1) { editCustomerButton_Click(sender, e); } }
/// <summary> /// Deletes selected customer from view and db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void deleteCustomerButton_Click(object sender, EventArgs e) { CUSTOMERS customer = (CUSTOMERS)ListViewBox.SelectedItems[0].Tag; for (int i = 0; i < ListViewBox.Items.Count; i++) { if (ListViewBox.Items[i].Selected) { ListViewBox.Items[i].Remove(); i--; } } _controller.DeleteCustomer(customer); }
private void btn_adoLambda_Click(object sender, EventArgs e) { if (!checkInfo()) { MessageBox.Show("لطفا نام مشتری را وارد کنید.", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { CUSTOMERS customer = ReturnCustInfo(); conection.insert <CUSTOMERS>(customer); ResultMessage(); } }
public static List <CUSTOMERS> GetAll() { CUSTOMERS customer = null; List <CUSTOMERS> customers = new List <CUSTOMERS>(); try { using (OracleConnection con = new OracleConnection(conlink)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "SELECT * FROM CUSTOMERS"; OracleCommand cmd = new OracleCommand(query, con); OracleDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { customer = new CUSTOMERS() { CUSTID = int.Parse(reader["CUSTID"].ToString()), EMAIL = reader["EMAIL"].ToString(), FIRSTNAME = reader["FIRSTNAME"].ToString(), LASTNAME = reader["LASTNAME"].ToString(), PHONE = long.Parse(reader["PHONE"].ToString()), }; customers.Add(customer); } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(customers); }
public ActionResult Index(string EMAIL, string PASSWORD) { CUSTOMERS tempUser = db.CUSTOMERS.Where(k => k.EMAIL == EMAIL && k.PASSWORD.Trim() == PASSWORD.Trim()).SingleOrDefault(); if (tempUser == null) { ViewBag.Sonuc = "Kullanıcı bulunamadı."; return(View()); } else { Session["CUSTOMERS"] = tempUser.CUSTOMERNAME; Session["Security"] = true; return(RedirectToAction("Index", "Home")); } }
public bool UpdateCustomer(CUSTOMERS editCustomer) { bool result = false; using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities()) { var recordToEdit = dbContext.CUSTOMERS.FirstOrDefault(x => x.client_id == editCustomer.client_id); recordToEdit.document_type = editCustomer.document_type; recordToEdit.document_nro = editCustomer.document_nro; recordToEdit.customer_name = editCustomer.customer_name; recordToEdit.address = editCustomer.address; recordToEdit.email = editCustomer.email; recordToEdit.state = editCustomer.state; } return(result); }
private void btn_entitySP_Click(object sender, EventArgs e) { if (!checkInfo()) { MessageBox.Show("لطفا نام مشتری را وارد کنید.", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { CUSTOMERS customer = ReturnCustInfo(); conection.insertEntitySP(customer.code, customer.special, customer.MONAME, customer.group_rdf, customer.vis_rdf, customer.addre, customer.tell1, customer.cred, customer.check_eteb, customer.just_naghdi, customer.MaxManFactor, customer.sharh); ResultMessage(); } }
public static CUSTOMERS Get(string customerEmail) { CUSTOMERS customer = null; try { using (OracleConnection con = new OracleConnection(conlink)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "SELECT * FROM CUSTOMERS WHERE EMAIL =:customerEmail"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add(new OracleParameter(":customerEmail", customerEmail)); OracleDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { if (reader.Read()) { customer = new CUSTOMERS() { CUSTID = int.Parse(reader["CUSTID"].ToString()), EMAIL = reader["EMAIL"].ToString(), FIRSTNAME = reader["FIRSTNAME"].ToString(), LASTNAME = reader["LASTNAME"].ToString(), PHONE = long.Parse(reader["PHONE"].ToString()), }; } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(customer); }
/// <summary> /// Deletes specified custoemr from db /// </summary> /// <param name="customer"></param> public void DeleteCustomer(CUSTOMERS customer) { using (db = new OptikItDbContext()) { var removeQuery = from a in db.CUSTOMERS where a.CS_STAMP == customer.CS_STAMP select a; foreach (var a in removeQuery) { db.CUSTOMERS.Remove(a); } try { db.SaveChanges(); } catch (Exception) { } } }
public ActionResult KayitOl(string CUSTOMERNAME, string EMAIL, string PASSWORD, string pswrepeat, int AGE, string GENDER) { if (PASSWORD == pswrepeat) { var x = new CUSTOMERS(); x.CUSTOMERNAME = CUSTOMERNAME; x.AGE = AGE; x.GENDER = GENDER; x.EMAIL = EMAIL; x.PASSWORD = PASSWORD; db.CUSTOMERS.Add(x); db.SaveChanges(); ViewBag.Basarili = "Üyeliğiniz tamamlanmıştır."; return(RedirectToAction("Index", "Admin")); } else { ViewBag.Basarili = "Üyeliğiniz tamamlanamamıştır."; return(View()); } }
//special operations public static CUSTOMERS CustomerAllData(int id) { CUSTOMERS customer = null; try { customer = CUSTOMERSDAL.Get(id); customer.ADDRESS = CUSTOMERADDRESSDAL.GetAddress(id); customer.ORDERS = ORDERSDAL.GetOrders(id); } catch (NullReferenceException nex) { customer.ADDRESS = new List <CUSTOMERADDRESS>(); customer.ORDERS = new List <ORDERS>(); } catch (Exception ex) { throw ex; } return(customer); }
public static bool InsertCustomer(CUSTOMERS customer) { bool status = false; try { using (OracleConnection connection = new OracleConnection(conlink)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } string query = "INSERT INTO CUSTOMERS (EMAIL,PASSWORD,FIRSTNAME,LASTNAME,PHONE) " + "VALUES (:email,:password,:fname,:lname,:phone)"; #pragma warning disable CS0618 // Type or member is obsolete OracleCommand cmd = new OracleCommand(query, connection); #pragma warning restore CS0618 // Type or member is obsolete cmd.Parameters.Add(new OracleParameter(":email", customer.EMAIL)); cmd.Parameters.Add(new OracleParameter(":password", customer.PASSWORD)); cmd.Parameters.Add(new OracleParameter(":fname", customer.FIRSTNAME)); cmd.Parameters.Add(new OracleParameter(":lname", customer.LASTNAME)); cmd.Parameters.Add(new OracleParameter(":phone", customer.PHONE)); cmd.ExecuteNonQuery(); if (connection.State == ConnectionState.Open) { connection.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
/// <summary> /// creates new specified customer in db /// </summary> /// <param name="customer"></param> public void PostCustomer(CUSTOMERS customer) { using (db = new OptikItDbContext()) { try { db.CUSTOMERS.Add(customer); db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
/// <summary> /// Gets all future appointments of specified customer /// </summary> /// <param name="customer"></param> /// <returns></returns> public List <APTDETAILS> GetFutureAppointments(CUSTOMERS customer) { List <APTDETAILS> futureCustomerAppoinments = new List <APTDETAILS>(); var allAppointments = GetAppointments(); var now = DateTime.Now; foreach (APTDETAILS a in allAppointments) { if (a.APD_CUSTOMER == customer.CS_STAMP && a.APD_DATE > now) { futureCustomerAppoinments.Add(a); } } var sorted = (from a in futureCustomerAppoinments orderby a.APD_DATE select a).ToList(); return(sorted); }
/// <summary> /// edits specified customer in db /// </summary> /// <param name="customer"></param> public void PutCustomer(CUSTOMERS customer) { using (db = new OptikItDbContext()) { var appointmentToEditQuery = from a in db.CUSTOMERS where a.CS_CPRNO == customer.CS_CPRNO select a; foreach (var a in appointmentToEditQuery) { a.CS_CPRNO = customer.CS_CPRNO; a.CS_FIRSTNAME = customer.CS_FIRSTNAME; a.CS_LASTNAME = customer.CS_LASTNAME; a.CS_ADRESS1 = customer.CS_ADRESS1; a.CS_PHONEMOBILE = customer.CS_PHONEMOBILE; a.CS_EMAIL = customer.CS_EMAIL; } try { db.SaveChanges(); } catch (Exception) { } } }