private void initializeWishListDetails(int wishID) { DataTable ds = new DataTable(); ds = wishRep.GetWishListID(wishID); CommonUIMethods.ClearControl(this); txtMembers.Text = ds.Rows[0]["MemberID"].ToString(); txtBookId.Text = ds.Rows[0]["BookID"].ToString(); txtBookName.Text = ds.Rows[0]["BookName"].ToString(); if (ds.Rows[0]["AuthorName"].ToString() == "--Select--") { lstAuthor.SelectedIndex = 0; } else { lstAuthor.Text = ds.Rows[0]["AuthorName"].ToString(); } chkBookGiven.Checked = bool.Parse(ds.Rows[0]["Status"].ToString()); lblWishID.Text = wishID.ToString(); if (String.IsNullOrEmpty(ds.Rows[0]["GrantDate"].ToString())) { dateGrantBook.Text = DateTime.Now.ToShortDateString(); dateGrantBook.Checked = false; } else { dateGrantBook.Checked = true; dateGrantBook.Text = ds.Rows[0]["GrantDate"].ToString(); } }
private void btnSeriesAdd_Click(object sender, EventArgs e) { String strSeries = lstSeries.Text; Series objSeries = new Series(); Utils.CommonMethods cmMethod = new CommonMethods(); if (bookRep.GetSeriesDetails(strSeries).Rows.Count > 0) { MessageBox.Show("Series already present"); return; } objSeries.SeriesName = strSeries; bookRep.InsertSeries(objSeries); lstSeries.DataSource = cmMethod.InitializeList(bookRep.GetSeriesDetails()); lstSeries.DisplayMember = "Seriesname"; lstSeries.ValueMember = "SeriesId"; CommonUIMethods.setLstValue(lstSeries, strSeries); autoSeries.Clear(); foreach (DataRowView dr in lstSeries.Items) autoSeries.Add(dr.Row[1].ToString()); lstSeries.AutoCompleteSource = AutoCompleteSource.CustomSource; lstSeries.AutoCompleteCustomSource = autoSubCategory; }
private void InitializeData(string bookID) { if (gridBooks.RowCount > 0) { lstAuthor.SelectedIndex = 0; lstCategory.SelectedIndex = 0; lstSeries.SelectedIndex = 0; txtMembers.Text = ""; //lstAlphas.SelectedIndex = 0; txtBookId.Text = bookID; tempBookid = txtBookId.Text; DataTable ds = new DataTable(); ds = bookRep.GetBookIDDetails(tempBookid); txtBookName.Text = ds.Rows[0]["BookName"].ToString(); if (transRep.GetTransLoanDetails(tempBookid).Rows.Count > 0) lblBookLendTo.Text = "Book Loaned To:" + transRep.GetTransLoanDetails(tempBookid).Rows[0]["MemberID"].ToString(); else lblBookLendTo.Text = ""; CommonUIMethods.setLstValue(lstAuthor, ds.Rows[0]["Authorname"].ToString()); txtBookPrice.Text = ds.Rows[0]["BookPrice"].ToString(); txtOrgprice.Text = ds.Rows[0]["OrgPrice"].ToString(); CommonUIMethods.setLstValue(lstCategory, ds.Rows[0]["CategoryName"].ToString()); CommonUIMethods.setLstValue(lstSubcat, ds.Rows[0]["Name"].ToString()); CommonUIMethods.setLstValue(lstSeries, ds.Rows[0]["SeriesName"].ToString()); autoAuthors.Clear(); autoSubCategory.Clear(); autoSeries.Clear(); foreach (DataRowView dr in lstAuthor.Items) autoAuthors.Add(dr.Row[1].ToString()); foreach (DataRowView dr in lstSubcat.Items) autoSubCategory.Add(dr.Row[1].ToString()); foreach (DataRowView dr in lstSeries.Items) autoSeries.Add(dr.Row[1].ToString()); lstAuthor.AutoCompleteSource = AutoCompleteSource.CustomSource; lstAuthor.AutoCompleteCustomSource = autoAuthors; lstSubcat.AutoCompleteSource = AutoCompleteSource.CustomSource; lstSubcat.AutoCompleteCustomSource = autoSubCategory; lstSeries.AutoCompleteSource = AutoCompleteSource.CustomSource; lstSeries.AutoCompleteCustomSource = autoSeries; } }
public void initializeTransData(int transID) { if (gridTrans.Rows.Count > 0) { DataTable ds = new DataTable(); btnMemWish.Enabled = false; if (transID == 0) { ds = CommonUIMethods.ConvertGridToTable(gridTrans); } else { ds = transRep.GetTransIDDetails(transID); } lblMemberNotes.Text = memRep.GetMemberNotes(ds.Rows[0]["MemberID"].ToString()).Rows[0]["Notes"].ToString(); lblAlreadyRead.Text = ""; txtTransBookid.Text = ds.Rows[0]["BookID"].ToString(); txtTransMemId.Text = ds.Rows[0]["MemberID"].ToString(); setTransMemName(); lblTransId.Text = ds.Rows[0]["TransID"].ToString(); dateTransLoan.Text = ds.Rows[0]["LendDate"].ToString(); dateTransDue.Text = ds.Rows[0]["DueDate"].ToString(); if (String.Compare(DateTime.MinValue.ToString(), ds.Rows[0]["ReturnDate"].ToString()) == 0) { dateTransReturn.Text = ""; } else { dateTransReturn.Text = ds.Rows[0]["ReturnDate"].ToString(); } txtTransLendRate.Text = ds.Rows[0]["LendRate"].ToString(); txtTransFine.Text = ds.Rows[0]["Fine"].ToString(); txtLibBal.Text = ds.Rows[0]["LibBal"].ToString(); txtMemBal.Text = ds.Rows[0]["MemBal"].ToString(); txtRenewal.Text = ds.Rows[0]["RenewalDays"].ToString(); CommonUIMethods.setBookLabel(lblBookLabel, txtTransBookid.Text); if (wishRep.SearchWishList(txtTransMemId.Text).Rows.Count > 0) { btnMemWish.Enabled = true; } } }
private void leaveBookID(object sender, EventArgs e) { CommonUIMethods.setBookLabel(lblBookLabel, txtTransBookid.Text); CommonUIMethods.setLendRate(txtTransLendRate, txtTransBookid.Text); }
private void btnClear_Click(object sender, EventArgs e) { CommonUIMethods.ClearControl(this); }