//public static HR_BenifitPackageRules GetHR_BenifitPackageRulesByBenifitPackageRulesID(int BenifitPackageRulesID) //{ // HR_BenifitPackageRules hR_BenifitPackageRules = new HR_BenifitPackageRules(); // SqlHR_BenifitPackageRulesProvider sqlHR_BenifitPackageRulesProvider = new SqlHR_BenifitPackageRulesProvider(); // hR_BenifitPackageRules = sqlHR_BenifitPackageRulesProvider.GetHR_BenifitPackageRulesByBenifitPackageRulesID(BenifitPackageRulesID); // return hR_BenifitPackageRules; //} public static HR_BenifitPackageRules GetHR_BenifitPackageRulesByEmployeeID(string employeeID) { HR_BenifitPackageRules hR_BenifitPackageRules = new HR_BenifitPackageRules(); SqlHR_BenifitPackageRulesProvider sqlHR_BenifitPackageRulesProvider = new SqlHR_BenifitPackageRulesProvider(); hR_BenifitPackageRules = sqlHR_BenifitPackageRulesProvider.GetHR_BenifitPackageRulesByEmployeeID(employeeID); return hR_BenifitPackageRules; }
public static int InsertHR_BenifitPackageRules(HR_BenifitPackageRules hR_BenifitPackageRules) { SqlHR_BenifitPackageRulesProvider sqlHR_BenifitPackageRulesProvider = new SqlHR_BenifitPackageRulesProvider(); return sqlHR_BenifitPackageRulesProvider.InsertHR_BenifitPackageRules(hR_BenifitPackageRules); }
protected void btnAddBenifitRules_Click(object sender, EventArgs e) { if (hfEmployeeID.Value != null) { HR_BenifitPackageRules hR_BenifitPackageRules = new HR_BenifitPackageRules(); hR_BenifitPackageRules.EmployeeID = hfEmployeeID.Value.ToString(); hR_BenifitPackageRules.BenifitPackageID = Convert.ToInt32(ddlBenifitPackage.SelectedValue.ToString()); int resutl = HR_BenifitPackageRulesManager.InsertHR_BenifitPackageRules(hR_BenifitPackageRules); hR_BenifitPackageRules.BenifitPackageRulesID = resutl; HR_BenifitPackage benefitPackage = HR_BenifitPackageManager.GetHR_BenifitPackageByBenifitPackageID(hR_BenifitPackageRules.BenifitPackageID); _benifitPackageColl.Add(benefitPackage); lblBenifitMsg.Text = "Benefit Rules Information is saved"; lblBenifitMsg.ForeColor = System.Drawing.Color.Green; } else { lblBenifitMsg.Text = "Employee is not specified."; lblBenifitMsg.ForeColor = System.Drawing.Color.Red; } gvHR_BenefitPackage.DataSource = _benifitPackageColl; gvHR_BenefitPackage.DataBind(); UpdatePanel1.Update(); }
public bool UpdateHR_BenifitPackage(HR_BenifitPackageRules hR_BenifitPackageRules) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_BenifitPackageRules", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BenifitPackageRulesID", SqlDbType.Int).Value = hR_BenifitPackageRules.BenifitPackageID; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_BenifitPackageRules.EmployeeID; cmd.Parameters.Add("@BenifitPackageID", SqlDbType.Int).Value = hR_BenifitPackageRules.BenifitPackageID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_BenifitPackageRules(HR_BenifitPackageRules hR_BenifitPackageRules) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_BenifitPackageRules", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BenifitPackageRulesID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_BenifitPackageRules.EmployeeID; cmd.Parameters.Add("@BenifitPackageID", SqlDbType.Int).Value = hR_BenifitPackageRules.BenifitPackageID; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@BenifitPackageRulesID"].Value; } }
public HR_BenifitPackageRules GetHR_BenifitPackageRulesFromReader(IDataReader reader) { try { HR_BenifitPackageRules hR_BenifitPackageRules = new HR_BenifitPackageRules ( DataAccessObject.IsNULL<int>(reader["BenifitPackageRulesID"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()), DataAccessObject.IsNULL<int>(reader["BenifitPackageID"]) ); return hR_BenifitPackageRules; } catch(Exception ex) { return null; } }