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()); } }