public static STD_Course GetSTD_CourseByCourseID(int CourseID)
{
STD_Course sTD_Course = new STD_Course();
SqlSTD_CourseProvider sqlSTD_CourseProvider = new SqlSTD_CourseProvider();
sTD_Course = sqlSTD_CourseProvider.GetSTD_CourseByCourseID(CourseID);
return sTD_Course;
}
private void showSTD_CourseData()
{
STD_Course sTD_Course = new STD_Course ();
sTD_Course = STD_CourseManager.GetSTD_CourseByCourseID(Int32.Parse(Request.QueryString["ID"]));
txtCourseName.Text =sTD_Course.CourseName.ToString();
txtDescription.Text =sTD_Course.Description.ToString();
txtDuration.Text =sTD_Course.Duration.ToString();
txtCost.Text =sTD_Course.Cost.ToString();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_Course sTD_Course = new STD_Course();
sTD_Course.CourseID = int.Parse(Request.QueryString["ID"].ToString());
sTD_Course.CourseName = txtCourseName.Text;
sTD_Course.Description = txtDescription.Text;
sTD_Course.Duration = txtDuration.Text;
sTD_Course.Cost = decimal.Parse(txtCost.Text);
sTD_Course.AddedBy = Profile.card_id;
sTD_Course.AddedDate = DateTime.Now;
sTD_Course.UpdatedBy = Profile.card_id;
sTD_Course.UpdateDate = DateTime.Now;
bool resutl = STD_CourseManager.UpdateSTD_Course(sTD_Course);
}
catch (Exception ex) { } Response.Redirect("AdminDisplaySTD_Course.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_Course sTD_Course = new STD_Course();
// sTD_Course.CourseID= int.Parse(ddlCourseID.SelectedValue);
sTD_Course.CourseName = txtCourseName.Text;
sTD_Course.Description = txtDescription.Text;
sTD_Course.Duration = txtDuration.Text;
sTD_Course.Cost = decimal.Parse(txtCost.Text);
sTD_Course.AddedBy = Profile.card_id;
sTD_Course.AddedDate = DateTime.Now;
sTD_Course.UpdatedBy = Profile.card_id;
sTD_Course.UpdateDate = DateTime.Now;
int resutl = STD_CourseManager.InsertSTD_Course(sTD_Course);
}
catch (Exception ex) { } Response.Redirect("AdminDisplaySTD_Course.aspx");
}
public static bool UpdateSTD_Course(STD_Course sTD_Course)
{
SqlSTD_CourseProvider sqlSTD_CourseProvider = new SqlSTD_CourseProvider();
return sqlSTD_CourseProvider.UpdateSTD_Course(sTD_Course);
}
public static int InsertSTD_Course(STD_Course sTD_Course)
{
SqlSTD_CourseProvider sqlSTD_CourseProvider = new SqlSTD_CourseProvider();
return sqlSTD_CourseProvider.InsertSTD_Course(sTD_Course);
}
public bool UpdateSTD_Course(STD_Course sTD_Course)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Course", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Course.CourseID;
cmd.Parameters.Add("@CourseName", SqlDbType.NVarChar).Value = sTD_Course.CourseName;
cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Course.Description;
cmd.Parameters.Add("@Duration", SqlDbType.NVarChar).Value = sTD_Course.Duration;
cmd.Parameters.Add("@Cost", SqlDbType.Decimal).Value = sTD_Course.Cost;
//cmd.Parameters.Add("@Cost", SqlDbType.Decimal).Value = sTD_Course.Cost;
//cmd.Parameters.Add("@Cost", SqlDbType.Decimal).Value = sTD_Course.Cost;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Course.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Course.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_Course GetSTD_CourseFromReader(IDataReader reader)
{
try
{
STD_Course sTD_Course = new STD_Course
(
DataAccessObject.IsNULL<int>(reader["CourseID"]),
DataAccessObject.IsNULL<string>(reader["CourseName"]),
DataAccessObject.IsNULL<string>(reader["Description"]),
DataAccessObject.IsNULL<string>(reader["Duration"]),
DataAccessObject.IsNULL<decimal>(reader["Cost"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"])
);
return sTD_Course;
}
catch (Exception ex)
{
return null;
}
}