public static USER_Roles GetUSER_RolesByRoleID(int RoleID) { USER_Roles uSER_Roles = new USER_Roles(); SqlUSER_RolesProvider sqlUSER_RolesProvider = new SqlUSER_RolesProvider(); uSER_Roles = sqlUSER_RolesProvider.GetUSER_RolesByRoleID(RoleID); return uSER_Roles; }
protected void btnUpdate_Click(object sender, EventArgs e) { USER_Roles uSER_Roles = new USER_Roles (); uSER_Roles.RoleID= int.Parse(Request.QueryString["ID"].ToString()); uSER_Roles.AddedBy= txtAddedBy.Text; uSER_Roles.AddedDate= DateTime.Now; uSER_Roles.UpdatedBy= txtUpdatedBy.Text; uSER_Roles.UpdatedDate= DateTime.Now; uSER_Roles.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); bool resutl =USER_RolesManager.UpdateUSER_Roles(uSER_Roles); Response.Redirect("AdminDisplayUSER_Roles.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { USER_Roles uSER_Roles = new USER_Roles (); // uSER_Roles.RoleID= int.Parse(ddlRoleID.SelectedValue); uSER_Roles.AddedBy= txtAddedBy.Text; uSER_Roles.AddedDate= DateTime.Now; uSER_Roles.UpdatedBy= txtUpdatedBy.Text; uSER_Roles.UpdatedDate= DateTime.Now; uSER_Roles.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); int resutl =USER_RolesManager.InsertUSER_Roles(uSER_Roles); Response.Redirect("AdminDisplayUSER_Roles.aspx"); }
public bool UpdateUSER_Roles(USER_Roles uSER_Roles) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateUSER_Roles", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = uSER_Roles.RoleID; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = uSER_Roles.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = uSER_Roles.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = uSER_Roles.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public USER_Roles GetUSER_RolesFromReader(IDataReader reader) { try { USER_Roles uSER_Roles = new USER_Roles ( DataAccessObject.IsNULL<int>(reader["RoleID"]), DataAccessObject.IsNULL<string>(reader["AddedBy"]), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"]), DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]) ); return uSER_Roles; } catch(Exception ex) { return null; } }
private void showUSER_RolesData() { USER_Roles uSER_Roles = new USER_Roles (); uSER_Roles = USER_RolesManager.GetUSER_RolesByRoleID(Int32.Parse(Request.QueryString["ID"])); ddlRowStatusID.SelectedValue =uSER_Roles.RowStatusID.ToString(); }
public static bool UpdateUSER_Roles(USER_Roles uSER_Roles) { SqlUSER_RolesProvider sqlUSER_RolesProvider = new SqlUSER_RolesProvider(); return sqlUSER_RolesProvider.UpdateUSER_Roles(uSER_Roles); }
public static int InsertUSER_Roles(USER_Roles uSER_Roles) { SqlUSER_RolesProvider sqlUSER_RolesProvider = new SqlUSER_RolesProvider(); return sqlUSER_RolesProvider.InsertUSER_Roles(uSER_Roles); }