public static HR_SalaryIncrementPackageRules GetHR_SalaryIncrementPackageRulesBySalaryIncrementPackageRulesID(int SalaryIncrementPackageRulesID)
{
HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules = new HR_SalaryIncrementPackageRules();
SqlHR_SalaryIncrementPackageRulesProvider sqlHR_SalaryIncrementPackageRulesProvider = new SqlHR_SalaryIncrementPackageRulesProvider();
hR_SalaryIncrementPackageRules = sqlHR_SalaryIncrementPackageRulesProvider.GetHR_SalaryIncrementPackageRulesBySalaryIncrementPackageRulesID(SalaryIncrementPackageRulesID);
return hR_SalaryIncrementPackageRules;
}
public static HR_SalaryIncrementPackageRules GetHR_SalaryIncrementPackageRulesByEmployeeID(string EmployeeID)
{
HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules = new HR_SalaryIncrementPackageRules();
SqlHR_SalaryIncrementPackageRulesProvider sqlHR_SalaryIncrementPackageRulesProvider = new SqlHR_SalaryIncrementPackageRulesProvider();
hR_SalaryIncrementPackageRules = sqlHR_SalaryIncrementPackageRulesProvider.GetHR_SalaryIncrementPackageRulesByEmployeeID(EmployeeID);
return hR_SalaryIncrementPackageRules;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules = new HR_SalaryIncrementPackageRules();
hR_SalaryIncrementPackageRules.SalaryIncrementPackageRulesID = int.Parse(Request.QueryString["ID"].ToString());
hR_SalaryIncrementPackageRules.EmployeeID = ddlEmployeeID.SelectedValue;
hR_SalaryIncrementPackageRules.SalaryIncrementPackageID = int.Parse(ddlSalaryIncrementPackageID.SelectedValue);
hR_SalaryIncrementPackageRules.Year = int.Parse(txtYear.Text);
hR_SalaryIncrementPackageRules.Month = int.Parse(txtMonth.Text);
string userID = Profile.card_id;
hR_SalaryIncrementPackageRules.AddedBy = userID;
hR_SalaryIncrementPackageRules.AddedDate = DateTime.Now;
hR_SalaryIncrementPackageRules.ModifiedBy = userID;
hR_SalaryIncrementPackageRules.ModifiedDate = DateTime.Now;
bool resutl = HR_SalaryIncrementPackageRulesManager.UpdateHR_SalaryIncrementPackageRules(hR_SalaryIncrementPackageRules);
Response.Redirect("AdminDisplayHR_SalaryIncrementPackageRules.aspx");
}
public static int InsertHR_SalaryIncrementPackageRules(HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules)
{
SqlHR_SalaryIncrementPackageRulesProvider sqlHR_SalaryIncrementPackageRulesProvider = new SqlHR_SalaryIncrementPackageRulesProvider();
return sqlHR_SalaryIncrementPackageRulesProvider.InsertHR_SalaryIncrementPackageRules(hR_SalaryIncrementPackageRules);
}
public static bool UpdateHR_SalaryIncrementPackageRules(HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules)
{
SqlHR_SalaryIncrementPackageRulesProvider sqlHR_SalaryIncrementPackageRulesProvider = new SqlHR_SalaryIncrementPackageRulesProvider();
return sqlHR_SalaryIncrementPackageRulesProvider.UpdateHR_SalaryIncrementPackageRules(hR_SalaryIncrementPackageRules);
}
private void showHR_SalaryIncrementPackageRulesData()
{
HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules = new HR_SalaryIncrementPackageRules();
hR_SalaryIncrementPackageRules = HR_SalaryIncrementPackageRulesManager.GetHR_SalaryIncrementPackageRulesBySalaryIncrementPackageRulesID(Int32.Parse(Request.QueryString["ID"]));
ddlEmployeeID.SelectedValue = hR_SalaryIncrementPackageRules.EmployeeID.ToString();
ddlSalaryIncrementPackageID.SelectedValue = hR_SalaryIncrementPackageRules.SalaryIncrementPackageID.ToString();
txtYear.Text = hR_SalaryIncrementPackageRules.Year.ToString();
txtMonth.Text = hR_SalaryIncrementPackageRules.Month.ToString();
}
protected void btnAddSalaryIncrement_Click(object sender, EventArgs e)
{
if (hfEmployeeID.Value != null)
{
if (!HR_SalaryIncrementPackageRulesManager.IsEmployeeExist(hfEmployeeID.Value.ToString()))
{
HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules = new HR_SalaryIncrementPackageRules();
// hR_SalaryIncrementPackageRules.SalaryIncrementPackageRulesID= int.Parse(ddlSalaryIncrementPackageRulesID.SelectedValue);
hR_SalaryIncrementPackageRules.EmployeeID = hfEmployeeID.Value.ToString();//ddlsalaryIncrementEmployeeID.SelectedValue;
hR_SalaryIncrementPackageRules.SalaryIncrementPackageID = int.Parse(ddlSalaryIncrementPackageID.SelectedValue);
hR_SalaryIncrementPackageRules.Year = int.Parse(txtSalaryYear.Text);
hR_SalaryIncrementPackageRules.Month = int.Parse(txtMonth.Text);
string userID = Profile.card_id;
hR_SalaryIncrementPackageRules.AddedBy = userID;
hR_SalaryIncrementPackageRules.AddedDate = DateTime.Now;
hR_SalaryIncrementPackageRules.ModifiedBy = userID;
hR_SalaryIncrementPackageRules.ModifiedDate = DateTime.Now;
int resutl = HR_SalaryIncrementPackageRulesManager.InsertHR_SalaryIncrementPackageRules(hR_SalaryIncrementPackageRules);
//Response.Redirect("AdminDisplayHR_SalaryIncrementPackageRules.aspx");
lblSalaryIncrementMsg.Text = "Salary Increment Information is saved";
}
else
{
lblSalaryIncrementMsg.Text = "Employee information is exist";
lblSalaryIncrementMsg.ForeColor = System.Drawing.Color.Red;
}
}
else
{
lblSalaryIncrementMsg.Text = "Employee is not specified.";
lblSalaryIncrementMsg.ForeColor = System.Drawing.Color.Red;
}
}
public bool UpdateHR_SalaryIncrementPackageRules(HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_SalaryIncrementPackageRules", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SalaryIncrementPackageRulesID", SqlDbType.Int).Value = hR_SalaryIncrementPackageRules.SalaryIncrementPackageRulesID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_SalaryIncrementPackageRules.EmployeeID;
cmd.Parameters.Add("@SalaryIncrementPackageID", SqlDbType.Int).Value = hR_SalaryIncrementPackageRules.SalaryIncrementPackageID;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = hR_SalaryIncrementPackageRules.Year;
cmd.Parameters.Add("@Month", SqlDbType.Int).Value = hR_SalaryIncrementPackageRules.Month;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_SalaryIncrementPackageRules.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_SalaryIncrementPackageRules.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_SalaryIncrementPackageRules GetHR_SalaryIncrementPackageRulesFromReader(IDataReader reader)
{
try
{
HR_SalaryIncrementPackageRules hR_SalaryIncrementPackageRules = new HR_SalaryIncrementPackageRules
(
DataAccessObject.IsNULL<int>(reader["SalaryIncrementPackageRulesID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<int>(reader["SalaryIncrementPackageID"]),
DataAccessObject.IsNULL<int>(reader["Year"]),
DataAccessObject.IsNULL<int>(reader["Month"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_SalaryIncrementPackageRules;
}
catch(Exception ex)
{
return null;
}
}
