internal static string LeaveReq(Users.LeaveRequest leaveRequest) { //string conn; //conn = ConfigurationManager.ConnectionStrings["conn"].ToString(); //SqlConnection connection = new SqlConnection(conn); //connection.Open(); SqlCommand cmd = new SqlCommand("request", _connection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter leaveID = cmd.Parameters.Add("@leaveID", SqlDbType.UniqueIdentifier); leaveID.Value = leaveRequest.leaveID; SqlParameter empID = cmd.Parameters.Add("@empID", SqlDbType.UniqueIdentifier); empID.Value = leaveRequest.empID; SqlParameter leavetype = cmd.Parameters.Add("@leave_type", SqlDbType.Int); leavetype.Value = leaveRequest.leavetype; SqlParameter daypart = cmd.Parameters.Add("@DayPart", SqlDbType.Int); daypart.Value = leaveRequest.DayPart; SqlParameter Category = cmd.Parameters.Add("@Category", SqlDbType.VarChar); Category.Value = leaveRequest.Category; SqlParameter CategoryID = cmd.Parameters.Add("@CategoryID", SqlDbType.TinyInt); CategoryID.Value = leaveRequest.CategoryID; SqlParameter reason = cmd.Parameters.Add("@Reason", SqlDbType.VarChar); reason.Value = leaveRequest.Reason; SqlParameter fromdate = cmd.Parameters.Add("@fromdate", SqlDbType.DateTime); fromdate.Value = leaveRequest.fromdate; SqlParameter todate = cmd.Parameters.Add("@todate", SqlDbType.DateTime); todate.Value = leaveRequest.todate; SqlParameter status = cmd.Parameters.Add("@Status", SqlDbType.VarChar); status.Value = leaveRequest.Status; cmd.ExecuteNonQuery(); //connection.Close(); return(Convert.ToString(leaveRequest)); }
private static double GetNumberOfDaysInLeave(LeaveRequest leave) { double days = 0; if (leave.leavetype == 2) { days += 0.5; } else { DateTime startDate = Convert.ToDateTime(leave.fromdate); DateTime endDate = Convert.ToDateTime(leave.todate); var difference = (endDate - startDate).TotalDays; if (difference == 0) { days++; } days += difference + 1; } return(days); }
public static void SetStatus(ref LeaveRequest leaveRequest, string statusValue) { leaveRequest.Status = statusValue; }