public List <tbl_TeacherValidation> GetSchool(int School_Id)
{
List <tbl_TeacherValidation> TeacherSchoolInformation = new List <tbl_TeacherValidation>();
SqlCommand sc = new SqlCommand("[Digital_School].get_TeacherSchool", Connections.GetConnection());
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.AddWithValue("@School_Id", School_Id);
SqlDataReader sdr = sc.ExecuteReader();
while (sdr.Read())
{
tbl_TeacherValidation gc = new tbl_TeacherValidation();
//gc.CourseId = Convert.ToInt32(sdr["courseId"]);
gc.Name = sdr["Name"].ToString();
gc.Id = Convert.ToInt32(sdr["Id"]);
TeacherSchoolInformation.Add(gc);
}
sdr.Close();
return(TeacherSchoolInformation);
}
public ActionResult ProfileSetting()
{
if (Session["Teacher"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
TeacherDBHandle sadb = new TeacherDBHandle();
int userid = Convert.ToInt32((Session["Teacher"]));
var sab = db.Teachers.Find(userid);
Session["imgPath"] = sab.Image;
tbl_TeacherValidation sa = sadb.GetProfileData(userid);
return(View(sa));
}
private string RegNo(tbl_TeacherValidation teacher)
{
int id = db.Teachers.Count(s => (s.Class_Id == teacher.Class_Id) &&
(teacher.JoiningDate.Year == teacher.JoiningDate.Year)) + 1;
Tbl_Class aClass = db.Tbl_Class.Where(d => d.Class_Id == teacher.Class_Id).FirstOrDefault();
string registrationId = aClass.Name + "-" + teacher.JoiningDate.Year + "-";
string addZero = "";
int len = 3 - id.ToString().Length;
for (int i = 0; i < len; i++)
{
addZero = "0" + addZero;
}
return(registrationId + addZero + id);
}
public tbl_TeacherValidation GetProfileData(int CurrentUserid)
{
tbl_TeacherValidation teacher = new tbl_TeacherValidation();
SqlCommand sc = new SqlCommand("[Digital_School].get_TeacherProfileData", Connections.GetConnection());
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.AddWithValue("@Id", CurrentUserid);
SqlDataReader reader = sc.ExecuteReader();
//ek hi row return hoga islye
reader.Read();//return one row only
teacher.Name = reader["Name"].ToString();
teacher.Contact = reader["Contact"].ToString();
teacher.Email = reader["Email"].ToString();
teacher.Password = reader["Password"].ToString();
teacher.Image = reader["Image"].ToString();
reader.Close();
return(teacher);
}
public ActionResult ProfileSetting(tbl_TeacherValidation sa)
{
try
{
digital_School.Models.Teacher teacher = new digital_School.Models.Teacher();
int userid = Convert.ToInt32((Session["Teacher"]));
var l = db.loginTables.FirstOrDefault(t => t.UserId == userid);
if (ModelState.IsValid)
{
if (sa.UserImageFIle != null)
{
if (l != null)
{
Session["TeacherName"] = sa.Name;
l.UserId = userid;
l.Name = sa.Name;
l.Password = sa.Password;
l.Email = sa.Email;
l.RoleID = 3;
db.Entry(l).State = EntityState.Modified;
db.SaveChanges();
}
string filename = Path.GetFileNameWithoutExtension(sa.UserImageFIle.FileName);
string extension = Path.GetExtension(sa.UserImageFIle.FileName);
filename = DateTime.Now.ToString("yymmssff") + extension;
teacher.Image = "~/FrontEnd/Images/TeacherImage/" + filename;
teacher.Name = sa.Name;
teacher.Email = sa.Email;
teacher.Password = sa.Password;
teacher.Id = userid;
if (extension.ToLower() == ".jpg" || extension.ToLower() == ".jpeg" || extension.ToLower() == ".png")
{
if (sa.UserImageFIle.ContentLength <= 1000000)
{
db.Entry(teacher).State = EntityState.Modified;
string oldImgPath = Request.MapPath(Session["imgPath"].ToString());
if (db.SaveChanges() > 0)
{
filename = Path.Combine(Server.MapPath("~/FrontEnd/Images/TeacherImage/"), filename);
sa.UserImageFIle.SaveAs(filename);
if (System.IO.File.Exists(oldImgPath))
{
System.IO.File.Delete(oldImgPath);
}
ViewBag.Message = "Data Updated";
return(RedirectToAction("ProfileSetting"));
}
}
else
{
ViewBag.msg = "File Size must be Equal or less than 1mb";
}
}
else
{
ViewBag.msg = "Inavlid File Type";
}
}
//}
else
{
teacher.Image = Session["imgPath"].ToString();
if (l != null)
{
Session["TeacherName"] = sa.Name;
l.UserId = userid;
l.Name = sa.Name;
l.Password = sa.Password;
l.Email = sa.Email;
l.RoleID = 3;
db.Entry(l).State = EntityState.Modified;
db.SaveChanges();
}
teacher.Name = sa.Name;
teacher.Email = sa.Email;
teacher.Password = sa.Password;
teacher.Id = userid;
db.Entry(teacher).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
ViewBag.Message = "Data Updated";
return(RedirectToAction("ProfileSetting"));
}
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Not Updated";
return(View());
}
return(View());
}
public ActionResult addteacher(tbl_TeacherValidation teacher)
{
try
{
int schoolid = Convert.ToInt32(Session["school"]);
ClassDBHandle gc = new ClassDBHandle();
List <tbl_ClassValidation> list = gc.GetClass(schoolid);
ViewBag.school = new SelectList(list, "Class_Id", "Name");
teacher.Reg_No = RegNo(teacher);
digital_School.Models.Teacher a = new digital_School.Models.Teacher();
var userWithSameEmail = db.Teachers.Where(m => m.Email == teacher.Email).SingleOrDefault(); //checking if the emailid already exits for any user
if (userWithSameEmail == null)
{
string filename = Path.GetFileNameWithoutExtension(teacher.UserImageFIle.FileName);
string extension = Path.GetExtension(teacher.UserImageFIle.FileName);
filename = DateTime.Now.ToString("yymmssff") + extension;
a.Image = "~/FrontEnd/Images/TeacherImage/" + filename;
//image ko folder me save krwanay ke leye
filename = Path.Combine(Server.MapPath("~/FrontEnd/Images/TeacherImage/"), filename);
teacher.UserImageFIle.SaveAs(filename);
a.Class_Id = teacher.Class_Id;
a.School_Id = Convert.ToInt32(Session["school"]);
a.Name = teacher.Name;
a.Reg_No = teacher.Reg_No;
a.Address = teacher.Address;
a.Email = teacher.Email;
a.Contact = teacher.Contact;
a.Password = teacher.Password;
a.JoiningDate = DateTime.Now;
db.Teachers.Add(a);
db.SaveChanges();
}
else
{
ViewBag.Message = "User with this Email Already Exist";
return(View());
}
int teacherlatestid = a.Id;
loginTable l = new loginTable();
l.UserId = teacherlatestid;
l.Name = a.Name;
l.Password = a.Password;
l.RoleID = 3;
l.Email = a.Email;
db.loginTables.Add(l);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
public ActionResult updateTeacher(tbl_TeacherValidation tea, int id)
{
int schoolid = Convert.ToInt32(Session["school"]);
ClassDBHandle gc = new ClassDBHandle();
List <tbl_ClassValidation> list = gc.GetClass(schoolid);
ViewBag.school = new SelectList(list, "Class_Id", "Name");
tea.Reg_No = RegNo(tea);
try
{
digital_School.Models.Teacher a = new digital_School.Models.Teacher();
//int userid = Convert.ToInt32((Session["Ad"]));
//var l = db.loginTables.FirstOrDefault(t => t.UserId == userid);
if (tea.UserImageFIle != null)
{
//if (l != null)
//{
// l.UserId = userid;
// l.Name = sa.ad_name;
// l.Password = sa.password;
// l.Email = sa.ad_email;
// l.RoleID = 1;
// db.Entry(l).State = EntityState.Modified;
// db.SaveChanges();
//}
string filename = Path.GetFileNameWithoutExtension(tea.UserImageFIle.FileName);
string extension = Path.GetExtension(tea.UserImageFIle.FileName);
filename = DateTime.Now.ToString("yymmssff") + extension;
a.Image = "~/FrontEnd/Images/TeacherImage/" + filename;
a.Id = id;
a.Class_Id = tea.Class_Id;
a.School_Id = Convert.ToInt32(Session["school"]);
a.Name = tea.Name;
a.Reg_No = tea.Reg_No;
a.Address = tea.Address;
a.Email = tea.Email;
a.Contact = tea.Contact;
a.Password = tea.Password;
a.JoiningDate = DateTime.Now;
if (extension.ToLower() == ".jpg" || extension.ToLower() == ".jpeg" || extension.ToLower() == ".png")
{
if (tea.UserImageFIle.ContentLength <= 1000000)
{
db.Entry(a).State = EntityState.Modified;
string oldImgPath = Request.MapPath(Session["imgPath"].ToString());
if (db.SaveChanges() > 0)
{
filename = Path.Combine(Server.MapPath("~/FrontEnd/Images/TeacherImage/"), filename);
tea.UserImageFIle.SaveAs(filename);
if (System.IO.File.Exists(oldImgPath))
{
System.IO.File.Delete(oldImgPath);
}
ViewBag.Message = "Data Updated";
return(RedirectToAction("viewsteacher"));
}
}
else
{
ViewBag.msg = "File Size must be Equal or less than 1mb";
}
}
else
{
ViewBag.msg = "Inavlid File Type";
}
}
//}
else
{
a.Image = Session["imgPath"].ToString();
//if (l != null)
//{
// Session["name"] = sa.ad_name;
// l.UserId = userid;
// l.Name = sa.ad_name;
// l.Password = sa.password;
// l.Email = sa.ad_email;
// l.RoleID = 1;
// db.Entry(l).State = EntityState.Modified;
// db.SaveChanges();
//}
//superadmin.ad_name = sa.ad_name;
//superadmin.ad_email = sa.ad_email;
//superadmin.ad_password = sa.password;
//superadmin.ad_Id = userid;
a.Id = id;
a.Class_Id = tea.Class_Id;
a.School_Id = Convert.ToInt32(Session["school"]);
a.Name = tea.Name;
a.Reg_No = tea.Reg_No;
a.Address = tea.Address;
a.Email = tea.Email;
a.Contact = tea.Contact;
a.Password = tea.Password;
a.JoiningDate = DateTime.Now;
db.Entry(a).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
ViewBag.Message = "Data Updated";
return(RedirectToAction("viewsteacher"));
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Not Updated";
return(View());
}
return(View());
}
