public frmSalesMargin() { InitializeComponent(); DataTable dt = period.GetRecord(); dtFrom.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); dtFrom.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); dtTo.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); dtTo.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); dtFrom.Value = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); dtTo.Value = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); DataTable dtitem = item.GetRecord(); DataRow dr = dtitem.NewRow(); dr["Description"] = "All"; dr["itemid"] = 0; dtitem.Rows.Add(dr); dtitem.DefaultView.Sort = "itemid"; cmbItem.DataSource = dtitem; cmbItem.DisplayMember = "Description"; cmbItem.ValueMember = "itemid"; if (Properties.Settings.Default.Lang == "Arabic") { Arabic(); } }
public frmSalesReport() { InitializeComponent(); DataTable dt = period.GetRecord(); txtfrom.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); txtfrom.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); txtto.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); txtto.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); //txtfrom.Value = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); //txtto.Value = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); DataTable dtToken = token.GetRecord(); string from = DateTime.Now.ToString("dd/MM/yyyy"); string to = DateTime.Now.ToString("dd/MM/yyyy"); txtfrom.Value = Convert.ToDateTime(from); txtto.Value = Convert.ToDateTime(to); txtfrom.CustomFormat = "dd/MM/yyyy"; txtto.CustomFormat = "dd/MM/yyyy"; timefrom.Value = (dtToken.Rows.Count > 0)? Convert.ToDateTime(dtToken.Rows[0]["tokenstarttime"].ToString()):Convert.ToDateTime("12:00 AM"); timeto.Value = (dtToken.Rows.Count > 0)? Convert.ToDateTime(dtToken.Rows[0]["tokenendtime"].ToString()):Convert.ToDateTime("11:59 PM"); if (Properties.Settings.Default.Lang == "Arabic") { Arabic(); } }
public frmsalescashsummary() { InitializeComponent(); DataTable dt = period.GetRecord(); dtfrom.Value = Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy")); dtTo.Value = Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy")); AddRecord(); if (Properties.Settings.Default.Lang == "Arabic") { Arabic(); } }
public frmBankBook() { InitializeComponent(); DataTable dt = period.GetRecord(); txtfrom.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); txtto.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); txtfrom.Value = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); txtto.Value = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); if (Properties.Settings.Default.Lang == "Arabic") { Arabic(); } }
public frmItemSales() { InitializeComponent(); DataTable dt = period.GetRecord(); dtFrom.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); dtFrom.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); dtTo.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); dtTo.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); string from = DateTime.Now.ToString("dd/MM/yyyy"); string to = DateTime.Now.ToString("dd/MM/yyyy"); dtFrom.Value = Convert.ToDateTime(from); dtTo.Value = Convert.ToDateTime(to); dtFrom.CustomFormat = "dd/MM/yyyy"; dtTo.CustomFormat = "dd/MM/yyyy"; //dtFrom.Value = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); //dtTo.Value = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); DataTable dtgroup = group.GetRecord(); DataRow dr = dtgroup.NewRow(); dr["itemname"] = "All"; dr["positemid"] = 0; dtgroup.Rows.Add(dr); dtgroup.DefaultView.Sort = "positemid"; cmbgroup.DataSource = dtgroup; cmbgroup.DisplayMember = "itemname"; cmbgroup.ValueMember = "positemid"; DataTable dtitem = item.GetRecord(); DataRow dr1 = dtitem.NewRow(); dr1["Description"] = "All"; dr1["itemid"] = 0; dtitem.Rows.Add(dr1); dtitem.DefaultView.Sort = "itemid"; cmbitems.DataSource = dtitem; cmbitems.DisplayMember = "Description"; cmbitems.ValueMember = "itemid"; if (Properties.Settings.Default.Lang == "Arabic") { Arabic(); } }
public frmLedger() { InitializeComponent(); cmbparticulars.DataSource = ledger.GetParticulars(); cmbparticulars.DisplayMember = "particulars"; cmbparticulars.ValueMember = "particulars"; DataTable dt = period.GetRecord(); txtdateFrom.MinDate = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); txtdateTo.MaxDate = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); txtdateFrom.Value = Convert.ToDateTime(dt.Rows[0]["periodstart"].ToString()); txtdateTo.Value = Convert.ToDateTime(dt.Rows[0]["periodend"].ToString()); if (Properties.Settings.Default.Lang == "Arabic") { Arabic(); } }
public void SetCompanyInfo(bool status = true) { if (status) { clscompanyinfo cmpinfo = new clscompanyinfo(); clsperiodinfo period = new clsperiodinfo(); DataTable dt = cmpinfo.GetRecord(); stripcompany.Text = (dt.Rows[0]["displayname"].ToString() != null && dt.Rows[0]["displayname"].ToString() != "")?dt.Rows[0]["displayname"].ToString(): dt.Rows[0]["companyname"].ToString(); DataTable per = period.GetRecord(); DateTime dtfrom = Convert.ToDateTime(per.Rows[0]["periodstart"]); DateTime dtTo = Convert.ToDateTime(per.Rows[0]["periodend"]); stripperiod.Text = ""; stripperiod.Text = dtfrom.ToString("dd/MM/yyyy") + " to " + dtTo.ToString("dd/MM/yyyy"); } else { stripcompany.Text = ""; stripperiod.Text = ""; } }