//data: { pdate: pdate, ptype: ptype, pnote: pnote, pinvid: pinvid}, public String save_it(String pdate, String ptype, Int64 pinvid, String pnote) { try { DateTime datenow = Convert.ToDateTime(pdate); using (var db = new dbsmsEntities()) { salespayment newdata = new salespayment(); newdata.date = datenow; newdata.description = ""; newdata.salesinvoiceid = pinvid; newdata.to = db.hsalesinvoices.Find(pinvid).customer.name + "\n" + db.hsalesinvoices.Find(pinvid).customer.address + "\n" + db.hsalesinvoices.Find(pinvid).customer.city + "\n" + db.hsalesinvoices.Find(pinvid).customer.phone; newdata.projectid = Convert.ToInt64(Session["project"]); newdata.type = ptype; newdata.note = pnote; newdata.total = db.hsalesinvoices.Find(pinvid).grandtotal; newdata.number = db.hsalesinvoices.Find(pinvid).number; db.hsalesinvoices.Find(pinvid).status = 1; db.salespayments.Add(newdata); db.projects.Find(Convert.ToInt64(Session["project"])).status1.salespayment = 1; db.SaveChanges(); return(GlobalFunction.get_max_id("salespayment").ToString()); } } catch (Exception e) { return("fail"); } }
public String delete_it(Int64 id) { try { using (var db = new dbsmsEntities()) { salespayment data = db.salespayments.Find(id); data.hsalesinvoice.status = 0; db.salespayments.Remove(data); db.SaveChanges(); return("success"); } } catch { return("fail"); } }