public async Task <ActionResult <TblStudent> > PostTblStudent(TblStudent tblStudent) { _context.TblStudent.Add(tblStudent); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblStudent", new { id = tblStudent.IdStudent }, tblStudent)); }
public ActionResult Edit(int id) { int _id = id; TblStudent st = db.TblStudents.Where(c => c.ID == id).SingleOrDefault(); return(View(st)); }
public async Task <IActionResult> PutTblStudent(int id, TblStudent tblStudent) { if (id != tblStudent.IdStudent) { return(BadRequest()); } _context.Entry(tblStudent).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblStudentExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <TblStudent> > Post([FromBody] TblStudent student) { if (student == null) { return(BadRequest()); } using (_context) { using (var _ctxTransaction = _context.Database.BeginTransaction()) { try { _context.TblStudent.Add(student); await _context.SaveChangesAsync(); _ctxTransaction.Commit(); } catch (Exception ex) { _ctxTransaction.Rollback(); ex.ToString(); return(BadRequest()); } } } return(Ok(student)); }
public ActionResult DeleteConfirmed(int id) { TblStudent tblStudent = db.TblStudents.Find(id); db.TblStudents.Remove(tblStudent); db.SaveChanges(); return(RedirectToAction("Index")); }
protected void btnSave_Click(object sender, EventArgs e) { TblStudent objstudent = new TblStudent(TblStudent.Columns.RegistrationNo, txtAdmissionNO.Text); TblClgFeeStructure objclgFee = new TblClgFeeStructure(); string msg = "Fee detail has been submit"; objclgFee.IsNew = true; if (!string.IsNullOrEmpty(hfclgFeeID.Value)) { objclgFee = new TblClgFeeStructure(hfclgFeeID.Value); objclgFee.IsNew = false; msg = "Fee detail has been updated"; } objclgFee.StudentID = objstudent.StudentID; int advance, discount, remaining, totalFee; advance = Convert.ToInt32(txtAdvance.Text); discount = Convert.ToInt32(txtDiscount.Text); totalFee = Convert.ToInt32(txtTotal.Text); remaining = totalFee - advance - discount; objclgFee.PreviousTotalFee = Convert.ToInt32(lblTotalFee.Text.Replace(",", "")); objclgFee.TotalFee = totalFee; objclgFee.Advance = advance; objclgFee.Discount = discount; objclgFee.Remaining = remaining; objclgFee.MonthlyFee = remaining / 8; objclgFee.Percentage = Convert.ToDouble(Percentage); objclgFee.TutionFee = Convert.ToInt32(lblTutionFee.Text.Replace(",", "")); objclgFee.Misc = Misc; objclgFee.AdmissionFee = AdmissionFee; if (rdNone.Checked) { objclgFee.IsEscholarship = false; objclgFee.EScholarship = "None"; } else { objclgFee.EScholarship = EscholarShip; objclgFee.IsEscholarship = true; } objclgFee.IsActive = 1; objclgFee.Save(); // lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); helper.ClearInputs(Page.Controls); btnSave.Text = "Submit"; BasciInfo.Visible = false; SectionScholarShips.Visible = true; SectionScholarShipsHeading.Visible = true; rdNone.Checked = true; hfclgFeeID.Value = string.Empty; Response.Redirect("ClgFeeEnrolement.aspx?msg=" + helper.Encrypt(msg)); }
public IActionResult slogin(TblStudent stu) { TblStudent t = new TblStudent(); t.SName = stu.SName; t.SPassword = stu.SPassword; dBEXAMContext.TblStudent.Add(t); dBEXAMContext.SaveChanges(); return(RedirectToAction("QuizStart")); }
public TblStudent AddStudent(TblStudent student) { if (student != null) { DbContext.TblStudents.Add(student); DbContext.SaveChanges(); return(student); } return(null); }
public ActionResult Edit([Bind(Include = "StudentNummer,Geboortedatum,Adres,Postcode,Plaats,Klas,GebruikersId")] TblStudent tblStudent) { if (ModelState.IsValid) { db.Entry(tblStudent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Klas = new SelectList(db.TblKlas, "KlasCode", "Mentor", tblStudent.Klas); return(View(tblStudent)); }
public ActionResult Edit([Bind(Include = "R_no,Std_Name,Std_Phn,Std_Email,CNIC,SUBJECT")] TblStudent tblStudent) { if (ModelState.IsValid) { db.Entry(tblStudent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.R_no = new SelectList(db.TblGuardians, "R_no", "G_Name", tblStudent.R_no); return(View(tblStudent)); }
// GET: TblStudents/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblStudent tblStudent = db.TblStudents.Find(id); if (tblStudent == null) { return(HttpNotFound()); } return(View(tblStudent)); }
// GET: Student/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblStudent tblStudent = db.TblStudent.Find(id); if (tblStudent == null) { return(HttpNotFound()); } ViewBag.Klas = new SelectList(db.TblKlas, "KlasCode", "Mentor", tblStudent.Klas); return(View(tblStudent)); }
// GET: TblStudents/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblStudent tblStudent = db.TblStudents.Find(id); if (tblStudent == null) { return(HttpNotFound()); } ViewBag.R_no = new SelectList(db.TblGuardians, "R_no", "G_Name", tblStudent.R_no); return(View(tblStudent)); }
public ActionResult Delete(int id) { TblStudent st = db.TblStudents.Where(c => c.ID == id).SingleOrDefault(); db.TblStudents.Remove(st); int Result = db.SaveChanges(); if (Result == 0) { ViewBag.Message = "failed"; } else { ViewBag.Message = "ok"; } return(RedirectToAction("ShowStudent")); }
public async Task <ActionResult <TblStudent> > Get(int id) { TblStudent student = null; try { using (_context) { student = await _context.TblStudent.FirstOrDefaultAsync(x => x.StudentId == id); } } catch (Exception ex) { ex.ToString(); return(BadRequest()); } return(Ok(student)); }
public async Task <ActionResult <TblStudent> > Put(int id, [FromBody] TblStudent student) { if (student == null || id <= 0) { return(BadRequest()); } using (_context) { using (var _ctxTransaction = _context.Database.BeginTransaction()) { try { var entityUpdate = _context.TblStudent.FirstOrDefault(x => x.StudentId == id); if (entityUpdate != null) { entityUpdate.FirstName = student.FirstName; entityUpdate.LastName = student.LastName; entityUpdate.Address = student.Address; entityUpdate.Email = student.Email; entityUpdate.Password = student.Password; entityUpdate.Status = student.Status; await _context.SaveChangesAsync(); } else { return(NotFound()); } await _context.SaveChangesAsync(); _ctxTransaction.Commit(); } catch (Exception ex) { _ctxTransaction.Rollback(); ex.ToString(); return(BadRequest()); } } } return(Ok(student)); }
public ActionResult Insert(TblStudent st) { if (ModelState.IsValid) { /// صحیح /// db.TblStudents.Add(st); int Result = db.SaveChanges(); if (Result == 0) { return(HttpNotFound()); } } { /// حالت غلط /// } return(View(st)); }
public static TblStudentDto ToDto(this TblStudent entity) { if (entity == null) { return(new TblStudentDto()); } return(new TblStudentDto { StudentId = entity.StudentId, StudentBirthday = entity.StudentBirthday, StudentName = entity.StudentName, StudentNum = entity.StudentNum, StudentPassword = entity.StudentPassword, StudentSex = entity.StudentSex, MajorNum = entity.MajorNum, CreateTime = entity.CreateTime, CreatedBy = entity.CreatedBy, ModifyBy = entity.ModifyBy, ModifyTime = entity.ModifyTime, DeleteBy = entity.DeleteBy, DeleteTime = entity.DeleteTime, IsDeleted = entity.IsDeleted, Version = entity.Version }); }
#pragma warning disable 1998 public async override global::System.Threading.Tasks.Task ExecuteAsync() { #line 2 "E:\StudentSelectClassSystem\SelectClassApplication\Views\Home\StudentResult.cshtml" var title = ViewBag.Title; TblStudent student = ViewBag.student; Layout = "~/Views/Shared/_UserLayout.cshtml"; #line default #line hidden BeginContext(168, 352, true); WriteLiteral(@" <div class=""container""> <div class=""row""> <div class=""col-md-4"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> 学号 </div> <div class=""col-md-8"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> "); EndContext(); BeginContext(521, 18, false); #line 14 "E:\StudentSelectClassSystem\SelectClassApplication\Views\Home\StudentResult.cshtml" Write(student.StudentNum); #line default #line hidden EndContext(); BeginContext(539, 320, true); WriteLiteral(@" </div> <div class=""col-md-4"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> 姓名 </div> <div class=""col-md-8"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> "); EndContext(); BeginContext(860, 19, false); #line 20 "E:\StudentSelectClassSystem\SelectClassApplication\Views\Home\StudentResult.cshtml" Write(student.StudentName); #line default #line hidden EndContext(); BeginContext(879, 320, true); WriteLiteral(@" </div> <div class=""col-md-4"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> 性别 </div> <div class=""col-md-8"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> "); EndContext(); BeginContext(1200, 18, false); #line 26 "E:\StudentSelectClassSystem\SelectClassApplication\Views\Home\StudentResult.cshtml" Write(student.StudentSex); #line default #line hidden EndContext(); BeginContext(1218, 320, true); WriteLiteral(@" </div> <div class=""col-md-4"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> 生日 </div> <div class=""col-md-8"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> "); EndContext(); BeginContext(1539, 23, false); #line 32 "E:\StudentSelectClassSystem\SelectClassApplication\Views\Home\StudentResult.cshtml" Write(student.StudentBirthday); #line default #line hidden EndContext(); BeginContext(1562, 320, true); WriteLiteral(@" </div> <div class=""col-md-4"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> 班级 </div> <div class=""col-md-8"" style=""background-color: #dedef8; box-shadow: inset 1px -1px 1px #444, inset -1px 1px 1px #444;""> "); EndContext(); BeginContext(1883, 16, false); #line 38 "E:\StudentSelectClassSystem\SelectClassApplication\Views\Home\StudentResult.cshtml" Write(student.MajorNum); #line default #line hidden EndContext(); BeginContext(1899, 56, true); WriteLiteral("\r\n </div>\r\n </div>\r\n <br>\r\n \r\n</div>\r\n\r\n"); EndContext(); }
//[Route("api/Student/AddStudent")] public TblStudent AddStudent(TblStudent student) { return(studentService.AddStudent(student)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["BranchUserID"] == null) { Response.Redirect("Login.aspx"); } if (!IsPostBack) { cmptodayDate.ValueToCompare = DateTime.Now.ToShortDateString(); cmpDOA.ValueToCompare = DateTime.Now.ToShortDateString(); cmpDOB.ValueToCompare = DateTime.Now.ToShortDateString(); LoadRoutes(); LoadHostels(); radioMale.Checked = true; radioSpring.Checked = true; //divHostel.Visible = false; //divTransport.Visible = false; if (Session["StudentID"] != null) { TblStudent student = new TblStudent(Session["StudentID"]); txtStudentName.Text = student.StudentName; txtFatherName.Text = student.FatherName; txtRegNo.Text = student.RegistrationNo; ddlLevel.SelectedValue = student.LevelID.ToString(); BindClasses(ddlLevel.SelectedValue); ddlClass.SelectedValue = student.ClassNo.ToString(); if (student.GroupID != -1) { LoadGroup(ddlClass.SelectedValue); ddlGroup.SelectedValue = student.GroupID.ToString(); } if (student.LevelID.ToString() == "2") { DDProgName.SelectedValue = student.Program; Query qry = new Query(TblStudentAcademicRecord.Schema); qry.AddWhere(TblStudentAcademicRecord.Columns.StudentID, Comparison.Equals, student.StudentID); DataTable dt = qry.ExecuteDataSet().Tables[0]; DropDownMatric.SelectedValue = dt.Rows[0]["Degree"].ToString(); txtSCCInstitue.Text = dt.Rows[0]["Board"].ToString(); txtSSCYear.Text = dt.Rows[0]["Year"].ToString(); txtSSCRNo.Text = dt.Rows[0]["RollNo"].ToString(); txtSSCTMarks.Text = dt.Rows[0]["TotalMarks"].ToString(); txtSSCOMarks.Text = dt.Rows[0]["ObtainedMarks"].ToString(); txtSSCGrade.Text = dt.Rows[0]["Grade"].ToString(); txtSSCDestinction.Text = dt.Rows[0]["MajorSubject"].ToString(); if (dt.Rows.Count == 2) { DropDownInter.SelectedValue = dt.Rows[1]["Degree"].ToString(); txtInterInstitue.Text = dt.Rows[1]["Board"].ToString(); txtInterYear.Text = dt.Rows[1]["Year"].ToString(); txtInterRNo.Text = dt.Rows[1]["RollNo"].ToString(); txtInterTMarks.Text = dt.Rows[1]["TotalMarks"].ToString(); txtInterOMarks.Text = dt.Rows[1]["ObtainedMarks"].ToString(); txtInterGrade.Text = dt.Rows[1]["Grade"].ToString(); txtInterDestinction.Text = dt.Rows[1]["MajorSubject"].ToString(); } devAcademic.Visible = true; } if (student.Session == "Spring") { radioSpring.Checked = true; } else { radioFall.Checked = true; } txtDOB.SelectedDate = Convert.ToDateTime(student.Dob); txtDOA.SelectedDate = Convert.ToDateTime(student.DateofAdmission); hdnID.Value = student.StudentID.ToString(); reqFpic.Enabled = false; lblimgName.Text = student.Pic; lblimgName.Visible = true; if (student.Gender == "Male") { radioMale.Checked = true; } else { radioFemale.Checked = true; } if (student.IsTrannsport == true) { chkTransport.Checked = true; divTransport.Visible = true; } if (student.IsHostel == true) { chkHostel.Checked = true; divHostel.Visible = true; } txtNationality.Text = student.Nationality; txtDomicile.Text = student.Domicile; ddlReligion.SelectedValue = student.Religion; txtCNIC.Text = student.Cnic; txtPlaceOfBirth.Text = student.PlaceofBirth; txtStdEmail.Text = student.SEmail; txtStdCell.Text = student.SCellNo; txtHomeAddress.Text = student.SAddress; txtPhoneNo.Text = student.SHomePhone; txtGardianName.Text = student.GName; txtRelationship.Text = student.GRelationship; txtOfficeAddress.Text = student.GAddress; txtGEmail.Text = student.GEmail; txtGOccupation.Text = student.GOccupation; txtMonthlyIncome.Text = student.GMonthlyIncome.ToString(); txtGCell.Text = student.GCellNo; LoadHostelRecord(); LoadTransportRecord(); //LoadEnrollment(); Session["StudentID"] = null; } else { hdnID.Value = ""; } } if (txtPic.HasFile) { lblimgName.Text = txtPic.FileName; } }
protected void btnSave_Click(object sender, EventArgs e) { if (helper.ExecutePlainQuery("select * from TblStudents where RegistrationNo='" + txtRegNo.Text + "' and BranchID=" + Session["BranchID"]).Rows.Count > 0 && String.IsNullOrEmpty(hdnID.Value)) { lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, txtRegNo.Text + " already exists!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-check"); } else { string msg = "student has been added!"; if (hdnID.Value == "") { student = new TblStudent(); student.IsNew = true; student.CreateBy = Convert.ToString(Session["BranchUserID"]); } else { student = new TblStudent(hdnID.Value); student.IsNew = false; msg = "student has been updated!"; student.UpdatedBy = Convert.ToString(Session["BranchUserID"]); } student.BranchID = Convert.ToInt32(Session["BranchID"]); student.StudentName = txtStudentName.Text; student.FatherName = txtFatherName.Text; student.IsActive = true; student.RegistrationNo = txtRegNo.Text; student.LevelID = Convert.ToInt32(ddlLevel.SelectedValue); if (DDProgName.SelectedValue != "-1") { if (DDProgName.SelectedValue == "PreEng") { student.Program = "FSC"; } else if (DDProgName.SelectedValue == "PreMed") { student.Program = "FSC"; } else { student.Program = DDProgName.SelectedValue; } } if (radioSpring.Checked) { student.Session = "Spring"; } else { student.Session = "Autumn"; } student.DateofAdmission = txtDOA.SelectedDate; if (radioMale.Checked) { student.Gender = "Male"; } else { student.Gender = "Female"; } if (txtPic.HasFile) { if (String.IsNullOrEmpty(lblimgName.Text)) { postedFile = txtPic.FileName; } else { postedFile = lblimgName.Text; } txtPic.SaveAs(Server.MapPath("~/Admin/assets/CustomImages/" + txtPic.FileName)); student.Pic = postedFile; } student.Nationality = txtNationality.Text; student.Domicile = txtDomicile.Text; student.Religion = ddlReligion.SelectedValue; student.Cnic = txtCNIC.Text; student.Dob = txtDOB.SelectedDate; student.PlaceofBirth = txtPlaceOfBirth.Text; student.SEmail = txtStdEmail.Text; student.SCellNo = txtStdCell.Text; student.SHomePhone = txtPhoneNo.Text; student.SAddress = txtHomeAddress.Text; if (chkTransport.Checked) { student.IsTrannsport = true; } else { student.IsTrannsport = false; } if (chkHostel.Checked) { student.IsHostel = true; } else { student.IsHostel = false; } student.GName = txtGardianName.Text; student.GRelationship = txtRelationship.Text; student.GAddress = txtOfficeAddress.Text; student.GEmail = txtGEmail.Text; student.GOccupation = txtGOccupation.Text; student.GMonthlyIncome = Convert.ToDecimal(txtMonthlyIncome.Text); student.GCellNo = txtGCell.Text; student.ClassNo = Convert.ToInt32(ddlClass.SelectedValue); if (!String.IsNullOrEmpty(ddlGroup.SelectedValue)) { student.GroupID = Convert.ToInt32(ddlGroup.SelectedValue); } student.Save(); if (ddlLevel.SelectedValue == "2") { student.Program = DDProgName.SelectedValue; Query qry = new Query(TblStudentAcademicRecord.Schema); qry.AddWhere(TblStudentAcademicRecord.Columns.StudentID, Comparison.Equals, student.StudentID); DataTable dt = qry.ExecuteDataSet().Tables[0]; TblStudentAcademicRecord academic; if (dt.Rows.Count == 0) { academic = new TblStudentAcademicRecord(); academic.IsNew = true; } else { academic = new TblStudentAcademicRecord(dt.Rows[0]["ARecordID"]); academic.IsNew = false; } academic.StudentID = student.StudentID; academic.Degree = DropDownMatric.SelectedValue; academic.Board = txtSCCInstitue.Text; academic.Year = txtSSCYear.Text; academic.RollNo = txtSSCRNo.Text; academic.TotalMarks = Convert.ToInt32(txtSSCTMarks.Text); academic.ObtainedMarks = Convert.ToInt32(txtSSCOMarks.Text); academic.Grade = txtSSCGrade.Text; academic.MajorSubject = txtSSCDestinction.Text; academic.Save(); if (DropDownInter.SelectedValue != "-1") { TblStudentAcademicRecord interacademic; if (dt.Rows.Count == 0) { interacademic = new TblStudentAcademicRecord(); interacademic.IsNew = true; } else { interacademic = new TblStudentAcademicRecord(dt.Rows[1]["ARecordID"]); interacademic.IsNew = false; } interacademic.StudentID = student.StudentID; interacademic.Degree = DropDownInter.SelectedValue; interacademic.Board = txtInterInstitue.Text; interacademic.Year = txtInterYear.Text; interacademic.RollNo = txtInterRNo.Text; interacademic.TotalMarks = Convert.ToInt32(txtInterTMarks.Text); interacademic.ObtainedMarks = Convert.ToInt32(txtInterOMarks.Text); interacademic.Grade = txtInterGrade.Text; interacademic.MajorSubject = txtInterDestinction.Text; interacademic.Save(); } } if (chkTransport.Checked) { TblTransportHolder transport; if (hdnID.Value != "") { transport = new SubSonic.Select() .From(TblTransportHolder.Schema) .Where(TblTransportHolder.Columns.MemberID).IsEqualTo(hdnID.Value) .And(TblTransportHolder.Columns.MemberType).IsEqualTo(false) .ExecuteSingle <TblTransportHolder>(); if (transport == null) { transport = new TblTransportHolder(); transport.IsNew = true; } else { transport.IsNew = false; } } else { transport = new TblTransportHolder(); transport.IsNew = true; } transport.RouteID = Convert.ToInt32(ddlRoute.SelectedValue); transport.BusID = Convert.ToInt32(ddlBus.SelectedValue); transport.MemberID = student.StudentID; transport.MemberType = false; transport.Discount = Convert.ToInt32(txtDiscount.Text); transport.SeatNo = Convert.ToInt32(txtSeatNo.Text); transport.Stop = txtBusStop.Text; transport.JoiningDate = txtTJoinDate.SelectedDate; transport.IsActive = true; transport.Save(); } if (chkHostel.Checked) { TblHostelEnrollment hostel; if (hdnID.Value != "") { hostel = new SubSonic.Select() .From(TblHostelEnrollment.Schema) .Where(TblHostelEnrollment.Columns.MemberID).IsEqualTo(hdnID.Value) .And(TblHostelEnrollment.Columns.MemberType).IsEqualTo(false) .ExecuteSingle <TblHostelEnrollment>(); if (hostel == null) { hostel = new TblHostelEnrollment(); hostel.IsNew = true; } else { hostel.IsNew = false; } } else { hostel = new TblHostelEnrollment(); hostel.IsNew = true; } hostel.MemberID = student.StudentID; hostel.MemberType = false; hostel.HostelID = Convert.ToInt32(ddlHostel.SelectedValue); hostel.HAdmissionDate = txtEnrollDate.SelectedDate; hostel.Save(); } //TblCurrentEnrollment Currenroll; //if (hdnID.Value != "") //{ // Currenroll = new SubSonic.Select() // .From(TblCurrentEnrollment.Schema) // .Where(TblCurrentEnrollment.Columns.StudentID).IsEqualTo(hdnID.Value) // .ExecuteSingle<TblCurrentEnrollment>(); // if (Currenroll == null) // { // Currenroll = new TblCurrentEnrollment(); // Currenroll.IsNew = true; // Currenroll.CreateBy = Convert.ToString(Session["BranchUserID"]); // } // else // { // Currenroll.IsNew = false; // Currenroll.UpdatedBy = Convert.ToString(Session["BranchUserID"]); // } //} //else //{ // Currenroll = new TblCurrentEnrollment(); // Currenroll.IsNew = true; // Currenroll.CreateBy = Convert.ToString(Session["BranchUserID"]); //} //Currenroll.StudentID = student.StudentID; //Currenroll.ClassNo = Convert.ToInt32(ddlClass.SelectedValue); //Currenroll.BranchID = Convert.ToInt32(Session["BranchID"]); //Currenroll.EnrollmentDate = DateTime.Now; //Currenroll.GroupID = Convert.ToInt32(ddlGroup.SelectedValue); //Currenroll.Save(); //TblEnrollmentHistory EnrollHistory; //if (hdnID.Value != "") //{ // EnrollHistory = new SubSonic.Select() // .From(TblEnrollmentHistory.Schema) // .Where(TblEnrollmentHistory.Columns.StudentID).IsEqualTo(hdnID.Value) // .And(TblEnrollmentHistory.Columns.ClassNo).IsEqualTo(ddlClass.SelectedValue) // .ExecuteSingle<TblEnrollmentHistory>(); // if (EnrollHistory == null) // { // EnrollHistory = new TblEnrollmentHistory(); // EnrollHistory.IsNew = true; // EnrollHistory.CreateBy = Convert.ToString(Session["BranchUserID"]); // } // else // { // EnrollHistory.IsNew = false; // EnrollHistory.UpdatedBy = Convert.ToString(Session["BranchUserID"]); // } //} //else //{ // EnrollHistory = new TblEnrollmentHistory(); // EnrollHistory.IsNew = true; // EnrollHistory.CreateBy = Convert.ToString(Session["BranchUserID"]); //} //EnrollHistory.StudentID = student.StudentID; //EnrollHistory.ClassNo = Convert.ToInt32(ddlClass.SelectedValue); //EnrollHistory.BranchID = Convert.ToInt32(Session["BranchID"]); //EnrollHistory.EnrollmentDate = DateTime.Now; //EnrollHistory.GroupID = Convert.ToInt32(ddlGroup.SelectedValue); //EnrollHistory.Save(); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); helper.ClearInputs(this.Controls); txtDOB.SelectedDate = null; txtDOA.SelectedDate = null; // LoadTransportRecord(); // LoadHostelRecord(); lblimgName.Text = string.Empty; hdnID.Value = ""; reqFpic.Enabled = true; chkHostel.Checked = false; chkTransport.Checked = false; lblimgName.Visible = false; } }
//[Route("api/Student/EditStudent")] public TblStudent EditStudent(TblStudent student) { return(studentService.UpdateStudent(student)); }
static void InsertStudents() { LINQ2SqlPracticeDataContext db; db = GetDBContext(); //TblSchool newSchool = db.TblSchools.FirstOrDefault(e => e.Sch_Name.Contains("ZP")); //TblSchool newSchool = db.TblSchools.FirstOrDefault(e => e.Sch_Id.Equals(1)); //Console.WriteLine(newSchool.Sch_Name); TblStudent stu1 = new TblStudent(); stu1.Stu_Id = 1; stu1.Stu_Name = "Venu Pigilam"; stu1.Stu_Gender = "Male"; stu1.Stu_Father = "Arjun Rao"; stu1.Stu_Mother = "Maha Lakshmi"; stu1.Stu_Dob = new DateTime(); stu1.Stu_Mobile = "9963456363"; //= 1; //TblSchool tblsch = db.TblSchools.FirstOrDefault(xy => xy.Sch_Id.Equals(1)); //stu1.Stu_School = tblsch.Sch_Id; db.TblStudents.InsertOnSubmit(stu1); //TblStudent stu2 = new TblStudent(); //stu2.Stu_Id = 2; //stu2.Stu_Name = "Sujana Pigilam"; //stu2.Stu_Gender = "FeMale"; //stu2.Stu_Father = "Arjun Rao"; //stu2.Stu_Mother = "Maha Lakshmi"; //stu2.Stu_Dob = new DateTime(); //stu2.Stu_Mobile = "9963451818"; //stu2.Stu_School = 2; //db.TblStudents.InsertOnSubmit(stu2); //TblStudent stu3 = new TblStudent(); //stu3.Stu_Id = 3; //stu3.Stu_Name = "Sree Vidya"; //stu3.Stu_Gender = "Male"; //stu3.Stu_Father = "Arjun Rao"; //stu3.Stu_Mother = "Maha Lakshmi"; //stu3.Stu_Dob = new DateTime(); //stu3.Stu_Mobile = "9963456363"; //stu3.Stu_School = 3; //db.TblStudents.InsertOnSubmit(stu3); //TblStudent stu4 = new TblStudent(); //stu4.Stu_Id = 4; //stu4.Stu_Name = "Muni dinakar"; //stu4.Stu_Gender = "Male"; //stu4.Stu_Father = "Ramanaih"; //stu4.Stu_Mother = "Muni Lakshmi"; //stu4.Stu_Dob = new DateTime(); //stu4.Stu_Mobile = "9441271662"; //stu4.Stu_School = 4; //db.TblStudents.InsertOnSubmit(stu4); //TblStudent stu5 = new TblStudent(); //stu5.Stu_Id = 5; //stu5.Stu_Name = "Venkata Suneel"; //stu5.Stu_Gender = "Male"; //stu5.Stu_Father = "Manohar"; //stu5.Stu_Mother = "Rajeswari"; //stu5.Stu_Dob = new DateTime(); //stu5.Stu_Mobile = "9704462687"; //stu5.Stu_School = 5; //db.TblStudents.InsertOnSubmit(stu5); db.SubmitChanges(); }
public TblStudent UpdateStudent(TblStudent student) { DbContext.Entry(student).State = EntityState.Modified; DbContext.SaveChanges(); return(student); }