internal static User Get(Guid id)
{
try
{
User _user = null;
using (saplingEntities sapling = new saplingEntities())
{
_user = sapling.User.First(w => w.Id == id);
}
return(_user);
}
catch (Exception ex)
{
throw ex;
}
}
public static long Save(SaplingsSaveDetails data, Guid loggedUserId)
{
long success = 0;
using (saplingEntities saplingEntites = new saplingEntities())
{
Sapling sap = new Sapling();
if (data.Id == 0)
{
sap.Address = data.Address;
sap.IsExists = true;
sap.Latitude = data.Latitude;
sap.Longitude = data.Longitude;
sap.NextActionText = data.NextActionText;
sap.TreeId = data.TreeId;
sap.NickName = data.NickName;
sap.UserId = loggedUserId;
sap.CreatedBy = loggedUserId;
sap.CreatedOn = DateTime.UtcNow;
//save
saplingEntites.Sapling.Add(sap);
}
else
{
var exdata = saplingEntites.Sapling.FirstOrDefault(s => s.Id == data.Id);
exdata.Address = data.Address;
exdata.IsExists = true;
exdata.Latitude = data.Latitude;
exdata.Longitude = data.Longitude;
exdata.NextActionText = data.NextActionText;
exdata.TreeId = data.TreeId;
exdata.NickName = data.NickName;
exdata.UserId = loggedUserId;
exdata.ModifiedBy = loggedUserId;
exdata.ModifiedOn = DateTime.UtcNow;
}
saplingEntites.SaveChanges();
success = sap.Id;
}
return(success);
}
public static bool SaveSaplingImages(long saplingId, byte[] image)
{
try
{
using (saplingEntities saplingEntites = new saplingEntities())
{
var saplingImage = new SaplingImage();
saplingImage.SaplingId = saplingId;
saplingImage.Photo = image;
saplingEntites.SaplingImage.Add(saplingImage);
saplingEntites.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static SaplingDetailViewModal GetSapling(long id, Guid loggedUserId)
{
try
{
SaplingDetailViewModal _saplingDetail = new SaplingDetailViewModal();
using (saplingEntities saplingEntites = new saplingEntities())
{
var sd = saplingEntites.Sapling.Where(w => w.Id == id).FirstOrDefault();
var sapling = saplingEntites.Sapling.FirstOrDefault(w => w.Id == id);
_saplingDetail.Id = sapling.Id;
_saplingDetail.IsMine = false;
_saplingDetail.Position = new decimal[2] {
sapling.Latitude, sapling.Longitude
};
_saplingDetail.TreeName = sapling.Tree != null ? sapling.Tree.Name : string.Empty;
_saplingDetail.NickName = sapling.NickName;
_saplingDetail.PlantedBy = sapling.User.UserName.Substring(0, sapling.User.UserName.IndexOf("@")); // remove after @
_saplingDetail.Description = sapling.Description;
_saplingDetail.Address = sapling.Address;
_saplingDetail.Photo = new List <string>();
_saplingDetail.MaintanceList = sapling.Maintance.Where(m => m.SaplingId == sapling.Id)
.Select(ss => new MaintanceViewModal()
{
Id = ss.Id,
UserId = ss.UserId,
UserName = ss.User.UserName.Substring(0, sapling.User.UserName.IndexOf("@")),
Description = ss.Description,
Date = ss.Date
})
.ToList();
foreach (var item in sapling.SaplingImage)
{
_saplingDetail.Photo.Add("data:image/png;base64," + Convert.ToBase64String(item.Photo));
}
;
}
return(_saplingDetail);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <SaplingViewModal> GetSaplings(Guid loggedUserId, decimal latitude, decimal longitude, bool isAll = true)
{
try
{
if ((!isAll && loggedUserId == Guid.Empty) || latitude == default(decimal) || longitude == default(decimal))
{
throw new Exception("Invalid Data");
}
List <SaplingViewModal> _saplings = new List <SaplingViewModal>();
using (saplingEntities saplingEntites = new saplingEntities())
{
_saplings = saplingEntites.Sapling.Where(w =>
((w.Latitude >= (latitude + 2) || w.Latitude <= (latitude - 2)) ||
(w.Longitude >= (longitude + 2) || w.Longitude <= (longitude - 2))
)
||
(isAll ? true : w.CreatedBy == loggedUserId)).AsEnumerable()
.Select(s => new SaplingViewModal
{
Id = s.Id,
IsMine = s.CreatedBy == loggedUserId,
Position = new decimal[2] {
s.Latitude, s.Longitude
},
TreeName = s.Tree != null ? s.Tree.Name : string.Empty
}).ToList()
;
}
return(_saplings);
}
catch (Exception ex)
{
throw ex;
}
}