public CMSResult Save(MasterFee masterfee)
{
var result = new CMSResult();
var isExists = _repository.Project <MasterFee, bool>
(masterfees => (from mfee in masterfees
where mfee.Year == masterfee.Year &&
mfee.SubjectId == masterfee.SubjectId &&
mfee.ClassId == masterfee.ClassId
select mfee).Any());
if (isExists)
{
result.Results.Add(new Result {
IsSuccessful = false, Message = string.Format("MasterFee already exists!")
});
}
else
{
_repository.Add(masterfee);
result.Results.Add(new Result {
IsSuccessful = true, Message = string.Format("MasterFee added successfully!")
});
}
return(result);
}
public CMSResult Update(MasterFee masterfee)
{
CMSResult result = new CMSResult();
var isExists = _repository.Project <MasterFee, bool>(
masterfees => (from mfee in masterfees
where mfee.MasterFeeId != masterfee.MasterFeeId &&
mfee.Year == masterfee.Year &&
mfee.SubjectId == masterfee.SubjectId &&
mfee.ClassId == masterfee.ClassId
select mfee).Any());
if (isExists)
{
result.Results.Add(new Result {
IsSuccessful = false, Message = string.Format("MasterFee already exists!")
});
}
else
{
var masterf = _repository.Load <MasterFee>(x => x.MasterFeeId == masterfee.MasterFeeId);
masterf.Year = masterfee.Year;
masterf.Fee = masterfee.Fee;
_repository.Update(masterf);
result.Results.Add(new Result {
IsSuccessful = true, Message = string.Format("MasterFee updated successfully!")
});
}
return(result);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
MasterFee masterFee = await db.MasterFees.FindAsync(id);
db.MasterFees.Remove(masterFee);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "MasterId,Date,BillNo,RID,session,TotalFee,Paid,Discount,Reason,Other,Balance,TimePeriod,status")] MasterFee masterFee)
{
if (ModelState.IsValid)
{
db.Entry(masterFee).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(masterFee));
}
public async Task <ActionResult> Create([Bind(Include = "MasterId,Date,BillNo,RID,session,TotalFee,Paid,Discount,Reason,Other,Balance,TimePeriod,status")] MasterFee masterFee)
{
if (ModelState.IsValid)
{
db.MasterFees.Add(masterFee);
await db.SaveChangesAsync();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(masterFee));
}
// GET: MasterFees/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MasterFee masterFee = await db.MasterFees.FindAsync(id);
if (masterFee == null)
{
return(HttpNotFound());
}
return(View(masterFee));
}
public ActionResult Fee(string bill, string date, string totalvalue, string annual, string transport, string pay, string balance, string period, int regno, string discount, string reason, string other, MonthlyFee Month, FeeStructure fee, MasterFee Master)
{
try
{
string[] array = new string[12];
array = period.Split(',');
if (array.Length > 0)
{
double total = (Convert.ToDouble(totalvalue) / Convert.ToDouble(array.Length));
double paymonthly = (Convert.ToDouble(pay) / Convert.ToDouble(array.Length));
double paybal = (Convert.ToDouble(balance) / Convert.ToDouble(array.Length));
double paydiscount = (Convert.ToDouble(discount) / Convert.ToDouble(array.Length));
double payother = (Convert.ToDouble(other) / Convert.ToDouble(array.Length));
for (int i = 1; i <= array.Length; i++)
{
int a = i - 1;
Month.Date = date;
Month.BillNo = Convert.ToInt32(bill);
Month.TimePeriod = array[a];
Month.Paid = paymonthly;
Month.TotalFee = total;
Month.session = Session["session"].ToString();
Month.Balance = paybal;
Month.status = "Paid";
Month.Discount = paydiscount;
Month.Reason = reason;
Month.Other = payother;
Month.RID = regno;
db.MonthlyFees.Add(Month);
db.SaveChanges();
}
Master.Date = date;
Master.BillNo = Convert.ToInt32(bill);
Master.TimePeriod = period;
Master.Paid = Convert.ToDouble(pay);
Master.TotalFee = Convert.ToDouble(totalvalue);
Master.session = Session["session"].ToString();
Master.Balance = Convert.ToDouble(balance);
Master.status = "Paid";
Master.Discount = Convert.ToDouble(discount);
Master.Reason = reason;
Master.Other = Convert.ToDouble(other);
Master.RID = regno;
db.MasterFees.Add(Master);
db.SaveChanges();
}
var id = db.FeeStructures.Where(x => x.RID == regno).FirstOrDefault().FeeID;
fee = db.FeeStructures.Find(id);
if (fee != null)
{
fee.Pay = (Convert.ToDouble(fee.Pay) + Convert.ToDouble(pay));
fee.Discount = (Convert.ToDouble(fee.Discount) + Convert.ToDouble(discount));
fee.AnnualCharges = (Convert.ToDouble(fee.AnnualCharges) + Convert.ToDouble(annual));
//fee.AdmissionFee = (Convert.ToDouble(fee.Discount) + Convert.ToDouble(discount));
db.Entry(fee).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index", "Invoice", new { id = bill }));
}
catch
{
return(View());
}
}
