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)); }