public static void init_Lendings()//מילוי רשימת ההשאלות מתוך בסיס הנתונים { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_all_lending"; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); Lendings = new List <Lending>(); DateTime DT; while (rdr.Read()) { if (rdr.GetValue(5).ToString().Equals("")) { DT = DateTime.MinValue; } else { DT = DateTime.Parse(rdr.GetValue(5).ToString()); } LendingStatus ls = (LendingStatus)Enum.Parse(typeof(LendingStatus), rdr.GetValue(3).ToString()); Lending l = new Lending(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse(rdr.GetValue(1).ToString()), DateTime.Parse(rdr.GetValue(2).ToString()), ls, GetCustomerByEmail(rdr.GetValue(4).ToString()), DT, false); Lendings.Add(l); } }
public Record_in_lending(Lending lending, Record record, int quantity, bool is_new) { this.record = record; this.lending = lending; this.quantity = quantity; if (is_new) { this.create_Record_in_lending(); } }
private void submit_button_Click(object sender, EventArgs e) { if (IsCustomer && IsBarCode && records.Count() > 0) { if (date_piker.Value.Date.CompareTo(DateTime.Now.Date) < 0) { string message3 = "Date invalid"; string title3 = "Error"; MessageBox.Show(message3, title3); } else { if (date_piker.Value.Date.CompareTo(customer.getLendingEndDate().Date) > 0) { string message4 = "End date is after customers lending tab expired"; string title4 = "Error"; MessageBox.Show(message4, title4); } else { isSubmit = true; DateTime dt = date_piker.Value; Lending l = new Lending(Program.Lendings.Count() + 1, DateTime.Now, dt, (LendingStatus)Enum.Parse(typeof(LendingStatus), "inLending".ToString()), customer, DateTime.MinValue, true); Record r; int q; for (int i = 0; i < textBoxes.Count(); i = i + 4) { if (textBoxes[i].Text != "") { r = Program.GetRecordByQR(int.Parse(textBoxes[i].Text)); q = int.Parse(textBoxes[i + 3].Text); Record_in_lending ril = new Record_in_lending(l, r, q, true); l.addRecord(ril); r.addRecordInLending(ril); r.setQuantityInLending(r.getQuantityInLending() + q); } } customer.add_lending(l); string message1 = "Lent Succsessful"; string title1 = ""; MessageBox.Show(message1, title1); submit_button.Hide(); } } } else { string message2 = "Please fill all details"; string title2 = "Error"; MessageBox.Show(message2, title2); } }
private Lending GetLending_ByCustomerAndDate(int id, DateTime dt) { Lending temp = Program.Lendings.First(); foreach (Lending l in Program.Lendings) { if (l.getCustomer().getCustomerID() == id && l.getStartDate() == dt) { temp = l; } } return(temp); }
public static Lending GetLendingByID(int id) { Lending temp = Lendings.First(); foreach (Lending l in Lendings) { if (l.getLendingID() == id) { temp = l; } } return(temp); }
public static void init_Records_in_Lendings()//מילוי רשימת התקיטים בהשאלות מתוך בסיס הנתונים { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_all_RecordsinLendings"; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); while (rdr.Read()) { Lending l = GetLendingByID(int.Parse(rdr.GetValue(0).ToString())); Record r = GetRecordByQR(int.Parse(rdr.GetValue(1).ToString())); Record_in_lending ril = new Record_in_lending(l, r, int.Parse(rdr.GetValue(2).ToString()), false); l.addRecord(ril); r.addRecordInLending(ril); } }
public Lend_Form(Lending l, string r) { this.l = l; InitializeComponent(); //if (LendingID != 0) //{ // this.l = Program.GetLendingByID(LendingID); // } // else // { // this.l = GetLending_ByCustomerAndDate(CustomerID, DateTime); // } textBoxes = new List <TextBox>(); textBoxes.Add(textBox1); textBoxes.Add(textBox2); textBoxes.Add(textBox3); textBoxes.Add(textBox4); textBoxes.Add(textBox5); textBoxes.Add(textBox6); textBoxes.Add(textBox7); textBoxes.Add(textBox8); textBoxes.Add(textBox9); textBoxes.Add(textBox10); textBoxes.Add(textBox11); textBoxes.Add(textBox12); textBoxes.Add(textBox13); textBoxes.Add(textBox14); textBoxes.Add(textBox15); textBoxes.Add(textBox16); textBoxes.Add(textBox17); textBoxes.Add(textBox18); textBoxes.Add(textBox19); textBoxes.Add(textBox20); this.role = r; foreach (TextBox tb in textBoxes) { tb.ReadOnly = true; } }
public void add_lending(Lending lending) { this.Lendings.Add(lending); }