public static STD_Program GetSTD_ProgramByProgramID(int ProgramID) { STD_Program sTD_Program = new STD_Program(); SqlSTD_ProgramProvider sqlSTD_ProgramProvider = new SqlSTD_ProgramProvider(); sTD_Program = sqlSTD_ProgramProvider.GetSTD_ProgramByProgramID(ProgramID); return sTD_Program; }
public static STD_Program GetSTD_CourseByCourseID(int CourseID) { STD_Program sTD_Program = new STD_Program(); SqlSTD_ProgramProvider sqlSTD_ProgramProvider = new SqlSTD_ProgramProvider(); sTD_Program = sqlSTD_ProgramProvider.GetSTD_ProgramByCourseID(CourseID); return sTD_Program; }
protected void btnUpdate_Click(object sender, EventArgs e) { STD_Program sTD_Program = new STD_Program (); sTD_Program.ProgramID= int.Parse(Request.QueryString["ID"].ToString()); sTD_Program.ProgramName= txtProgramName.Text; sTD_Program.CourseID= int.Parse(ddlCourseID.SelectedValue); sTD_Program.Description= txtDescription.Text; sTD_Program.Duration= decimal.Parse(txtDuration.Text); sTD_Program.Cost= decimal.Parse(txtCost.Text); sTD_Program.AddedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_Program.AddedDate= DateTime.Now; sTD_Program.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; sTD_Program.UpdateDate= DateTime.Now; bool resutl =STD_ProgramManager.UpdateSTD_Program(sTD_Program); Response.Redirect("AdminDisplaySTD_Program.aspx"); }
public static bool UpdateSTD_Program(STD_Program sTD_Program) { SqlSTD_ProgramProvider sqlSTD_ProgramProvider = new SqlSTD_ProgramProvider(); return sqlSTD_ProgramProvider.UpdateSTD_Program(sTD_Program); }
public static int InsertSTD_Program(STD_Program sTD_Program) { SqlSTD_ProgramProvider sqlSTD_ProgramProvider = new SqlSTD_ProgramProvider(); return sqlSTD_ProgramProvider.InsertSTD_Program(sTD_Program); }
private void showSTD_ProgramData() { STD_Program sTD_Program = new STD_Program (); sTD_Program = STD_ProgramManager.GetSTD_ProgramByProgramID(Int32.Parse(Request.QueryString["ID"])); txtProgramName.Text =sTD_Program.ProgramName.ToString(); ddlCourseID.SelectedValue =sTD_Program.CourseID.ToString(); txtDescription.Text =sTD_Program.Description.ToString(); txtDuration.Text =sTD_Program.Duration.ToString(); txtCost.Text =sTD_Program.Cost.ToString(); }
public bool UpdateSTD_Program(STD_Program sTD_Program) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_Program", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ProgramID", SqlDbType.Int).Value = sTD_Program.ProgramID; cmd.Parameters.Add("@ProgramName", SqlDbType.NVarChar).Value = sTD_Program.ProgramName; cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Program.CourseID; cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Program.Description; cmd.Parameters.Add("@Duration", SqlDbType.Decimal).Value = sTD_Program.Duration; cmd.Parameters.Add("@Cost", SqlDbType.Decimal).Value = sTD_Program.Cost; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Program.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Program.UpdateDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_Program GetSTD_ProgramFromReader(IDataReader reader) { try { STD_Program sTD_Program = new STD_Program ( DataAccessObject.IsNULL<int>(reader["ProgramID"]), DataAccessObject.IsNULL<string>(reader["ProgramName"]), DataAccessObject.IsNULL<int>(reader["CourseID"]), DataAccessObject.IsNULL<string>(reader["Description"]), DataAccessObject.IsNULL<decimal>(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_Program; } catch(Exception ex) { return null; } }