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