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 = "";
}
}