public async Task <CheckStatusModel> CheckStatus(string Name, string Url)
{
var result = await(from cr in _context.CheckRegister
join crun in _context.CheckRun
on cr.Id equals crun.CheckRegister.Id
where cr.Name == Name && cr.Url == Url
orderby crun.LastRunOn descending
select new{ Status = crun.Status,
RunTime = TimeSpan.Parse(crun.RunTime),
LastRunOn = crun.LastRunOn }).ToListAsync();
var checkStatus = new CheckStatusModel();
if (result.Any())
{
var lastRun = result.Where(x => x.Status != result.FirstOrDefault().Status).FirstOrDefault();
checkStatus.Name = Name;
checkStatus.Url = Url;
checkStatus.Status = result.FirstOrDefault().Status;
checkStatus.StatusSince = lastRun == null?result.FirstOrDefault().LastRunOn : lastRun.LastRunOn;
checkStatus.AveragResoponseTime = result.Average(x => x.RunTime.TotalMilliseconds).ToString();
}
return(checkStatus);
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
var Chuu2 = new CheckStatusModel();
using (SqlConnection Rikka = new SqlConnection(Dekomori.GetConnection()))
{
Rikka.Open();
string Takanashi = @"SELECT r.RSG_CheckStatID, r.RSG_RID, res.RSG_RName, res.RSG_Image, res.RSG_RName, u.RSG_Username,
res.RSG_Address, res.RSG_ContactNumber, res.RSG_Branch,
res.RSG_OperatingHours,res.RSG_TotalSeats, c.RSG_Category FROM RSG_CheckStat r
INNER JOIN RSG_Restaurants res ON r.RSG_RID = res.RSG_RID
INNER JOIN RSG_Categories c ON res.RSG_CatID = c.RSG_CatID
INNER JOIN RSG_Users u ON r.RSG_UserID = u.RSG_UserID
WHERE r.RSG_RID = @RID";
using (SqlCommand WickedEye = new SqlCommand(Takanashi, Rikka))
{
WickedEye.Parameters.AddWithValue("@RID", id);
using (SqlDataReader Nibutani = WickedEye.ExecuteReader())
{
if (Nibutani.HasRows)
{
while (Nibutani.Read())
{
Chuu2.RestaurantID = int.Parse(Nibutani["RSG_RID"].ToString());
Chuu2.RestaurantName = Nibutani["RSG_RName"].ToString();
Chuu2.Address = Nibutani["RSG_Address"].ToString();
Chuu2.Image = Nibutani["RSG_Image"].ToString();
Chuu2.Branch = Nibutani["RSG_Branch"].ToString();
Chuu2.ContactNumber = Nibutani["RSG_ContactNumber"].ToString();
Chuu2.Owner = Nibutani["RSG_Username"].ToString();
Chuu2.TotalSeats = Nibutani["RSG_TotalSeats"].ToString();
Chuu2.OperatingHours = Nibutani["RSG_OperatingHours"].ToString();
Chuu2.Category = Nibutani["RSG_Category"].ToString();
Chuu2.CheckStatusID = int.Parse(Nibutani["RSG_CheckStatID"].ToString());
}
ViewBag.Total = (GetTotalCheckIns(id).ToString());
return(View(Chuu2));
}
else
{
return(RedirectToAction("Index"));
}
}
}
}
}
public async Task <bool> CheckBusinessID(Guid businessID)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from checkbusinessid(@thebusinessid) as checkbusinessid", businessId)
.Select(e => new CheckStatusModel()
{
BusinessIDStatus = e.BusinessIDStatus
}).FirstOrDefault());
return(checkStatusModel.BusinessIDStatus);
}
public async Task <bool> ActivateUserById(Guid userID)
{
var userId = new Npgsql.NpgsqlParameter("@theuserid", userID);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from activateuser(@theuserid)", userId)
.Select(e => new CheckStatusModel()
{
Status = e.Status
}).FirstOrDefault());
return(checkStatusModel.Status);
}
public async Task <bool> ActivateEmployeeById(Guid BusinessID, Guid employeeId)
{
var businessID = new Npgsql.NpgsqlParameter("@thebusinessid", BusinessID);
var employeeID = new Npgsql.NpgsqlParameter("@theempid", employeeId);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from activateemployeebyid(@thebusinessid,@theempid)", businessID, employeeID)
.Select(e => new CheckStatusModel()
{
Status = e.Status
}).FirstOrDefault());
return(checkStatusModel.Status);
}
public async Task <bool> CheckIfEmployeeHasAlreaySaleryAssigned(Guid businessID, Guid employeeID)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var employeeId = new Npgsql.NpgsqlParameter("@theempid", employeeID);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from checkemployeeidhavingsaleryassigned(@thebusinessid,@theempid) as checkemployeeid", businessId, employeeId)
.Select(e => new CheckStatusModel()
{
EmployeeIDStatus = e.EmployeeIDStatus
}).FirstOrDefault());
return(checkStatusModel.EmployeeIDStatus);
}
public async Task <bool> ActivateBusinessUserById(Guid businessID, Guid businesUserID)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var businesUserId = new Npgsql.NpgsqlParameter("@thebuid", businesUserID);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from activatebusinessuser(@thebusinessid,@thebuid) as status", businessId, businesUserId)
.Select(e => new CheckStatusModel()
{
Status = e.Status
}).FirstOrDefault());
return(checkStatusModel.Status);
}
public async Task <bool> CheckDeductionID(Guid businessID, Guid deductionID)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var deductionId = new Npgsql.NpgsqlParameter("@thedeductionid", deductionID);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from checkdeductionid(@thebusinessid,@thedeductionid)", businessId, deductionId)
.Select(e => new CheckStatusModel()
{
DeductionIDStatus = e.DeductionIDStatus
}).FirstOrDefault());
return(checkStatusModel.DeductionIDStatus);
}
public async Task <bool> CheckIncrementID(Guid businessID, Guid incrementID)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var incrementId = new Npgsql.NpgsqlParameter("@theincrementid", incrementID);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from checkincrementid(@thebusinessid,@theincrementid) ", businessId, incrementId)
.Select(e => new CheckStatusModel()
{
IncrementIDStatus = e.IncrementIDStatus
}).FirstOrDefault());
return(checkStatusModel.IncrementIDStatus);
}
public async Task <bool> UpdateEmployeeSalaryBySalaryID(Guid businessID, Guid SalaryID, UpdateSalaryModel updateSalaryModel)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var salaryId = new Npgsql.NpgsqlParameter("@thesalaryid", SalaryID);
var salary = new Npgsql.NpgsqlParameter("@thesalary", updateSalaryModel.Salary);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from updatesalarybyid(@thebusinessid,@thesalaryid," +
"@thesalary) as salaryupdatastatus", businessId, salaryId, salary)
.Select(e => new CheckStatusModel()
{
salaryUpdateStatus = e.salaryUpdateStatus
}).FirstOrDefault());
return(checkStatusModel.salaryUpdateStatus);
}
public async Task <bool> AddEmployeeSalary(Guid businessID, SalaryModel salaryModel)
{
var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID);
var employeeId = new Npgsql.NpgsqlParameter("@theempid", salaryModel.EmployeeID);
var salary = new Npgsql.NpgsqlParameter("@thesalary", salaryModel.Salary);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from addsalary(@thebusinessid,@theempid," +
"@thesalary)", businessId, employeeId, salary)
.Select(e => new CheckStatusModel()
{
Status = e.Status
}).FirstOrDefault());
return(checkStatusModel.Status);
}
public async Task <bool> UpdateUserById(Guid userID, UserModel userModel)
{
var userId = new Npgsql.NpgsqlParameter("@theuserid", userID);
var userName = new Npgsql.NpgsqlParameter("@theusername", userModel.UserName);
var userFName = new Npgsql.NpgsqlParameter("@thefirstname", userModel.UserFirstName);
var userLName = new Npgsql.NpgsqlParameter("@thelastname", userModel.UserLastName);
var userEmail = new Npgsql.NpgsqlParameter("@theuseremail", userModel.UserEmail);
var userContact = new Npgsql.NpgsqlParameter("@thecontact", userModel.UserContact);
CheckStatusModel checkStatusModel = await Task.Run(() => _projectContextDB.CheckStatusModel.FromSqlRaw("select * from updateuser(@theuserid,@theusername," +
"@thefirstname,@thelastname,@theuseremail,@thecontact)", userId, userName, userFName, userLName, userEmail, userContact)
.Select(e => new CheckStatusModel()
{
Status = e.Status
}).FirstOrDefault());
return(checkStatusModel.Status);
}