private void btnpurchaseorder_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
PurchaseOrder BA = new PurchaseOrder();
BA.TopLevel = false;
// BA.AutoScroll = true;
this.Controls.Add(BA);
BA.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
BA.Dock = DockStyle.Fill;
BA.Visible = true;
BA.BringToFront();
}
}
private void guna2Button1_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
Estimate_Quotation BA = new Estimate_Quotation();
BA.TopLevel = false;
// BA.AutoScroll = true;
this.Controls.Add(BA);
// BA.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
BA.Dock = DockStyle.Fill;
BA.Visible = true;
BA.BringToFront();
}
}
private void button4_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
OtherIncome BA = new OtherIncome();
BA.TopLevel = false;
// BA.AutoScroll = true;
this.Controls.Add(BA);
BA.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
BA.Dock = DockStyle.Fill;
BA.Visible = true;
BA.Show();
}
}
private void guna2Button1_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
//this.Controls.Clear();
PurchaseBill PB = new PurchaseBill();
PB.TopLevel = false;
// PB.AutoScroll = true;
this.Controls.Add(PB);
PB.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
PB.Dock = DockStyle.Fill;
PB.Show();
// PB.BringToFront();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
CashInHandAdjust BA = new CashInHandAdjust();
//BA.TopLevel = false;
// BA.AutoScroll = true;
this.Controls.Add(BA);
// CN.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
BA.Dock = DockStyle.Fill;
BA.Visible = true;
BA.BringToFront();
}
}
private void btnPartyGroup_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
Party_Group BA = new Party_Group();
// BA.TopLevel = false;
// BA.AutoScroll = true;
this.Controls.Add(BA);
// BA.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
BA.Dock = DockStyle.Fill;
BA.Visible = true;
BA.BringToFront();
guna2ShadowPanel3.Visible = true;
}
// BA.Show();
}
private void btnPrint_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
if (MessageBox.Show("DO YOU WANT PRINT??", "PRINT", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
DataSet ds = new DataSet();
//string Query = string.Format("SELECT a.CompanyID,a.CompanyName, a.Address, a.PhoneNo, a.EmailID,a.GSTNumber,a.AddLogo,b.Company_ID,b.TableName,b.PartyName,b.DueDate,b.InvoiceDate,b.Total,b.ReturnNo,b.Received,b.RemainingBal,b.Status,b.DeleteData FROM tbl_CompanyMaster as a, tbl_DebitNote as b where a.CompanyID='" + NewCompany.company_id + "' and b.Company_ID='" + NewCompany.company_id + "' and b.DeleteData = '1' ");
string Query = string.Format("SELECT a.CompanyID,a.CompanyName, a.Address, a.PhoneNo, a.EmailID,a.GSTNumber,a.AddLogo,b.Company_ID,b.ReceiptNo,b.CustomerName,b.PaymentType,b.ReceivedAmount,b.UnusedAmount,b.Total,b.DeleteData FROM tbl_CompanyMaster as a, tbl_PaymentIn as b where a.CompanyID='" + NewCompany.company_id + "' and b.Company_ID='" + NewCompany.company_id + "' and b.DeleteData='1' ");
SqlDataAdapter SDA = new SqlDataAdapter(Query, con);
SDA.Fill(ds);
StiReport report = new StiReport();
report.Load(@"PaymetinData.mrt");
report.Compile();
StiPage page = report.Pages[0];
report.RegData("PaymentinData", "PaymentinData", ds.Tables[0]);
report.Dictionary.Synchronize();
report.Render();
report.Show(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void button3_Click(object sender, EventArgs e)
{
if (DateTime.Now > Program.expdate)
{
Trialform tf = new Trialform();
tf.Show();
}
else
{
if (MessageBox.Show("DO YOU WANT PRINT??", "PRINT", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
DataSet ds = new DataSet();
string Query = string.Format("select c.CompanyID,c.CompanyName,c.Address,c.AddLogo,c.PhoneNo,c.GSTNumber,c.EmailID,b.BillDate,b.Company_ID, b.BillNo, b.PartyName, b.PaymentType, b.Total, b.Paid, b.RemainingBal,b.DeleteData, b.Status from tbl_PurchaseBill as b,tbl_CompanyMaster as c where c.CompanyID = '" + NewCompany.company_id + "' and b.Company_ID = '" + NewCompany.company_id + "' and b.DeleteData = '1'");
SqlDataAdapter SDA = new SqlDataAdapter(Query, con);
SDA.Fill(ds);
StiReport report = new StiReport();
report.Load(@"PurchaseBillData.mrt");
report.Compile();
StiPage page = report.Pages[0];
report.RegData("PurchaseBillData", "PurchaseBillData", ds.Tables[0]);
report.Dictionary.Synchronize();
report.Render();
report.Show(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
