protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_SalaryAdjustmentListRules salaryAdjustmentListRules = new HR_SalaryAdjustmentListRules();
salaryAdjustmentListRules.SalaryAdjustmentListRulesID = int.Parse(Request.QueryString["ID"].ToString());
salaryAdjustmentListRules.EmployeeID = ddlEmployeeID.SelectedValue;
salaryAdjustmentListRules.SalaryAdjustmentGroupID = int.Parse(ddlSalaryAdjustmentListID.SelectedValue);
string userID = Profile.card_id;
salaryAdjustmentListRules.AddedBy = userID;
salaryAdjustmentListRules.AddedDate = DateTime.Now;
salaryAdjustmentListRules.UpdatedBy = userID;
salaryAdjustmentListRules.UpdatedDate = DateTime.Now;
bool resutl = HR_SalaryAdjustmentListRulesManager.UpdateSalaryAdjustmentListRules(salaryAdjustmentListRules);
Response.Redirect("AdminDisplaySalaryAdjustmentListRules.aspx");
}
public HR_SalaryAdjustmentListRules GetSalaryAdjustmentListRulesByEmployeeID(string employeeID)
{
HR_SalaryAdjustmentListRules SalaryAdjustmentListRuless = new HR_SalaryAdjustmentListRules();
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand command = new SqlCommand("GetHR_SalaryAdjustmentListRulesByEmployeeID", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = employeeID;
connection.Open();
IDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
return GetSalaryAdjustmentListRulesFromReader(reader);
}
else
{
return null;
}
}
}
public bool UpdateSalaryAdjustmentListRules(HR_SalaryAdjustmentListRules salaryAdjustmentListRules)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_SalaryAdjustmentListRules", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SalaryAdjustmentListRulesID", SqlDbType.Int).Value = salaryAdjustmentListRules.SalaryAdjustmentListRulesID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = salaryAdjustmentListRules.EmployeeID;
cmd.Parameters.Add("@SalaryAdjustmentGroupID", SqlDbType.Int).Value = salaryAdjustmentListRules.SalaryAdjustmentGroupID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = salaryAdjustmentListRules.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = salaryAdjustmentListRules.UpdatedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_SalaryAdjustmentListRules GetSalaryAdjustmentListRulesFromReader(IDataReader reader)
{
try
{
HR_SalaryAdjustmentListRules salaryAdjustmentListRules = new HR_SalaryAdjustmentListRules
(
DataAccessObject.IsNULL<int>(reader["SalaryAdjustmentListRulesID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<int>(reader["SalaryAdjustmentGroupID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"])
);
return salaryAdjustmentListRules;
}
catch (Exception ex)
{
return null;
}
}
private void showSalaryAdjustmentListRulesData()
{
HR_SalaryAdjustmentListRules salaryAdjustmentListRules = new HR_SalaryAdjustmentListRules();
salaryAdjustmentListRules = HR_SalaryAdjustmentListRulesManager.GetSalaryAdjustmentListRulesBySalaryAdjustmentListRulesID(Int32.Parse(Request.QueryString["ID"]));
ddlEmployeeID.SelectedValue = salaryAdjustmentListRules.EmployeeID.ToString();
ddlSalaryAdjustmentListID.SelectedValue = salaryAdjustmentListRules.SalaryAdjustmentGroupID.ToString();
}
protected void btnSalaryAdjustmentListRules_Click(object sender, EventArgs e)
{
if (hfEmployeeID.Value != null)
{
if (HR_SalaryAdjustmentListRulesManager.IsEmployeeExist(hfEmployeeID.Value.ToString()))
{
HR_SalaryAdjustmentListRulesManager.DeleteSalaryAdjustmentListRulesByEmployeeID(hfEmployeeID.Value.ToString());
}
HR_SalaryAdjustmentListRules item = new HR_SalaryAdjustmentListRules();
item.EmployeeID = hfEmployeeID.Value.ToString();
item.SalaryAdjustmentGroupID = Convert.ToInt32(ddlAdjustmentGroup.SelectedValue);
string userID = Profile.card_id;
item.AddedBy = userID;
item.AddedDate = DateTime.Now;
item.UpdatedBy = userID;
item.UpdatedDate = DateTime.Now;
HR_SalaryAdjustmentListRulesManager.InsertSalaryAdjustmentListRules(item);
lblSalaryAdjustmentGroupMsg.Text = "This information is saved";
lblSalaryAdjustmentGroupMsg.ForeColor = System.Drawing.Color.Green;
//}
//else
//{
// lblSalaryAdjustmentGroupMsg.Text = "Employee information is exist.";
// lblSalaryAdjustmentGroupMsg.ForeColor = System.Drawing.Color.Red;
//}
}
else
{
lblSalaryAdjustmentGroupMsg.Text = "Employee is not specified.";
lblSalaryAdjustmentGroupMsg.ForeColor = System.Drawing.Color.Red;
}
UpdatePanel1.Update();
}
private void RefreshSalaryAdjustmentListRules()
{
HR_SalaryAdjustmentListRules salaryAdjustmentListRules = new HR_SalaryAdjustmentListRules();
salaryAdjustmentListRules = HR_SalaryAdjustmentListRulesManager.GetSalaryAdjustmentListRulesOnlyByEmployeeID(hfEmployeeID.Value.ToString());
if (salaryAdjustmentListRules != null)
{
ddlAdjustmentGroup.SelectedValue = salaryAdjustmentListRules.SalaryAdjustmentGroupID.ToString();
gvHR_AdjustmentList.DataSource = HR_SalaryAdjustmentListManager.GetSalaryAdjustmentListBySalaryAdjustmenGroupID(Convert.ToInt32(ddlAdjustmentGroup.SelectedValue));
gvHR_AdjustmentList.DataBind();
}
}
