public static string checkBalance(HR_Employees_Vacation_Balance detail)
{
List <HR_Employees_Vacation_Balance> HR_Employees_Vacation_Balance =
new List <HR_Employees_Vacation_Balance>();
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("select * from HR_Employees_Vacation_Balance where Emp_id = @Emp_id",
con)
)
{
cmd.Parameters.AddWithValue("@Emp_id", detail.Emp_id);
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
HR_Employees_Vacation_Balance =
populateHR_Employees_Vacation_BalanceLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(HR_Employees_Vacation_Balance));
}
public static string EmpVacBalance(HR_Employees_Vacation_Balance Balance)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <HR_Employees_Vacation_Balance> HR_Employees_Vacation_Balance =
new List <HR_Employees_Vacation_Balance>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("insert into HR_Employees_Vacation_Balance (Emp_id,Annual_Balance,Casual_Balance,Q1,Q1_DateTo,Q2,Q2_DateTo,Q3,Q3_DateTo,Q4,Q4_DateTo,Old_Balance,Old_Balance_ExpirationDate) values (@Emp_id,@Annual_Balance,@Casual_Balance,@Q1,@Q1_DateTo,@Q2,@Q2_DateTo,@Q3,@Q3_DateTo,@Q4,@Q4_DateTo,@Old_Balance,@Old_Balance_ExpirationDate)",
con)
)
{
cmd.Parameters.Add("@Emp_id", SqlDbType.Int).Value = Balance.Emp_id;
cmd.Parameters.Add("@Annual_Balance", SqlDbType.Int).Value =
Balance.Annual_Balance;
cmd.Parameters.Add("@Casual_Balance", SqlDbType.Int).Value =
Balance.Casual_Balance;
cmd.Parameters.Add("@Q1", SqlDbType.Int).Value = Balance.Q1;
cmd.Parameters.Add("@Q1_DateTo", SqlDbType.VarChar).Value =
Balance.Q1_DateTo;
cmd.Parameters.Add("@Q2", SqlDbType.Int).Value = Balance.Q2;
cmd.Parameters.Add("@Q2_DateTo", SqlDbType.VarChar).Value =
Balance.Q2_DateTo;
cmd.Parameters.Add("@Q3", SqlDbType.Int).Value = Balance.Q3;
cmd.Parameters.Add("@Q3_DateTo", SqlDbType.VarChar).Value =
Balance.Q3_DateTo;
cmd.Parameters.Add("@Q4", SqlDbType.Int).Value = Balance.Q4;
cmd.Parameters.Add("@Q4_DateTo", SqlDbType.VarChar).Value =
Balance.Q4_DateTo;
cmd.Parameters.Add("@Old_Balance", SqlDbType.Int).Value =
Balance.Old_Balance;
cmd
.Parameters
.Add("@Old_Balance_ExpirationDate", SqlDbType.VarChar)
.Value = Balance.Old_Balance_ExpirationDate;
cmd.ExecuteNonQuery();
}
con.Close();
return(JsonConvert.SerializeObject(HR_Employees_Vacation_Balance));
}
public static string updateBalance(HR_Employees_Vacation_Balance detail)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <HR_Employees_Vacation_Balance> HR_Employees_Vacation_Balance =
new List <HR_Employees_Vacation_Balance>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("update HR_Employees_Vacation_Balance set Annual_Balance= @Annual_Balance, Casual_Balance= @Casual_Balance, Old_Balance= @Old_Balance,Off_Balance= @Off_Balance,Q1= @Q1,Q2= @Q2,Q3= @Q3,Q4= @Q4,Old_Balance_ExpirationDate = @Old_Balance_ExpirationDate where Emp_id = @Emp_id;",
con)
)
{
cmd.Parameters.AddWithValue("@Emp_id", detail.Emp_id);
cmd
.Parameters
.AddWithValue("@Annual_Balance", detail.Annual_Balance);
cmd
.Parameters
.AddWithValue("@Casual_Balance", detail.Casual_Balance);
cmd.Parameters.AddWithValue("@Old_Balance", detail.Old_Balance);
cmd.Parameters.AddWithValue("@Off_Balance", detail.Off_Balance);
cmd.Parameters.AddWithValue("@Q1", detail.Q1);
cmd.Parameters.AddWithValue("@Q2", detail.Q2);
cmd.Parameters.AddWithValue("@Q3", detail.Q3);
cmd.Parameters.AddWithValue("@Q4", detail.Q4);
cmd
.Parameters
.AddWithValue("@Old_Balance_ExpirationDate",
detail.Old_Balance_ExpirationDate);
cmd.ExecuteNonQuery();
}
con.Close();
return(JsonConvert.SerializeObject(HR_Employees_Vacation_Balance));
}
