Exemple #1
0
 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;
 }
Exemple #2
0
 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();
 }
Exemple #3
0
 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");
 }
Exemple #4
0
 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");
 }
Exemple #5
0
    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;
        }
    }
Exemple #6
0
    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;
        }
    }
Exemple #7
0
    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;
        }
    }
Exemple #8
0
 public static bool UpdateHR_Rank(HR_Rank hR_Rank)
 {
     SqlHR_RankProvider sqlHR_RankProvider = new SqlHR_RankProvider();
     return sqlHR_RankProvider.UpdateHR_Rank(hR_Rank);
 }
Exemple #9
0
 public static int InsertHR_Rank(HR_Rank hR_Rank)
 {
     SqlHR_RankProvider sqlHR_RankProvider = new SqlHR_RankProvider();
     return sqlHR_RankProvider.InsertHR_Rank(hR_Rank);
 }