public ActionResult CreateDisposal(int rt, int IORecptID, int?wrk)
{
InOutRegsIssue model = new InOutRegsIssue {
IORecptID = IORecptID, RegisterTypeID = rt
};
ViewBag.wrk = wrk;
if (rt == 21)
{
return(View("CreateDisposal9", model));
}
if (rt == 22)
{
return(View("CreateDisposal6", model));
}
if (rt == 23)
{
return(View("CreateDisposalSD", model));
}
if (rt == 24)
{
return(View("CreateDisposalEMD", model));
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
public ActionResult EditDisposal([Bind(Include = "IOissueID,IORecptID,RegisterTypeID,TDate,Value,IssuedTo,RVno,Remarks,RefundReason")] InOutRegsIssue inOutRegsIssue)
{
if (ModelState.IsValid)
{
//find original value
//var origspends = db.InOutRegsIssues.Find(inOutRegsIssue.IOissueID).Value;
//Save Current value
db.Entry(inOutRegsIssue).State = EntityState.Modified;
db.SaveChanges();
if (inOutRegsIssue.RegisterTypeID == 21)
{
var rec = db.InOutRegsRecpts.Find(inOutRegsIssue.IORecptID).Value; //value of grant
var spends = db.InOutRegsIssues.Where(i => i.IORecptID == inOutRegsIssue.IORecptID).Sum(s => s.Value);
// spends = spends - origspends + inOutRegsIssue.Value;
inOutRegsIssue.Balance = (rec ?? 0) - (spends ?? 0);
}
db.Entry(inOutRegsIssue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { rt = inOutRegsIssue.RegisterTypeID }));
}
return(View(inOutRegsIssue));
}
public ActionResult DeleteConfirmed(int id)
{
InOutRegsIssue inOutRegsIssue = db.InOutRegsIssues.Find(id);
db.InOutRegsIssues.Remove(inOutRegsIssue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: InOutRegsIssues/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InOutRegsIssue inOutRegsIssue = db.InOutRegsIssues.Find(id);
if (inOutRegsIssue == null)
{
return(HttpNotFound());
}
return(View(inOutRegsIssue));
}
public ActionResult Edit([Bind(Include = "IOissueID,IORecptID,RegisterTypeID,TDate,ItemID,Qty,Value,IssuedTo,Balance,Remarks,RVno")] InOutRegsIssue inOutRegsIssue, int?OldQty)
{
if (ModelState.IsValid)
{
//int id = (int)inOutRegsIssue.RVno;
//var voucher = db.Vouchers.Find(id);
if (inOutRegsIssue.RegisterTypeID == 21)
{
db.Entry(inOutRegsIssue).State = EntityState.Modified;
//voucher.Amount = inOutRegsIssue.Value;
//db.Entry(voucher).Property(a => a.Amount).IsModified = true;
//voucher.ActualAmount = inOutRegsIssue.Value;
//db.Entry(voucher).Property(a => a.ActualAmount).IsModified = true;
db.SaveChanges();
}
else
{
//voucher.Amount = inOutRegsIssue.Qty * inOutRegsIssue.Value;
//db.Entry(voucher).Property(a => a.Amount).IsModified = true;
//voucher.ActualAmount = inOutRegsIssue.Qty * inOutRegsIssue.Value;
//db.Entry(voucher).Property(a => a.ActualAmount).IsModified = true;
var item = db.Inventories.Where(x => x.ItemID == inOutRegsIssue.ItemID).FirstOrDefault();
if (item != null)
{
db.Entry(inOutRegsIssue).State = EntityState.Modified;
item.Qty = item.Qty + (int)OldQty;
item.Qty = item.Qty - (int)inOutRegsIssue.Qty;
inOutRegsIssue.Balance = item.Qty;
inOutRegsIssue.IORecptID = null;
db.Entry(item).Property(a => a.Qty).IsModified = true;
db.SaveChanges();
}
}
return(RedirectToAction("Index", new { rt = inOutRegsIssue.RegisterTypeID }));
}
ViewBag.RegisterTypeID = inOutRegsIssue.RegisterTypeID;
ViewBag.ItemID = new SelectList(db.InvItems, "ItemID", "Item", inOutRegsIssue.ItemID);
return(View(inOutRegsIssue));
}
// GET: InOutRegsIssues/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InOutRegsIssue inOutRegsIssue = db.InOutRegsIssues.Find(id);
if (inOutRegsIssue == null)
{
return(HttpNotFound());
}
ViewBag.OldQty = (int)inOutRegsIssue.Qty;
ViewBag.RegisterTypeID = inOutRegsIssue.RegisterTypeID;
ViewBag.ItemID = new SelectList(db.InvItems, "ItemID", "Item", inOutRegsIssue.ItemID);
return(View(inOutRegsIssue));
}
// GET: SD9EMD6/Edit/5
public ActionResult EditDisposal(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InOutRegsIssue inOutRegsIssues = db.InOutRegsIssues.Find(id);
if (inOutRegsIssues == null)
{
return(HttpNotFound());
}
if (inOutRegsIssues.RegisterTypeID == 22)
{
ViewBag.isRVtoday = db.Form4.Find(inOutRegsIssues.RVno).PayDate == DateTime.Today;
return(View("EditDisposal6", inOutRegsIssues));
}
if (inOutRegsIssues.RegisterTypeID == 21 || inOutRegsIssues.RegisterTypeID == 23 || inOutRegsIssues.RegisterTypeID == 24)
{
ViewBag.isRVtoday = db.Vouchers.Find(inOutRegsIssues.RVno).PayDate == DateTime.Today;
}
if (inOutRegsIssues.RegisterTypeID == 21)
{
return(View("EditDisposal9", inOutRegsIssues));
}
if (inOutRegsIssues.RegisterTypeID == 23)
{
return(View("EditDisposalSD", inOutRegsIssues));
}
if (inOutRegsIssues.RegisterTypeID == 24)
{
return(View("EditDisposalEMD", inOutRegsIssues));
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
public ActionResult CreateDisposal([Bind(Include = "IOissueID,IORecptID,RegisterTypeID,TDate,Value,IssuedTo,Remarks,RefundReason")] InOutRegsIssue inOutRegsIssue, int?wrk)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.InOutRegsIssues.Add(inOutRegsIssue);
//Create a receipt for Form6
if (inOutRegsIssue.RegisterTypeID == 22 && inOutRegsIssue.Value > 0)
{
var item = new Form4 {
Amount = inOutRegsIssue.Value, LedgerID = 10, PayDate = DateTime.Today, RecvdFrom = "Disposal of Property", SubLedgerID = 69
};
db.Form4.Add(item);
db.SaveChanges();
inOutRegsIssue.RVno = item.RecieptNo;
}
//Create a voucher for Form9 or SD
if ((inOutRegsIssue.RegisterTypeID == 21 || inOutRegsIssue.RegisterTypeID == 23 || inOutRegsIssue.RegisterTypeID == 24) && inOutRegsIssue.Value > 0)
{
var rec = db.InOutRegsRecpts.Find(inOutRegsIssue.IORecptID).Value; //value of grant
var spends = db.InOutRegsIssues.Where(i => i.IORecptID == inOutRegsIssue.IORecptID).Sum(s => s.Value);
inOutRegsIssue.Balance = (rec ?? 0) - (spends ?? 0) - (inOutRegsIssue.Value ?? 0);
string UserID = User.Identity.GetUserName();
var pn = db.Configs.Select(x => x.VP).FirstOrDefault();
var item = new Voucher {
PassedBy = UserID, of = pn, Amount = inOutRegsIssue.Value, ActualAmount = inOutRegsIssue.Value, For = inOutRegsIssue.Remarks, PayDate = DateTime.Today, CBfolio = null, ResNo = null, HeldOn = inOutRegsIssue.TDate, Meeting = "N/A", LedgerID = 3, SubLedgerID = 5
};
if (inOutRegsIssue.RegisterTypeID == 23)
{
item.SubLedgerID = 121; item.LedgerID = 19;
}
if (inOutRegsIssue.RegisterTypeID == 24)
{
item.SubLedgerID = 120; item.LedgerID = 19;
}
db.Vouchers.Add(item);
db.SaveChanges();
inOutRegsIssue.RVno = item.VoucherID;
}
db.SaveChanges(); //to save the receipt or voucher no
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
if (wrk != null)
{
return(RedirectToAction("Edit", "Works", new { id = (int)wrk, IOrID = inOutRegsIssue.IORecptID, rt = inOutRegsIssue.RegisterTypeID }));
}
return(RedirectToAction("Index", new { rt = inOutRegsIssue.RegisterTypeID }));
}
return(View(inOutRegsIssue));
}
public ActionResult Create([Bind(Include = "IOissueID,IORecptID,RegisterTypeID,TDate,ItemID,Qty,Value,IssuedTo,Balance,Remarks,RVno")] InOutRegsIssue inOutRegsIssue, int?IORecptID)
{
if (ModelState.IsValid)
{
inOutRegsIssue.TDate = DateTime.Now;
//inOutRegsIssue.Qty = (int)inOutRegsIssue.Value;
db.InOutRegsIssues.Add(inOutRegsIssue);
db.SaveChanges();
int lid = 0, sid = 0;
string UserID = User.Identity.GetUserName();
if (inOutRegsIssue.RegisterTypeID == 17)
{
lid = 8;
sid = 42;
}
if (inOutRegsIssue.RegisterTypeID == 18)
{
lid = 8;
sid = 137;
}
if (inOutRegsIssue.RegisterTypeID == 19)
{
lid = 8;
sid = 138;
}
if (inOutRegsIssue.RegisterTypeID == 20)
{
lid = 8;
sid = 139;
}
int vid = 0;
if (inOutRegsIssue.RegisterTypeID == 21)
{
lid = 1;
sid = 3;
var pn = db.Configs.Select(x => x.VP).FirstOrDefault();
var item1 = new Voucher {
PassedBy = UserID, of = pn, Amount = inOutRegsIssue.Value, ActualAmount = inOutRegsIssue.Value, For = null, PayDate = inOutRegsIssue.TDate, CBfolio = null, ResNo = null, HeldOn = inOutRegsIssue.TDate, Meeting = "N/A", LedgerID = lid, SubLedgerID = sid
};
db.Vouchers.Add(item1);
db.SaveChanges();
vid = item1.VoucherID;
}
else
{
//var pn = db.Configs.Select(x => x.VP).FirstOrDefault();
//var item1 = new Voucher { PassedBy = UserID, of = pn, Amount = inOutRegsIssue.Value * inOutRegsIssue.Qty, ActualAmount = inOutRegsIssue.Value * inOutRegsIssue.Qty, For = null, PayDate = inOutRegsIssue.TDate, CBfolio = null, ResNo = null, HeldOn = inOutRegsIssue.TDate, Meeting = "N/A", LedgerID = lid, SubLedgerID = sid};
//db.Vouchers.Add(item1);
db.SaveChanges();
//vid = item1.VoucherID;
}
//inOutRegsIssue.RVno =vid;
//Update the Inventory table Qtys
var item = db.Inventories.Where(x => x.ItemID == inOutRegsIssue.ItemID).FirstOrDefault();
if (item != null)
{
var rcp = inOutRegsIssue.IORecptID;
var rcptBal = db.InOutRegsRecpts.Find(rcp);
if (inOutRegsIssue.RegisterTypeID == 21)
{
db.Entry(item).Property(a => a.Qty).IsModified = true;
inOutRegsIssue.Balance = rcptBal.Qty - inOutRegsIssue.Value;
rcptBal.Qty = (int)inOutRegsIssue.Balance;
db.Entry(rcptBal).Property(a => a.Qty).IsModified = true;
db.SaveChanges();
}
else
{
item.Qty = item.Qty - (int)inOutRegsIssue.Qty;
inOutRegsIssue.Balance = item.Qty;
db.Entry(item).Property(a => a.Qty).IsModified = true;
db.SaveChanges();
}
}
if (inOutRegsIssue.RegisterTypeID == 21)
{
return(RedirectToAction("Index", "InOutRegsRecpts", new { rt = inOutRegsIssue.RegisterTypeID }));
}
else
{
return(RedirectToAction("Index", new { rt = inOutRegsIssue.RegisterTypeID }));
}
}
else
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
}
ViewBag.RegisterTypeID = inOutRegsIssue.RegisterTypeID;
ViewBag.ItemID = new SelectList(db.InvItems, "ItemID", "Item", inOutRegsIssue.ItemID);
return(View(inOutRegsIssue));
}
