//................Delete....................
//public JsonResult OBSalesDelete(OutdorBloodSalesVoucher tbv, OutdorBloodSalesDetails tbvd, string OutdorBloodSalesVoucherNo, int OutdorBloodSalesID)
//{
// tbvd = db.OutdorBloodSalesDetails.FirstOrDefault(x => x.OutdorBloodSalesID == OutdorBloodSalesID);
// db.OutdorBloodSalesDetails.Remove(tbvd);
// db.SaveChanges();
// tbv = db.OutdorBloodSalesVouchers.FirstOrDefault(x => x.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo);
// db.OutdorBloodSalesVouchers.Remove(tbv);
// db.SaveChanges();
// var jsonData = new { success = true, message = "Successfully Deleted." };
// return Json(jsonData, JsonRequestBehavior.AllowGet);
// return Json(true, JsonRequestBehavior.AllowGet);
//}
//........................Delete.............
public ActionResult Delete(tbl_OutdorBloodSalesVoucher tbv, tbl_OutdorBloodSalesDetails tbvd, string OutdorBloodSalesVoucherNo)
{
var info = (from item in db.tbl_OutdorBloodSalesDetails where item.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo select item).ToList();
if (info.Count > 1)
{
foreach (var vp in info)
{
db.tbl_OutdorBloodSalesDetails.Remove(vp);
}
}
else
{
if (OutdorBloodSalesVoucherNo != null)
{
tbvd = db.tbl_OutdorBloodSalesDetails.FirstOrDefault(x => x.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo);
db.tbl_OutdorBloodSalesDetails.Remove(tbvd);
}
}
db.SaveChanges();
tbv = db.tbl_OutdorBloodSalesVoucher.FirstOrDefault(x => x.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo);
db.tbl_OutdorBloodSalesVoucher.Remove(tbv);
db.SaveChanges();
return(RedirectToAction("OutdoorBloodSalesList"));
}
public ActionResult OutdoorBloodSalesList(string keyword, tbl_OutdorBloodSalesVoucher Oblood)
{
var results = (from item in db.tbl_OutdorBloodSalesVoucher where item.OutdorBuyerName.Contains(keyword) || item.OutdorBuyerPnoneNo.Contains(keyword) select item).ToList();
var pageIndex = Oblood.Page ?? 1;
Oblood.OutdoorBloodSalesListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(Oblood));
}
public ActionResult OutDoorbloodSalesEdit(tbl_OutdorBloodSalesVoucher tbv, string OutdorBloodSalesVoucherNo, ReferenceOutdoorBloodSalesModel model)
{
ViewBag.MediUnitID = new SelectList(db.tbl_MedicinUnit, "MediUnitID", "UnitName");
ViewBag.BloodID = new SelectList(db.tbl_BloodGroup, "BloodID", "BloodName");
ViewBag.OutdorBloodSalesVoucherNo = OutdorBloodSalesVoucherNo;
model.OutDoorBloodSalesVoucherTbl = (from item in db.tbl_OutdorBloodSalesVoucher where item.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo select item).ToList();
model.OutdoorbloodSalesDeltailsTbl = (from item in db.tbl_OutdorBloodSalesDetails where item.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo select item).ToList();
return(View(model));
}
public JsonResult OutdorBloodSaleProcess(tbl_OutdorBloodSalesVoucher o)
{
bool status = false;
int vc;
var MaxValue = (from item in db.tbl_OutdorBloodSalesVoucher select item.OutdorBloodSalesVoucherNo);
if (MaxValue.Count() > 0)
{
vc = Convert.ToInt32(MaxValue.Max()) + 1;
OutdorBloodSalesVoucherNo = vc.ToString("0000000000");
}
else
{
OutdorBloodSalesVoucherNo = "0000000001";
}
ViewBag.OutdorBloodSalesVoucherNo = OutdorBloodSalesVoucherNo;
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.UserInfoID = Convert.ToInt32(userid);
if (ModelState.IsValid)
{
tbl_OutdorBloodSalesVoucher fc = new tbl_OutdorBloodSalesVoucher {
OutdorBloodSalesVoucherNo = OutdorBloodSalesVoucherNo, OutdorBuyerName = o.OutdorBuyerName, OutdorBuyerPnoneNo = o.OutdorBuyerPnoneNo, OutdorBuyerAddress = o.OutdorBuyerAddress, GrandTotalAmount = o.GrandTotalAmount, PayAmount = o.PayAmount, DeuAmount = o.DeuAmount, Remarks = o.Remarks, UserInfoID = o.UserInfoID, EntryDate = o.EntryDate, UpdateDate = o.UpdateDate
};
foreach (var i in o.tbl_OutdorBloodSalesDetails)
{
fc.tbl_OutdorBloodSalesDetails.Add(i);
}
db.tbl_OutdorBloodSalesVoucher.Add(fc);
status = true;
}
else
{
status = false;
}
db.SaveChanges();
ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName");
var jsonData = new { success = true, status = status, OutdorBloodSalesVoucherNo = OutdorBloodSalesVoucherNo };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult OutdoorBloodSalesList(tbl_OutdorBloodSalesVoucher Oblood)
{
var results = (from item in db.tbl_OutdorBloodSalesVoucher
select item).ToList().OrderBy(p => p.OutdorBloodSalesVoucherNo);
var pageIndex = Oblood.Page ?? 1;
Oblood.OutdoorBloodSalesListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(Oblood));
//return View(db.OutdorBloodSalesVouchers.ToList());
}
public JsonResult OutdoorBloodSalesDelete(tbl_OutdorBloodSalesVoucher tbv, tbl_OutdorBloodSalesDetails tbvd, string OutdorBloodSalesVoucherNo, int OutdorBloodSalesID, decimal GrandTotalAmount)
{
tbvd = db.tbl_OutdorBloodSalesDetails.FirstOrDefault(x => x.OutdorBloodSalesID == OutdorBloodSalesID);
db.tbl_OutdorBloodSalesDetails.Remove(tbvd);
db.SaveChanges();
tbv = db.tbl_OutdorBloodSalesVoucher.FirstOrDefault(x => x.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo);
tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount;
tbv.PayAmount = 0;
tbv.DeuAmount = tbv.GrandTotalAmount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Deleted." };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult OutDoorBloodSalesUpdate(tbl_OutdorBloodSalesVoucher tbv, tbl_OutdorBloodSalesDetails tbvd, string OutdorBloodSalesVoucherNo, string OutdorBuyerName, string OutdorBuyerPnoneNo, decimal GrandTotalAmount, decimal PayAmount, decimal DeuAmount, int OutdorBloodSalesID, int BloodID, int Quantity, decimal Rate, int MediUnitID, decimal TotalAmount)
{
tbv = db.tbl_OutdorBloodSalesVoucher.FirstOrDefault(x => x.OutdorBloodSalesVoucherNo == OutdorBloodSalesVoucherNo);
tbv.OutdorBuyerName = OutdorBuyerName;
tbv.OutdorBuyerPnoneNo = OutdorBuyerPnoneNo;
tbv.GrandTotalAmount = GrandTotalAmount;
tbv.PayAmount = PayAmount;
tbv.DeuAmount = DeuAmount;
db.SaveChanges();
tbvd = db.tbl_OutdorBloodSalesDetails.FirstOrDefault(x => x.OutdorBloodSalesID == OutdorBloodSalesID);
tbvd.BloodID = BloodID;
tbvd.Quantity = Quantity;
tbvd.Rate = Rate;
tbvd.MediUnitID = MediUnitID;
tbvd.TotalAmount = TotalAmount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Updated" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
