public bool add() { log = new TMS.db(); log.open(); string query; query = "insert into product(pcode,pname,srate,prate) values('" + pcode + "', '" + pname + "', " + srate + ", " + prate + ")"; bool success = log.insertquery(query); log.close(); if (success) { return(true); } else { return(false); } }
public bool add() { log = new TMS.db(); log.open(); string query; query = "insert into party(pname,address,city,contact,balance) values('" + pname + "', '" + paddress + "', '" + pcity + "', '" + contact + "', '" + pbalance + "')"; bool success = log.insertquery(query); log.close(); if (success) { return(true); } else { return(false); } }
private void CityWiseReport_Load(object sender, EventArgs e) { string query = "select city,sum(balance) as amount from party group by city"; db log = new db(); log.open(); dataGridView1.Rows.Clear(); dataGridView1.Refresh(); read = log.searchquery(query); log.close(); if (read.Rows.Count != 0) { for (int i = 0; i < read.Rows.Count; i++) { dataGridView1.Rows.Add(1); dataGridView1[0, i].Value = read.Rows[i][0].ToString(); dataGridView1[1, i].Value = read.Rows[i][1].ToString(); } } }
public bool search(string key) { log = new db(); log.open(); string query = "select * from product where pcode = '" + key + "' or pname = '" + key + "'"; DataTable read = log.searchquery(query); log.close(); if (read.Rows.Count != 0) { pname = read.Rows[0]["pname"].ToString(); code = read.Rows[0]["pcode"].ToString(); srate = Convert.ToInt32(read.Rows[0]["srate"]); prate = Convert.ToInt32(read.Rows[0]["prate"]); return(true); } else { return(false); } }
public bool search(int key) { log = new TMS.db(); log.open(); DataTable read; string query = "select * from payselect where eno=" + key + " and etype='CPV'"; read = log.searchquery(query); bool success = false; log.close(); if (read.Rows.Count != 0) { success = true; eno = Convert.ToInt32(read.Rows[0]["eno"]); amount = Convert.ToInt32(read.Rows[0]["amount"]); party = Convert.ToInt32(read.Rows[0]["partyid"]); partyname = read.Rows[0]["name"].ToString(); description = read.Rows[0]["dscrpt"].ToString(); date = read.Rows[0]["edate"].ToString(); } return(success); }
public order[] search(int key) { log = new TMS.db(); string query = "select * from selectsale1 where eno=" + key + " and etype='SALE'"; log.open(); DataTable read; order[] s = new order[100]; read = log.searchquery(query); log.close(); if (read.Rows.Count != 0) { saleno = Convert.ToInt32(read.Rows[0]["eno"].ToString()); type = read.Rows[0]["etype"].ToString(); totalamount = Convert.ToInt32(read.Rows[0]["tm"].ToString()); party = read.Rows[0]["name"].ToString(); date = read.Rows[0]["edate"].ToString(); desc = read.Rows[0]["dsc"].ToString(); row = 0; for (int i = 0; i < read.Rows.Count; i++) { s[i] = new order(); s[i].kg = Convert.ToInt32(read.Rows[i]["kg"].ToString()); s[i].pc = Convert.ToInt32(read.Rows[i]["pc"].ToString()); s[i].bag = Convert.ToInt32(read.Rows[i]["bag"].ToString()); s[i].rate = Convert.ToInt32(read.Rows[i]["rate"].ToString()); s[i].amt = Convert.ToInt32(read.Rows[i]["amount"].ToString()); s[i].pname = read.Rows[i]["pname"].ToString(); s[i].code = read.Rows[i]["pcode"].ToString(); row++; } } return(s); }
public void search(string searchkey) { log = new TMS.db(); log.open(); int key; DataTable read; string query = "select id from partysearch where name = '" + searchkey + "'"; read = log.searchquery(query); key = Convert.ToInt32(read.Rows[0][0].ToString()); query = "select * from party where id = " + key + ""; read = log.searchquery(query); log.close(); pname = read.Rows[0]["pname"].ToString(); pcity = read.Rows[0]["city"].ToString(); pbalance = Convert.ToInt32(read.Rows[0]["balance"]); paddress = read.Rows[0]["address"].ToString(); pcontact = read.Rows[0]["contact"].ToString(); }
public legdertable[] show(string startdate, string enddate, string pname) { legdertable[] l = new legdertable[1000]; int partyid = getpartyno(pname); int prevbal = prevbalance(startdate, partyid); string query = "select * from entry where edate between '" + startdate + "' and '" + enddate + "' and partyid = " + partyid + " order by edate"; log = new db(); log.open(); DataTable read = log.searchquery(query); log.close(); totalcredit = 0; totaldebit = 0; balance = 0; row = 0; l[0] = new legdertable(); l[0].balance = Math.Abs(prevbal); l[0].description = "Brought Forward"; l[0].type = ""; l[0].no = 0; if (prevbal < 0) { l[0].CRDR = "DR"; } else { l[0].CRDR = "CR"; } l[0].formdate = startdate; balance = prevbal; if (read.Rows.Count != 0) { for (int i = 0; i < read.Rows.Count; i++) { l[i + 1] = new legdertable(); l[i + 1].no = Convert.ToInt32(read.Rows[i]["eno"]); l[i + 1].description = read.Rows[i]["dscrpt"].ToString(); l[i + 1].formdate = read.Rows[i]["edate"].ToString(); l[i + 1].type = read.Rows[i]["etype"].ToString(); if (l[i + 1].type == "SALE" || l[i + 1].type == "CPV") { l[i + 1].credit = Convert.ToInt32(read.Rows[i]["amount"]); balance += l[i + 1].credit; totalcredit += l[i + 1].credit; } else { l[i + 1].debit = Convert.ToInt32(read.Rows[i]["amount"]); balance -= l[i + 1].debit; totaldebit += l[i + 1].debit; } if (balance >= 0) { l[i + 1].CRDR = "CR"; } else { l[i + 1].CRDR = "DR"; } l[i + 1].balance = Math.Abs(balance); row++; } } return(l); }