public static HR_SalaryTaxPackage GetHR_SalaryTaxPackageBySalaryTaxPackagePackageID(int SalaryTaxPackagePackageID) { HR_SalaryTaxPackage hR_SalaryTaxPackage = new HR_SalaryTaxPackage(); SqlHR_SalaryTaxPackageProvider sqlHR_SalaryTaxPackageProvider = new SqlHR_SalaryTaxPackageProvider(); hR_SalaryTaxPackage = sqlHR_SalaryTaxPackageProvider.GetHR_SalaryTaxPackageBySalaryTaxPackagePackageID(SalaryTaxPackagePackageID); return hR_SalaryTaxPackage; }
private void showHR_SalaryTaxPackageData() { HR_SalaryTaxPackage hR_SalaryTaxPackage = new HR_SalaryTaxPackage(); hR_SalaryTaxPackage = HR_SalaryTaxPackageManager.GetHR_SalaryTaxPackageBySalaryTaxPackagePackageID(Int32.Parse(Request.QueryString["ID"])); txtSalaryTaxPackageName.Text = hR_SalaryTaxPackage.SalaryTaxPackagePackageName.ToString(); txtSalaryTaxPackageFormula.Text = hR_SalaryTaxPackage.SalaryTaxPackageFormula.ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { HR_SalaryTaxPackage hR_SalaryTaxPackage = new HR_SalaryTaxPackage(); hR_SalaryTaxPackage.SalaryTaxPackagePackageID = int.Parse(Request.QueryString["ID"].ToString()); hR_SalaryTaxPackage.SalaryTaxPackagePackageName = txtSalaryTaxPackageName.Text; hR_SalaryTaxPackage.SalaryTaxPackageFormula = txtSalaryTaxPackageFormula.Text; string userID = Profile.card_id; hR_SalaryTaxPackage.AddedBy = userID; hR_SalaryTaxPackage.AddedDate = DateTime.Now; hR_SalaryTaxPackage.ModifiedBy = userID; hR_SalaryTaxPackage.ModifiedDate = DateTime.Now; bool resutl = HR_SalaryTaxPackageManager.UpdateHR_SalaryTaxPackage(hR_SalaryTaxPackage); Response.Redirect("AdminDisplayHR_SalaryTaxPackage.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { HR_SalaryTaxPackage hR_SalaryTaxPackage = new HR_SalaryTaxPackage(); // hR_SalaryTaxPackage.SalaryTaxPackagePackageID= int.Parse(ddlSalaryTaxPackagePackageID.SelectedValue); hR_SalaryTaxPackage.SalaryTaxPackagePackageName = txtSalaryTaxPackageName.Text; hR_SalaryTaxPackage.SalaryTaxPackageFormula = txtSalaryTaxPackageFormula.Text; string userID = Profile.card_id; hR_SalaryTaxPackage.AddedBy = userID; hR_SalaryTaxPackage.AddedDate = DateTime.Now; hR_SalaryTaxPackage.ModifiedBy = userID; hR_SalaryTaxPackage.ModifiedDate = DateTime.Now; int resutl = HR_SalaryTaxPackageManager.InsertHR_SalaryTaxPackage(hR_SalaryTaxPackage); Response.Redirect("AdminDisplayHR_SalaryTaxPackage.aspx"); }
public static bool UpdateHR_SalaryTaxPackage(HR_SalaryTaxPackage hR_SalaryTaxPackage) { SqlHR_SalaryTaxPackageProvider sqlHR_SalaryTaxPackageProvider = new SqlHR_SalaryTaxPackageProvider(); return sqlHR_SalaryTaxPackageProvider.UpdateHR_SalaryTaxPackage(hR_SalaryTaxPackage); }
public static int InsertHR_SalaryTaxPackage(HR_SalaryTaxPackage hR_SalaryTaxPackage) { SqlHR_SalaryTaxPackageProvider sqlHR_SalaryTaxPackageProvider = new SqlHR_SalaryTaxPackageProvider(); return sqlHR_SalaryTaxPackageProvider.InsertHR_SalaryTaxPackage(hR_SalaryTaxPackage); }
public bool UpdateHR_SalaryTaxPackage(HR_SalaryTaxPackage hR_SalaryTaxPackage) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_SalaryTaxPackage", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SalaryTaxPackagePackageID", SqlDbType.Int).Value = hR_SalaryTaxPackage.SalaryTaxPackagePackageID; cmd.Parameters.Add("@SalaryTaxPackagePackageName", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.SalaryTaxPackagePackageName; cmd.Parameters.Add("@SalaryTaxPackageFormula", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.SalaryTaxPackageFormula; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_SalaryTaxPackage.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_SalaryTaxPackage(HR_SalaryTaxPackage hR_SalaryTaxPackage) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_SalaryTaxPackage", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SalaryTaxPackagePackageID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@SalaryTaxPackagePackageName", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.SalaryTaxPackagePackageName; cmd.Parameters.Add("@SalaryTaxPackageFormula", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.SalaryTaxPackageFormula; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_SalaryTaxPackage.AddedDate; //cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_SalaryTaxPackage.ModifiedBy; //cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_SalaryTaxPackage.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@SalaryTaxPackagePackageID"].Value; } }
public HR_SalaryTaxPackage GetHR_SalaryTaxPackageFromReader(IDataReader reader) { try { HR_SalaryTaxPackage hR_SalaryTaxPackage = new HR_SalaryTaxPackage ( DataAccessObject.IsNULL<int>(reader["SalaryTaxPackagePackageID"]), DataAccessObject.IsNULL<string>(reader["SalaryTaxPackagePackageName"]), DataAccessObject.IsNULL<string>(reader["SalaryTaxPackageFormula"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_SalaryTaxPackage; } catch(Exception ex) { return null; } }