private void showSalaryAdjustmentListData()
{
HR_SalaryAdjustmentList salaryAdjustmentList = new HR_SalaryAdjustmentList();
salaryAdjustmentList = HR_SalaryAdjustmentListManager.GetSalaryAdjustmentListBySalaryAdjustmentListID(Int32.Parse(Request.QueryString["ID"]));
txtName.Text = salaryAdjustmentList.Name.ToString();
txtValue.Text = salaryAdjustmentList.Value.ToString();
}
public static HR_SalaryAdjustmentList GetSalaryAdjustmentListBySalaryAdjustmentListID(int SalaryAdjustmentListID)
{
HR_SalaryAdjustmentList salaryAdjustmentList = new HR_SalaryAdjustmentList();
SqlHR_SalaryAdjustmentListProvider sqlSalaryAdjustmentListProvider = new SqlHR_SalaryAdjustmentListProvider();
salaryAdjustmentList = sqlSalaryAdjustmentListProvider.GetSalaryAdjustmentListBySalaryAdjustmentListID(SalaryAdjustmentListID);
return salaryAdjustmentList;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
HR_SalaryAdjustmentList salaryAdjustmentList = new HR_SalaryAdjustmentList();
salaryAdjustmentList.SalaryAdjustmentGroupID = int.Parse(ddlAdjustmentGroup.SelectedValue);
salaryAdjustmentList.Name = txtName.Text;
salaryAdjustmentList.Value = decimal.Parse(txtValue.Text);
string userID = Profile.card_id;
salaryAdjustmentList.AddedBy = userID;
salaryAdjustmentList.AddedDate = DateTime.Now;
salaryAdjustmentList.UpdatedBy = userID;
salaryAdjustmentList.UpdatedDate = DateTime.Now;
int resutl = HR_SalaryAdjustmentListManager.InsertSalaryAdjustmentList(salaryAdjustmentList);
//Response.Redirect("AdminDisplayHR_SalaryAdjustmentList.aspx");
}
public bool UpdateSalaryAdjustmentList(HR_SalaryAdjustmentList salaryAdjustmentList)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_SalaryAdjustmentList", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SalaryAdjustmentListID", SqlDbType.Int).Value = salaryAdjustmentList.SalaryAdjustmentListID;
cmd.Parameters.Add("@SalaryAdjustmentGroupID", SqlDbType.NVarChar).Value = salaryAdjustmentList.SalaryAdjustmentGroupID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = salaryAdjustmentList.Name;
cmd.Parameters.Add("@Value", SqlDbType.Decimal).Value = salaryAdjustmentList.Value;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = salaryAdjustmentList.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = salaryAdjustmentList.UpdatedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_SalaryAdjustmentList GetSalaryAdjustmentListFromReader(IDataReader reader)
{
try
{
HR_SalaryAdjustmentList salaryAdjustmentList = new HR_SalaryAdjustmentList
(
DataAccessObject.IsNULL<int>(reader["SalaryAdjustmentListID"]),
DataAccessObject.IsNULL<int>(reader["SalaryAdjustmentGroupID"]),
DataAccessObject.IsNULL<string>(reader["Name"]),
DataAccessObject.IsNULL<decimal>(reader["Value"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"])
);
return salaryAdjustmentList;
}
catch (Exception ex)
{
return null;
}
}
public static bool UpdateSalaryAdjustmentList(HR_SalaryAdjustmentList salaryAdjustmentList)
{
SqlHR_SalaryAdjustmentListProvider sqlSalaryAdjustmentListProvider = new SqlHR_SalaryAdjustmentListProvider();
return sqlSalaryAdjustmentListProvider.UpdateSalaryAdjustmentList(salaryAdjustmentList);
}
public static int InsertSalaryAdjustmentList(HR_SalaryAdjustmentList salaryAdjustmentList)
{
SqlHR_SalaryAdjustmentListProvider sqlSalaryAdjustmentListProvider = new SqlHR_SalaryAdjustmentListProvider();
return sqlSalaryAdjustmentListProvider.InsertSalaryAdjustmentList(salaryAdjustmentList);
}
