private void button2_Click(object sender, EventArgs e)
{
int sid = Convert.ToInt32(txt_sid.Text);
int pino = Convert.ToInt32(cmb_pino.Text);
int qty = Convert.ToInt32(ret_qty.Text);
class_p_return p = new class_p_return();
int flag = 0;
p.add(sid, pino, qty, txt_res.Text);
flag = p.update(qty, pino);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conDB.con.Open();
int id = Convert.ToInt32(txt_sid.Text);
SqlDataAdapter dap = new SqlDataAdapter("SELECT * FROM tbl_rt where pino='" + pino + "' ", conDB.con);
DataTable dt = new DataTable();
dap.Fill(dt);
metroGrid1.DataSource = dt;
metroGrid1.Refresh();
conDB.con.Close();
}
private void button2_Click(object sender, EventArgs e)
{
int ff = 0;
if (p.Text == cp.Text)
{
class_user h = new class_user();
ff = h.updt_pwd(u.Text, p.Text);
if (ff > 0)
{
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show("Error ", "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Both Password Should be same ", "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
// string type = comboBox1.SelectedIndex.ToString();
string un = txt_un.Text;
string pwd = txt_pwd.Text;
string cnf = txt_cpwd.Text;
if (txt_un.Text.Length > 0)
{
errorProvider3.Clear();
if (txt_pwd.Text.Length > 0)
{
errorProvider1.Clear();
if (txt_cpwd.Text.Length > 0)
{
errorProvider1.Clear();
}
else
{
errorProvider1.SetError(txt_un, "Required");
}
}
else
{
errorProvider1.SetError(txt_cpwd, "Requierd");
}
}
else
{
errorProvider3.SetError(txt_un, "Requierd");
}
int flag = 0;
if (pwd == cnf)
{
errorProvider1.Clear();
class_user u = new class_user();
flag = u.add(un, pwd);
}
else
{
errorProvider1.SetError(txt_pwd, "Password not matching");
}
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button9_Click(object sender, EventArgs e)
{
try
{
int flag = 0;
int id = Convert.ToInt32(txt_sid.Text);
class_supplier cs = new class_supplier();
flag = cs.delete(id);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
setDataGride2();
}
catch (Exception)
{
MessageBox.Show("Error");
}
toClearTextField_sup();
}
private void button3_Click(object sender, EventArgs e)
{
try
{
int flag = 0;
int id = Convert.ToInt32(txt_cid.Text);
int mno = Convert.ToInt32(txt_cmno.Text);
class_customer ss = new class_customer();
flag = ss.update(txt_cfnme.Text, txt_cmnme.Text, txt_clnme.Text, txt_add1.Text, txt_add2.Text, txt_add3.Text, mno, txt_cemail.Text, id);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
MessageBox.Show("Error");
}
toClearText();
}
private void button3_Click(object sender, EventArgs e)
{
if (txt_siz.Text.Length > 0)
{
errorProvider1.Clear();
if (txt_clr.Text.Length > 0)
{
errorProvider3.Clear();
if (txt_cat.Text.Length > 0)
{
errorProvider1.Clear();
if (txt_mat.Text.Length > 0)
{
errorProvider1.Clear();
class_user u = new class_user();
int flag = 0;
flag = u.add(txt_cat.Text, txt_mat.Text, txt_clr.Text, txt_siz.Text);
setDataGride2();
clear();
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
errorProvider1.SetError(txt_mat, "Required");
}
}
else
{
errorProvider1.SetError(txt_cat, "Requierd");
}
}
else
{
errorProvider3.SetError(txt_clr, "Requierd");
}
}
else
{
errorProvider1.SetError(txt_siz, "Required");
}
}
/// <summary>
/// Create a new instance.
/// </summary>
/// <param name="parent">PopupNotifier</param>
public PopupNotifierForm(PopupNotifier parent)
{
Parent = parent;
this.SetStyle(ControlStyles.OptimizedDoubleBuffer, true);
this.SetStyle(ControlStyles.ResizeRedraw, true);
this.SetStyle(ControlStyles.AllPaintingInWmPaint, true);
this.ShowInTaskbar = false;
this.VisibleChanged += new EventHandler(PopupNotifierForm_VisibleChanged);
this.MouseMove += new MouseEventHandler(PopupNotifierForm_MouseMove);
this.MouseUp += new MouseEventHandler(PopupNotifierForm_MouseUp);
this.Paint += new PaintEventHandler(PopupNotifierForm_Paint);
}
private void button1_Click(object sender, EventArgs e)
{
//int pid = Convert.ToInt32(txt_pid.Text);
// DateTime dt = DateTime.Today;
int sid = Convert.ToInt32(cmb_sid.Text);
int qty = Convert.ToInt32(txt_Qty.Text);
double up = Convert.ToDouble(txt_UP.Text);
String iname = txt_iname.Text;
String des = txt_Descrip.Text;
//txt_Date.Text=dt.ToString();
Class_purchase a = new Class_purchase();
a.add(iname, qty, des, up, txt_Date.Text);
conDB.con.Open();
string qury = "SELECT max(pino) from tbl_purchase_item";
SqlCommand cmd = new SqlCommand(qury, conDB.con);
SqlDataReader dr = cmd.ExecuteReader();
int pino = 0;
while (dr.Read())
{
// txt_oid.Text = dr.GetValue(0).ToString();
pino = dr.GetInt32(0);
}
cmd.Dispose();
dr.Dispose();
cmd.Dispose();
conDB.con.Close();
int flag = 0;
flag = a.add(sid, pino, qty, txt_Date.Text);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
lddata();
}
private void button4_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txt_ino.Text);
int flag = 0;
class_user u = new class_user();
flag = u.delete(id);
setDataGride2();
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button2_Click_1(object sender, EventArgs e)
{
try
{
int flag = 0;
int cid = Convert.ToInt32(txt_icid.Text);
int oid = Convert.ToInt32(cmb_ioid.SelectedIndex.ToString());
string dt = txt_date.Text;
double st = Convert.ToDouble(txt_nt.Text);
class_invoice inv = new class_invoice();
flag = inv.add(cid, oid, dt, st);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (SqlException)
{
MessageBox.Show(this, "Database Error ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MessageBox.Show(this, "Error ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button3_Click(object sender, EventArgs e)
{
// try
// {
conDB.con.Open();
int oid = Convert.ToInt32(txt_roid.Text);
int pid = Convert.ToInt32(cmb_rpid.SelectedIndex.ToString());
int cid = Convert.ToInt32(txt_rcid.Text);
int qty = Convert.ToInt32(txt_rqty.Text);
string q = "select fqty from tbl_finish_output where f_ID = '" + pid + "' ";
SqlCommand cd = new SqlCommand(q, conDB.con);
SqlDataReader drr = cd.ExecuteReader();
int qtyo = 0;
while (drr.Read())
{
// qtyo = Convert.ToInt32(drr.GetValue(0).ToString());
qtyo = drr.GetInt32(0);
}
// txt_rcid.Text = cid.ToString();
cd.Dispose();
drr.Dispose();
conDB.con.Close();
if (qty > qtyo)
{
MessageBox.Show("Invalid", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int flag = 0;
class_s_return s = new class_s_return();
flag = s.add(cid, oid, pid, qty, txt_reson.Text);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conDB.con.Open();
//int oid = Convert.ToInt32(txt_oid.Text);
SqlDataAdapter dap = new SqlDataAdapter("SELECT * FROM tbl_cus_rt where cus_ID='" + cid + "' ", conDB.con);
DataTable dt = new DataTable();
dap.Fill(dt);
metroGrid3.DataSource = dt;
metroGrid3.Refresh();
conDB.con.Close();
}
/* }
* catch (Exception)
* {
* }*/
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (cmb_oid.Text.Length > 0)
{
errorProvider1.Clear();
if (txt_pnme.Text.Length > 0)
{
errorProvider3.Clear();
if (txt_qty.Text.Length > 0)
{
errorProvider2.Clear();
if (txt_fqty.Text.Length > 0)
{
errorProvider1.Clear();
int flag = 0;
DateTime dtnow = DateTime.Today;
int qty = 0;
int ino = Convert.ToInt32(txt_rino.Text);
int tot = Convert.ToInt16(txt_tot.Text);
int oid = Convert.ToInt32(cmb_oid.Text);
qty = Convert.ToInt32(txt_qty.Text);
int fqty = Convert.ToInt32(txt_fqty.Text);
Class_product PP = new Class_product();
flag = PP.add(oid, tot, txt_pnme.Text, fqty);
// cmd = new SqlCommand();
conDB.con.Open();
int fid = 0;
cmd.Connection = conDB.con;
cmd.CommandText = "SELECT max(f_ID) FROM tbl_finish_output ";
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
fid = Convert.ToInt32(dr.GetValue(0).ToString());
}
dr.Close();
cmd.Dispose();
conDB.con.Close();
PP.update(qty, ino);
PP.add(ino, fid, qty);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
errorProvider1.SetError(txt_fqty, "Enter quantity");
}
}
else
{
errorProvider3.SetError(txt_qty, "Quantity Required");
}
}
else
{
errorProvider2.SetError(txt_pnme, "Please enter design no");
}
}
else
{
errorProvider1.SetError(cmb_oid, "Please select customer");
}
}
catch (SqlException)
{
MessageBox.Show(this, "Database Error ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MessageBox.Show(this, "Error ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btn_srch_Click(object sender, EventArgs e)
{
try
{
if (cmb_fnme.Text.Length > 0)
{
errorProvider1.Clear();
if (txt_dsno.Text.Length > 0)
{
if (txt_qty.Text.Length > 0)
{
errorProvider2.Clear();
int flag = 0;
DateTime dtnow = DateTime.Today;
int qty = 0;
int ino = Convert.ToInt16(txt_ino.Text);
int oid = Convert.ToInt32(txt_oid.Text);
qty = Convert.ToInt32(txt_qty.Text);
Class_sales cs = new Class_sales();
flag = cs.add(ino, oid, qty, txt_dsno.Text);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
clear();
}
else
{
errorProvider3.SetError(txt_qty, "Quantity Required");
}
}
else
{
errorProvider2.SetError(txt_dsno, "Please enter design no");
}
}
else
{
errorProvider1.SetError(cmb_fnme, "Please select customer");
}
loadmetro2();
// load();
}
catch (SqlException)
{
MessageBox.Show(this, "Database Error ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MessageBox.Show(this, "Error ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button7_Click(object sender, EventArgs e)
{
try
{
if (txt_sfnme.Text.Length > 0)
{
errorProvider1.Clear();
errorProvider3.Clear();
if (txt_sadd1.Text.Length > 0)
{
errorProvider4.Clear();
if (txt_sadd2.Text.Length > 0)
{
errorProvider5.Clear();
if (txt_sadd3.Text.Length > 0)
{
errorProvider6.Clear();
if (txt_smno.Text.Length != 0)
{
errorProvider7.Clear();
if (txt_semail.Text.Length > 0)
{
errorProvider8.Clear();
if (txt_c_nme.Text.Length > 0)
{
errorProvider2.Clear();
}
else
{
errorProvider2.SetError(txt_c_nme, "You should fiil required data");
}
}
else
{
errorProvider8.SetError(txt_semail, "You should fiil required data");
}
}
else
{
errorProvider7.SetError(txt_smno, "You should fiil required data");
}
}
else
{
errorProvider6.SetError(txt_sadd3, "You should fiil required data");
}
}
else
{
errorProvider5.SetError(txt_sadd2, "You should fiil required data");
}
}
else
{
errorProvider4.SetError(txt_sadd1, "You should fiil required data");
}
}
else
{
errorProvider1.SetError(txt_sfnme, "You should fiil required data");
}
int flag = 0;
int mno = Convert.ToInt32(txt_smno.Text);
class_supplier ss = new class_supplier();
flag = ss.add(txt_sfnme.Text, txt_sadd1.Text, txt_sadd2.Text, txt_sadd3.Text, mno, txt_semail.Text, txt_c_nme.Text);
if (flag > 0)
{
// MessageBox.Show(this, "Row added", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
PopupNotifier popup = new Tulpep.NotificationWindow.PopupNotifier();
popup.Image = Properties.Resources.Information_Bubble_48;
popup.ContentText = "Success";
// popup.BodyColor.ToString();
popup.Popup();
}
else
{
MessageBox.Show(this, "Data not added ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
setDataGride2();
}
catch (Exception)
{
}
toClearTextField_sup();
}