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;
}
}
