public static bool ChangePassword(string username, string password)
{
try
{
User existingUser = new User();
using (var context = new PropertyDBEntities())
{
existingUser = context.Users
.Where(t => t.Username == username)
.FirstOrDefault();
}
if (existingUser != null)
{
existingUser.Password = password;
existingUser.FirstTime = false;
using (var context = new PropertyDBEntities())
{
context.Entry(existingUser).State = EntityState.Modified;
context.SaveChanges();
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(MailTemplate mailTemplate)
{
try
{
MailTemplate existingMailTemplate = new MailTemplate();
using (var context = new PropertyDBEntities())
{
existingMailTemplate = context.MailTemplates
.Where(t => t.ID == mailTemplate.ID)
.FirstOrDefault();
}
if (existingMailTemplate != null)
{
existingMailTemplate.Body = mailTemplate.Body;
existingMailTemplate.Company = mailTemplate.Company;
existingMailTemplate.Footer = mailTemplate.Footer;
existingMailTemplate.FromEmailAddress = mailTemplate.FromEmailAddress;
existingMailTemplate.Password = mailTemplate.Password;
existingMailTemplate.Subject = mailTemplate.Subject;
existingMailTemplate.Username = mailTemplate.Username;
existingMailTemplate.WebsiteUrl = mailTemplate.WebsiteUrl;
using (var context = new PropertyDBEntities())
{
context.Entry(existingMailTemplate).State = EntityState.Modified;
context.SaveChanges();
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdatePropertyAsSold(PropertyDetail propertyDetails)
{
try
{
PropertyDetail existingPropertyDetails = new PropertyDetail();
using (var context = new PropertyDBEntities())
{
existingPropertyDetails = context.PropertyDetails.Include("PropertyImages")
.Where(t => t.PropertyID == propertyDetails.PropertyID)
.FirstOrDefault();
}
if (existingPropertyDetails != null)
{
existingPropertyDetails.Status = propertyDetails.Status;
using (var context = new PropertyDBEntities())
{
context.Entry(existingPropertyDetails).State = EntityState.Modified;
context.SaveChanges();
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(PropertyDetail propertyDetails)
{
try
{
using (var context = new PropertyDBEntities())
{
context.PropertyDetails.Add(propertyDetails);
context.SaveChanges();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(PropertyDetail propertyDetails, List<long> imageIDToRemove, List<byte[]> newImages)
{
try
{
PropertyDetail existingPropertyDetails = new PropertyDetail();
using (var context = new PropertyDBEntities())
{
existingPropertyDetails = context.PropertyDetails.Include("PropertyImages")
.Where(t => t.PropertyID == propertyDetails.PropertyID)
.FirstOrDefault();
}
if (existingPropertyDetails != null)
{
existingPropertyDetails.Title = propertyDetails.Title;
existingPropertyDetails.Type = propertyDetails.Type;
existingPropertyDetails.NumberOfBedrooms = propertyDetails.NumberOfBedrooms;
existingPropertyDetails.Location = propertyDetails.Location;
existingPropertyDetails.Price = propertyDetails.Price;
existingPropertyDetails.Description = propertyDetails.Description;
using (var context = new PropertyDBEntities())
{
//Transaction block
using (var transaction = context.Database.BeginTransaction())
{
try
{
//Modifying just the property details
context.Entry(existingPropertyDetails).State = EntityState.Modified;
context.SaveChanges();
//Delete block for images that were removed from the property
IEnumerable<PropertyImage> existingImages = context.PropertyImages.Include("PropertyDetail")
.Where(t => imageIDToRemove.Contains(t.PropertyImageID))
.ToList();
if (existingImages != null && existingImages.ToList().Count != 0)
{
context.PropertyImages.RemoveRange(existingImages);
context.SaveChanges();
}
//Adding new images for the property
List<PropertyImage> newPropertyImages = new List<PropertyImage>();
foreach (byte[] newImage in newImages)
{
PropertyImage newPropertyImage = new PropertyImage();
newPropertyImage.PropertyID = propertyDetails.PropertyID;
newPropertyImage.Image = newImage;
newPropertyImages.Add(newPropertyImage);
}
if (newPropertyImages != null && newPropertyImages.Count != 0)
{
context.PropertyImages.AddRange(newPropertyImages);
context.SaveChanges();
}
//commit changes
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}