public ActionResult DeleteConfirmed(int id)
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
StudentCourse student_Course = db.StudentCourses.Find(id);
Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == student_Course.RollNo && x.franchid == a && x.CourseId == student_Course.CourseId);
db.Fees_Master.Remove(feemaster);
db.SaveChanges();
db.StudentCourses.Remove(student_Course);
db.SaveChanges();
dbTran.Commit();
TempData["Success"] = "Deleted Successfully";
return(RedirectToAction("Index", new { roll = rollno }));
}
catch (Exception)
{
dbTran.Rollback();
return(RedirectToAction("Index", new { roll = rollno }));
throw;
}
}
}
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());
}
}
public ActionResult Edit([Bind(Include = "Id,CourseId,Admitdate,enddate,Fees,RoomId,Status,Days,Token")] StudentCourse student_Course)
{
if (ModelState.IsValid)
{
string a = help.Permission();
Course cc = db.Courses.First(x => x.CourseId == student_Course.CourseId && x.franchid == a);
student_Course.RollNo = rollno;
student_Course.Uid = a;
student_Course.enddate = Convert.ToDateTime(student_Course.Admitdate).AddDays(student_Course.Days);
student_Course.Fees = (Convert.ToInt32(cc.Fees) * Convert.ToInt32(student_Course.Days)).ToString();
db.Entry(student_Course).State = EntityState.Modified;
db.SaveChanges();
Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Token == student_Course.Token && x.Status == true);
//feemaster.RollNo = student_Course.RollNo;
feemaster.Date = System.DateTime.Now;
feemaster.CourseId = student_Course.CourseId;
feemaster.AlertDate = System.DateTime.Now.AddDays(2);
feemaster.Status = true;
feemaster.TotalFees = (Convert.ToInt32(cc.Fees) * Convert.ToInt32(student_Course.Days));
// feemaster.TotalFees += Convert.ToInt32(student_Course.Fees);
db.Entry(feemaster).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Updated Successfully";
ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName");
return(RedirectToAction("Index", new { roll = rollno }));
}
return(View(student_Course));
}
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 Create([Bind(Include = "Id,rollno,name,dob,fathername,address,phone,fatherphn,language,board,qualification,coaching,institutename,type,refferedby,image,uid,Status,username,password,gender,remarks,email,discount,date")] tblstudentdata tblstudentdata, HttpPostedFileBase file, Helper Help, DateTime joining, DateTime enddate, string addmission, int CourseId, int RoomId)
{
if (ModelState.IsValid)
{
tblstudentdata studentdata = db.tblstudentdata.FirstOrDefault();
if (studentdata == null)
{
tblstudentdata.rollno = 1;
}
else
{
var ab = db.tblstudentdata.Max(x => x.rollno);
tblstudentdata.rollno = Convert.ToInt32(ab) + 1;
}
tblstudentdata.uid = User.Identity.Name;
tblstudentdata.image = Help.uploadfile(file);
if (tblstudentdata.password != null)
{
tblstudentdata.password = Help.EncryptData(tblstudentdata.password);
}
db.tblstudentdata.Add(tblstudentdata);
db.SaveChanges();
//Recipt_Details receiptdetail = new Recipt_Details();
//receiptdetail.RollNo = tblstudentdata.rollno;
Fees_Master feemaster = new Fees_Master();
feemaster.RollNo = tblstudentdata.rollno;
feemaster.Date = tblstudentdata.date;
//feemaster.CourseId = CourseId;
feemaster.AlertDate = System.DateTime.Now.AddDays(2);
feemaster.discount = tblstudentdata.discount;
feemaster.Status = tblstudentdata.Status;
feemaster.TotalFees = Convert.ToInt32(addmission);
db.Fees_Master.Add(feemaster);
db.SaveChanges();
StudentCourse studentcourse = new StudentCourse();
studentcourse.RollNo = tblstudentdata.rollno;
studentcourse.RoomId = RoomId;
studentcourse.CourseId = CourseId;
studentcourse.Admitdate = joining;
studentcourse.enddate = enddate;
studentcourse.Fees = addmission;
studentcourse.Uid = Session["User"].ToString();
studentcourse.Status = tblstudentdata.Status;
db.StudentCourses.Add(studentcourse);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(tblstudentdata));
}
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 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 }));
}
public ActionResult SMS(int id, Helper Help)
{
tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == id);
Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.RollNo == id);
tblsms sms = db.tblsms.FirstOrDefault();
float pending = fm.TotalFees - fm.PaidFees;
if (ss.phone != null)
{
string msg = "Dear, " + Convert.ToString(ss.name) + ". Reminder That Your Course Fee is still Due Rs." + pending + ". Thanks for Joining Us. visit www.englishtreemoga.com.";
string result = Help.apicall("http://sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + "");
TempData["Success"] = "SMS Send Successfully";
}
return(RedirectToAction("Index"));
}
public ActionResult AddDays(StudentCourse course)
{
string a = help.Permission();
StudentCourse ss = db.StudentCourses.FirstOrDefault(x => x.Token == course.Token && x.Uid == a && x.Status == true);
Course cc = db.Courses.FirstOrDefault(x => x.CourseId == ss.CourseId && x.franchid == a);
string daysfee = (Convert.ToInt32(course.Days) * Convert.ToInt32(cc.Fees)).ToString();
string fee = (Convert.ToInt32(ss.Fees) + Convert.ToInt32(daysfee)).ToString();
ss.Fees = fee;
ss.enddate = Convert.ToDateTime(ss.enddate).AddDays(course.Days);
db.Entry(ss).State = EntityState.Modified;
db.SaveChanges();
Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.Token == course.Token && x.franchid == a && x.Status == true);
fm.TotalFees = Convert.ToInt32(fee);
fm.AlertDate = System.DateTime.Now.AddDays(2);
db.Entry(fm).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("CourseFinishAlert", "Default"));
}
public ActionResult Edit([Bind(Include = "Id,rollno,name,dob,fathername,address,phone,fatherphn,language,board,qualification,coaching,institutename,type,refferedby,image,uid,Status,username,password,gender,remarks,email,discount,date")] tblstudentdata tblstudentdata, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
tblstudentdata.image = file != null?Help.uploadfile(file) : img;
if (tblstudentdata.password != null)
{
tblstudentdata.password = Help.EncryptData(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.Entry(tblstudentdata).State = EntityState.Modified;
db.SaveChanges();
Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == tblstudentdata.rollno);
feemaster.Status = tblstudentdata.Status;
db.Entry(feemaster).State = EntityState.Modified;
db.SaveChanges();
StudentCourse studentcourse = db.StudentCourses.FirstOrDefault(x => x.RollNo == tblstudentdata.rollno);
studentcourse.Status = tblstudentdata.Status;
db.Entry(studentcourse).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Updated Successfully";
return(RedirectToAction("Index"));
}
return(View(tblstudentdata));
}
public ActionResult DeleteConfirmed(int id)
{
StudentCourse student_Course = db.StudentCourses.Find(id);
rollno = student_Course.RollNo;
db.StudentCourses.Remove(student_Course);
db.SaveChanges();
Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == student_Course.RollNo);
feemaster.RollNo = student_Course.RollNo;
feemaster.Date = System.DateTime.Now;
//feemaster.CourseId = student_Course.CourseId;
feemaster.AlertDate = System.DateTime.Now.AddDays(2);
feemaster.Status = true;
feemaster.TotalFees -= Convert.ToInt32(student_Course.Fees);
db.Entry(feemaster).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Deleted Successfully";
return(RedirectToAction("Index", new { roll = rollno }));
}
public ActionResult Edit([Bind(Include = "Id,RollNo,CourseId,Admitdate,enddate,Fees,Uid,RoomId,Status")] StudentCourse student_Course)
{
if (ModelState.IsValid)
{
student_Course.RollNo = rollno;
student_Course.Uid = Session["User"].ToString();
db.Entry(student_Course).State = EntityState.Modified;
db.SaveChanges();
Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == student_Course.RollNo);
feemaster.RollNo = student_Course.RollNo;
feemaster.Date = System.DateTime.Now;
//feemaster.CourseId = student_Course.CourseId;
feemaster.AlertDate = System.DateTime.Now.AddDays(2);
feemaster.Status = true;
feemaster.TotalFees += Convert.ToInt32(student_Course.Fees);
db.Entry(feemaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { roll = rollno }));
}
return(View(student_Course));
}
public ActionResult Create([Bind(Include = "Id,rollno,name,dob,fathername,address,phone,fatherphn,language,board,qualification,coaching,institutename,type,refferedby,image,uid,Status,username,password,gender,remarks,email,discount,date,Time,UserId,Material,By")] tblstudentdata tblstudentdata, HttpPostedFileBase file, Helper Help, [Bind(Include = "CourseId,AdmitDate,Fees,enddate,Days,FixedFee,Reason")] StudentCourse scourse, int CourseId)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (ModelState.IsValid)
{
if (User.IsInRole("Receptionists"))
{
DataTable dd2 = objsql.GetTable("select * from tblstudentdatas where name='" + tblstudentdata.name + "' and fathername='" + tblstudentdata.fathername + "' and phone='" + tblstudentdata.phone + "'");
if (dd2.Rows.Count > 0)
{
goto xx;
}
else
{
transaction.Rollback();
TempData["danger"] = "Student Not Exist";
return(View());
}
}
xx:
scourse.CourseId = CourseId;
Course co = db.Courses.FirstOrDefault(x => x.CourseId == scourse.CourseId);
int alter = Convert.ToInt32(co.Days);
string a = help.Permission();
StudentCourse studentcourse = new StudentCourse();
#region insert student table
tblstudentdata studentdata = db.tblstudentdata.FirstOrDefault(x => x.uid == a && x.Status == true);
#region Create Rollno
if (studentdata == null)
{
tblstudentdata.rollno = 1;
}
else
{
var ab = db.tblstudentdata.Where(x => x.uid == a).Max(x => x.rollno);
tblstudentdata.rollno = Convert.ToInt32(ab) + 1;
}
#endregion
tblstudentdata.uid = help.Permission(); //franchid Detail
tblstudentdata.image = Help.uploadfile(file);
tblstudentdata.role = HttpContext.User.Identity.Name;
db.tblstudentdata.Add(tblstudentdata);
db.SaveChanges();
#endregion
#region Insert Fee table and studentcourse
var token = db.Fees_Master.Where(x => x.franchid == a && x.Status == true).Max(x => x.Token);
if (token != null)
{
if (scourse.FixedFee == 0)
{
studentcourse.FixedFee = studentcourse.FixedFee;
}
else
{
if (scourse.Reason == null)
{
TempData["danger"] = "Please Update Reason";
transaction.Rollback();
ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName", scourse.CourseId);
ViewBag.UserId = new SelectList(db.tblreceptionists.Where(x => x.franchid == a && x.Type == "Teacher"), "Id", "Name", studentdata.UserId);
ViewBag.Time = new SelectList(db.Timings.Where(x => x.franchid == a), "Tid", "BatchTime", studentdata.Time);
return(View(tblstudentdata));
}
studentcourse.FixedFee = scourse.FixedFee;
studentcourse.Reason = scourse.Reason;
}
token += 1;
Fees_Master feemaster = new Fees_Master();
feemaster.RollNo = tblstudentdata.rollno;
feemaster.role = HttpContext.User.Identity.Name;
feemaster.Date = tblstudentdata.date;
feemaster.CourseId = scourse.CourseId;
//feemaster.CourseId = CourseId;
feemaster.AlertDate = System.DateTime.Now.AddDays(alter);
feemaster.discount = tblstudentdata.discount;
feemaster.Status = tblstudentdata.Status;
feemaster.TotalFees = Convert.ToInt32(scourse.Fees);
feemaster.franchid = help.Permission();
feemaster.Token = token;
db.Fees_Master.Add(feemaster);
db.SaveChanges();
studentcourse.RollNo = tblstudentdata.rollno;
studentcourse.CourseId = scourse.CourseId;
studentcourse.Admitdate = studentdata.date;
studentcourse.enddate = Convert.ToDateTime(studentdata.date).AddDays(Convert.ToInt32(co.Days));
studentcourse.Fees = Convert.ToInt32(scourse.Fees).ToString();
studentcourse.Uid = help.Permission();
studentcourse.Token = token;
studentcourse.role = HttpContext.User.Identity.Name;
studentcourse.Status = tblstudentdata.Status;
db.StudentCourses.Add(studentcourse);
db.SaveChanges();
}
else
{
token = 1;
if (studentcourse.FixedFee != 0)
{
studentcourse.FixedFee = studentcourse.FixedFee;
}
else
{
if (studentcourse.Reason == null)
{
TempData["danger"] = "Please Update Reason";
transaction.Rollback();
ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName", scourse.CourseId);
return(View(tblstudentdata));
}
}
Fees_Master feemaster = new Fees_Master();
feemaster.RollNo = tblstudentdata.rollno;
feemaster.Date = tblstudentdata.date;
feemaster.CourseId = scourse.CourseId;
feemaster.role = HttpContext.User.Identity.Name;
//feemaster.CourseId = CourseId;
feemaster.AlertDate = System.DateTime.Now.AddDays(alter);
feemaster.discount = tblstudentdata.discount;
feemaster.Status = tblstudentdata.Status;
feemaster.TotalFees = Convert.ToInt32(scourse.Fees);
feemaster.franchid = help.Permission();
feemaster.Token = token;
db.Fees_Master.Add(feemaster);
db.SaveChanges();
studentcourse.RollNo = tblstudentdata.rollno;
studentcourse.CourseId = scourse.CourseId;
studentcourse.Admitdate = studentdata.date;
studentcourse.role = HttpContext.User.Identity.Name;
studentcourse.enddate = Convert.ToDateTime(studentdata.date).AddDays(Convert.ToInt32(co.Days));
studentcourse.Fees = Convert.ToInt32(scourse.Fees).ToString();
studentcourse.Uid = help.Permission();
studentcourse.Token = token;
studentcourse.Status = tblstudentdata.Status;
db.StudentCourses.Add(studentcourse);
db.SaveChanges();
}
#endregion
#region Send Message To Student
tbldetail dd = db.tbldetails.FirstOrDefault();
// help.sendsms(studentdata.phone, "Dear " + Convert.ToString(tblstudentdata.name) + ". Welcome to " + dd.name + " . Your Course EndDate is (" + Convert.ToString(studentcourse.enddate) + "). Thanks for Joining Us.");
TempData["Success"] = "Saved Successfully";
ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == help.Permission()), "CourseId", "CourseName", scourse.CourseId);
// ViewBag.UserId = new SelectList(db.tblreceptionists.Where(x => x.franchid == help.Permission() && x.Type == "Teacher"), "Id", "Name", studentdata.UserId);
// ViewBag.Time = new SelectList(db.Timings.Where(x => x.franchid == help.Permission()), "Tid", "BatchTime", studentdata.Time);
transaction.Commit();
return(RedirectToAction("Index"));
#endregion
}
return(View(tblstudentdata));
}
catch (Exception e)
{
var mesaage = e.Message;
transaction.Rollback();
TempData["danger"] = "Error Occur ! " + mesaage;
throw;
}
}
}
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([Bind(Include = "Id,RollNo,CourseId,Admitdate,enddate,Fees,Uid,RoomId,Status,Days")] StudentCourse student_Course)
{
if (ModelState.IsValid)
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
string a = help.Permission();
try
{
//StudentCourse sc = db.StudentCourses.FirstOrDefault(x => x.CourseId == student_Course.CourseId && x.RollNo == rollno && x.Uid == a);
//Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.CourseId == student_Course.CourseId && x.RollNo == rollno && x.franchid == a);
//if (sc!=null)
//{
// objsql.ExecuteNonQuery("update studentcourses set status='0' where id='" + sc.Id + "'");
// objsql.ExecuteNonQuery("update fees_master set status='0' where id='" + fm.Id + "'");
//}
var token = db.Fees_Master.Where(x => x.franchid == a && x.Status == true).Max(x => x.Token);
if (token != null)
{
token += 1;
//string a= User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
student_Course.Uid = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
student_Course.enddate = Convert.ToDateTime(student_Course.Admitdate).AddDays(student_Course.Days);
student_Course.Fees = (Convert.ToInt32(student_Course.Fees)).ToString();
student_Course.RollNo = rollno;
student_Course.Token = token;
db.StudentCourses.Add(student_Course);
db.SaveChanges();
Fees_Master feemaster1 = new Fees_Master();
feemaster1.RollNo = student_Course.RollNo;
feemaster1.Date = System.DateTime.Now;
feemaster1.CourseId = student_Course.CourseId;
feemaster1.AlertDate = System.DateTime.Now.AddDays(2);
feemaster1.discount = 0;
feemaster1.Status = true;
feemaster1.TotalFees = int.Parse(student_Course.Fees);
feemaster1.franchid = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
feemaster1.Token = token;
// feemaster.franchid= HttpContext.User.Identity.Name;
db.Fees_Master.Add(feemaster1);
db.SaveChanges();
dbTran.Commit();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index", new { roll = rollno }));
}
else
{
dbTran.Rollback();
TempData["danger"] = "Invalid Token ! Conceren With Developer";
}
}
catch (Exception)
{
dbTran.Rollback();
return(RedirectToAction("Index", new { roll = rollno }));
throw;
}
}
}
return(View(student_Course));
}
