//public JsonResult InvoiceDelete(InvoiceVocher tbv, InvoiceDetails tbvd, string InvoiceVoucherNo, int InvoiceID, decimal TotalAmount)
//{
// tbvd = db.InvoiceDetails.FirstOrDefault(x => x.InvoiceID == InvoiceID);
// db.InvoiceDetails.Remove(tbvd);
// db.SaveChanges();
// tbv = db.InvoiceVochers.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
// //tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount;
// //tbv.vat = 0;
// //tbv.Discount = tbv.GrandTotalAmount;
// tbv.TotalAmount = tbv.TotalAmount - TotalAmount;
// //tbv.vat = 0;
// //tbv.Discount = tbv.TotalAmount;
// db.SaveChanges();
// var jsonData = new { success = true, message = "Successfully Deleted." };
// return Json(jsonData, JsonRequestBehavior.AllowGet);
//}
//............Delete...........
public ActionResult Delete(tbl_InvoiceVocher tbv, tbl_InvoiceDetails tbvd, string InvoiceVoucherNo)
{
var info = (from item in db.tbl_InvoiceDetails where item.InvoiceVoucherNo == InvoiceVoucherNo select item).ToList();
if (info.Count > 1)
{
foreach (var vp in info)
{
db.tbl_InvoiceDetails.Remove(vp);
}
}
else
{
if (InvoiceVoucherNo != null)
{
tbvd = db.tbl_InvoiceDetails.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
db.tbl_InvoiceDetails.Remove(tbvd);
}
}
db.SaveChanges();
tbv = db.tbl_InvoiceVocher.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
db.tbl_InvoiceVocher.Remove(tbv);
db.SaveChanges();
return(RedirectToAction("Invoicelist"));
}
public ActionResult Invoicelist(string keyword, tbl_InvoiceVocher invoice)
{
var results = (from item in db.tbl_InvoiceVocher where item.tbl_PatientInfo.PatientName.Contains(keyword) select item).ToList();
var pageIndex = invoice.Page ?? 1;
invoice.InvoicelistResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(invoice));
}
//.................list................
public ActionResult Invoicelist(tbl_InvoiceVocher invoice)
{
var results = (from item in db.tbl_InvoiceVocher
select item).ToList().OrderBy(p => p.InvoiceVoucherNo);
var pageIndex = invoice.Page ?? 1;
invoice.InvoicelistResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(invoice));
}
public JsonResult InvoiceProcess(tbl_InvoiceVocher o)
{
bool status = false;
int vc;
var MaxValue = (from item in db.tbl_InvoiceVocher select item.InvoiceVoucherNo);
if (MaxValue.Count() > 0)
{
vc = Convert.ToInt32(MaxValue.Max()) + 1;
InvoiceVoucherNo = vc.ToString("0000000000");
}
else
{
InvoiceVoucherNo = "0000000001";
}
ViewBag.InvoiceVoucherNo = InvoiceVoucherNo;
string userid = "";
string userSettings = "";
if (Request.Cookies["UserSettings"] != null)
{
if (Request.Cookies["UserSettings"]["UserName"] != null)
{
userSettings = Request.Cookies["UserSettings"]["UserName"]; userid = Request.Cookies["UserSettings"]["UserId"];
}
}
o.EntryDate = DateTime.Today;
o.UserID = Convert.ToInt32(userid);
if (ModelState.IsValid)
{
tbl_InvoiceVocher fc = new tbl_InvoiceVocher {
InvoiceVoucherNo = InvoiceVoucherNo, PatientID = o.PatientID, ReleaseDate = o.ReleaseDate, TotalAmount = o.TotalAmount, vat = o.vat, Discount = o.Discount, GrandTotalAmount = o.GrandTotalAmount, Remarks = o.Remarks, UserID = o.UserID, EntryDate = o.EntryDate, UpdateDate = o.UpdateDate
};
foreach (var i in o.tbl_InvoiceDetails)
{
fc.tbl_InvoiceDetails.Add(i);
}
db.tbl_InvoiceVocher.Add(fc);
status = true;
}
else
{
status = false;
}
db.SaveChanges();
ViewBag.UserID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName");
ViewBag.PatientID = new SelectList(db.tbl_PatientInfo, "PatientID", "PatientName");
var jsonData = new { success = true, status = status, InvoiceVoucherNo = InvoiceVoucherNo };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult InvoiceEdit(tbl_InvoiceVocher tbv, string InvoiceVoucherNo, ReferenceInvoiceModel model)
{
ViewBag.ServiceId = new SelectList(db.tbl_Service, "ServiceId", "ServiceName");
ViewBag.PatientID = new SelectList(db.tbl_PatientInfo, "PatientID", "PatientName");
ViewBag.InvoiceVoucherNo = InvoiceVoucherNo;
model.InvoiceVoucherTbl = (from item in db.tbl_InvoiceVocher where item.InvoiceVoucherNo == InvoiceVoucherNo select item).ToList();
model.InvoiceDeltailsTbl = (from item in db.tbl_InvoiceDetails where item.InvoiceVoucherNo == InvoiceVoucherNo select item).ToList();
return(View(model));
}
public JsonResult IvoiceUpdate(tbl_InvoiceVocher tbv, tbl_InvoiceDetails tbvd, string InvoiceVoucherNo, int PatientID, DateTime ReleaseDate, decimal TotalAmount, decimal vat, decimal Discount, decimal GrandTotalAmount, int InvoiceID, int ServiceId, float Amount)
{
tbv = db.tbl_InvoiceVocher.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
tbv.PatientID = PatientID;
tbv.ReleaseDate = ReleaseDate;
tbv.TotalAmount = TotalAmount;
tbv.vat = vat;
tbv.Discount = Discount;
tbv.GrandTotalAmount = GrandTotalAmount;
db.SaveChanges();
tbvd = db.tbl_InvoiceDetails.FirstOrDefault(x => x.InvoiceID == InvoiceID);
tbvd.ServiceId = ServiceId;
tbvd.Amount = Amount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Updated" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
