public async Task <IActionResult> ClockOut(TimeSignatureModel body) { try { if (body == null) { IActionResult actionResult = customActionResult.BadRequest( "The client set the requested body to null before it was sent." ); return(StatusCode(StatusCodes.Status400BadRequest, actionResult)); } else { if (body.finish == false) { DynamicParameters checkIfClockOut_params = new DynamicParameters(); checkIfClockOut_params.Add("@userId", _claims.GetUserId()); string checkIfClockOut_string = @$ " SELECT TOP 1 [id], [startDate] FROM [TimeSignature] WHERE [endDate] IS NULL AND [userId] = @userId ORDER BY [id] DESC
public async Task <IActionResult> ClockIn(TimeSignatureModel body) { try { if (body == null) { IActionResult actionResult = customActionResult.BadRequest("The client set the requested body to null before it was sent."); return(StatusCode(StatusCodes.Status400BadRequest, actionResult)); } else if (string.IsNullOrEmpty(body.typeCode) || string.IsNullOrWhiteSpace(body.typeCode)) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'type code' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.typeCode != "FLX") { IActionResult actionResult = customActionResult.Conflict( "This option is only for 'Fixed Time Signature'. For 'Flexible Time Signature', try the other option." ); return(StatusCode(StatusCodes.Status409Conflict, actionResult)); } else if (string.IsNullOrEmpty(body.wd_typeCode) || string.IsNullOrWhiteSpace(body.wd_typeCode)) { IActionResult actionResult = customActionResult.FieldsRequired( "The Workday 'code type' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else { var checkIfAnyWorkdaySavedInDbWithCurrentDate = await CheckIfAnyWorkdaySavedInDbWithCurrentDate(); if ( checkIfAnyWorkdaySavedInDbWithCurrentDate.Count > 0 && checkIfAnyWorkdaySavedInDbWithCurrentDate[0].typeCode == "FLX" && checkIfAnyWorkdaySavedInDbWithCurrentDate[0].stateCode == "TT" && checkIfAnyWorkdaySavedInDbWithCurrentDate[0].endDate.Date == DateTime.Now.Date ) { IActionResult actionResult = customActionResult.Locked( @$ "You already finished your workday for today using flexible time signatures. If you checked in the finish checkbox from the client by mistake, contact your manager. Have a nice day and see you tommorrow" ); return(StatusCode(StatusCodes.Status423Locked, actionResult)); } else { var checkIfAnyTSignatureSavedInDbWithCurrentDate = await CheckIfAnyTSignatureSavedInDbWithCurrentDate(); if (checkIfAnyTSignatureSavedInDbWithCurrentDate.Count > 0) { IActionResult actionResult = customActionResult.Locked( @$ "You already clocked in. You must clock out before you clock in again. Your session already started at {checkIfAnyTSignatureSavedInDbWithCurrentDate[0].startDate}" ); return(StatusCode(StatusCodes.Status423Locked, actionResult)); } else { if (body.wd_typeCode != "ZI") { IActionResult actionResult = customActionResult.BadRequest( @$ "The workday 'code type' value provided by the client is not valid: {body.wd_typeCode}." ); return(StatusCode(StatusCodes.Status400BadRequest, actionResult)); } else { var selectWorkdayById = await SelectWorkdayById(); if (selectWorkdayById.Count < 1) { await InsertIntoWorkday(body); } var selectWorkdayByIdAgain = await SelectWorkdayById(); await ClockIn(body, selectWorkdayByIdAgain); DateTime dateNow = new DateTime(); dateNow = DateTime.Now; IActionResult actionResult = customActionResult.Ok( @$ "You signed successfuly for flexible 'Time Signature' at {dateNow}. Don't forget to clock out." ); return(StatusCode(StatusCodes.Status200OK, actionResult)); } } } } } catch (Exception e) { return(StatusCode(StatusCodes.Status500InternalServerError, e.Message)); } }
public async Task <IActionResult> DeleteAsOrdinaryAsync(int id, TimeSignatureModel body) { try { if (body == null) { IActionResult actionResult = customActionResult.BadRequest( "The client set the requested body to null before it was sent." ); return(StatusCode(StatusCodes.Status400BadRequest, actionResult)); } else { if (string.IsNullOrEmpty(body.typeCode) || string.IsNullOrWhiteSpace(body.typeCode)) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'code type' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.typeCode != "FIX" && _claims.GetUserRole() != "admin") { IActionResult actionResult = customActionResult.Conflict( "This option is only for 'Fixed Time Signature' type. If you want to delete a 'Flexible Time Signature', please contact your manager." ); return(StatusCode(StatusCodes.Status409Conflict, actionResult)); } else if (body.typeCode == "FIX" && _claims.GetUserRole() != "admin") { DynamicParameters selectUserIdByWokrdayId_params = new DynamicParameters(); selectUserIdByWokrdayId_params.Add("@userId", _claims.GetUserId()); selectUserIdByWokrdayId_params.Add("@workdayId", id); string selectUserIdByWokrdayId_string = $@" SELECT [userId] FROM [Workday] WHERE [userId] = @userId AND [id] = @workdayId "; var selectUserIdByWorkdayId_result = await _db.SelectAsync <WorkdayModel, dynamic>(selectUserIdByWokrdayId_string, selectUserIdByWokrdayId_params); if (selectUserIdByWorkdayId_result.Count < 1) { IActionResult actionResult = customActionResult.NotFound("No time signature found by given id"); return(StatusCode(StatusCodes.Status404NotFound, actionResult)); } else if (selectUserIdByWorkdayId_result[0].userId != _claims.GetUserId()) { IActionResult actionResult = customActionResult.Unauthorized( "You are not authorized to delete this time signature." ); return(StatusCode(StatusCodes.Status401Unauthorized, actionResult)); } else { DynamicParameters deleteFixTSignatureByWorkdayId_params = new DynamicParameters(); deleteFixTSignatureByWorkdayId_params.Add("@workdayId", id); string deleteFixTSignaturesByWorkdayId = $@" DELETE FROM [TimeSignature] WHERE [workdayId] = @workdayId AND [typeCode] = 'FIX' "; await _db.DeleteAsync(deleteFixTSignaturesByWorkdayId, deleteFixTSignatureByWorkdayId_params); string deleteFixWorkdayByWorkdayId = $@" DELETE FROM [Workday] WHERE [id] = @workdayId "; await _db.DeleteAsync(deleteFixWorkdayByWorkdayId, deleteFixTSignatureByWorkdayId_params); IActionResult actionResult = customActionResult.Ok( "You deleted successfuly your workday." ); return(StatusCode(StatusCodes.Status200OK, actionResult)); } } else { DynamicParameters selectUserIdByWokrdayId_params = new DynamicParameters(); selectUserIdByWokrdayId_params.Add("@userId", _claims.GetUserId()); selectUserIdByWokrdayId_params.Add("@workdayId", id); string selectUserIdByWokrdayId_string = $@" SELECT [userId] FROM [Workday] WHERE [userId] = @userId AND [id] = @workdayId "; var selectUserIdByWorkdayId_result = await _db.SelectAsync <WorkdayModel, dynamic>(selectUserIdByWokrdayId_string, selectUserIdByWokrdayId_params); if (selectUserIdByWorkdayId_result.Count < 1) { IActionResult actionResult = customActionResult.NotFound("No time signature found by given id"); return(StatusCode(StatusCodes.Status404NotFound, actionResult)); } else if (selectUserIdByWorkdayId_result[0].userId != _claims.GetUserId()) { IActionResult actionResult = customActionResult.Unauthorized( "You are not authorized to delete this time signature." ); return(StatusCode(StatusCodes.Status401Unauthorized, actionResult)); } else { DynamicParameters deleteFixTSignatureByWorkdayId_params = new DynamicParameters(); deleteFixTSignatureByWorkdayId_params.Add("@workdayId", id); string deleteFixTSignaturesByWorkdayId = $@" DELETE FROM [TimeSignature] WHERE [workdayId] = @workdayId "; await _db.DeleteAsync(deleteFixTSignaturesByWorkdayId, deleteFixTSignatureByWorkdayId_params); string deleteFixWorkdayByWorkdayId = $@" DELETE FROM [Workday] WHERE [id] = @workdayId "; await _db.DeleteAsync(deleteFixWorkdayByWorkdayId, deleteFixTSignatureByWorkdayId_params); IActionResult actionResult = customActionResult.Ok( "You deleted successfuly your workday." ); return(StatusCode(StatusCodes.Status200OK, actionResult)); } } } } catch (Exception e) { return(StatusCode(StatusCodes.Status500InternalServerError, e.Message)); } }
public async Task <IActionResult> UpdateSelfsWorkdayAndTSignatureByWorkdayId(int id, TimeSignatureModel body) { try { if (body == null) { IActionResult actionResult = customActionResult.BadRequest( "The client set the requested body to null before it was sent." ); return(StatusCode(StatusCodes.Status400BadRequest, actionResult)); } else { if (body.startDate == null || body.endDate == null) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'start date' or 'end date' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else { DynamicParameters selectTSignaturesIdentifiersByWorkdayIdAndUserId_params = new DynamicParameters(); selectTSignaturesIdentifiersByWorkdayIdAndUserId_params.Add("@workdayId", id); selectTSignaturesIdentifiersByWorkdayIdAndUserId_params.Add("@userId", _claims.GetUserId()); string selectTSignaturesIdentifiersByWorkdayIdAndUserId_string = $@" SELECT [typeCode], [updateBy] FROM [TimeSignature] WHERE [workdayId] = @workdayId AND [userId] = @userId "; var selectTSignaturesIdentifiersByWorkdayIdAndUserId = await _db.SelectAsync <TimeSignatureModel, dynamic>( selectTSignaturesIdentifiersByWorkdayIdAndUserId_string, selectTSignaturesIdentifiersByWorkdayIdAndUserId_params ); if ( selectTSignaturesIdentifiersByWorkdayIdAndUserId.Count > 0 && selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].typeCode == "FIX" && ( selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].updateBy == null || selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].updateBy == "self" ) ) { DynamicParameters updateTSignature_params = new DynamicParameters(); updateTSignature_params.Add("@userId", _claims.GetUserId()); updateTSignature_params.Add("@userName", _claims.GetUserName()); updateTSignature_params.Add("@id", id); updateTSignature_params.Add("@startDate", body.startDate); updateTSignature_params.Add("@endDate", body.endDate); updateTSignature_params.Add("@wd_typeCode", body.wd_typeCode); string updateTSignature_string = $@" UPDATE [TimeSignature] SET [startDate] = @startDate, [endDate] = @endDate, [aom] = (SELECT DATEDIFF(MINUTE, @startDate, @endDate)), [wd_typeCode] = @wd_typeCode, [lastUpdate] = GETDATE(), [updateBy] = 'self' WHERE [userId] = @userId AND [workdayId] = @id "; await _db.UpdateAsync(updateTSignature_string, updateTSignature_params); string updateWorkday_string = $@" UPDATE [Workday] SET [startDate] = @startDate, [endDate] = @endDate, [aom] = (SELECT DATEDIFF(MINUTE, @startDate, @endDate)), [typeCode] = @wd_typeCode WHERE [userId] = @userId AND [id] = @id "; await _db.UpdateAsync(updateWorkday_string, updateTSignature_params); IActionResult actionResult = customActionResult.Ok(@$ "Your time signature was successfully updated."); return(StatusCode(StatusCodes.Status200OK, actionResult)); } else if ( selectTSignaturesIdentifiersByWorkdayIdAndUserId.Count > 0 && selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].typeCode == "FIX" && ( selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].updateBy != null || selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].updateBy != "self" ) ) { IActionResult actionResult = customActionResult.Unauthorized( "You are not authorzied to make any updates on workdays having time signatures that were updated by an admin user." ); return(StatusCode(StatusCodes.Status401Unauthorized, actionResult)); } else if ( selectTSignaturesIdentifiersByWorkdayIdAndUserId.Count > 0 && selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].typeCode == "FLX" && _claims.GetUserRole() == "admin" ) { DynamicParameters deleteFlxTSignaturesByWorkdayId_params = new DynamicParameters(); deleteFlxTSignaturesByWorkdayId_params.Add("@id", id); string deleteFlxTSignaturesByWorkdayId = $@" DELETE FROM [TimeSignature] WHERE [WorkdayId] = @id "; await _db.DeleteAsync(deleteFlxTSignaturesByWorkdayId, deleteFlxTSignaturesByWorkdayId_params); DynamicParameters insertIntoTSignature_params = new DynamicParameters(); insertIntoTSignature_params.Add("@userId", _claims.GetUserId()); insertIntoTSignature_params.Add("@workdayId", id); insertIntoTSignature_params.Add("@wd_typeCode", body.wd_typeCode); insertIntoTSignature_params.Add("@startDate", body.startDate); insertIntoTSignature_params.Add("@endDate", body.endDate); string insertIntoTSignature_string = $@" INSERT INTO [TimeSignature] ( [startDate], [endDate], [typeCode], [stateCode], [wd_typeCode], [workdayId], [userId], [aom], [lastUpdate], [updateBy] ) VALUES ( @startDate, @endDate, (SELECT [code] FROM [SignatureType] WHERE [code] = 'FIX'), (SELECT [code] FROM [SignatureState] WHERE [code] = 'TT'), (SELECT [code] FROM [WorkdayType] WHERE [code] = @wd_typeCode), (SELECT [id] FROM [Workday] WHERE [id] = @workdayId), (SELECT [id] FROM [User] WHERE [id] = @userId), (SELECT DATEDIFF(MINUTE, @startDate, @endDate)), (SELECT GETDATE()), 'self' ) "; await _db.InsertAsync(insertIntoTSignature_string, insertIntoTSignature_params); DynamicParameters updateWorkdayById_params = new DynamicParameters(); updateWorkdayById_params.Add("@userId", _claims.GetUserId()); updateWorkdayById_params.Add("@workdayId", id); updateWorkdayById_params.Add("@startDate", body.startDate); updateWorkdayById_params.Add("@endDate", body.endDate); string updateWorkdayById_string = $@" UPDATE [Workday] SET [date] = (SELECT [startDate] FROM [TimeSignature] WHERE [workdayId] = @workdayId), [startDate] = (SELECT [startDate] FROM [TimeSignature] WHERE [workdayId] = @workdayId), [endDate] = (SELECT [endDate] FROM [TimeSignature] WHERE [workdayId] = @workdayId), [aom] = (SELECT DATEDIFF(MINUTE, @startDate, @endDate)) WHERE [userId] = @userId AND [id] = @workdayId "; await _db.UpdateAsync(updateWorkdayById_string, updateWorkdayById_params); IActionResult actionResult = customActionResult.Ok(@$ "Your time signature was successfully updated."); return(StatusCode(StatusCodes.Status200OK, actionResult)); } else if ( selectTSignaturesIdentifiersByWorkdayIdAndUserId.Count > 0 && selectTSignaturesIdentifiersByWorkdayIdAndUserId[0].typeCode == "FLX" && _claims.GetUserRole() != "admin" ) { IActionResult actionResult = customActionResult.Unauthorized( "You are not authorized to update your workdays with flexible time signature, if by mystake you made a databes record using flexible time signature, please contact your manager." ); return(StatusCode(StatusCodes.Status401Unauthorized, actionResult)); } else { IActionResult actionResult = customActionResult.NotFound( @$ "No time signatures found searching by workday id and user id." ); return(StatusCode(StatusCodes.Status404NotFound, actionResult)); } } } } catch (Exception e) { return(StatusCode(StatusCodes.Status500InternalServerError, e.Message)); } }
public async Task <IActionResult> ClockInAsOrdinary(TimeSignatureModel body) { try { //#region CHECK INPUTS SENT FROM CLIENT if (body == null) { IActionResult actionResult = customActionResult.BadRequest( "The client set the requested body to null before it was sent." ); return(StatusCode(StatusCodes.Status400BadRequest, actionResult)); } else { if (string.IsNullOrEmpty(body.typeCode) || string.IsNullOrWhiteSpace(body.typeCode)) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'code type' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.typeCode != "FIX") { IActionResult actionResult = customActionResult.Conflict( "This option is only for 'Fixed Time Signature'. For 'Flexible Time Signature', try the other option." ); return(StatusCode(StatusCodes.Status409Conflict, actionResult)); } else { var selectTodaysUserTSignatureIdentifiersByUserId = await SelectTodaysUserTSignatureIdentifiersByUserId(body); if (selectTodaysUserTSignatureIdentifiersByUserId.Count < 1) { if (string.IsNullOrEmpty(body.wd_typeCode) || string.IsNullOrWhiteSpace(body.wd_typeCode)) { IActionResult actionResult = customActionResult.FieldsRequired( "The workday 'code type' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.fullDay == false && (body.startDate == null || body.endDate == null)) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'start date' or 'end date' field has been sent from the client null." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.fullDay == false && (body.startDate != null || body.endDate != null)) { await InsertIntoWorkdayWithOutFullDayOption(body); IActionResult actionResult = customActionResult.Ok(@$ "You signed successfuly without full day option."); return(StatusCode(StatusCodes.Status200OK, actionResult)); } else if (body.fullDay == true && body.startDate == null) { IActionResult actionResult = customActionResult.FieldsRequired("The 'start date' field has been sent from the client null."); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.fullDay == true && body.startDate != null) { await InsertIntoWorkdayWithFullDayOption(body); IActionResult actionResult = customActionResult.Ok(@$ "You signed successfuly with full day option."); return(StatusCode(StatusCodes.Status200OK, actionResult)); } else { IActionResult actionResult = customActionResult.NotFound(@$ "No options found with given keys."); return(StatusCode(StatusCodes.Status404NotFound, actionResult)); } } else { var checkDbIfUserClockedInTodayFixTSignature = await CheckDbIfUserClockedInTodayWithFixTSignature(selectTodaysUserTSignatureIdentifiersByUserId); if ( checkDbIfUserClockedInTodayFixTSignature.Count > 0 && selectTodaysUserTSignatureIdentifiersByUserId[0].stateCode == "TT" && selectTodaysUserTSignatureIdentifiersByUserId[0].typeCode == "FIX" ) { if (string.IsNullOrEmpty(body.wd_typeCode) || string.IsNullOrWhiteSpace(body.wd_typeCode)) { IActionResult actionResult = customActionResult.FieldsRequired( "The workday 'code type' field has been sent from the client null, empty, or whitespaced." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.fullDay == false && (body.startDate == null || body.endDate == null)) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'start date' or 'end date' field has been sent from the client null." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.fullDay == false && (body.startDate != null || body.endDate != null)) { await InsertIntoWorkdayWithOutFullDayOption(body); IActionResult actionResult = customActionResult.Ok("You signed successfuly without full day option."); return(StatusCode(StatusCodes.Status200OK, actionResult)); } else if (body.fullDay == true && body.startDate == null) { IActionResult actionResult = customActionResult.FieldsRequired( "The 'start date' field has been sent from the client null." ); return(StatusCode(StatusCodes.Status411LengthRequired, actionResult)); } else if (body.fullDay == true && body.startDate != null) { await InsertIntoWorkdayWithFullDayOption(body); IActionResult actionResult = customActionResult.Ok("You signed successfuly with full day option."); return(StatusCode(StatusCodes.Status200OK, actionResult)); } else { IActionResult actionResult = customActionResult.NotFound("No options found with given keys."); return(StatusCode(StatusCodes.Status404NotFound, actionResult)); } } else { IActionResult actionResult = customActionResult.Locked(@$ " You already clocked in for today with workday type code 'ZI'. If you want to, you have the option to update your time signature. Your session started at {selectTodaysUserTSignatureIdentifiersByUserId[0].startDate} and ended at {selectTodaysUserTSignatureIdentifiersByUserId[0].endDate} "); return(StatusCode(StatusCodes.Status423Locked, actionResult)); } } } } } catch (Exception e) { return(StatusCode(StatusCodes.Status500InternalServerError, e.Message)); } }