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