private void button3_Click(object sender, EventArgs e) { TB_IC_No.Text = DBAccess.GetMaxNext("ConsignmentNo", "Consignments", "max").ToString(); _uiManager.clearFields(P_IC.Controls, diContConsignmentsMand, true); TB_IC_No.Focus(); }
private void FormNewConsignment_Load(object sender, EventArgs e) { #region Setting up UI RB_IC_Value.Checked = true; P_IC.Dock = DockStyle.Fill; DTP_IC.Format = DateTimePickerFormat.Custom; DTP_IC.Text = DateTime.Now.ToShortDateString(); DTP_IC.CustomFormat = "dd/MM/yyyy"; TB_IC_No.MaxLength = TB_IC_Packages.MaxLength = 10; TB_IC_Amount.MaxLength = TB_IC_Rate.MaxLength = TB_IC_Weight.MaxLength = 13; TB_IC_Inv.MaxLength = 20; TB_IC_Vehicle.MaxLength = 20; TB_IC_Desc.MaxLength = 500; TB_IC_Amount.TextAlign = TB_IC_Packages.TextAlign = TB_IC_Rate.TextAlign = TB_IC_Weight.TextAlign = HorizontalAlignment.Right; //cbConsignor.DropDownStyle = ComboBoxStyle.DropDown; _uiManager.setBackColor(P_IC.Controls, Color.Transparent); #endregion #region Setting up data TB_IC_No.Text = DBAccess.GetMaxNext("ConsignmentNo", "Consignments", "max").ToString(); DataTable dt = DBAccess.GetKeyValueDataTable("CityID", "City", "Cities"); dt.Rows.InsertAt(dt.NewRow(), 0); dt.Rows[0]["CityId"] = 0; dt.Rows[0]["City"] = "--select--"; cbFrom.DisplayMember = cbTo.DisplayMember = "City"; cbFrom.ValueMember = cbTo.ValueMember = "CityID"; // Sometimes it gives ArgumentException at the time of binding DisplayMember to data source, which is why I am assigning them before Data source. cbFrom.DataSource = dt; cbTo.DataSource = dt.Copy(); dt = null; dt = DBAccess.GetKeyValueDataTable("PartyID", "Name", "Parties"); dt.Rows.InsertAt(dt.NewRow(), 0); dt.Rows[0]["PartyID"] = 0; dt.Rows[0]["Name"] = "--select--"; cbConsignor.DisplayMember = cbConsignee.DisplayMember = "Name"; cbConsignor.ValueMember = cbConsignee.ValueMember = "PartyID"; cbConsignor.DataSource = dt; cbConsignee.DataSource = dt.Copy(); dt = null; #endregion #region Collecting numeric controls diContConsignmentsNum.Add(TB_IC_No, "Int"); diContConsignmentsNum.Add(TB_IC_Packages, "Int"); diContConsignmentsNum.Add(TB_IC_Weight, "Decimal"); diContConsignmentsNum.Add(TB_IC_Rate, "Decimal"); diContConsignmentsNum.Add(TB_IC_Amount, "Decimal"); #endregion #region Collecting compulsory controls diContConsignmentsMand.Add(TB_IC_No, EP_IC_No); diContConsignmentsMand.Add(cbConsignor, EP_IC_Signor); diContConsignmentsMand.Add(cbConsignee, EP_IC_Signee); diContConsignmentsMand.Add(cbFrom, EP_IC_Signee); diContConsignmentsMand.Add(cbTo, EP_IC_To); diContConsignmentsMand.Add(TB_IC_Weight, EP_IC_Weight); #endregion TB_IC_No.Focus(); TB_IC_Amount.Enabled = false; }