public ActionResult Edit([Bind(Include = "id,name,phone,email,address,logo")] tbldetail tbldetail, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
tbldetail.logo = file != null?Help.uploadfile(file) : img;
#region delete file
string fullPath = Request.MapPath("~/UploadedFiles/" + img);
if (img == tbldetail.logo)
{
}
else
{
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
#endregion
db.Entry(tbldetail).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Updated Successfully";
return(RedirectToAction("Index"));
}
return(View(tbldetail));
}
public tbldetail CompanyName()
{
int per = Convert.ToInt32(Permission());
tbldetail rr = db.tbldetails.Where(x => x.franchid == per).FirstOrDefault();
return(rr);
}
public ActionResult Create([Bind(Include = "id,name,phone,email,address,logo")] tbldetail tbldetail, HttpPostedFileBase file, Helper Help)
{
if (ModelState.IsValid)
{
tbldetail.logo = Help.uploadfile(file);
db.tbldetails.Add(tbldetail);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(tbldetail));
}
// GET: Auth/OurDetail/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbldetail tbldetail = db.tbldetails.Find(id);
if (tbldetail == null)
{
return(HttpNotFound());
}
return(View(tbldetail));
}
public ActionResult Login(tblreceptionist model, string returnUrl, Helper Help, string ddltype)
{
dbcontext db = new dbcontext();
var otp = Help.otp();
tblreceptionist rr = db.tblreceptionists.FirstOrDefault(x => x.rid == model.rid);
tbldetail dd = db.tbldetails.FirstOrDefault();
Help.sendsms(rr.contact, "Dear, " + rr.name + ". Login OTP Is " + otp + " ");
tblreceptionist data = new tblreceptionist()
{
Type = ddltype,
rid = model.rid,
OTP = Convert.ToInt32(otp)
};
Session["mydata"] = data;
return(RedirectToAction("OTP", "Accounts"));
}
public ActionResult DeleteConfirmed(int id)
{
tbldetail tbldetail = db.tbldetails.Find(id);
img = tbldetail.logo;
#region delete file
string fullPath = Request.MapPath("~/UploadedFiles/" + img);
if (img == tbldetail.logo)
{
}
else
{
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
#endregion
db.tbldetails.Remove(tbldetail);
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,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;
}
}
}
