//............................Delete.........................
public ActionResult Delete(tbl_IndorMedicenPurshaseVoucher tbv, tbl_IndorMedicinePurchaseDetails tbvd, string MedicinePurchaseVoucherNo)
{
var info = (from item in db.tbl_IndorMedicinePurchaseDetails where item.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo select item).ToList();
if (info.Count > 1)
{
foreach (var vp in info)
{
db.tbl_IndorMedicinePurchaseDetails.Remove(vp);
}
}
else
{
if (MedicinePurchaseVoucherNo != null)
{
tbvd = db.tbl_IndorMedicinePurchaseDetails.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo);
db.tbl_IndorMedicinePurchaseDetails.Remove(tbvd);
}
}
db.SaveChanges();
tbv = db.tbl_IndorMedicenPurshaseVoucher.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo);
db.tbl_IndorMedicenPurshaseVoucher.Remove(tbv);
db.SaveChanges();
return(RedirectToAction("IndorMedicinePurchaseList"));
}
public ActionResult IndorMedicinePurchaseList(string keyword, tbl_IndorMedicenPurshaseVoucher medicine)
{
var results = (from item in db.tbl_IndorMedicenPurshaseVoucher where item.tbl_MedicineSupplierInfo.MediSupplyerName.Contains(keyword) select item).ToList();
var pageIndex = medicine.Page ?? 1;
medicine.IndorMedicinePurchaseListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(medicine));
}
public JsonResult indorMedicinePurchaseProcess(tbl_IndorMedicenPurshaseVoucher o)
{
bool status = false;
int vc;
var MaxValue = (from item in db.tbl_IndorMedicenPurshaseVoucher select item.MedicinePurchaseVoucherNo);
if (MaxValue.Count() > 0)
{
vc = Convert.ToInt32(MaxValue.Max()) + 1;
MedicinePurchaseVoucherNo = vc.ToString("0000000000");
}
else
{
MedicinePurchaseVoucherNo = "0000000001";
}
ViewBag.MedicinePurchaseVoucherNo = MedicinePurchaseVoucherNo;
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_IndorMedicenPurshaseVoucher fc = new tbl_IndorMedicenPurshaseVoucher {
MedicinePurchaseVoucherNo = MedicinePurchaseVoucherNo, MediSupplyerID = o.MediSupplyerID, PurchaseDate = o.PurchaseDate, VoucharCopyImage = o.VoucharCopyImage, GrandTotalAmount = o.GrandTotalAmount, PayAmount = o.PayAmount, DueAmount = o.DueAmount, UserID = o.UserID, ExperDate = o.ExperDate, Remarks = o.Remarks, EntryDate = o.EntryDate, UpdateDate = o.UpdateDate
};
foreach (var i in o.tbl_IndorMedicinePurchaseDetails)
{
fc.tbl_IndorMedicinePurchaseDetails.Add(i);
}
db.tbl_IndorMedicenPurshaseVoucher.Add(fc);
status = true;
}
else
{
status = false;
}
db.SaveChanges();
ViewBag.UserID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName");
ViewBag.MediSupplyerID = new SelectList(db.tbl_MedicineSupplierInfo, "MediSupplyerID", "MediSupplyerName");
var jsonData = new { success = true, status = status, MedicinePurchaseVoucherNo = MedicinePurchaseVoucherNo };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult IndorMedicinePurchaseEdit(tbl_IndorMedicenPurshaseVoucher tbv, string MedicinePurchaseVoucherNo, ReferenceIndorMedicinePurchase model)
{
ViewBag.MediInfoID = new SelectList(db.tbl_MedicineInfo, "MediInfoID", "MediName");
ViewBag.MediSupplyerID = new SelectList(db.tbl_MedicineSupplierInfo, "MediSupplyerID", "MediSupplyerName");
ViewBag.MedicinePurchaseVoucherNo = MedicinePurchaseVoucherNo;
model.indorMedicinePurchaseVocherTbl = (from item in db.tbl_IndorMedicenPurshaseVoucher where item.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo select item).ToList();
model.indorMedicinePurchaseDetailsTbl = (from item in db.tbl_IndorMedicinePurchaseDetails where item.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo select item).ToList();
return(View(model));
}
//...........List..............
public ActionResult IndorMedicinePurchaseList(tbl_IndorMedicenPurshaseVoucher medicine)
{
var results = (from item in db.tbl_IndorMedicenPurshaseVoucher
select item).ToList().OrderBy(p => p.MedicinePurchaseVoucherNo);
var pageIndex = medicine.Page ?? 1;
medicine.IndorMedicinePurchaseListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(medicine));
//return View(db.IndorMedicenPurshaseVouchers.ToList());
}
public JsonResult IndormedicinePurchaseDelete(tbl_IndorMedicenPurshaseVoucher tbv, tbl_IndorMedicinePurchaseDetails tbvd, string MedicinePurchaseVoucherNo, int MedicinePurchaseId, decimal GrandTotalAmount)
{
tbvd = db.tbl_IndorMedicinePurchaseDetails.FirstOrDefault(x => x.MedicinePurchaseId == MedicinePurchaseId);
db.tbl_IndorMedicinePurchaseDetails.Remove(tbvd);
db.SaveChanges();
tbv = db.tbl_IndorMedicenPurshaseVoucher.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo);
tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount;
tbv.PayAmount = 0;
tbv.DueAmount = tbv.GrandTotalAmount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Deleted." };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult IndorMedicinePurchaseUpdate(tbl_IndorMedicenPurshaseVoucher tbv, tbl_IndorMedicinePurchaseDetails tbvd, string MedicinePurchaseVoucherNo, int MediSupplyerID, DateTime PurchaseDate, decimal GrandTotalAmount, decimal PayAmount, decimal DueAmount, int MedicinePurchaseId, int MediInfoID, decimal Rate, int Quantity, decimal Amount)
{
tbv = db.tbl_IndorMedicenPurshaseVoucher.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo);
tbv.MediSupplyerID = MediSupplyerID;
tbv.PurchaseDate = PurchaseDate;
tbv.GrandTotalAmount = GrandTotalAmount;
tbv.PayAmount = PayAmount;
tbv.DueAmount = DueAmount;
db.SaveChanges();
tbvd = db.tbl_IndorMedicinePurchaseDetails.FirstOrDefault(x => x.MedicinePurchaseId == MedicinePurchaseId);
tbvd.MediInfoID = MediInfoID;
tbvd.Rate = Rate;
tbvd.Quantity = Quantity;
tbvd.Amount = Amount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Updated" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
