public int UpdatePayScale(PayScaleBO ps)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
//query to add new earning
query = @"UPDATE [dbo].[PayScaleMaster]
SET " +
"[EffectiveMonthYear] = '" + ps.EffectiveMonthYear + "'" +
" [EmpGroup] = '" + ps.EmpGroup + "'" +
" [PayBandNumber] = '" + ps.PayBandNumber + "'" +
" [StartPay] = '" + ps.StartPay + "'" +
" [EndPay] = '" + ps.EndPay + "'" +
" [GradePay] = '" + ps.GradePay + "'" +
" [SpecialPay] = '" + ps.SpecialPay + "'" +
" WHERE[ScaleCD] LIKE '" + ps.ScaleCD + "'";
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
Console.WriteLine(ex.Message);
dbErrMsg = ex.Message;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
public int AddPayScale(PayScaleBO ps)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
//query to add new earning
query = @"INSERT INTO [dbo].[PayScaleMaster]
([ScaleCD]
,[EffectiveMonthYear]
,[EmpGroup]
,[PayBandNumber]
,[StartPay]
,[EndPay]
,[GradePay]
,[SpecialPay])
VALUES
( " +
"SELECT CAST((SELECT TOP 1 ps.[ScaleCD] FROM [dbo].[PayScaleMaster] as ps ORDER BY CAST(ps.[ScaleCD] as int) DESC)+1 as varchar)," +
"'" + ps.EffectiveMonthYear + "'," +
"'" + ps.EmpGroup + "'," +
"'" + ps.PayBandNumber + "'," +
"'" + ps.StartPay + "'," +
"'" + ps.EndPay + "'," +
"'" + ps.GradePay + "'," +
"'" + ps.SpecialPay + "',";
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
Console.WriteLine(ex.Message);
dbErrMsg = ex.Message;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
