public ELEMENT updateElement(ElementView element)
{
if (!element.isValid())
throw new Exception("Element is not valid. Please send error.");
ELEMENT updateElement = convertElement(element);
updateElement.ELEMENT_ID = element.ID;
try {
using (ConsoleDataContext db = (ConsoleDataContext)MainFactory.getDb("Console", false)) {
var details = db.ELEMENTs.Where(x => x.ELEMENT_ID == element.ID).FirstOrDefault();
details.ASSIGNED_TO_ID = element.AssignedTo.EmployeeID;
details.ELEMENT_STATUS_ID = (byte)element.Status.ID;
details.PERCENT_COMPLETE = (int)element.PercentComplete;
details.HOURS = element.Hours;
details.RESOLUTION = element.Resolution;
details.CLOSED_DATE = element.ClosedDate;
db.SubmitChanges();
return details;
}
} catch (Exception se) {
throw new Exception(se.Message);
}
}
public ELEMENT saveElement(ElementView element)
{
if (!element.isValid())
throw new Exception("There is an issue with your element.");
ELEMENT details = convertElement(element);
try {
using (ConsoleDataContext db = (ConsoleDataContext)MainFactory.getDb("Console", false)) {
db.ELEMENTs.InsertOnSubmit(details);
db.SubmitChanges();
return details;
}
} catch (Exception se) {
throw new Exception("Unable to save new element due to " + se.Message);
}
}
