public static COMN_Religion GetCOMN_ReligionByReligionID(int ReligionID) { COMN_Religion cOMN_Religion = new COMN_Religion(); SqlCOMN_ReligionProvider sqlCOMN_ReligionProvider = new SqlCOMN_ReligionProvider(); cOMN_Religion = sqlCOMN_ReligionProvider.GetCOMN_ReligionByReligionID(ReligionID); return cOMN_Religion; }
protected void btnUpdate_Click(object sender, EventArgs e) { COMN_Religion cOMN_Religion = new COMN_Religion (); cOMN_Religion.ReligionID= int.Parse(Request.QueryString["ID"].ToString()); cOMN_Religion.ReligionName= txtReligionName.Text; cOMN_Religion.AddedBy= Profile.card_id; cOMN_Religion.AddedDate= DateTime.Now; cOMN_Religion.ModifiedBy= Profile.card_id; cOMN_Religion.ModifiedDate= DateTime.Now; bool resutl =COMN_ReligionManager.UpdateCOMN_Religion(cOMN_Religion); Response.Redirect("AdminDisplayCOMN_Religion.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { COMN_Religion cOMN_Religion = new COMN_Religion (); // cOMN_Religion.ReligionID= int.Parse(ddlReligionID.SelectedValue); cOMN_Religion.ReligionName= txtReligionName.Text; cOMN_Religion.AddedBy= Profile.card_id; cOMN_Religion.AddedDate= DateTime.Now; cOMN_Religion.ModifiedBy= Profile.card_id; cOMN_Religion.ModifiedDate= DateTime.Now; int resutl =COMN_ReligionManager.InsertCOMN_Religion(cOMN_Religion); Response.Redirect("AdminDisplayCOMN_Religion.aspx"); }
private void showCOMN_ReligionData() { COMN_Religion cOMN_Religion = new COMN_Religion (); cOMN_Religion = COMN_ReligionManager.GetCOMN_ReligionByReligionID(Int32.Parse(Request.QueryString["ID"])); txtReligionName.Text =cOMN_Religion.ReligionName.ToString(); }
public COMN_Religion GetCOMN_ReligionFromReader(IDataReader reader) { try { COMN_Religion cOMN_Religion = new COMN_Religion ( DataAccessObject.IsNULL<int>(reader["ReligionID"]), DataAccessObject.IsNULL<string>(reader["ReligionName"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return cOMN_Religion; } catch(Exception ex) { return null; } }
public bool UpdateCOMN_Religion(COMN_Religion cOMN_Religion) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateCOMN_Religion", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ReligionID", SqlDbType.Int).Value = cOMN_Religion.ReligionID; cmd.Parameters.Add("@ReligionName", SqlDbType.NVarChar).Value = cOMN_Religion.ReligionName; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_Religion.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_Religion.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertCOMN_Religion(COMN_Religion cOMN_Religion) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertCOMN_Religion", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ReligionID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@ReligionName", SqlDbType.NVarChar).Value = cOMN_Religion.ReligionName; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = cOMN_Religion.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = cOMN_Religion.AddedDate; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = cOMN_Religion.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = cOMN_Religion.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@ReligionID"].Value; } }
public static bool UpdateCOMN_Religion(COMN_Religion cOMN_Religion) { SqlCOMN_ReligionProvider sqlCOMN_ReligionProvider = new SqlCOMN_ReligionProvider(); return sqlCOMN_ReligionProvider.UpdateCOMN_Religion(cOMN_Religion); }
public static int InsertCOMN_Religion(COMN_Religion cOMN_Religion) { SqlCOMN_ReligionProvider sqlCOMN_ReligionProvider = new SqlCOMN_ReligionProvider(); return sqlCOMN_ReligionProvider.InsertCOMN_Religion(cOMN_Religion); }