private void cmbaccname_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true; // This will eliminate the beeping
bool inList = false;
for (int i = 0; i < cmbaccname.Items.Count; i++)
{
s = cmbaccname.GetItemText(cmbaccname.Items[i]);
if (s == cmbaccname.Text)
{
inList = true;
cmbaccname.Text = s;
break;
}
}
if (!inList)
{
cmbaccname.Text = "";
}
DataTable dt = new DataTable();
dt = conn.getdataset("select Product_Name from ProductMaster order by Product_Name");
for (int i = 0; i < dt.Rows.Count; i++)
{
if (cmbaccname.Text == dt.Rows[i]["Product_Name"].ToString())
{
DTPFrom.Focus();
}
}
}
}
private void txtorderno_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
DTPFrom.Focus();
}
}
private void AgentCommissionReport_Load(object sender, EventArgs e)
{
try
{
DataSet dtrange = ods.getdata("SELECT Company.* FROM Company where CompanyID='" + Master.companyId + "'");
DTPFrom.MinDate = Convert.ToDateTime(dtrange.Tables[0].Rows[0]["Startdate"].ToString());
DTPFrom.MaxDate = Convert.ToDateTime(dtrange.Tables[0].Rows[0]["Enddate"].ToString());
DTPTo.MinDate = Convert.ToDateTime(dtrange.Tables[0].Rows[0]["Startdate"].ToString());
DTPTo.MaxDate = Convert.ToDateTime(dtrange.Tables[0].Rows[0]["Enddate"].ToString());
DTPFrom.Value = Convert.ToDateTime(dtrange.Tables[0].Rows[0]["Startdate"].ToString());
LVagent.Columns.Add("Party Name", 400, HorizontalAlignment.Center);
LVagent.Columns.Add("Op.Balance", 150, HorizontalAlignment.Center);
LVagent.Columns.Add("Sales", 150, HorizontalAlignment.Center);
LVagent.Columns.Add("Receipt", 150, HorizontalAlignment.Center);
// LVagent.Columns.Add("Sale Return", 130, HorizontalAlignment.Center);
// LVagent.Columns.Add("Discount", 130, HorizontalAlignment.Center);
// LVagent.Columns.Add("Cl.Balance", 130, HorizontalAlignment.Center);
LVagent.Columns.Add("Commission", 150, HorizontalAlignment.Center);
binaagent();
DTPFrom.CustomFormat = Master.dateformate;
DTPTo.CustomFormat = Master.dateformate;
DTPFrom.Focus();
this.ActiveControl = DTPFrom;
}
catch
{
}
}
private void cmbbarcode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
e.SuppressKeyPress = true; // This will eliminate the beeping
bool inList = false;
for (int i = 0; i < cmbbarcode.Items.Count; i++)
{
s = cmbbarcode.GetItemText(cmbbarcode.Items[i]);
if (s == cmbbarcode.Text)
{
inList = true;
cmbbarcode.Text = s;
break;
}
}
if (!inList)
{
cmbbarcode.Text = "";
}
DTPFrom.Focus();
}
}
public ComplainReceiveList(Master master, TabControl tabcontrol)
{
this.tabControl = tabcontrol;
this.master = master;
InitializeComponent();
//DTPFrom.CustomFormat = Master.dateformate;
//DTPTo.CustomFormat = Master.dateformate;
//DTPFrom.Value = Convert.ToDateTime(DateTime.Now.ToString(Master.dateformate));
//DTPTo.Value = Convert.ToDateTime(DateTime.Now.ToString(Master.dateformate));
//bindgrid();
DTPFrom.Focus();
}
public void getcustdata()
{
isavail = conn.getdataset("select * from clientmaster where isactive=1 and accountname='" + txtcusname.Text + "'");
if (isavail.Rows.Count > 0)
{
txtcusmobile.Text = isavail.Rows[0]["mobile"].ToString();
txtcuscity.Text = isavail.Rows[0]["city"].ToString();
DTPFrom.Focus();
}
else
{
txtcuscity.Focus();
}
}
private void btnlock_Click(object sender, EventArgs e)
{
try
{
pnllockorder.Visible = true;
options = conn.getdataset("select * from options");
if (options.Rows[0]["lockorderno"].ToString() == "Continuous")
{
bindorderno();
DTPFrom.Focus();
this.ActiveControl = DTPFrom;
}
else
{
txtorderno.Focus();
this.ActiveControl = txtorderno;
}
}
catch
{
}
}