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); } }
//this contructor is use for clone book item from db public BookItem(int id, int info, LendingStatus lending) { this.id = id; this.info = info; this.lendingStatus = lending; if (getBookInfor() != null) { BookInfo = getBookInfor(); } }
public void setStatus(LendingStatus status) { this.status = status; string temp1 = "dbo.sp_LendingStatus " + this.getLendingID().ToString() + " , " + this.status.ToString(); SqlCommand c1 = new SqlCommand(); c1.CommandText = temp1; SQL_CON SC1 = new SQL_CON(); SqlDataReader rdr1 = SC1.execute_query(c1); }
public Lending(int ID, DateTime startDate, DateTime endDate, LendingStatus status, Customer Customer, DateTime returnDate, bool is_new) { this.lendingID = ID; this.startDate = startDate; this.endDate = endDate; this.status = status; this.Customer = Customer; this.returnDate = returnDate; this.records = new List <Record_in_lending>(); foreach (Record_in_lending r in records) { this.records.Add(r); } if (is_new) { this.create_lending(); Program.Lendings.Add(this); } }
private void button1_Click_1(object sender, EventArgs e) { if (dateTimePicker.Value.Date.CompareTo(l.getCustomer().getLendingEndDate().Date) > 0) { string message4 = "End date is after customers lending tab expired"; string title4 = "Error"; MessageBox.Show(message4, title4); return; } if (dateTimePicker.Value.Date.CompareTo(DateTime.Now.Date) < 0) { string message3 = "Date invalid"; string title3 = "Error"; MessageBox.Show(message3, title3); return; } LendingStatus ls = (LendingStatus)Enum.Parse(typeof(LendingStatus), Status_comboBox.SelectedItem.ToString()); l.setStatus(ls); l.setEndDate(dateTimePicker.Value); l.setReturnDate(dateTimePicker1.Value); if (Status_comboBox.SelectedItem.ToString() == "completed") { foreach (Record_in_lending ril in l.getRecords()) { ril.getRecord().setQuantityInStock(ril.getRecord().getQuantityInStock() + ril.getQuantity()); ril.getRecord().setQuantityInLending(ril.getRecord().getQuantityInLending() + ril.getQuantity()); } } string message2 = "Update succeed"; string title2 = ""; MessageBox.Show(message2, title2); }
/// <summary> /// Config the specified lending. /// </summary> /// <param name="lending">Lending.</param> public void Config(LendingStatus lending) { using (var cylinderImageView = ItemView.FindViewById <ImageView>(Resource.Id.cylinderImageView)) { var icon = ProductIcon.GetIcon(lending.ProductCode); if (icon != null) { cylinderImageView.SetImageResource(icon.Value); } } using (var descriptionTextView = ItemView.FindViewById <TextView>(Resource.Id.descriptionTextView)) { descriptionTextView.Text = lending.ShortDescription; } using (var quantityTextView = ItemView.FindViewById <TextView>(Resource.Id.quantityTextView)) { var label = ItemView.Context.Resources.GetString(Resource.String.title_lending); quantityTextView.Text = String.Format("{0} {1}", lending.Quantity, label); } }