public static string VacRejection(HR_Vacations_Requests request)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <HR_Vacations_Requests> HR_Vacations_Requests =
new List <HR_Vacations_Requests>();
SqlConnection con = new SqlConnection(config);
con.Open();
SqlCommand cmd =
new SqlCommand("update HR_Vacations_Requests set HR_Comment= @HR_Comment, Status= @Status where id = @id;",
con);
{
cmd.Parameters.AddWithValue("@HR_Comment", request.HR_Comment);
cmd.Parameters.AddWithValue("@Status", request.Status);
cmd.Parameters.AddWithValue("@id", request.id);
cmd.ExecuteNonQuery();
}
con.Close();
return(JsonConvert.SerializeObject(HR_Vacations_Requests));
}
NewHR_Vacations_Requests(HR_Vacations_Requests HR_Vacations_Request)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <HR_Vacations_Requests> HR_Vacations_Requests =
new List <HR_Vacations_Requests>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("insert into HR_Vacations_Requests (Requester_id,Delegation_EmpName,Delegation_EmpCode,Deduction_name,Deduction_id,Vacation_Type_name,Vacation_Type_id,Vacation_Type_Others,Total_Days,Emergency_Contact,Requester_Comment,Attach_File,Status, Dept_id,OFF_Day) values (@Requester_id,@Delegation_EmpName,@Delegation_EmpCode,@Deduction_name,@Deduction_id,@Vacation_Type_name,@Vacation_Type_id,@Vacation_Type_Others,@Total_Days,@Emergency_Contact,@Requester_Comment,@Attach_File,@Status, @Dept_id,@OFF_Day) select @@identity",
con)
)
{
cmd.Parameters.Add("@Requester_id", SqlDbType.Int).Value =
HttpContext.Current.Session["Emp_ID"];
cmd.Parameters.Add("@Delegation_EmpName", SqlDbType.VarChar).Value =
HR_Vacations_Request.Delegation_EmpName;
cmd.Parameters.Add("@Delegation_EmpCode", SqlDbType.Int).Value =
HR_Vacations_Request.Delegation_EmpCode;
cmd.Parameters.Add("@Deduction_name", SqlDbType.VarChar).Value =
HR_Vacations_Request.Deduction_name;
cmd.Parameters.Add("@Deduction_id", SqlDbType.Int).Value =
HR_Vacations_Request.Deduction_id;
cmd.Parameters.Add("@Vacation_Type_name", SqlDbType.VarChar).Value =
HR_Vacations_Request.Vacation_Type_name;
cmd.Parameters.Add("@Vacation_Type_id", SqlDbType.Int).Value =
HR_Vacations_Request.Vacation_Type_id;
cmd
.Parameters
.Add("@Vacation_Type_Others", SqlDbType.VarChar)
.Value = HR_Vacations_Request.Vacation_Type_Others;
cmd.Parameters.Add("@Total_Days", SqlDbType.Int).Value =
HR_Vacations_Request.Total_Days;
cmd.Parameters.Add("@Emergency_Contact", SqlDbType.VarChar).Value =
HR_Vacations_Request.Emergency_Contact;
cmd.Parameters.Add("@Requester_Comment", SqlDbType.VarChar).Value =
HR_Vacations_Request.Requester_Comment;
cmd.Parameters.Add("@Attach_File", SqlDbType.VarChar).Value =
HR_Vacations_Request.Attach_File;
cmd.Parameters.Add("@Status", SqlDbType.Int).Value = 1;
cmd.Parameters.Add("@Dept_id", SqlDbType.Int).Value =
HttpContext.Current.Session["Dept_id"];
cmd.Parameters.Add("@OFF_Day", SqlDbType.Int).Value =
HR_Vacations_Request.OFF_Day;
NewId = Convert.ToInt32(cmd.ExecuteScalar());
Type_id = HR_Vacations_Request.Vacation_Type_id;
}
con.Close();
return(JsonConvert.SerializeObject(HR_Vacations_Requests));
}
