public static HR_Rank GetHR_RankByRankID(int RankID) { HR_Rank hR_Rank = new HR_Rank(); SqlHR_RankProvider sqlHR_RankProvider = new SqlHR_RankProvider(); hR_Rank = sqlHR_RankProvider.GetHR_RankByRankID(RankID); return hR_Rank; }
private void showHR_RankData() { HR_Rank hR_Rank = new HR_Rank(); hR_Rank = HR_RankManager.GetHR_RankByRankID(Int32.Parse(Request.QueryString["ID"])); txtRankName.Text = hR_Rank.RankName.ToString(); txtSeniorityLevel.Text = hR_Rank.SeniorityLevel.ToString(); }
protected void btnAdd_Click(object sender, EventArgs e) { HR_Rank hR_Rank = new HR_Rank(); hR_Rank.RankName = txtRankName.Text; hR_Rank.SeniorityLevel = int.Parse(txtSeniorityLevel.Text); string userID = Profile.card_id; hR_Rank.AddedBy = userID; hR_Rank.AddedDate = DateTime.Now; hR_Rank.UpdatedBy = userID; hR_Rank.UpdateDate = DateTime.Now; int resutl = HR_RankManager.InsertHR_Rank(hR_Rank); Response.Redirect("AdminDisplayHR_Rank.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { HR_Rank hR_Rank = new HR_Rank(); hR_Rank.RankID = int.Parse(Request.QueryString["ID"].ToString()); hR_Rank.RankName = txtRankName.Text; hR_Rank.SeniorityLevel = int.Parse(txtSeniorityLevel.Text); string userID = Profile.card_id; hR_Rank.AddedBy = userID; hR_Rank.AddedDate = DateTime.Now; hR_Rank.UpdatedBy = userID; hR_Rank.UpdateDate = DateTime.Now; bool resutl = HR_RankManager.UpdateHR_Rank(hR_Rank); Response.Redirect("AdminDisplayHR_Rank.aspx"); }
public HR_Rank GetHR_RankFromReader(IDataReader reader) { try { HR_Rank hR_Rank = new HR_Rank ( DataAccessObject.IsNULL<int>(reader["RankID"]), DataAccessObject.IsNULL<string>(reader["RankName"]), DataAccessObject.IsNULL<int>(reader["SeniorityLevel"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]) ); return hR_Rank; } catch(Exception ex) { return null; } }
public bool UpdateHR_Rank(HR_Rank hR_Rank) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_Rank", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RankID", SqlDbType.Int).Value = hR_Rank.RankID; cmd.Parameters.Add("@RankName", SqlDbType.NVarChar).Value = hR_Rank.RankName; cmd.Parameters.Add("@SeniorityLevel", SqlDbType.Int).Value = hR_Rank.SeniorityLevel; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = hR_Rank.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = hR_Rank.UpdateDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_Rank(HR_Rank hR_Rank) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_Rank", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RankID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@RankName", SqlDbType.NVarChar).Value = hR_Rank.RankName; cmd.Parameters.Add("@SeniorityLevel", SqlDbType.Int).Value = hR_Rank.SeniorityLevel; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_Rank.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_Rank.AddedDate; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = hR_Rank.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = hR_Rank.UpdateDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@RankID"].Value; } }
public static bool UpdateHR_Rank(HR_Rank hR_Rank) { SqlHR_RankProvider sqlHR_RankProvider = new SqlHR_RankProvider(); return sqlHR_RankProvider.UpdateHR_Rank(hR_Rank); }
public static int InsertHR_Rank(HR_Rank hR_Rank) { SqlHR_RankProvider sqlHR_RankProvider = new SqlHR_RankProvider(); return sqlHR_RankProvider.InsertHR_Rank(hR_Rank); }