private void getdropdownData()
{
BLLStudent objBLLStudent = new BLLStudent();
ViewBag.dpClass = objBLLStudent.GetClassDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
ViewBag.dpSection = objBLLStudent.GetClassSectionDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
}
}//deleting record
private void loadStudent()//string pagesize,int pageindex)
{
try
{
EntityStudent es = new EntityStudent();
es.Task = 4;
es.pagesize = grdStudent.PageSize;
if (ViewState["OBJ"] != null)
{
es.PageIndex = int.Parse(ViewState["OBJ"].ToString());
}
else
{
es.PageIndex = 1;
}
DataSet ds = new DataSet();
ds = BLLStudent.getStudentData(es);
if (ds.Tables.Count > 0)
{
grdStudent.DataSource = ds;
grdStudent.DataBind();
}
else
{
ltrlerror.Text = "No Records Found";
btnclose.Visible = true;
}
}
catch (Exception ex)
{
ltrlerror.Text = "Error .. Could not Load data";
btnclose.Visible = true;
}
}//fetching all record
private void assignvaluesToControl(int id)
{
EntityStudent es = new EntityStudent();
btnsave.Text = "Update";
DataSet ds = new DataSet();
es.Task = 5;
es.Id = id;
ds = BLLStudent.getSingeStudentData(es);
if (ds.Tables.Count > 0)
{
txtName.Text = ds.Tables[0].Rows[0]["Name"].ToString();
txtEmail.Text = ds.Tables[0].Rows[0]["EmailId"].ToString();
txtcntnum.Text = ds.Tables[0].Rows[0]["ContactNum"].ToString();
txtAge.Text = ds.Tables[0].Rows[0]["Age"].ToString();
txtaddress.Text = ds.Tables[0].Rows[0]["Addresses"].ToString();
if (ds.Tables[0].Rows[0]["Gender"].ToString().Equals("0"))
{
rdMale.Checked = true;
}
else
{
rdFemale.Checked = true;
}
clddate.Text = ds.Tables[0].Rows[0]["DOB"].ToString();
}
}//assigning values to Control
private void deleteStudent(int id)
{
try
{
EntityStudent es = new EntityStudent();
es.Task = 3;
es.Id = id;
bool b = BLLStudent.deleteStudent(es);
if (b == true)
{
// Response.Write("<script language=javascript>alert('Deleted Successfully');</script>");
ltrlerror.Text = "Deleted Successfully";
btnclose.Visible = true;
}
else
{
ltrlerror.Text = "Error while deletion";
btnclose.Visible = true;
// Response.Write("<script language=javascript>alert('Error');</script>");
}
}
catch (Exception ex)
{
ltrlerror.Text = "Error while deletion";
btnclose.Visible = true;
}
}//deleting record
public ActionResult UpdateStudentInfo(ViewModelStudent objModelStudent)
{
try
{
BindDropdownlist();
BLLStudent objBLLStudent = new BLLStudent();
if (ModelState.IsValid)
{
objModelStudent.Status = 1;
decimal result = objBLLStudent.UpdateStudent(objModelStudent);
if (result > 0)
{
Success("Update Record at" + DateTime.Now);
ModelState.Clear();
return(View());
}
else
{
Error("Data Submition Error, Plz Correct All Fields and Try Again");
}
}
Error("Plz Fill out All Fields");
return(PartialView(customview("_EditFormStudent", "Student"), objModelStudent));
}
catch
{
return(View());
}
}
public ActionResult Search1()
{
BLLStudent objBLLStudent = new BLLStudent();
ViewBag.dpClass = objBLLStudent.GetClassDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
ViewBag.dpSection = objBLLStudent.GetClassSectionDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
return(PartialView(customview("_SearchFormPartial", "Student")));
}
//
// GET: /Add/
public void BindDropdownlist()
{
BLLStudent objBLLStudent = new BLLStudent();
ViewBag.dpClass = objBLLStudent.GetClassDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
ViewBag.dpSection = objBLLStudent.GetClassSectionDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
ViewBag.dpFeeMonths = objBLLStudent.GetFeeMonthDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
}
protected void btnsearch_Click(object sender, EventArgs e)
{
try
{
EntityStudent es = new EntityStudent();
es.Task = 7;
if (!string.IsNullOrEmpty(txtname.Text) || !string.IsNullOrEmpty(txtcntnum.Text) || !string.IsNullOrEmpty(txtEID.Text) || !string.IsNullOrEmpty(txtID.Text))
{
if (!string.IsNullOrEmpty(txtID.Text))
{
es.Id = int.Parse(txtID.Text);
}
es.Name = txtname.Text;
if (!string.IsNullOrEmpty(txtcntnum.Text))
{
es.Contactnumb = double.Parse(txtcntnum.Text);
}
es.Emailid = txtEID.Text;
es.pagesize = grdStudent.PageSize;
if (ViewState["OBJ"] != null)
{
es.PageIndex = int.Parse(ViewState["OBJ"].ToString());
}
else
{
es.PageIndex = 1;
}
DataSet ds = new DataSet();
ds = BLLStudent.getStudentData(es);
if (ds.Tables.Count > 0)
{
grdStudent.DataSource = ds;
grdStudent.DataBind();
}
else
{
ltrlerror.Text = "No Records Found";
btnclose.Visible = true;
}
}
else
{
loadStudent();
}
}
catch (Exception ex)
{
ltrlerror.Text = "Error .. Could not Load data";
btnclose.Visible = true;
}
}
public ActionResult GetStudentInfoWithBarCode(string strStudentId)
{
BLLStudent objBLLStudent = new BLLStudent();
DataTable aStudentInfo = new DataTable();
string _StudentName = String.Empty;
aStudentInfo = objBLLStudent.GetStudentInfoWithBarCode(Convert.ToDecimal(strStudentId));
if (aStudentInfo.Rows.Count > 0)
{
_StudentName = Convert.ToString(aStudentInfo.Rows[0]["StudentName"].ToString());
}
return(Json(new { studentName = _StudentName }));
}
private void ShowAllInfo()
{
string className = this.tvwClass.SelectedNode.Text; //获取选中节点的名称（班级名称）
DataView dataview = new DataView(dtClass); //通过班级表new一个DataView
dataview.RowFilter = "className = '" + className + "'"; //根据班级名称筛选数据
DataTable dt = dataview.ToTable(); //获取筛选后的班级表
int classID = int.Parse(dt.Rows[0][0].ToString());
lstViewStudent.Items.Clear();
bllstudent = new BLLStudent();
dtStudent = bllstudent.GetStudentInfoClassID(classID);//查询所在班级的学生信息
if (dtStudent == null)
{
MessageBox.Show("該班級才剛剛建立，還沒有學生！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
for (int i = 0; i < dtStudent.Rows.Count; i++)
{
listview = new ListViewItem();
listview.Text = dtStudent.Rows[i][2].ToString();
listview.SubItems.Add(dtStudent.Rows[i][1].ToString());
listview.SubItems.Add(dtStudent.Rows[i][3].ToString());
listview.SubItems.Add(dtStudent.Rows[i][4].ToString());
listview.SubItems.Add(className);
listview.SubItems.Add(dtStudent.Rows[i][5].ToString());
lstViewStudent.Items.Add(listview);
}
}
tvwCourse.Nodes.Clear();
dtCourse = new DataTable();
bllcourse = new BLLCourse();
dtCourse = bllcourse.GetCourseInfoClassID(classID);//點擊班级列表時顯示課程訊息
if (dtStudent == null)
{
MessageBox.Show("該班級才剛剛建立，還沒有學生！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
for (int i = 0; i < dtCourse.Rows.Count; i++)
{
TreeNode tn = new TreeNode(className + "-" + dtCourse.Rows[i]["CourseName"].ToString());
tvwCourse.Nodes.Add(tn);
}
tvwCourse.SelectedNode = tvwCourse.Nodes[0];
}
}
public ActionResult EditStudent(string studentID)
{
ViewModelStudent objModelStudent = new ViewModelStudent();
if (!String.IsNullOrEmpty(studentID.Trim()))
{
BLLStudent objBLLStudent = new BLLStudent();
objModelStudent = objBLLStudent.GetStudentInfoById(Convert.ToDecimal(studentID));
ViewBag.dpClass = objBLLStudent.GetClassDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
ViewBag.dpSection = objBLLStudent.GetClassSectionDropdown(Convert.ToInt32(Session[DALVariables.SchoolAccountId]));
}
return(PartialView(customview("_EditFormStudent", "Student"), objModelStudent));
}
public ActionResult GetAllStudentData()
{
try
{
List <ModelStudent> lstModelStudent = new List <ModelStudent>();
BLLStudent objBLLStudent = new BLLStudent();
lstModelStudent = objBLLStudent.GetStudentList();
return(PartialView(customview("_GetStudentList", "Student"), lstModelStudent));
}
catch (Exception)
{
throw;
}
}
public ActionResult CreateStudentInfo(ViewModelStudent objModelStudent)
{
try
{
BindDropdownlist();
BLLStudent objBLLStudent = new BLLStudent();
if (ModelState.IsValid)
{
objModelStudent.Status = 1;
objModelStudent.P = "N/A";
if (Request.Files.Count > 0)
{
if (Request.Files["Simage"].ContentLength > 0)
{
var image = System.Drawing.Image.FromStream(Request.Files["Simage"].InputStream);
var rName = SecureRandomString(15) + System.IO.Path.GetExtension(Request.Files["Simage"].FileName);
image.Save(Server.MapPath("/StudentImage/" + rName + ""));
objModelStudent.Simage = rName;
}
}
else
{
Error("Student Image not found");
return(PartialView(customview("_StudentInformation", "Student"), objModelStudent));
}
decimal result = objBLLStudent.AddStudentInfo(objModelStudent);
if (result > 0)
{
Success("Record Added at" + DateTime.Now);
return(PartialView(customview("_StudentInformation", "Student"), objModelStudent));
}
else
{
Error("Data Submition Error, Plz Correct All Fields and Try Again");
}
}
Error("Plz Fill out All Fields");
return(PartialView(customview("_StudentInformation", "Student"), objModelStudent));
}
catch
{
return(View());
}
}
//
// GET: /StudentReport/
//Test Report PDF Download
public ActionResult PrintStudentList()
{
objBLLStudent = new BLLStudent();
lstModelStudent = new List <ModelStudent>();
string SearchCriteria = "Students.ClassId = 1 AND Students.SectionId = 1";
lstModelStudent = objBLLStudent.GetStudentList(SearchCriteria, Convert.ToInt32(Session[DALVariables.SchoolAccountId].ToString()));
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports/ReportStudentsInfo.rpt")));
rd.SetDataSource(lstModelStudent);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream objStream = rd.ExportToStream(
CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
objStream.Seek(0, SeekOrigin.Begin);
return(File(objStream, "application/pdf", "StudentList-" + DateTime.Now.ToString() + ".pdf"));
}
public ActionResult Search1(string ComputerCode, string RegNo, string StudentName, string FatherName, string StudentStatus, string dropDownClass, string dropDownSection)
{
StringBuilder strSearchCriteria = new StringBuilder();
string searchCriteria = "";
//If Computer Code Is Not Empty
if ((!string.IsNullOrEmpty(RegNo.Trim())))
{
strSearchCriteria.Append(" Students.RegNo =" + RegNo.Trim() + " AND ");
}
//If Computer Code Is Not Empty
if ((!string.IsNullOrEmpty(ComputerCode.Trim())))
{
strSearchCriteria.Append(" Students.ComputerCode =" + ComputerCode.Trim() + " AND ");
}
//If Student Name Is Not Empty
if ((!string.IsNullOrEmpty(StudentName.Trim())))
{
strSearchCriteria.Append(" (Students.StudentName LIKE '%" + StudentName.Trim() + "%') AND ");
}
//If Father Name Is Not Empty
if ((!string.IsNullOrEmpty(FatherName.Trim())))
{
strSearchCriteria.Append(" (Students.FatherName LIKE '%" + FatherName.Trim() + "%') AND ");
}
//If Student Statuse Is Not Empty
if ((!string.IsNullOrEmpty(StudentStatus.Trim())))
{
int _studentStaus = Convert.ToInt32(StudentStatus.Trim());
if (_studentStaus > 0)
{
strSearchCriteria.Append(" Students.Status = " + _studentStaus + " AND ");
}
}
//If Selected Class Is Not Empty
if ((!string.IsNullOrEmpty(dropDownClass.Trim())))
{
int _selectedClass = Convert.ToInt32(dropDownClass.Trim());
if (_selectedClass > 0)
{
strSearchCriteria.Append(" Students.ClassId = " + _selectedClass + " AND ");
}
}
//If Class Section Is Not Empty
if ((!string.IsNullOrEmpty(dropDownSection.Trim())))
{
int _selectedSection = Convert.ToInt32(dropDownSection.Trim());
if (_selectedSection > 0)
{
strSearchCriteria.Append(" Students.SectionId = " + _selectedSection + " AND ");
}
}
//strSearchCriteria.Append(" ServiceTypeCategoryId = " + CategoryId + " AND ");
//If Filter Expression Is Not Null Or Empty
if ((!string.IsNullOrEmpty(strSearchCriteria.ToString())))
{
//Set Filter Expression
searchCriteria = strSearchCriteria.ToString().Remove(strSearchCriteria.ToString().Length - 4, 4);
//User Log
DALUtility.InsertUserLog("Search Manage Short Code. Search Criteria - " + searchCriteria, "Student/Search", Convert.ToInt32(Session[DALVariables.UserAccountId].ToString()));
}
else
{
//User Log
DALUtility.InsertUserLog("Search Manage Short Code. Search Criteria - Nothing", "Student/Search", Convert.ToInt32(Session[DALVariables.UserAccountId].ToString()));
}
try
{
List <ModelStudent> lstModelStudent = new List <ModelStudent>();
BLLStudent objBLLStudent = new BLLStudent();
lstModelStudent = objBLLStudent.GetStudentList(searchCriteria, Convert.ToInt32(Session[DALVariables.SchoolAccountId].ToString()));
return(PartialView(customview("_SearchResultsPartial", "Student"), lstModelStudent));
}
catch (Exception ex)
{
DALUtility.ErrorLog(ex.Message, "StudentController, Search1");
}
return(PartialView("Error"));
}
}//assigning values to Control
private void insertStudent()
{
try
{
if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtEmail.Text) && !string.IsNullOrEmpty(txtcntnum.Text) && !string.IsNullOrEmpty(txtAge.Text) && !string.IsNullOrEmpty(txtaddress.Text))
{
EntityStudent es = new EntityStudent();
es.Name = txtName.Text;
es.Address = txtaddress.Text;
es.Age = Convert.ToInt16(txtAge.Text);
es.DOB1 = DateTime.Parse(clddate.Text);
es.Emailid = txtEmail.Text;
es.Contactnumb = Convert.ToDouble(txtcntnum.Text);
if (rdMale.Checked == true)
{
es.Gender = false;
}
else
{
es.Gender = true;
}
if (btnsave.Text.Equals("Save"))
{
es.Task = 1;
bool b = BLLStudent.insertStudent(es);
clearControls();
if (b == true)
{
Response.Redirect("StudentView.aspx?stud={0}");
clearControls();
}
else
{
btnclose.Visible = true;
ltrlerror.Text = "Error while insertion";
}
}
if (btnsave.Text.Equals("Update"))
{
es.Task = 2;
es.Id = int.Parse(ViewState["Id"].ToString());
bool b = BLLStudent.updateStudent(es);
if (b == true)
{
Response.Redirect("StudentView.aspx?stud1={1}");
clearControls();
}
else
{
btnclose.Visible = true;
ltrlerror.Text = "Error while Updation";
}
}
}
}
catch (Exception ex)
{
ltrlerror.Text = "Error";
btnclose.Visible = true;
}
}//insertion and updation
