protected void btnupload_Click(object sender, EventArgs e) { for (int i = 0; i < dgassignment.Rows.Count - 1; i++) { FileUpload FileUpload1 = ((FileUpload)(dgassignment.Rows[i].Cells[1].FindControl("flu"))); if (FileUpload1.HasFile) { string fileName = FileUpload1.PostedFile.FileName; string extension = System.IO.Path.GetExtension(fileName); if (extension == ".pdf" || extension == ".doc" || extension == ".docx") { BLLAssignment objbll = new BLLAssignment(); objbll.Rollno = user; objbll.Name = lblAdmin_USername.Text; objbll.Course_code = txtcoursecode.Text; objbll.Course_title = txtcoursetitle.Text; objbll.Title = "Assignment"; //objbll.Total_marks = txtlesson.Text; objbll.Assignment_path = ("SolutionAssignment/" + fileName); FileUpload1.PostedFile.SaveAs(Server.MapPath("SolutionAssignment/") + fileName); int a = objbll.InsertAssignmentSolution(objbll); if (a == 1) { ASPxPopupControl1.ShowOnPageLoad = true; } } else { //lblresult.Text = "Choose Pdf or Doc file..."; } } } }
public void InsertAssignment() { if (FileUpload1.HasFile) { string fileName = FileUpload1.PostedFile.FileName; string extension = System.IO.Path.GetExtension(fileName); if (extension == ".pdf" || extension == ".doc" || extension == ".docx") { BLLAssignment objbll = new BLLAssignment(); objbll.Course_code = txtcoursecode.Text; objbll.Course_title = txtcoursetitle.Text; objbll.Title = txttopic.Text; objbll.Lesson = txtlesson.Text; objbll.Assignment_name = fileName; objbll.Assignment_path = ("Assignments/" + fileName); objbll.Total_marks = txttotalmarks.Text; objbll.Due_date = Convert.ToDateTime(dtduedate.Text); objbll.Createdby = user; objbll.Modifiedby = user; FileUpload1.PostedFile.SaveAs(Server.MapPath("Assignments/") + fileName); int a = objbll.InsertAssignment(objbll); if (a == 1) { lblresult.Text = "Assignment upload Successfully"; BtnSave.Enabled = false; BtnNew.Enabled = true; } } else { lblresult.Text = "Choose Pdf or Doc file..."; } } }
public void LoadGrid() { BLLAssignment objbll = new BLLAssignment(); objbll.Course_code = txtcoursecode.Text; objbll.Course_title = txtcoursetitle.Text; List <BLLAssignment> objlist = new List <BLLAssignment>(); objlist = objbll.SelectAssignment(objbll); if (objlist.Count > 0) { dgassignment.DataSource = objlist; dgassignment.DataBind(); for (int i = 0; i <= dgassignment.Rows.Count - 1; i++) { DateTime currentdate = System.DateTime.Now; DateTime duedate = objlist[i].Due_date; int a = DateTime.Compare(currentdate, duedate); if (a == 1) { dgassignment.Rows[i].Cells[1].Enabled = false; } else { dgassignment.Rows[i].Cells[1].Enabled = true; } } } }
public List <BLLAssignment> SelectAssignment(BLLAssignment objbll) { List <BLLAssignment> objlist = new List <BLLAssignment>(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar); param[0].Value = objbll.Course_code; param[1] = new SqlParameter("@course_title", SqlDbType.NVarChar); param[1].Value = objbll.Course_title; SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectByMultimoreprogram("sp_selectassignment", param); while (dr.Read()) { objbll = new BLLAssignment(); objbll.Title = dr["title"].ToString(); objbll.Lesson = dr["lesson"].ToString(); objbll.Assignment_name = dr["assignment_name"].ToString(); objbll.Assignment_path = dr["assignment_path"].ToString(); objbll.Total_marks = dr["total_marks"].ToString(); objbll.Due_date = Convert.ToDateTime(dr["due_date"].ToString()); objbll.Insert_date = Convert.ToDateTime(dr["insert_date"].ToString()); objlist.Add(objbll); } objcon.CloseConnection(); return(objlist); }
public List <BLLAssignment> SelectAssignmentSolution(BLLAssignment objbll) { List <BLLAssignment> objlist = new List <BLLAssignment>(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar); param[0].Value = objbll.Course_code; SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectByMultimoreprogram("sp_selectassignmentsolution", param); while (dr.Read()) { objbll = new BLLAssignment(); objbll.Id = Convert.ToInt32(dr["id"].ToString()); objbll.Rollno = dr["rollno"].ToString(); objbll.Name = dr["name"].ToString(); objbll.Course_code = dr["course_code"].ToString(); objbll.Course_title = dr["course_title"].ToString(); objbll.Title = dr["topic"].ToString(); objbll.Assignment_path = dr["assignment_path"].ToString(); objbll.Insert_date = Convert.ToDateTime(dr["insert_date"].ToString()); objlist.Add(objbll); } objcon.CloseConnection(); return(objlist); }
public void LoadAssignments() { BLLAssignment objbll = new BLLAssignment(); objbll.Course_code = cbcourses.SelectedItem.Value.ToString(); List <BLLAssignment> objlist = new List <BLLAssignment>(); objlist = objbll.SelectAssignmentSolution(objbll); if (objlist.Count > 0) { dgassignment.DataSource = objlist; dgassignment.DataBind(); } }
public int InsertAssignment(BLLAssignment objbll) { SqlParameter[] param = new SqlParameter[13]; param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar); param[0].Value = objbll.Course_code; param[1] = new SqlParameter("@course_title", SqlDbType.NVarChar); param[1].Value = objbll.Course_title; param[2] = new SqlParameter("@title", SqlDbType.NVarChar); param[2].Value = objbll.Title; param[3] = new SqlParameter("@lesson", SqlDbType.NVarChar); param[3].Value = objbll.Lesson; param[4] = new SqlParameter("@assignment_name", SqlDbType.NVarChar); param[4].Value = objbll.Assignment_name; param[5] = new SqlParameter("@assignment_path", SqlDbType.NVarChar); param[5].Value = objbll.Assignment_path; param[6] = new SqlParameter("@total_marks", SqlDbType.NVarChar); param[6].Value = objbll.Total_marks; param[7] = new SqlParameter("@due_date", SqlDbType.DateTime); param[7].Value = objbll.Due_date; param[8] = new SqlParameter("@status", SqlDbType.Bit); param[8].Value = objbll.Status; param[9] = new SqlParameter("@createdby", SqlDbType.NVarChar); param[9].Value = objbll.Createdby; param[10] = new SqlParameter("@modifiedby ", SqlDbType.NVarChar); param[10].Value = objbll.Modifiedby; param[11] = new SqlParameter("@Insert_Date", SqlDbType.DateTime); param[11].Value = objbll.Insert_date; param[12] = new SqlParameter("@Update_Date", SqlDbType.DateTime); param[12].Value = objbll.Update_date; objcon.OpenConnection(); int a = objcon.sqlcmdInsert("sp_insertassignment", param); objcon.CloseConnection(); return(a); }
public void LoadGrid() { BLLAssignment objbll = new BLLAssignment(); objbll.Course_code = txtcoursecode.Text; objbll.Course_title = txtcoursetitle.Text; List <BLLAssignment> objlist = new List <BLLAssignment>(); objlist = objbll.SelectAssignment(objbll); if (objlist.Count > 0) { dgassignment.DataSource = objlist; dgassignment.DataBind(); } }
public void LoadAssignmentName() { BLLAssignment objbll = new BLLAssignment(); objbll.Course_code = cbcourses.SelectedItem.ToString(); List <BLLAssignment> objlist = new List <BLLAssignment>(); objlist = objbll.SelectAssignmentNamebycode(objbll); if (objlist.Count > 0) { cbname.DataSource = objlist; cbname.ValueField = "title"; cbname.TextField = "title"; cbname.DataBind(); } }
public List <BLLAssignment> SelectAssignmentNamebycode(BLLAssignment objbll) { List <BLLAssignment> objlist = new List <BLLAssignment>(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar); param[0].Value = objbll.Course_code; SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectByMultimoreprogram("sp_selectassignmentnamebycode", param); while (dr.Read()) { objbll = new BLLAssignment(); objbll.Title = dr["title"].ToString(); objlist.Add(objbll); } objcon.CloseConnection(); return(objlist); }
public int InsertAssignmentSolution(BLLAssignment objbll) { SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@rollno", SqlDbType.NVarChar); param[0].Value = objbll.Rollno; param[1] = new SqlParameter("@name", SqlDbType.NVarChar); param[1].Value = objbll.Name; param[2] = new SqlParameter("@course_code", SqlDbType.NVarChar); param[2].Value = objbll.Course_code; param[3] = new SqlParameter("@course_title", SqlDbType.NVarChar); param[3].Value = objbll.Course_title; param[4] = new SqlParameter("@topic", SqlDbType.NVarChar); param[4].Value = objbll.Title; param[5] = new SqlParameter("@total_marks", SqlDbType.NVarChar); param[5].Value = objbll.Total_marks; param[6] = new SqlParameter("@assignment_path", SqlDbType.NVarChar); param[6].Value = objbll.Assignment_path; param[7] = new SqlParameter("@Insert_Date", SqlDbType.DateTime); param[7].Value = objbll.Insert_date; param[8] = new SqlParameter("@status", SqlDbType.Bit); param[8].Value = "False"; objcon.OpenConnection(); int a = objcon.sqlcmdInsert("sp_insertassignmentsolution", param); objcon.CloseConnection(); return(a); }
public List <BLLAssignment> SelectAssignmentSolution(BLLAssignment objbll) { DALAssignment objdal = new DALAssignment(); return(objdal.SelectAssignmentSolution(objbll)); }
public List <BLLAssignment> SelectAssignmentNamebycode(BLLAssignment objbll) { DALAssignment objdal = new DALAssignment(); return(objdal.SelectAssignmentNamebycode(objbll)); }
public int InsertAssignmentSolution(BLLAssignment objbll) { DALAssignment objdal = new DALAssignment(); return(objdal.InsertAssignmentSolution(objbll)); }