public static bl_Registry_Result UpdateSelect(bl_Registry info)
{
using (var metadata = DataAccess.getDesktopMetadata())
{
//Get original guest record
var qReg = (from row in metadata.db_Registry
where row.registryID == info.registryID
select row).FirstOrDefault();
var item = qReg;
if (item == null)
{
throw new NullReferenceException("No Gift found. Refresh Page");
}
item.isSelected = info.isSelected;
item.selectedUserID = info.selectedUserID;
metadata.SaveChanges();
var result = new bl_Registry_Result
{
hasError = false
};
return(result);
}
}
public static bl_Registry_Result Edit(bl_Registry info)
{
using (var metadata = DataAccess.getDesktopMetadata())
{
//Get original guest record
var qReg = (from row in metadata.db_Registry
where row.registryID == info.registryID
select row).FirstOrDefault();
//Check if their is a duplicate
var qDuplicate = (from row in metadata.db_Registry
where row.GiftName.ToLower().Trim() == info.GiftName.ToLower().Trim() &&
row.registryID != info.registryID
select row).FirstOrDefault();
var item = qReg;
if (item == null)
{
throw new NullReferenceException("No Gift found. Refresh Page");
}
var duplicate = qDuplicate;
if (duplicate == null && item.isSelected == false)
{
item.GiftName = info.GiftName;
metadata.SaveChanges();
var result = new bl_Registry_Result
{
hasError = false
};
return(result);
}
else if (duplicate == null && item.isSelected == true)
{
var result = new bl_Registry_Result
{
hasError = true,
ErrorText = "Cannot edit a gift already chosen by a Guest"
};
return(result);
}
else
{
var result = new bl_Registry_Result
{
hasError = true,
ErrorText = "Gift already exist"
};
return(result);
}
}
}
public static bl_Registry_Result Add(bl_Registry info)
{
using (var metadata = DataAccess.getDesktopMetadata())
{
var qDuplicate = (from row in metadata.db_Registry
where row.GiftName.ToLower().Trim() == info.GiftName.ToLower().Trim()
select row).FirstOrDefault();
if (qDuplicate == null)
{
var newRegistry = new db_Registry
{
GiftName = info.GiftName,
isSelected = false,
};
metadata.db_Registry.Add(newRegistry);
metadata.SaveChanges();
var result = new bl_Registry_Result
{
hasError = false,
};
return(result);
}
else
{
var result = new bl_Registry_Result
{
hasError = true,
ErrorText = "Gift already exist"
};
return(result);
}
}
}