public ActionResult TCHRAttendance(FormCollection Collection, FilterModel Model)
{
ViewData["AlertData"] = "";
ViewData["AlertType"] = "danger";
ViewData["AlertHeading"] = "Error";
Query = @"SELECT STD_RollNo FROM UPS_Students WHERE (STD_PRGPCode = '" + Model.PRG_PCode + "') AND (STD_PRGSCode = '" + Model.PRG_SCode + "') AND (STD_SCLSchoolCode = '" + Model.PRG_SCLSchoolCode + "') ORDER BY STD_RollNo";
ReturnValue = DBQueries.DBFilDTable(ref FormDataTable, Query);
if (ReturnValue == "Y")
{
for (int i = 0; i < FormDataTable.Rows.Count; i++)
{
Query = @"INSERT INTO UPS_STDAttendance ( SA_STDRollNo, SA_SubjectName, SA_SCLSchoolCode, SA_PRGPCode, SA_PRGSCode, SA_Date, SA_StartTime, SA_EndTime, SA_Status)
VALUES ('" + FormDataTable.Rows[i]["STD_RollNo"].ToString() + "','" + Model.Subject + "','" + Model.PRG_SCLSchoolCode + "','" + Model.PRG_PCode + "','" + Model.PRG_SCode + "','" + Model.ClassDate.ToString() + "','" + Model.StartTime + "', '" + Model.EndTime + "','" + ((Collection[FormDataTable.Rows[i]["STD_RollNo"].ToString() + "Chk"]) == "on" ? "Y" : "N") + "')";
ReturnValue = DBQueries.DB_ExecuteNonQuery(Query);
}
if (ReturnValue == "Y")
{
ViewData["AlertType"] = "Success";
ViewData["AlertHeading"] = "Info";
ViewData["AlertData"] = "Marks Sheet Saved.";
}
}
else
{
ViewData["AlertData"] = ReturnValue;
}
return(RedirectToAction("TCHRAttendance"));
}
public ActionResult Edit(int id, StudentModel Model)
{
try
{
Query = @"UPDATE UPS_Students SET " +
"STD_RollNo = '" + Model.STD_RollNo + "', STD_Password ='******', STD_FirstName ='" + Model.STD_FirstName + "'," +
"STD_LastName ='" + Model.STD_LastName + "', STD_CNIC ='" + Model.STD_CNIC + "', STD_Address ='" + Model.STD_Address + "', STD_SCLSchoolCode ='" + Model.STD_SCLSchoolCode + "', " +
"STD_PRGPCode ='" + Model.STD_PRGPCode + "', STD_PRGSCode ='" + Model.STD_PRGSCode + "', STD_CrntSemester ='" + Model.STD_CrntSemester + "', " +
"STD_PhoneNo ='" + Model.STD_PhoneNo + "', STD_Email ='" + Model.STD_Email + "', STD_Gender ='" + Model.STD_Gender + "', " +
"STD_CCCityCode ='" + Model.STD_CCCityCode + "', STD_CCCntryCode ='" + Model.STD_CCCntryCode + "'";
ReturnValue = DBQueries.DB_ExecuteNonQuery(Query);
if (ReturnValue == "Y")
{
ViewData["AlertType"] = "success";
ViewData["AlertHeading"] = "Info";
ViewData["AlertData"] = "Data Successfully Updated.";
}
else
{
ViewData["AlertData"] = ReturnValue;
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewData["AlertData"] = ex.Message.ToString();
return(View());
}
}
public ActionResult TCHRMarkSheet(FormCollection Collection, FilterModel Model)
{
ViewData["AlertData"] = "";
ViewData["AlertType"] = "danger";
ViewData["AlertHeading"] = "Error";
Query = @"SELECT STD_RollNo FROM UPS_Students WHERE (STD_PRGPCode = '" + Model.PRG_PCode + "') AND (STD_PRGSCode = '" + Model.PRG_SCode + "') AND (STD_SCLSchoolCode = '" + Model.PRG_SCLSchoolCode + "') ORDER BY STD_RollNo";
ReturnValue = DBQueries.DBFilDTable(ref FormDataTable, Query);
if (ReturnValue == "Y")
{
for (int i = 0; i < FormDataTable.Rows.Count; i++)
{
Query = @"INSERT INTO UPS_STDMarks ( SM_STDRollNo, SM_ExamName, SM_SubjectName, STD_SCLSchoolCode, SM_PRGPCode, SM_PRGSCode, SM_Date, SM_TotalMarks, SM_ObtainedMarks)
VALUES ('" + FormDataTable.Rows[i]["STD_RollNo"].ToString() + "','" + Model.ExamType + "','" + Model.Subject + "','" + Model.PRG_SCLSchoolCode + "','" + Model.PRG_PCode + "','" + Model.PRG_SCode + "','" + Model.ClassDate.ToString() + "','" + Model.TotalMarks + "','" + Collection[FormDataTable.Rows[i]["STD_RollNo"].ToString() + "OM"] + "')";
ReturnValue = DBQueries.DB_ExecuteNonQuery(Query);
}
if (ReturnValue == "Y")
{
ViewData["AlertType"] = "Success";
ViewData["AlertHeading"] = "Info";
ViewData["AlertData"] = "Marks Sheet Saved.";
}
}
else
{
ViewData["AlertData"] = ReturnValue;
}
return(RedirectToAction("TCHRMarkSheet"));
}
public ActionResult Create()
{
ViewData["AlertData"] = "";
ViewData["AlertType"] = "danger";
ViewData["AlertHeading"] = "Error";
Query = @"SELECT CC_CntryCode, CC_CntryName FROM UPS_CityCountry ORDER BY CC_CntryName";
ReturnValue = DBQueries.DB_ExecuteNonQuery(Query);
if (ReturnValue == "Y")
{
List <SelectListItem> cbCountries = new List <SelectListItem>();
foreach (DataRow dtRow in FormDataTable.Rows)
{
cbCountries.Add(new SelectListItem {
Value = dtRow["CC_CntryCode"].ToString(), Text = dtRow["CC_CntryName"].ToString()
});
}
ViewData["cbCountries"] = cbCountries;
}
else
{
ViewData["AlertData"] = ReturnValue;
}
Query = @"SELECT SCL_SchoolCode, SCL_SchoolName FROM UPS_Schools ORDER BY SCL_SchoolName";
ReturnValue = DBQueries.DBFilDTable(ref FormDataTable, Query);
if (ReturnValue == "Y")
{
List <SelectListItem> cbSchools = new List <SelectListItem>();
foreach (DataRow dtRow in FormDataTable.Rows)
{
cbSchools.Add(new SelectListItem {
Value = dtRow["SCL_SchoolCode"].ToString(), Text = dtRow["SCL_SchoolName"].ToString()
});
}
ViewData["cbSchools"] = cbSchools;
}
else
{
ViewData["AlertData"] = ReturnValue;
}
return(View());
}
public ActionResult Delete(int id)
{
Query = @"DELETE FROM UPS_Students WHERE (STD_PKID = '" + id + "')";
ReturnValue = DBQueries.DB_ExecuteNonQuery(Query);
if (ReturnValue == "Y")
{
ViewData["AlertType"] = "success";
ViewData["AlertHeading"] = "Info";
ViewData["AlertData"] = "Data successfully Deleted.";
}
else
{
ViewData["AlertType"] = "danger";
ViewData["AlertHeading"] = "Error";
ViewData["AlertData"] = ReturnValue;
}
return(RedirectToAction("Index"));
}
