//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())
         {
             purchasepayment newdata = new purchasepayment();
             newdata.date              = datenow;
             newdata.description       = "";
             newdata.purchaseinvoiceid = pinvid;
             newdata.supplierid        = db.hpurchaseinvoices.Find(pinvid).supplierid;
             newdata.projectid         = Convert.ToInt64(Session["project"]);
             newdata.type              = ptype;
             newdata.note              = pnote;
             newdata.total             = db.hpurchaseinvoices.Find(pinvid).grandtotal;
             newdata.number            = db.hpurchaseinvoices.Find(pinvid).number;
             db.hpurchaseinvoices.Find(pinvid).status = 1;
             db.purchasepayments.Add(newdata);
             db.projects.Find(Convert.ToInt64(Session["project"])).status1.purchasepayment = 1;
             db.SaveChanges();
             return(GlobalFunction.get_max_id("purchasepayment").ToString());
         }
     }
     catch (Exception e)
     {
         return("fail");
     }
 }
 public String delete_it(Int64 id)
 {
     try
     {
         using (var db = new dbsmsEntities())
         {
             purchasepayment data = db.purchasepayments.Find(id);
             data.hpurchaseinvoice.status = 0;
             db.purchasepayments.Remove(data);
             db.SaveChanges();
             return("success");
         }
     }
     catch
     {
         return("fail");
     }
 }