public bool insert(order[] sorder) { log = new db(); int partyno = getpartyno(party); string query = "insert into entry values(" + saleno + ",'" + type + "'," + totalamount + "," + partyno + ",'" + desc + "','" + date + "')"; log.open(); if (log.insertquery(query)) { for (int i = 0; i < rowcount; i++) { query = "insert into sale values(" + sorder[i].no + ",'SALE','" + sorder[i].code + "'," + sorder[i].amt + "," + sorder[i].kg + "," + sorder[i].pc + "," + sorder[i].bag + "," + sorder[i].rate + ")"; if (!log.insertquery(query)) { return(false); } } } else { log.close(); return(false); } log.close(); return(true); }
public bool points(int start, int end) { log = new db(); int partyno = getpartyno(partyname); string query = "insert into cr values(" + start + "," + end + ")"; log.open(); bool sucess = log.insertquery(query); log.close(); return(sucess); }
public bool insert() { log = new db(); int partyno = getpartyno(partyname); string query = "insert into entry values(" + eno + ",'CRV','" + amt + "'," + partyno + ",'" + description + "','" + date + "')"; log.open(); bool sucess = log.insertquery(query); log.close(); return(sucess); }
public bool del(string key) { log = new db(); log.open(); string query = "delete from product where pcode = '" + key + "' "; bool success = log.insertquery(query); log.close(); if (success) { return(true); } else { return(false); } }
public bool update(string key) { log = new db(); log.open(); string query = "update product set pcode='" + pcode + "',pname='" + pname + "',srate=" + srate + ",prate=" + prate + " where pcode = '" + key + "'"; 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 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); } }