public HDPlannerForm(MainForm frmMainIn)
{
InitializeComponent();
frmMain = frmMainIn;
dtpServiceDate.Value = DateTime.Today;
dadAdpt = new SqlDataAdapter();
dset = new DataSet();
conn = new SqlConnection(CCFBGlobal.connectionString);
filllvwStatus();
clsHDRoute.openWhere(" ORDER BY RouteTitle");
if (clsHDRoute.RowCount > 0)
{
cboHDRoute.DataSource = clsHDRoute.DTable;
cboHDRoute.DisplayMember = "RouteTitle";
cboHDRoute.ValueMember = "ID";
}
else
{
cboHDRoute.DataSource = null;
cboHDRoute.Items.Add("No Selection");
}
CCFBGlobal.dtPopulateCombo((DataGridViewComboBoxColumn)dgvHD.Columns["clmSvcItem"], "SELECT * From HDItems", "ShortName", "ID", "Std", conn);
//CCFBGlobal.InitCombo(cboHDRoute, CCFBGlobal.parmTbl_HomeDeliveryRoutes);
andStatement = " And h.HDRoute = " + cboHDRoute.SelectedValue + " ";
cboOrderBy.SelectedIndex = 0;
loadList();
}
public void initForm()
{
loadingData = true;
curHHID = clsHH.ID;
clsVoucher = new VoucherLog(conn);
loadingData = true;
dtpTrxDate.Value = DateTime.Today;
pnlEditVLog.Dock = DockStyle.Fill;
pnlSelect.Dock = DockStyle.Fill;
setEditMode(false);
CCFBGlobal.InitCombo(cboClientType, CCFBGlobal.parmTbl_Client);
CCFBGlobal.dtPopulateCombo(cboNewVoucherItem, "SELECT * FROM VoucherItems ORDER BY UID", "Description", "UID", "No Selection", conn);
foreach (TextBox tb in pnlEditVLog.Controls.OfType <TextBox>())
{
tb.Text = "";
if (tb.Tag != null)
{
if (tb.Tag.ToString() != "")
{
tb.Text = clsHH.GetDataString(tb.Tag.ToString());
}
tbFamData.Add(tb);
tb.LostFocus += new System.EventHandler(this.tbFamData_LostFocus);
}
}
foreach (CheckBox chk in pnlEditVLog.Controls.OfType <CheckBox>())
{
chk.Checked = Convert.ToBoolean(clsHH.GetDataValue(chk.Tag.ToString()));
chkList.Add(chk);
}
tbClient.Text = curHHID.ToString() + Environment.NewLine + clsHH.Name;
cboClientType.SelectedValue = clsHH.ClientType.ToString();
//fillClientInfo();
loadVItmsList();
//loadList();
loadingData = false;
}