//data: { pino: pino, pidate: pidate, poid: poid, desc: desc, detail: detail, disc:disc },
public String save_it(String pino, String pidate, Int64 poid, Int64 disc, String desc, String detail)
{
try
{
DateTime datenow = Convert.ToDateTime(pidate);
using (var db = new dbsmsEntities())
{
hpurchaseinvoice newdata = new hpurchaseinvoice();
newdata.date = datenow;
newdata.description = desc;
newdata.poid = poid;
newdata.supplierid = db.hpoes.Find(poid).supplierid;
newdata.projectid = Convert.ToInt64(Session["project"]);
newdata.terms = "C.O.D";
newdata.number = pino;
db.hpurchaseinvoices.Add(newdata);
Int64 total = 0;
String[] res = detail.Split('ѥ');
for (int i = 0; i < res.Length - 1; i++)
{
String[] result = res[i].Split('Ё');
dpurchaseinvoice data = new dpurchaseinvoice();
//detail += itemcatid + "Ё" + itemdescription + "Ё" + qty + "Ё" + unitprice;
data.itemcategoryid = Convert.ToInt64(result[0]);
data.itemdescription = result[1];
data.qty = Convert.ToInt32(result[2]);
data.unitprice = Convert.ToInt32(result[3]);
data.subtotal = data.qty * data.unitprice;
total += data.subtotal;
//data.penawaranid = GlobalFunction.get_max_id("hpenawaran");
db.dpurchaseinvoices.Add(data);
}
total -= db.hpoes.Find(poid).dp;
newdata.total = total;
newdata.diskon = disc;
newdata.grandtotal = newdata.total - newdata.diskon;
db.SaveChanges();
using (var db1 = new dbsmsEntities())
{
db1.projects.Find(Convert.ToInt64(Session["project"])).status1.purchaseinvoice = 1;
db1.SaveChanges();
return("success");
}
}
}
catch (Exception e)
{
return("fail");
}
}
public String save_it(String podate, Int64 poid, String expecteddate, String shipto, String terms, Int64 projectid, String desc, Int64 dp, Int64 discount, Int64 remainingpayment, String detail, Boolean edit = false)
{
try
{
DateTime datenow = Convert.ToDateTime(podate);
DateTime datenow1 = Convert.ToDateTime(expecteddate);
using (var db = new dbsmsEntities())
{
hpo newdata = db.hpoes.Find(poid);
newdata.date = datenow;
newdata.expecteddate = datenow1;
newdata.terms = terms;
newdata.description = desc;
newdata.dp = dp;
newdata.discount = discount;
newdata.grandtotal = remainingpayment;
newdata.to = shipto;
newdata.status = 1;
db.SaveChanges();
if (dp > 0 && !edit)
{
using (var db1 = new dbsmsEntities())
{
hpurchaseinvoice newdata1 = new hpurchaseinvoice();
newdata1.date = datenow;
newdata1.number = GlobalFunction.generate_code("DP");
newdata1.projectid = projectid;
newdata1.terms = terms;
newdata1.supplierid = newdata.supplierid;
newdata1.description = "Down payment untuk PO : " + newdata.number;
newdata1.total = dp;
newdata1.grandtotal = dp;
newdata1.poid = poid;
newdata1.diskon = 0;
db1.hpurchaseinvoices.Add(newdata1);
dpurchaseinvoice newdata2 = new dpurchaseinvoice();
newdata2.itemcategoryid = 2;
newdata2.itemdescription = "Down Payment";
newdata2.qty = 1;
newdata2.unitprice = dp;
newdata2.subtotal = dp;
db1.dpurchaseinvoices.Add(newdata2);
db1.hpoes.Find(poid).project.status1.purchaseinvoice = 1;
db1.SaveChanges();
}
}
using (var db1 = new dbsmsEntities())
{
//purchasepayment pp = new purchasepayment();
//pp.projectid = projectid;
//pp.purchaseinvoiceid = GlobalFunction.get_max_id("hpurchaseinvoice");
//pp.number = db1.hpurchaseinvoices.Find(GlobalFunction.get_max_id("hpurchaseinvoice")).number;
//pp.date = datenow;
//pp.supplierid = newdata.supplierid;
//pp.total = dp;
//pp.description = "Pembayaran DP untuk PO : " + newdata.number;
//pp.type = terms;
//pp.note = "";
//db1.purchasepayments.Add(pp);
db1.hpoes.Find(poid).project.status1.purchaseorder = 1;
db1.SaveChanges();
return("success");
}
}
}
catch (Exception e)
{
return("fail");
}
}
