protected void btnUpdate_Click(object sender, EventArgs e) { COMN_Nationality cOMN_Nationality = new COMN_Nationality (); cOMN_Nationality.NationalityID= int.Parse(Request.QueryString["ID"].ToString()); cOMN_Nationality.NationalityName= txtNationalityName.Text; cOMN_Nationality.AddedBy= Profile.card_id; cOMN_Nationality.AddedDate= DateTime.Now; cOMN_Nationality.ModifiedBy= Profile.card_id; cOMN_Nationality.ModifiedDate= DateTime.Now; bool resutl =COMN_NationalityManager.UpdateCOMN_Nationality(cOMN_Nationality); Response.Redirect("AdminDisplayCOMN_Nationality.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { COMN_Nationality cOMN_Nationality = new COMN_Nationality (); // cOMN_Nationality.NationalityID= int.Parse(ddlNationalityID.SelectedValue); cOMN_Nationality.NationalityName= txtNationalityName.Text; cOMN_Nationality.AddedBy= Profile.card_id; cOMN_Nationality.AddedDate= DateTime.Now; cOMN_Nationality.ModifiedBy= Profile.card_id; cOMN_Nationality.ModifiedDate= DateTime.Now; int resutl =COMN_NationalityManager.InsertCOMN_Nationality(cOMN_Nationality); Response.Redirect("AdminDisplayCOMN_Nationality.aspx"); }
private void showCOMN_NationalityData() { COMN_Nationality cOMN_Nationality = new COMN_Nationality (); cOMN_Nationality = COMN_NationalityManager.GetCOMN_NationalityByNationalityID(Int32.Parse(Request.QueryString["ID"])); txtNationalityName.Text =cOMN_Nationality.NationalityName.ToString(); }
public COMN_Nationality GetCOMN_NationalityFromReader(IDataReader reader) { try { COMN_Nationality cOMN_Nationality = new COMN_Nationality ( DataAccessObject.IsNULL<int>(reader["NationalityID"]), DataAccessObject.IsNULL<string>(reader["NationalityName"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return cOMN_Nationality; } catch(Exception ex) { return null; } }
public bool UpdateCOMN_Nationality(COMN_Nationality cOMN_Nationality) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateCOMN_Nationality", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@NationalityID", SqlDbType.Int).Value = cOMN_Nationality.NationalityID; cmd.Parameters.Add("@NationalityName", SqlDbType.NVarChar).Value = cOMN_Nationality.NationalityName; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_Nationality.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_Nationality.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertCOMN_Nationality(COMN_Nationality cOMN_Nationality) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertCOMN_Nationality", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@NationalityID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@NationalityName", SqlDbType.NVarChar).Value = cOMN_Nationality.NationalityName; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = cOMN_Nationality.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = cOMN_Nationality.AddedDate; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_Nationality.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_Nationality.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@NationalityID"].Value; } }