protected void btnAdd_Click(object sender, EventArgs e)
{
HR_Package hR_Package = new HR_Package();
// hR_Package.PackageID= int.Parse(ddlPackageID.SelectedValue);
hR_Package.PackageName = txtPackageName.Text;
hR_Package.PackageValue = 0;
int PackageID = HR_PackageManager.InsertHR_Package(hR_Package);
for (int i = 0; i < ListPackageRules.Count; i++)
{
HR_PackageRules hR_PackageRules = new HR_PackageRules();
// hR_PackageRules.PackageRulesID= int.Parse(ddlPackageRulesID.SelectedValue);
Label lblPackageRulesName = ((Label)gvHR_PackageRules.Rows[i].FindControl("lblPackageRulesName"));
Label lblRulesValue = ((Label)gvHR_PackageRules.Rows[i].FindControl("lblRulesValue"));
Label lblRulesOperator = ((Label)gvHR_PackageRules.Rows[i].FindControl("lblRulesOperator"));
hR_PackageRules.PackageRulesName = lblPackageRulesName.Text;
hR_PackageRules.PackageID = PackageID;
hR_PackageRules.RulesValue = int.Parse(lblRulesValue.Text);
hR_PackageRules.RulesOperator = lblRulesOperator.Text;
string userID = Profile.card_id;
hR_PackageRules.AddedBy = userID;
hR_PackageRules.AddedDate = DateTime.Now;
hR_PackageRules.UpdatedBy = userID;
hR_PackageRules.UpdatedDate = DateTime.Now;
int resutl = HR_PackageRulesManager.InsertHR_PackageRules(hR_PackageRules);
}
Response.Redirect("AdminDisplayHR_Package.aspx");
}
public static HR_Package GetHR_PackageByPackageID(int PackageID)
{
HR_Package hR_Package = new HR_Package();
SqlHR_PackageProvider sqlHR_PackageProvider = new SqlHR_PackageProvider();
hR_Package = sqlHR_PackageProvider.GetHR_PackageByPackageID(PackageID);
return hR_Package;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_Package hR_Package = new HR_Package();
hR_Package.PackageID = int.Parse(Request.QueryString["ID"].ToString());
hR_Package.PackageName = txtPackageName.Text;
hR_Package.PackageValue = 0;
bool resutlPackage = HR_PackageManager.UpdateHR_Package(hR_Package);
for (int i = 0; i < ListPackageRules.Count; i++)
{
HR_PackageRules hR_PackageRules = new HR_PackageRules();
// hR_PackageRules.PackageRulesID= int.Parse(ddlPackageRulesID.SelectedValue);
Label lblPackageRulesID = (Label)gvHR_PackageRules.Rows[i].FindControl("lblPackageRulesID");
Label lblPackageRulesName = ((Label)gvHR_PackageRules.Rows[i].FindControl("lblPackageRulesName"));
Label lblRulesValue = ((Label)gvHR_PackageRules.Rows[i].FindControl("lblRulesValue"));
Label lblRulesOperator = ((Label)gvHR_PackageRules.Rows[i].FindControl("lblRulesOperator"));
hR_PackageRules.PackageRulesID = Convert.ToInt32(lblPackageRulesID.Text);
hR_PackageRules.PackageRulesName = lblPackageRulesName.Text;
hR_PackageRules.PackageID = hR_Package.PackageID;
hR_PackageRules.RulesValue = int.Parse(lblRulesValue.Text);
hR_PackageRules.RulesOperator = lblRulesOperator.Text;
string userID = Profile.card_id;
hR_PackageRules.AddedBy = userID;
hR_PackageRules.AddedDate = DateTime.Now;
hR_PackageRules.UpdatedBy = userID;
hR_PackageRules.UpdatedDate = DateTime.Now;
if (hR_PackageRules.PackageRulesID == 0)
{
int resutl = HR_PackageRulesManager.InsertHR_PackageRules(hR_PackageRules);
}
else if (hR_PackageRules.PackageRulesID > 0)
{
bool resutl = HR_PackageRulesManager.UpdateHR_PackageRules(hR_PackageRules);
}
}
Response.Redirect("AdminDisplayHR_Package.aspx");
}
private void showHR_PackageData()
{
try
{
HR_Package hR_Package = new HR_Package();
hR_Package = HR_PackageManager.GetHR_PackageByPackageID(Int32.Parse(Request.QueryString["ID"]));
txtPackageName.Text = hR_Package.PackageName.ToString();
//txtPackageName.ReadOnly = true;
ListPackageRules.Clear();
DataSet listPackageRulesDataSet = HR_PackageRulesManager.GetAllHR_PackageRulessByPackageID(hR_Package.PackageID);
if (listPackageRulesDataSet.Tables[0] != null)
{
foreach (DataRow row in listPackageRulesDataSet.Tables[0].Rows)
{
HR_PackageRules packageRule = new HR_PackageRules();
packageRule.PackageRulesID = Convert.ToInt32(row["PackageRulesID"]);
packageRule.PackageRulesName = Convert.ToString(row["PackageRulesName"]);
packageRule.RulesValue = Convert.ToInt32(row["RulesValue"]);
packageRule.RulesOperator = Convert.ToString(row["RulesOperator"]);
ListPackageRules.Add(packageRule);
}
}
gvHR_PackageRules.DataSource = ListPackageRules;
gvHR_PackageRules.DataBind();
}
catch (Exception ex)
{
}
}
public bool UpdateHR_Package(HR_Package hR_Package)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_Package", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PackageID", SqlDbType.Int).Value = hR_Package.PackageID;
cmd.Parameters.Add("@PackageName", SqlDbType.NVarChar).Value = hR_Package.PackageName;
cmd.Parameters.Add("@PackageValue", SqlDbType.Int).Value = hR_Package.PackageValue;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertHR_Package(HR_Package hR_Package)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertHR_Package", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PackageID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@PackageName", SqlDbType.NVarChar).Value = hR_Package.PackageName;
cmd.Parameters.Add("@PackageValue", SqlDbType.Int).Value = hR_Package.PackageValue;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@PackageID"].Value;
}
}
public HR_Package GetHR_PackageFromReader(IDataReader reader)
{
try
{
HR_Package hR_Package = new HR_Package
(
DataAccessObject.IsNULL<int>(reader["PackageID"]),
DataAccessObject.IsNULL<string>(reader["PackageName"]),
DataAccessObject.IsNULL<int>(reader["PackageValue"])
);
return hR_Package;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateHR_Package(HR_Package hR_Package)
{
SqlHR_PackageProvider sqlHR_PackageProvider = new SqlHR_PackageProvider();
return sqlHR_PackageProvider.UpdateHR_Package(hR_Package);
}
public static int InsertHR_Package(HR_Package hR_Package)
{
SqlHR_PackageProvider sqlHR_PackageProvider = new SqlHR_PackageProvider();
return sqlHR_PackageProvider.InsertHR_Package(hR_Package);
}
