public static COMN_Campus GetCOMN_CityByCityID(int CityID) { COMN_Campus cOMN_Campus = new COMN_Campus(); SqlCOMN_CampusProvider sqlCOMN_CampusProvider = new SqlCOMN_CampusProvider(); cOMN_Campus = sqlCOMN_CampusProvider.GetCOMN_CampusByCityID(CityID); return cOMN_Campus; }
private void showCOMN_CampusData() { COMN_Campus cOMN_Campus = new COMN_Campus (); cOMN_Campus = COMN_CampusManager.GetCOMN_CampusByCampusID(Int32.Parse(Request.QueryString["ID"])); txtCampusName.Text =cOMN_Campus.CampusName.ToString(); txtAddress.Text =cOMN_Campus.Address.ToString(); txtDescription.Text =cOMN_Campus.Description.ToString(); ddlCityID.SelectedValue =cOMN_Campus.CityID.ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { COMN_Campus cOMN_Campus = new COMN_Campus (); cOMN_Campus.CampusID= int.Parse(Request.QueryString["ID"].ToString()); cOMN_Campus.CampusName= txtCampusName.Text; cOMN_Campus.Address= txtAddress.Text; cOMN_Campus.Description= txtDescription.Text; cOMN_Campus.CityID= int.Parse(ddlCityID.SelectedValue); cOMN_Campus.AddedBy= Profile.card_id; cOMN_Campus.AddedDate= DateTime.Now; cOMN_Campus.UpdatedBy= Profile.card_id; cOMN_Campus.UpdateDate = DateTime.Now; bool resutl =COMN_CampusManager.UpdateCOMN_Campus(cOMN_Campus); Response.Redirect("AdminDisplayCOMN_Campus.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { COMN_Campus cOMN_Campus = new COMN_Campus (); // cOMN_Campus.CampusID= int.Parse(ddlCampusID.SelectedValue); cOMN_Campus.CampusName= txtCampusName.Text; cOMN_Campus.Address= txtAddress.Text; cOMN_Campus.Description= txtDescription.Text; cOMN_Campus.CityID= int.Parse(ddlCityID.SelectedValue); cOMN_Campus.AddedBy= Profile.card_id; cOMN_Campus.AddedDate= DateTime.Now; cOMN_Campus.UpdatedBy= Profile.card_id; cOMN_Campus.UpdateDate = DateTime.Now; int resutl =COMN_CampusManager.InsertCOMN_Campus(cOMN_Campus); Response.Redirect("AdminDisplayCOMN_Campus.aspx"); }
public bool UpdateCOMN_Campus(COMN_Campus cOMN_Campus) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateCOMN_Campus", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = cOMN_Campus.CampusID; cmd.Parameters.Add("@CampusName", SqlDbType.NVarChar).Value = cOMN_Campus.CampusName; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = cOMN_Campus.Address; cmd.Parameters.Add("@Description", SqlDbType.NText).Value = cOMN_Campus.Description; cmd.Parameters.Add("@CityID", SqlDbType.Int).Value = cOMN_Campus.CityID; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = cOMN_Campus.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = cOMN_Campus.UpdateDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public COMN_Campus GetCOMN_CampusFromReader(IDataReader reader) { try { COMN_Campus cOMN_Campus = new COMN_Campus ( DataAccessObject.IsNULL<int>(reader["CampusID"]), DataAccessObject.IsNULL<string>(reader["CampusName"]), DataAccessObject.IsNULL<string>(reader["Address"]), DataAccessObject.IsNULL<string>(reader["Description"]), DataAccessObject.IsNULL<int>(reader["CityID"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]) ); return cOMN_Campus; } catch(Exception ex) { return null; } }
public static int InsertCOMN_Campus(COMN_Campus cOMN_Campus) { SqlCOMN_CampusProvider sqlCOMN_CampusProvider = new SqlCOMN_CampusProvider(); return sqlCOMN_CampusProvider.InsertCOMN_Campus(cOMN_Campus); }
public static bool UpdateCOMN_Campus(COMN_Campus cOMN_Campus) { SqlCOMN_CampusProvider sqlCOMN_CampusProvider = new SqlCOMN_CampusProvider(); return sqlCOMN_CampusProvider.UpdateCOMN_Campus(cOMN_Campus); }