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);
}
}
