protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_Subject sTD_Subject = new STD_Subject();
sTD_Subject.SubjectID = int.Parse(Request.QueryString["ID"].ToString());
sTD_Subject.CourseID = int.Parse(ddlCourseID.SelectedValue);
sTD_Subject.SubjectName = txtSubjectName.Text;
sTD_Subject.Description = txtDescription.Text;
sTD_Subject.ExtraField1 = txtPassMark.Text;
sTD_Subject.ExtraField2 = "";
sTD_Subject.ExtraField3 = "";
sTD_Subject.ExtraField4 = "";
sTD_Subject.ExtraField5 = "";
sTD_Subject.AddedBy = Profile.card_id;
sTD_Subject.AddedDate = DateTime.Now;
sTD_Subject.UpdatedBy = Profile.card_id;
sTD_Subject.UpdateDate = DateTime.Now;
bool resutl = STD_SubjectManager.UpdateSTD_Subject(sTD_Subject);
}
catch (Exception ex)
{
}
Response.Redirect("AdminDisplaySTD_Subject.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_Subject sTD_Subject = new STD_Subject ();
// sTD_Subject.SubjectID= int.Parse(ddlSubjectID.SelectedValue);
sTD_Subject.CourseID= int.Parse(ddlCourseID.SelectedValue);
sTD_Subject.SubjectName= txtSubjectName.Text;
sTD_Subject.Description= txtDescription.Text;
sTD_Subject.AddedBy= Profile.card_id;
sTD_Subject.AddedDate= DateTime.Now;
sTD_Subject.UpdatedBy= Profile.card_id;
sTD_Subject.UpdateDate = DateTime.Now;
int resutl =STD_SubjectManager.InsertSTD_Subject(sTD_Subject);
}catch(Exception ex){}
loadGrid();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_Subject sTD_Subject = new STD_Subject ();
sTD_Subject.SubjectID= int.Parse(Request.QueryString["ID"].ToString());
sTD_Subject.CourseID= int.Parse(ddlCourseID.SelectedValue);
sTD_Subject.SubjectName= txtSubjectName.Text;
sTD_Subject.Description= txtDescription.Text;
sTD_Subject.AddedBy= Profile.card_id;
sTD_Subject.AddedDate= DateTime.Now;
sTD_Subject.UpdatedBy= Profile.card_id;
sTD_Subject.UpdateDate = DateTime.Now;
bool resutl =STD_SubjectManager.UpdateSTD_Subject(sTD_Subject);
}catch(Exception ex){}
loadGrid();
}
private void showSTD_SubjectData()
{
STD_Subject sTD_Subject = new STD_Subject ();
sTD_Subject = STD_SubjectManager.GetSTD_SubjectBySubjectID(Int32.Parse(Request.QueryString["ID"]));
ddlCourseID.SelectedValue =sTD_Subject.CourseID.ToString();
txtSubjectName.Text =sTD_Subject.SubjectName.ToString();
txtDescription.Text =sTD_Subject.Description.ToString();
}
public bool UpdateSTD_Subject(STD_Subject sTD_Subject)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Subject", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SubjectID", SqlDbType.Int).Value = sTD_Subject.SubjectID;
cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Subject.CourseID;
cmd.Parameters.Add("@SubjectName", SqlDbType.NVarChar).Value = sTD_Subject.SubjectName;
cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Subject.Description;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_Subject.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_Subject.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Subject.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Subject.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertSTD_Subject(STD_Subject sTD_Subject)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertSTD_Subject", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SubjectID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Subject.CourseID;
cmd.Parameters.Add("@SubjectName", SqlDbType.NVarChar).Value = sTD_Subject.SubjectName;
cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Subject.Description;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_Subject.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_Subject.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_Subject.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Subject.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Subject.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
int subjectID = (int)cmd.Parameters["@SubjectID"].Value;
using (SqlConnection connection2 = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd1 = new SqlCommand("InsertQuiz_Chapter", connection);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@ChapterID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd1.Parameters.Add("@SubjectID", SqlDbType.Int).Value = subjectID;
cmd1.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Subject.CourseID;
cmd1.Parameters.Add("@ChapterName", SqlDbType.NVarChar).Value = "All Chapter";
cmd1.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_Subject.AddedBy;
cmd1.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_Subject.AddedDate;
cmd1.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = sTD_Subject.UpdatedBy;
cmd1.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = sTD_Subject.UpdateDate;
connection2.Open();
result = cmd1.ExecuteNonQuery();
}
return subjectID;
}
}
public STD_Subject GetSTD_SubjectFromReader(IDataReader reader)
{
try
{
STD_Subject sTD_Subject = new STD_Subject
(
DataAccessObject.IsNULL<int>(reader["SubjectID"]),
DataAccessObject.IsNULL<int>(reader["CourseID"]),
DataAccessObject.IsNULL<string>(reader["SubjectName"]),
DataAccessObject.IsNULL<string>(reader["Description"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"])
);
return sTD_Subject;
}
catch (Exception ex)
{
return null;
}
}
public static bool UpdateSTD_Subject(STD_Subject sTD_Subject)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.UpdateSTD_Subject(sTD_Subject);
}
public static int InsertSTD_Subject(STD_Subject sTD_Subject)
{
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
return sqlSTD_SubjectProvider.InsertSTD_Subject(sTD_Subject);
}
public static STD_Subject GetSTD_SubjectFromSubjectEmployeeBySubjectID(int SubjectID)
{
STD_Subject sTD_Subject = new STD_Subject();
SqlSTD_SubjectProvider sqlSTD_SubjectProvider = new SqlSTD_SubjectProvider();
sTD_Subject = sqlSTD_SubjectProvider.GetSTD_SubjectFromSubjectEmployeeBySubjectID(SubjectID);
return sTD_Subject;
}
