public bool Homework_Edit(Homework homework) { int result = 0; try { SqlCommand cmd = new SqlCommand("Homework_Update", constr); cmd.Parameters.AddWithValue("@HomeworkId", homework.HomeworkId); cmd.Parameters.AddWithValue("@HomeworkName", homework.HomeworkName); cmd.Parameters.AddWithValue("@Path", homework.Path); cmd.Parameters.AddWithValue("@Type", homework.Type); cmd.Parameters.AddWithValue("@StudentId", homework.StudentId); cmd.Parameters.AddWithValue("@FacultyId", homework.FacultyId); cmd.CommandType = CommandType.StoredProcedure; constr.Open(); result = cmd.ExecuteNonQuery(); constr.Close(); } catch (Exception ex) { Exceptions exception = new Exceptions { ExceptionNumber = ex.HResult.ToString(), ExceptionMessage = ex.Message, ExceptionMethod = "Homework_Update", ExceptionUrl = "" }; int r = exceptionrepo.Exception_Create(exception); if (r == 0) { exceptionrepo.Exception_InsertInLogFile(exception); } if (constr.State != ConnectionState.Open) { constr.Close(); constr.Open(); } } if (result >= 1) { return(true); } return(false); }
public int Homework_Create(Homework homework) { try { SqlCommand cmd = new SqlCommand("Homework_Insert", constr); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HomeworkName", homework.HomeworkName); cmd.Parameters.AddWithValue("@Path", homework.Path); cmd.Parameters.AddWithValue("@Type", homework.Type); cmd.Parameters.AddWithValue("@StudentId", homework.StudentId); cmd.Parameters.AddWithValue("@FacultyId", homework.FacultyId); cmd.Parameters.Add("@HomeworkId", SqlDbType.Int); cmd.Parameters["@HomeworkId"].Direction = ParameterDirection.Output; constr.Open(); cmd.ExecuteNonQuery(); homework.HomeworkId = Convert.ToInt32(cmd.Parameters["@HomeworkId"].Value); constr.Close(); } catch (Exception ex) { Exceptions exception = new Exceptions { ExceptionNumber = ex.HResult.ToString(), ExceptionMessage = ex.Message, ExceptionMethod = "Homework_Insert", ExceptionUrl = "" }; int r = exceptionrepo.Exception_Create(exception); if (r == 0) { exceptionrepo.Exception_InsertInLogFile(exception); } if (constr.State != ConnectionState.Open) { constr.Close(); constr.Open(); } } return(homework.HomeworkId); }
public Homework Homework_ReadById(int id) { Homework homework = new Homework(); try { SqlCommand cmd = new SqlCommand("Homework_ReadById", constr); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HomeworkId", id); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); constr.Open(); da.Fill(dt); constr.Close(); foreach (DataRow dr in dt.Rows) { //if(dr["deletedOn"] != null) //{ // assignment.AssignmentId = id; // assignment.AssignmentName = Convert.ToString(dr["AssignmentName"]); // assignment.Path = Convert.ToString(dr["Path"]); // assignment.Type = Convert.ToString(dr["Type"]); // assignment.FacultyId = Convert.ToInt32(dr["FacultyId"]); // assignment.createdOn = Convert.ToDateTime(dr["createdOn"]); // assignment.modifiedOn = Convert.ToDateTime(dr["modifiedOn"]); // assignment.deletedOn = Convert.ToDateTime(dr["deletedOn"]); // assignment.isDeleted = Convert.ToBoolean(dr["isDeleted"]); //} //else //{ homework.HomeworkId = id; homework.HomeworkName = Convert.ToString(dr["HomeworkName"]); homework.Path = Convert.ToString(dr["Path"]); homework.Type = Convert.ToString(dr["Type"]); homework.StudentId = Convert.ToInt32(dr["StudentId"]); homework.FacultyId = Convert.ToInt32(dr["FacultyId"]); homework.createdOn = Convert.ToDateTime(dr["createdOn"]); homework.modifiedOn = Convert.ToDateTime(dr["modifiedOn"]); homework.isDeleted = Convert.ToBoolean(dr["isDeleted"]); //} } } catch (Exception ex) { Exceptions exception = new Exceptions { ExceptionNumber = ex.HResult.ToString(), ExceptionMessage = ex.Message, ExceptionMethod = "Homework_ReadById", ExceptionUrl = "" }; int r = exceptionrepo.Exception_Create(exception); if (r == 0) { exceptionrepo.Exception_InsertInLogFile(exception); } if (constr.State != ConnectionState.Open) { constr.Close(); constr.Open(); } } return(homework); }