public BuildingSite AddNewSite(int userID, string siteName, string siteAddress, string image64) { BuildingSite site = null; string imgRef = uploadImg(image64); try { var result = Dal.AddNewSite(userID, siteName, siteAddress, imgRef); if (result == null) { return(null); } site = new BuildingSite { SiteId = int.Parse(result.Rows[0]["siteID"].ToString()), SiteName = result.Rows[0]["siteName"].ToString(), SiteAddress = result.Rows[0]["siteAddress"].ToString(), SiteStatus = bool.Parse(result.Rows[0]["siteStatus"].ToString()), UserTypeId = int.Parse(result.Rows[0]["userTypeID"].ToString()), UserTypeName = result.Rows[0]["userTypName"].ToString(), SiteImage = imgRef, Rooms = new List <Room>() }; return(site); } catch (Exception e) { throw new Exception(e.Message); } }
public List <BuildingSite> GetUserSites(int userId) { var results = Dal.GetUserSites(userId); var sites = new List <BuildingSite>(); if (results == null) { return(sites); } for (var i = 0; i < results.Rows.Count; i++) { var staticsSite = Dal.GetStaticsOnSite(int.Parse(results.Rows[i]["siteID"].ToString())); var site = new BuildingSite { SiteId = int.Parse(results.Rows[i]["siteID"].ToString()), SiteName = results.Rows[i]["siteName"].ToString(), SiteAddress = results.Rows[i]["siteAddress"].ToString(), SiteStatus = bool.Parse(results.Rows[i]["siteStatus"].ToString()), UserTypeId = int.Parse(results.Rows[i]["userTypeID"].ToString()), UserTypeName = results.Rows[i]["userTypName"].ToString(), SiteImage = results.Rows[i]["img"].ToString(), SumUserInSite = int.Parse(staticsSite.Rows[0]["sumOfUser"].ToString()), SumRoomInSite = int.Parse(staticsSite.Rows[0]["sumOfRooms"].ToString()), }; sites.Add(site); } return(sites); }
public List <BuildingSite> GetUserSites(int userId) { var results = Dal.GetUserSites(userId); var sites = new List <BuildingSite>(); if (results == null) { return(sites); } for (var i = 0; i < results.Rows.Count; i++) { var site = new BuildingSite { SiteId = int.Parse(results.Rows[i]["siteID"].ToString()), SiteName = results.Rows[i]["siteName"].ToString(), SiteAddress = results.Rows[i]["siteAddress"].ToString(), SiteStatus = bool.Parse(results.Rows[i]["siteStatus"].ToString()), UserTypeId = int.Parse(results.Rows[i]["userTypeID"].ToString()), UserTypeName = results.Rows[i]["userTypName"].ToString() }; sites.Add(site); } return(sites); }
public UserInSite ConfirmInvite(int siteId, int senderId, int reciverId) { DataTable res = Dal.ConfirmInvite(siteId, senderId, reciverId); if (res == null) { return(null); } var site = new BuildingSite { SiteName = res.Rows[0]["siteName"].ToString(), SiteId = int.Parse(res.Rows[0]["SiteID"].ToString()), SiteAddress = res.Rows[0]["SiteAddress"].ToString(), UserTypeId = int.Parse(res.Rows[0]["userTypeID"].ToString()), UserTypeName = res.Rows[0]["userTypName"].ToString(), SiteStatus = true }; site.Rooms = getSiteRooms(siteId); var user = new User { Email = res.Rows[0]["email"].ToString(), UserName = res.Rows[0]["userName"].ToString(), FirstName = res.Rows[0]["firstName"].ToString(), LastName = res.Rows[0]["lastName"].ToString(), Tel = res.Rows[0]["tel"].ToString(), Img = res.Rows[0]["img"].ToString(), UserId = int.Parse(res.Rows[0]["userID"].ToString()) }; var userInSite = new UserInSite { user = user, Site = site }; Notify(res.Rows[0]["OwnerEmail"].ToString(), "Invitation accepted", $"{user.FirstName} {user.LastName} has accepted your invite"); return(userInSite); }
public List <UserInSite> GetSentInvites(int userId) { var results = Dal.GetSentInvites(userId); if (results == null) { return(null); } List <UserInSite> InvitedUsers = new List <UserInSite>(); for (int i = 0; i < results.Rows.Count; i++) { var user = new User { UserId = int.Parse(results.Rows[i]["userID"].ToString()), UserName = results.Rows[i]["userName"].ToString(), FirstName = results.Rows[i]["firstName"].ToString(), LastName = results.Rows[i]["lastName"].ToString(), Email = results.Rows[i]["email"].ToString(), Img = results.Rows[i]["img"].ToString(), }; var site = new BuildingSite { SiteAddress = results.Rows[i]["siteAddress"].ToString(), SiteId = int.Parse(results.Rows[i]["siteID"].ToString()), SiteName = results.Rows[i]["siteName"].ToString(), UserTypeName = results.Rows[i]["userTypName"].ToString(), UserTypeId = int.Parse(results.Rows[i]["userTypeID"].ToString()), SiteImage = results.Rows[i]["img"].ToString() }; InvitedUsers.Add(new UserInSite { user = user, Site = site }); } return(InvitedUsers); }
public BuildingSite ChangeSiteStatus(int siteID, int statusID) { var result = Dal.ChangeSiteStatus(siteID, statusID); if (result == null) { return(null); } var site = new BuildingSite { SiteId = int.Parse(result.Rows[0]["siteID"].ToString()), SiteName = result.Rows[0]["siteName"].ToString(), SiteAddress = result.Rows[0]["siteAddress"].ToString(), SiteStatus = bool.Parse(result.Rows[0]["siteStatus"].ToString()), UserTypeId = 0, UserTypeName = null, Rooms = new List <Room>() }; return(site); }
public BuildingSite AddNewSite(int userID, string siteName, string siteAddress) { var result = Dal.AddNewSite(userID, siteName, siteAddress); if (result == null) { return(null); } var site = new BuildingSite { SiteId = int.Parse(result.Rows[0]["siteID"].ToString()), SiteName = result.Rows[0]["siteName"].ToString(), SiteAddress = result.Rows[0]["siteAddress"].ToString(), SiteStatus = bool.Parse(result.Rows[0]["siteStatus"].ToString()), UserTypeId = int.Parse(result.Rows[0]["userTypeID"].ToString()), UserTypeName = result.Rows[0]["userTypName"].ToString(), Rooms = new List <Room>() }; return(site); }