public static STD_Campus GetSTD_CityByCityID(int CityID) { STD_Campus sTD_Campus = new STD_Campus(); SqlSTD_CampusProvider sqlSTD_CampusProvider = new SqlSTD_CampusProvider(); sTD_Campus = sqlSTD_CampusProvider.GetSTD_CampusByCityID(CityID); return sTD_Campus; }
protected void btnUpdate_Click(object sender, EventArgs e) { try { STD_Campus sTD_Campus = new STD_Campus (); sTD_Campus.CampusID= int.Parse(Request.QueryString["ID"].ToString()); sTD_Campus.CampusName= txtCampusName.Text; sTD_Campus.Address= txtAddress.Text; sTD_Campus.Description= txtDescription.Text; sTD_Campus.CityID= int.Parse(ddlCityID.SelectedValue); sTD_Campus.AddedBy= Profile.card_id; sTD_Campus.AddedDate= DateTime.Now; sTD_Campus.UpdatedBy= Profile.card_id; sTD_Campus.UpdateDate = DateTime.Now; bool resutl =STD_CampusManager.UpdateSTD_Campus(sTD_Campus); }catch(Exception ex){}Response.Redirect("AdminDisplaySTD_Campus.aspx"); }
public bool UpdateSTD_Campus(STD_Campus sTD_Campus) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_Campus", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = sTD_Campus.CampusID; cmd.Parameters.Add("@CampusName", SqlDbType.NVarChar).Value = sTD_Campus.CampusName; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = sTD_Campus.Address; cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Campus.Description; cmd.Parameters.Add("@CityID", SqlDbType.Int).Value = sTD_Campus.CityID; //cmd.Parameters.Add("@CityID", SqlDbType.Int).Value = sTD_Campus.CityID; //cmd.Parameters.Add("@CityID", SqlDbType.Int).Value = sTD_Campus.CityID; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Campus.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Campus.UpdateDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_Campus GetSTD_CampusFromReader(IDataReader reader) { try { STD_Campus sTD_Campus = new STD_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 sTD_Campus; } catch(Exception ex) { return null; } }
public static int InsertSTD_Campus(STD_Campus sTD_Campus) { SqlSTD_CampusProvider sqlSTD_CampusProvider = new SqlSTD_CampusProvider(); return sqlSTD_CampusProvider.InsertSTD_Campus(sTD_Campus); }
public static bool UpdateSTD_Campus(STD_Campus sTD_Campus) { SqlSTD_CampusProvider sqlSTD_CampusProvider = new SqlSTD_CampusProvider(); return sqlSTD_CampusProvider.UpdateSTD_Campus(sTD_Campus); }
private void showSTD_CampusData() { STD_Campus sTD_Campus = new STD_Campus (); sTD_Campus = STD_CampusManager.GetSTD_CampusByCampusID(Int32.Parse(Request.QueryString["ID"])); txtCampusName.Text =sTD_Campus.CampusName.ToString(); txtAddress.Text =sTD_Campus.Address.ToString(); txtDescription.Text =sTD_Campus.Description.ToString(); ddlCityID.SelectedValue =sTD_Campus.CityID.ToString(); }