public string AttendanceSave(LocationAttendance model) { var userid = _httpContextAccessor.HttpContext.User.GetLoggedInUserId <string>(); if (string.IsNullOrEmpty(userid)) { throw new InvalidOperationException("User Not found"); } CoreSQLConnection CoreSQL = new CoreSQLConnection(); ArrayList arrayList = new ArrayList(); var sqlQuery = "exec prc_AttCheckInOut '" + userid + "','" + model.Type + "','" + model.CheckInLatitude + "', '" + model.CheckInLongitude + "', N'" + model.CheckInAddress.Replace("'", "`") + "'"; arrayList.Add(sqlQuery); CoreSQL.CoreSQL_SaveDataUseSQLCommand(arrayList); return("Success"); }
public IActionResult AttendanceSave([FromBody] LocationAttendance model) { try { if (_attendanceQuery.AttendanceSave(model) == "Success") { return(Ok()); } else { return(BadRequest("Save Failed !!!")); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }