public float yesterdayIelts()
{
string franchid = help.Permission();
// DateTime today = System.DateTime.Now;
if (franchid == "Admin")
{
Recipt_Details eee = db.Recipt_Details.FirstOrDefault(x => x.Date == yesterday);
if (eee != null)
{
return((db.Recipt_Details.Where(x => x.Date == yesterday)).Sum(x => x.Amount));
}
else
{
return(0);
}
}
Recipt_Details ee = db.Recipt_Details.FirstOrDefault(x => x.franchid == franchid && x.Date == yesterday);
if (ee != null)
{
return((db.Recipt_Details.Where(x => x.franchid == franchid && x.Date == yesterday)).Sum(x => x.Amount));
}
else
{
return(0);
}
}
// GET: Auth/Deposit/Create
public ActionResult Create(int roll)
{
TempData["roll"] = roll;
Session["roll"] = roll;
rollno = roll;
StudentCourse course = db.StudentCourses.Where(x => x.RollNo == roll && x.Status == true).FirstOrDefault();
var courses = db.Courses.Where(x => x.CourseId == course.CourseId);
ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName");
ViewBag.RollNo = roll;
Recipt_Details receiptd = db.Recipt_Details.FirstOrDefault();
if (receiptd == null)
{
var receip = db.tblReceipt.FirstOrDefault();
if (receip == null)
{
ViewBag.Receipt = 1;
}
else
{
var recp = receip.Start_no;
ViewBag.Receipt = recp;
}
}
else
{
var ab = db.Recipt_Details.Max(x => x.ReciptNo);
ViewBag.Receipt = Convert.ToInt32(ab) + 1;
}
receiptno = ViewData["Receipt"].ToString();
receiptd.Date = System.DateTime.Now;
return(View(receiptd));
}
//public ActionResult invoice(int id)
//{
// return View();
//}
public ActionResult invoice(int id)
{
Recipt_Details receiptdetail = db.Recipt_Details.FirstOrDefault(x => x.Id == id);
ViewBag.courseid = receiptdetail.CourseId;
return(View(receiptdetail));
}
public ActionResult DeleteConfirmed(int id)
{
if (User.IsInRole("Receptionist"))
{
roles = help.Receptionist();
}
else
{
roles = help.Franchisee();
}
tblstudentdata tblstudentdata = db.tblstudentdata.Find(id);
int roll = tblstudentdata.rollno;
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName");
img = tblstudentdata.image;
if (tblstudentdata.password != null)
{
tblstudentdata.password = help.DecryptData(tblstudentdata.password);
}
#region delete file
string fullPath = Request.MapPath("~/UploadedFiles/" + img);
if (img == tblstudentdata.image)
{
}
else
{
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
#endregion
db.tblstudentdata.Remove(tblstudentdata);
db.SaveChanges();
Fees_Master feemaster = new Fees_Master();
feemaster = db.Fees_Master.Where(x => x.RollNo == roll && x.franchid == roles).FirstOrDefault();
if (feemaster != null)
{
db.Fees_Master.Remove(feemaster);
db.SaveChanges();
}
StudentCourse studentcourse = new StudentCourse();
studentcourse = db.StudentCourses.Where(x => x.RollNo == roll && x.Uid == roles).FirstOrDefault();
if (studentcourse != null)
{
db.StudentCourses.Remove(studentcourse);
db.SaveChanges();
}
Recipt_Details rr = db.Recipt_Details.Where(x => x.RollNo == roll && x.franchid == roles).FirstOrDefault();
if (rr != null)
{
db.Recipt_Details.Remove(rr);
db.SaveChanges();
}
TempData["Success"] = "Deleted Successfully";
return(RedirectToAction("Index"));
}
//public ActionResult invoice(int id)
//{
// return View();
//}
public ActionResult invoice(int id)
{
Helper help = new Helper();
string a = id.ToString();
string franch = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
Recipt_Details receiptdetail = db.Recipt_Details.FirstOrDefault(x => x.ReciptNo == a && x.franchid == franch);
ViewBag.courseid = receiptdetail.CourseId;
return(View(receiptdetail));
}
public ActionResult DeleteConfirmed(int id)
{
Recipt_Details receiptdetail = db.Recipt_Details.Find(id);
db.Recipt_Details.Remove(receiptdetail);
db.SaveChanges();
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == receiptdetail.RollNo && x.CourseId == receiptdetail.CourseId && x.Status == true && x.franchid == receiptdetail.franchid);
feesmaster.PaidFees = (Convert.ToInt32(feesmaster.PaidFees) - Convert.ToInt32(receiptdetail.Amount));
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Deleted Successfully";
return(RedirectToAction("Index", new { roll = receiptdetail.RollNo }));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Recipt_Details receiptdetail = db.Recipt_Details.Find(id);
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName");
if (receiptdetail == null)
{
return(HttpNotFound());
}
return(View(receiptdetail));
}
public ActionResult DeleteConfirmed(int id)
{
Recipt_Details receiptdetail = db.Recipt_Details.Find(id);
db.Recipt_Details.Remove(receiptdetail);
db.SaveChanges();
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == receiptdetail.RollNo);
feesmaster.PaidFees = feesmaster.PaidFees - receiptdetail.Amount;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Deleted Successfully";
return(RedirectToAction("Index", new { roll = receiptdetail.RollNo }));
}
// GET: Auth/Deposit/Create
public ActionResult Create(int roll)
{
TempData["roll"] = roll;
Session["roll"] = roll;
rollno = roll;
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
StudentCourse course = db.StudentCourses.Where(x => x.RollNo == roll && x.Status == true).FirstOrDefault();
var courses = db.Courses.Where(x => x.CourseId == course.CourseId && x.franchid == a);
var list = db.StudentCourses.Where(x => x.RollNo == roll && x.Uid == a && x.Status == true)
.Join(db.Courses.Where(x => x.franchid == a),
c => c.CourseId,
o => o.CourseId,
(c, o) => new
{
CourseId = o.CourseId,
CourseName = o.CourseName
});
ViewBag.CourseId = new SelectList(list, "CourseId", "CourseName");
// ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName");
ViewBag.RollNo = roll;
Recipt_Details receiptd = db.Recipt_Details.FirstOrDefault(x => x.franchid == a);
if (receiptd == null)
{
var receip = db.tblReceipt.FirstOrDefault();
if (receip == null)
{
ViewBag.Receipt = 1;
}
else
{
var recp = receip.Start_no;
ViewBag.Receipt = recp;
recp1 = Convert.ToInt32(recp);
}
}
else
{
// Recipt_Details ab=db.Recipt_Details.Where(x => x.franchid == a).Max();
//DataTable dt = new DataTable();
//dt= objsql.GetTable("select reciptno from Recipt_Details where id=(select max(id) from Recipt_Details where franchid='" + a + "')");
//if(dt.Rows.Count>0)
//{
//}
//else
//{
//}
string ab = objsql.GetSingleValue("select reciptno from Recipt_Details where id=(select max(id) from Recipt_Details where franchid='" + a + "')").ToString();
// var ab = db.Recipt_Details.Where(x => x.franchid == a).Max(x => x.ReciptNo);
ViewBag.Receipt = Convert.ToInt32(ab) + 1;
}
Recipt_Details rr = new Recipt_Details();
receiptno = ViewData["Receipt"].ToString();
rr.Date = System.DateTime.Now;
return(View(rr));
}
public ActionResult Create([Bind(Include = "Type")] Recipt_Details receiptdetail, int Amount, int Discount, int CourseId, DateTime?Alert, DateTime date, Helper Help)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
DateTime today = System.DateTime.Now;
DataTable dt = objsql.GetTable("select * from expenselocks where lockdate='" + today + "'");
if (dt.Rows.Count > 0)
{
TempData["danger"] = "Sorry DayEnd";
return(View());
}
else
{
string franchid = help.Permission();
tblreceptionist re = db.tblreceptionists.FirstOrDefault(x => x.rid == franchid);
if (re.StartTime != null || re.EndTime != null)
{
if (help.Checklock() == true)
{
#region data
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
// TODO: Add insert logic here
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Status == true && x.CourseId == CourseId);
int pending = (Convert.ToInt32(feesmaster.TotalFees) - Convert.ToInt32(feesmaster.PaidFees));
if (feesmaster.PaidFees < feesmaster.TotalFees)
{
#region condition greater than
feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount));
feesmaster.Date = date;
feesmaster.AlertDate = Alert;
feesmaster.PaidFees += Amount;
feesmaster.Status = true;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
receiptdetail.RollNo = rollno;
receiptdetail.ReciptNo = receiptno;
receiptdetail.discount = Discount;
receiptdetail.CourseId = CourseId;
receiptdetail.Date = date;
receiptdetail.role = HttpContext.User.Identity.Name;
receiptdetail.Amount = Amount;
receiptdetail.Active = true;
receiptdetail.franchid = User.IsInRole("Franchisee") ? Help.Franchisee() : Help.Receptionist();
db.Recipt_Details.Add(receiptdetail);
db.SaveChanges();
TempData["roll"] = rollno;
ViewData["Receipt"] = recp1;
TempData["Success"] = "Saved Successfully";
tblsms sms = db.tblsms.FirstOrDefault();
tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == rollno);
if (ss.phone != null)
{
if (sms != null)
{
string msg = "Dear, " + Convert.ToString(ss.name) + ". Thank You for Deposit Rs." + Amount + ". Thanks for Joining Us.";
string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + "");
}
TempData["Success"] = "SMS Send Successfully";
}
StudentCourse course = db.StudentCourses.Where(x => x.RollNo == rollno && x.Status == true).FirstOrDefault();
var courses = db.Courses.Where(x => x.CourseId == course.CourseId);
ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName");
ts.Complete();
ts.Dispose();
return(RedirectToAction("invoice", new { id = receiptno }));
#endregion
}
else
{
TempData["danger"] = "Please Check Amount First";
return(View());
}
#endregion
}
else
{
TempData["danger"] = "Sorry DayEnd";
return(View());
}
}
else
{
#region data
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
// TODO: Add insert logic here
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Status == true && x.CourseId == CourseId);
int pending = (Convert.ToInt32(feesmaster.TotalFees) - Convert.ToInt32(feesmaster.PaidFees));
if (feesmaster.PaidFees < feesmaster.TotalFees)
{
#region condition greater than
feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount));
feesmaster.Date = date;
feesmaster.AlertDate = Alert;
feesmaster.PaidFees += Amount;
feesmaster.Status = true;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
receiptdetail.RollNo = rollno;
receiptdetail.ReciptNo = receiptno;
receiptdetail.discount = Discount;
receiptdetail.CourseId = CourseId;
receiptdetail.Date = date;
receiptdetail.Amount = Amount;
receiptdetail.Active = true;
receiptdetail.franchid = User.IsInRole("Franchisee") ? Help.Franchisee() : Help.Receptionist();
db.Recipt_Details.Add(receiptdetail);
db.SaveChanges();
TempData["roll"] = rollno;
ViewData["Receipt"] = recp1;
TempData["Success"] = "Saved Successfully";
tblsms sms = db.tblsms.FirstOrDefault();
tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == rollno);
if (ss.phone != null)
{
if (sms != null)
{
string msg = "Dear " + Convert.ToString(ss.name) + ". Thank You for Deposit Rs." + Amount + ". Thanks for Joining Us.";
string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + "");
}
TempData["Success"] = "SMS Send Successfully";
}
StudentCourse course = db.StudentCourses.Where(x => x.RollNo == rollno && x.Status == true).FirstOrDefault();
var courses = db.Courses.Where(x => x.CourseId == course.CourseId);
ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName");
ts.Complete();
ts.Dispose();
return(RedirectToAction("invoice", new { id = receiptno }));
#endregion
}
else
{
TempData["danger"] = "Please Check Amount First";
return(View());
}
#endregion
}
}
}
catch (Exception a)
{
return(View());
}
}
}
public ActionResult Create(int Amount, int Discount, int CourseId, DateTime Alert, DateTime date, Recipt_Details receiptdetail)
{
try
{
// TODO: Add insert logic here
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno);
feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount));
feesmaster.Date = date;
feesmaster.AlertDate = Alert;
feesmaster.PaidFees += Amount;
feesmaster.Status = true;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
receiptdetail.RollNo = rollno;
receiptdetail.ReciptNo = receiptno;
receiptdetail.CourseId = CourseId;
receiptdetail.Date = date;
receiptdetail.Amount = Amount;
receiptdetail.Active = true;
db.Recipt_Details.Add(receiptdetail);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("invoice", new { id = receiptno }));
}
catch
{
return(View());
}
}
