public ActionResult edit(studentmodel model)
{
studentdal dal = new studentdal();
dal.update(model.studentid, model.studentpassword, model.studentmobile);
return(View("view_update"));
}
public studentmodel Find(int id)
{
SqlCommand com_find = new SqlCommand("proc_find", con);
com_find.Parameters.AddWithValue("@id", id);
com_find.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = com_find.ExecuteReader();
if (dr.Read())
{
studentmodel model = new studentmodel();
model.studentid = dr.GetInt32(0);
model.studentname = dr.GetString(1);
model.studentemailid = dr.GetString(2);
model.studentpassword = dr.GetString(3);
model.studentmobile = dr.GetString(4);
model.studentcity = dr.GetString(5);
model.studentgender = dr.GetString(6);
model.studentimageaddress = dr.GetString(7);
con.Close();
return(model);
}
else
{
con.Close();
return(null);
}
}
protected void btn_register_Click(object sender, EventArgs e)
{
StudentsOperation students = new StudentsOperation();
studentmodel model = new studentmodel()
{
fname = fname.Text,
lname = lname.Text,
email = email.Text,
mobile = mobile.Text,
qualification = qualification.Text,
address = address.Text,
gender = gen.Checked == true ? "Male" : gen1.Checked == true ? "Female" : gen2.Checked == true ? "Transgender" : "Unknown"
};
bool result = students.CreateStudent(model);
if (result == true)
{
lblmsg.Text = "Student created successfully...";
System.Threading.Thread.Sleep(5000);
Response.Redirect("Show-All-Students.aspx");
}
else
{
lblmsg.Text = "Student not created !";
}
}
public ActionResult edit(int id)
{
studentdal dal = new studentdal();
studentmodel model = dal.Find(id);
return(View(model));
}
public ActionResult getprofiledetails()
{
int loginid = Convert.ToInt32(Session["loginid"]);
studentdal dal = new studentdal();
studentmodel model = dal.Find(loginid);
ViewBag.id = model.studentid;
ViewBag.name = model.studentname;
ViewBag.imageaddress = model.studentimageaddress;
return(PartialView("myprofilepartialview"));
}
//CRUD FUNCTION FOR PROGRAMMME
public void insertProgrammeDetails(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO Programme_table(Programme_name) VALUES ('" + studentMod.Programmename1 + "')";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
MessageBox.Show("No of Records have been inserted" + ret, "Information");
con.Close();
}
public void updateacademicyrandsem(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string sql = "UPDATE Academicyrsemtable SET AcademicYrsem='" + studentMod.Academicyearsemester1 + "' WHERE AcademicYrsemId = '" + studentMod.Academicyearsemester_id1 + "'";
SqlDataAdapter sad = new SqlDataAdapter(sql, con);
sad.SelectCommand.ExecuteNonQuery();
MessageBox.Show(" Record have been updated", "Information");
}
public void insertAcademicyearsemesterDetails(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO Academicyrsemtable(AcademicYrsem) VALUES ('" + studentMod.Academicyearsemester1 + "')";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
MessageBox.Show("No of Records have been inserted" + ret, "Information");
con.Close();
}
public void All_Details(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO Student_Details(AcademicYrSemester,Programme,Groupnumber,GroupId,SubGroupnumber,SubGroupId) VALUES ('" + studentMod.Academic_yr_sem1 + "','" + studentMod.Programme1 + "','" + studentMod.Group_number1 + "','" + studentMod.Group_Id1 + "','" + studentMod.Sub_group_number2 + "','" + studentMod.Sub_Group_Id1 + "')";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
MessageBox.Show("No of Records have been inserted" + ret, "Information");
con.Close();
}
public void insert_Group_Id_and_SubGroupId(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO Student_Details(Group_Id,Sub_Group_Id) VALUES ('" + studentMod.Group_Id1 + "','" + studentMod.Sub_Group_Id1 + "')";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
MessageBox.Show("No of Records have been inserted" + ret, "Information");
con.Close();
}
//CRUD FUNCTION FOR SUB-GROUP-ID
public void insertSubGroupId(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO Sub_group_id_table(Subgroup_id_value) VALUES ('" + studentMod.Sub_Group_id1 + "')";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
MessageBox.Show("No of Records have been inserted" + ret, "Information");
con.Close();
}
//CRUD FUNCTION FOR GROUP NUMBER
public void insertGroupnumber(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO Group_number_table(Group_number) VALUES ('" + studentMod.Group_number1 + "')";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
MessageBox.Show("No of Records have been inserted" + ret, "Information");
con.Close();
}
public void updatesubgroupnumber(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string sql = "UPDATE Sub_group_numbers SET Sub_group_number='" + studentMod.Sub_group_number1 + "' WHERE Sub_group_id = '" + studentMod.Sub_group_number_primary_key1 + "'";
SqlDataAdapter sad = new SqlDataAdapter(sql, con);
sad.SelectCommand.ExecuteNonQuery();
MessageBox.Show(" Record have been updated", "Information");
}
public void updateprogramme(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string sql = "UPDATE Programme_table SET Programme_name='" + studentMod.Programmename1 + "' WHERE Programme_Id = '" + studentMod.Programme_id1 + "'";
SqlDataAdapter sad = new SqlDataAdapter(sql, con);
sad.SelectCommand.ExecuteNonQuery();
MessageBox.Show(" Record have been updated", "Information");
}
public void DeleteAcademicyearsem(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "DELETE FROM Academicyrsemtable WHERE AcademicYrsemId='" + studentMod.Academicyearsemester_id1 + "'";
SqlCommand com = new SqlCommand(query, con);
string ans = MessageBox.Show("Are sure to delete this record?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString();
if (ans == "Yes")
{
int ret = com.ExecuteNonQuery();
MessageBox.Show("No of records deleted" + ret, "Information");
}
con.Close();
}
public ActionResult newstudent(studentmodel model)
{
if (ModelState.IsValid)
{
model.studentimageaddress = "/images/" + Guid.NewGuid() + ".jpg";
model.studentimagefile.SaveAs(Server.MapPath(model.studentimageaddress));
studentdal dal = new studentdal();
int id = dal.Addstudent(model);
ViewBag.msg = "student added: " + id;
ModelState.Clear();
ViewBag.cities = dal.Getcities();
return(View());
}
else
{
studentdal dal = new studentdal();
ViewBag.cities = dal.Getcities();
return(View());
}
}
public bool CreateStudent(studentmodel student)
{
string query = "insert into students values ('" + student.fname + "','" + student.lname + "','" + student.email + "','" + student.mobile + "','" + student.qualification + "','" + student.gender + "','" + student.address + "')";
SqlCommand sql = new SqlCommand(query, connection);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
int i = sql.ExecuteNonQuery();
connection.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
public void DeletesubgroupId(studentmodel studentMod)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "DELETE FROM Sub_group_id_table WHERE Subgroup_id_key='" + studentMod.Sub_Group_id_primary_key1 + "'";
SqlCommand com = new SqlCommand(query, con);
string ans = MessageBox.Show("Are sure to delete this record?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString();
if (ans == "Yes")
{
int ret = com.ExecuteNonQuery();
MessageBox.Show("No of records deleted" + ret, "Information");
}
con.Close();
}
public int Addstudent(studentmodel model)
{
SqlCommand com_add = new SqlCommand("proc_addstudent", con);
com_add.Parameters.AddWithValue("@name", model.studentname);
com_add.Parameters.AddWithValue("@email", model.studentemailid);
com_add.Parameters.AddWithValue("@password", model.studentpassword);
com_add.Parameters.AddWithValue("@mobile", model.studentmobile);
com_add.Parameters.AddWithValue("@city", model.studentcity);
com_add.Parameters.AddWithValue("@gender", model.studentgender);
com_add.Parameters.AddWithValue("@imgaddress", model.studentimageaddress);
com_add.CommandType = CommandType.StoredProcedure;
SqlParameter para_ret = new SqlParameter();
para_ret.Direction = ParameterDirection.ReturnValue;
com_add.Parameters.Add(para_ret);
con.Open();
com_add.ExecuteNonQuery();
con.Close();
int id = Convert.ToInt32(para_ret.Value);
return(id);
}
public ActionResult StudentdetailsAdd(Addstudent AS, string[] DynamicTextBox, HttpPostedFileBase[] Dynamicfile)
{
try
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
ViewBag.Values = serializer.Serialize(DynamicTextBox);
//string message = "";
//foreach (string textboxValue in DynamicTextBox)
//{
// message += textboxValue + "\\n";
//}
//ViewBag.Message = message;
string path = Path.Combine(Server.MapPath("~/SSLCcertificate/"), Path.GetFileName(AS.tenth.FileName.ToString().Replace("JPG", "jpg")));
AS.tenth.SaveAs(path);
string path1 = Path.Combine(Server.MapPath("~/HSSCertificate/"), Path.GetFileName(AS.plustwo.FileName.ToString().Replace("JPG", "jpg")));
AS.plustwo.SaveAs(path1);
string path2 = Path.Combine(Server.MapPath("~/UGCertificate/"), Path.GetFileName(AS.UG.FileName.ToString().Replace("JPG", "jpg")));
AS.UG.SaveAs(path2);
string path3 = Path.Combine(Server.MapPath("~/PGCertificate/"), Path.GetFileName(AS.PG.FileName.ToString().Replace("JPG", "jpg")));
AS.PG.SaveAs(path3);
string path4 = Path.Combine(Server.MapPath("~/CommunityCertificate/"), Path.GetFileName(AS.CC.FileName.ToString().Replace("JPG", "jpg")));
AS.CC.SaveAs(path4);
//foreach (HttpPostedFileBase h in Dynamicfile)
//{
// string path2 = Path.Combine(Server.MapPath("~/visascancopy/"), Path.GetFileName(h.FileName.ToString().Replace("JPG", "jpg")));
// h.SaveAs(path2);
//}
//byte[] bytes;
//byte[] bytes1;
//byte[] bytes2;
//using (BinaryReader br = new BinaryReader(em.fileupload1.InputStream))
//{
// bytes = br.ReadBytes(em.fileupload1.ContentLength);
//}
//using (BinaryReader br = new BinaryReader(em.fileupload2.InputStream))
//{
// bytes1 = br.ReadBytes(em.fileupload2.ContentLength);
//}
//using (BinaryReader br = new BinaryReader(em.fileupload3.InputStream))
//{
// bytes2 = br.ReadBytes(em.fileupload3.ContentLength);
//}
studentmodel stutenttbl = new studentmodel();
stutenttbl.StudentName = AS.StudentName;
stutenttbl.Dob = Convert.ToDateTime(AS.Dob);
stutenttbl.contact = AS.contact;
stutenttbl.Gender = AS.Gender;
stutenttbl.GuardianName = AS.GuardianName;
stutenttbl.UG = AS.UG.FileName.ToString();
stutenttbl.PG = AS.PG.FileName.ToString();
stutenttbl.tenth = AS.tenth.FileName.ToString();
stutenttbl.plustwo = AS.plustwo.FileName.ToString();
stutenttbl.CC = AS.CC.FileName.ToString();
stutenttbl.Address = AS.Address;
stutenttbl.Coursetype = AS.Coursetype;
stutenttbl.collegename = AS.collegename;
stutenttbl.Degree = AS.Degree;
//emptbl.visacopyname = em.fileupload3.FileName.ToString();
//var x = (from y in cv.employeescandetails where y.windowuserid == emptbl.windowuserid select y).FirstOrDefault();
//if (x != null)
//{
// cv.employeescandetails.Remove(x);
//}
// var studentList = cv.employeescandetails.SqlQuery("if exists(Select * from employeescandetails").ToList<empmodel>();
CM.Studentmanagement.Add(stutenttbl);
//List<employeevisa> empl = new List<employeevisa>();
//var data = new employeevisa();
//for (int i = 0; i <= Dynamicfile.Length; i++)
//{
// data.visaimage = Dynamicfile[i].FileName.ToString().Replace("JPG", "jpg");
// for (int j = 0; j <= DynamicTextBox.Length; j++)
// {
// data.visatype = DynamicTextBox[j];
// for (int k = 0; k <= visacountry.Length; k++)
// {
// data.visacountry = visacountry[k];
// }
// }
// empl.Add(data);
//}
// foreach (HttpPostedFileBase h in Dynamicfile)
// {
// var data = new employeevisa();
// data.visaimage = h.FileName.ToString().Replace("JPG", "jpg");
// foreach (var t in DynamicTextBox)
// {
// data.visatype = t;
// }
// foreach (var k in visacountry)
// {
// data.visacountry = k;
// }
// empl.Add(data);
//}
//cv.employeevisadetails.Add(ev);
CM.SaveChanges();
return(RedirectToAction("StudentDetailsView"));
}
catch
{
return(View());
}
}
