public bool SaveInDB()
{
try
{
ClassificationDataContext context = new ClassificationDataContext(System.Configuration.ConfigurationManager.ConnectionStrings["ClassificationConnectionStringProd"].ConnectionString);
if (this.ID == -1)
{
tbl_Schema item = new tbl_Schema();
UpdateEntity(item);
item.Status = "New";
context.tbl_Schemas.InsertOnSubmit(item);
context.SubmitChanges();
this.ID = item.record_id;
}
else
{
var query = from entity in context.tbl_Schemas
where entity.record_id == this.ID
select entity;
foreach (var item in query)
{
UpdateEntity(item);
}
context.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
Solr.Utilities.SolrException.WriteError(ex);
}
return(false);
}
private void UpdateEntity(tbl_Schema item)
{
item.Name = this.Name;
item.Description = this.Description;
item.Type = this.Type;
item.Indexed = this.Indexed;
item.Stored = this.Stored;
item.DefaultValue = this.DefaultValue;
item.ModifiedDate = DateTime.Now;
item.ModifiedBy = "jllorin";
}
