public static HR_BenifitPackage GetHR_BenifitPackageByBenifitPackageID(int BenifitPackageID) { HR_BenifitPackage hR_BenifitPackage = new HR_BenifitPackage(); SqlHR_BenifitPackageProvider sqlHR_BenifitPackageProvider = new SqlHR_BenifitPackageProvider(); hR_BenifitPackage = sqlHR_BenifitPackageProvider.GetHR_BenifitPackageByBenifitPackageID(BenifitPackageID); return hR_BenifitPackage; }
private void showHR_BenifitPackageData() { HR_BenifitPackage hR_BenifitPackage = new HR_BenifitPackage(); hR_BenifitPackage = HR_BenifitPackageManager.GetHR_BenifitPackageByBenifitPackageID(Int32.Parse(Request.QueryString["ID"])); txtBenifitPackageName.Text = hR_BenifitPackage.BenifitPackageName.ToString(); txtBenifitTimesYear.Text = hR_BenifitPackage.BenifitTimesYear.ToString(); txtBebifitFormula.Text = hR_BenifitPackage.BebifitFormula.ToString(); chkIsRespectGross.Checked = hR_BenifitPackage.IsGrossBenifit; }
protected void btnUpdate_Click(object sender, EventArgs e) { HR_BenifitPackage hR_BenifitPackage = new HR_BenifitPackage(); hR_BenifitPackage.BenifitPackageID = int.Parse(Request.QueryString["ID"].ToString()); hR_BenifitPackage.BenifitPackageName = txtBenifitPackageName.Text; hR_BenifitPackage.BenifitTimesYear = int.Parse(txtBenifitTimesYear.Text); hR_BenifitPackage.BebifitFormula = txtBebifitFormula.Text; hR_BenifitPackage.IsGrossBenifit = chkIsRespectGross.Checked; string userID = Profile.card_id; hR_BenifitPackage.ModifiedBy = userID; hR_BenifitPackage.ModifiedDate = DateTime.Now; bool resutl = HR_BenifitPackageManager.UpdateHR_BenifitPackage(hR_BenifitPackage); Response.Redirect("AdminDisplayHR_BenifitPackage.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { HR_BenifitPackage hR_BenifitPackage = new HR_BenifitPackage(); // hR_BenifitPackage.BenifitPackageID= int.Parse(ddlBenifitPackageID.SelectedValue); hR_BenifitPackage.BenifitPackageName = txtBenifitPackageName.Text; hR_BenifitPackage.BenifitTimesYear = int.Parse(txtBenifitTimesYear.Text); hR_BenifitPackage.BebifitFormula = txtBebifitFormula.Text.Trim(); hR_BenifitPackage.IsGrossBenifit = chkIsRespectGross.Checked; string userID = Profile.card_id; hR_BenifitPackage.AddedBy = userID; hR_BenifitPackage.AddedDate = DateTime.Now; int resutl = HR_BenifitPackageManager.InsertHR_BenifitPackage(hR_BenifitPackage); Response.Redirect("AdminDisplayHR_BenifitPackage.aspx"); }
public static bool UpdateHR_BenifitPackage(HR_BenifitPackage hR_BenifitPackage) { SqlHR_BenifitPackageProvider sqlHR_BenifitPackageProvider = new SqlHR_BenifitPackageProvider(); return sqlHR_BenifitPackageProvider.UpdateHR_BenifitPackage(hR_BenifitPackage); }
public static int InsertHR_BenifitPackage(HR_BenifitPackage hR_BenifitPackage) { SqlHR_BenifitPackageProvider sqlHR_BenifitPackageProvider = new SqlHR_BenifitPackageProvider(); return sqlHR_BenifitPackageProvider.InsertHR_BenifitPackage(hR_BenifitPackage); }
//protected void lblSelectBenefit_Click(object sender, EventArgs e) //{ //} protected void lblDeleteBenefit_Click(object sender, EventArgs e) { ImageButton linkButton = new ImageButton(); linkButton = (ImageButton)sender; int index = Convert.ToInt32(linkButton.CommandArgument); HR_BenifitPackage benifitPackage = new HR_BenifitPackage(); benifitPackage = _benifitPackageColl.ElementAt(index); if (benifitPackage.BenifitPackageID != 0) { bool result = HR_BenifitPackageRulesManager.DeleteHR_BenifitPackageRulesByEmpIDAndBenPackageID(hfEmployeeID.Value.ToString(),benifitPackage.BenifitPackageID) ; } _benifitPackageColl.RemoveAt(index); gvHR_BenefitPackage.DataSource = _benifitPackageColl; gvHR_BenefitPackage.DataBind(); UpdatePanel1.Update(); }
public bool UpdateHR_BenifitPackage(HR_BenifitPackage hR_BenifitPackage) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_BenifitPackage", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BenifitPackageID", SqlDbType.Int).Value = hR_BenifitPackage.BenifitPackageID; cmd.Parameters.Add("@BenifitPackageName", SqlDbType.NVarChar).Value = hR_BenifitPackage.BenifitPackageName; cmd.Parameters.Add("@BenifitTimesYear", SqlDbType.Int).Value = hR_BenifitPackage.BenifitTimesYear; cmd.Parameters.Add("@BebifitFormula", SqlDbType.NVarChar).Value = hR_BenifitPackage.BebifitFormula; cmd.Parameters.Add("@IsRespectGross", SqlDbType.Int).Value = hR_BenifitPackage.IsGrossBenifit; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_BenifitPackage.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_BenifitPackage.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_BenifitPackage(HR_BenifitPackage hR_BenifitPackage) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_BenifitPackage", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BenifitPackageID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@BenifitPackageName", SqlDbType.NVarChar).Value = hR_BenifitPackage.BenifitPackageName; cmd.Parameters.Add("@BenifitTimesYear", SqlDbType.Int).Value = hR_BenifitPackage.BenifitTimesYear; cmd.Parameters.Add("@BebifitFormula", SqlDbType.NVarChar).Value = hR_BenifitPackage.BebifitFormula; cmd.Parameters.Add("@IsRespectGross", SqlDbType.Bit).Value = hR_BenifitPackage.IsGrossBenifit; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_BenifitPackage.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_BenifitPackage.AddedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@BenifitPackageID"].Value; } }
public HR_BenifitPackage GetHR_BenifitPackageFromReader(IDataReader reader) { try { HR_BenifitPackage hR_BenifitPackage = new HR_BenifitPackage ( DataAccessObject.IsNULL<int>(reader["BenifitPackageID"]), DataAccessObject.IsNULL<string>(reader["BenifitPackageName"]), DataAccessObject.IsNULL<int>(reader["BenifitTimesYear"]), DataAccessObject.IsNULL<string>(reader["BebifitFormula"]), DataAccessObject.IsNULL<bool>(reader["IsRespectGross"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_BenifitPackage; } catch (Exception ex) { return null; } }