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