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