//
// GET: /cheque/Edit/5
public ActionResult Edit(int id)
{
cheque cheque = db.cheques.Find(id);
ViewBag.payFeeid = new SelectList(db.payfees, "id", "id", cheque.payFeeid);
return(View(cheque));
}
public async Task <IHttpActionResult> Putcheque(int id, cheque cheque)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cheque.id)
{
return(BadRequest());
}
db.Entry(cheque).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!chequeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
cheque cheque = db.cheques.Find(id);
db.cheques.Remove(cheque);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int getLastChequeId(cheque q)
{
cheque c = ((from x in dc.GetTable <cheque>()
where x.doctorid == q.doctorid && x.amount == q.amount && x.date == q.date
orderby x.date descending
select x).Take(1)).SingleOrDefault();
return(c.chequeid);
}
public ActionResult Edit([Bind(Include = "ChequeID,Bank,Branch,Cheque_No,Amount")] cheque cheque)
{
if (ModelState.IsValid)
{
db.Entry(cheque).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cheque));
}
public async Task <IHttpActionResult> Getcheque(int id)
{
cheque cheque = await db.cheque.FindAsync(id);
if (cheque == null)
{
return(NotFound());
}
return(Ok(cheque));
}
public ActionResult Edit(cheque cheque)
{
if (ModelState.IsValid)
{
db.Entry(cheque).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.payFeeid = new SelectList(db.payfees, "id", "id", cheque.payFeeid);
return(View(cheque));
}
public ActionResult Create([Bind(Include = "ChequeID,Bank,Branch,Cheque_No,Amount")] cheque cheque)
{
if (ModelState.IsValid)
{
db.cheques.Add(cheque);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cheque));
}
public async Task <IHttpActionResult> Postcheque(cheque cheque)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.cheque.Add(cheque);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = cheque.id }, cheque));
}
public ActionResult Create(cheque cheque)
{
if (ModelState.IsValid)
{
db.cheques.Add(cheque);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.payFeeid = new SelectList(db.payfees, "id", "id", cheque.payFeeid);
return(View(cheque));
}
public async Task <IHttpActionResult> Deletecheque(int id)
{
cheque cheque = await db.cheque.FindAsync(id);
if (cheque == null)
{
return(NotFound());
}
db.cheque.Remove(cheque);
await db.SaveChangesAsync();
return(Ok(cheque));
}
// GET: cheques/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
cheque cheque = db.cheques.Find(id);
if (cheque == null)
{
return(HttpNotFound());
}
return(View(cheque));
}
/* public List<item> viewBill(int BillId)
* {
* return true;
* }
* public List<bill> viewBillsInCase(int CaseId)
* {
* return true;
* }
*
*/
public bool giveSalaries()
{
DoctorClass docs = new DoctorClass();
//GetAllDoctors
IQueryable <doctor> ld = docs.getAllDoctors();
long sal, starting_balance, final_balance;
//Check if all doctors can be given salaries
bool res = checkEnoughCash();
if (res == false)
{
return(false);
}
//Give Salaries
foreach (var doc in ld)
{
//Generate Cheque
cheque chq = new cheque();
chq.doctorid = doc.doctorid;
chq.date = DateTime.Now;
chq.amount = doc.salary;
dc.cheques.InsertOnSubmit(chq);
dc.SubmitChanges();
//Log it and modify Balance
sal = doc.salary;
starting_balance = getBalance();
final_balance = starting_balance - sal;
cost c = new cost();
c.date = DateTime.Now;
c.starting_balance = starting_balance;
c.billid = 0;
c.chequeid = getLastChequeId(chq); //Cheque id of the last cheque inserted
c.final_balance = final_balance;
setBalance(final_balance);
dc.costs.InsertOnSubmit(c);
dc.SubmitChanges();
}
return(true);
}
//
// GET: /cheque/Delete/5
public ActionResult Delete(int id)
{
cheque cheque = db.cheques.Find(id);
return(View(cheque));
}
//
// GET: /cheque/Details/5
public ViewResult Details(int id)
{
cheque cheque = db.cheques.Find(id);
return(View(cheque));
}
