public static string Copy(Guid OrgId, int DepartmentId, int ModelID, int MakeID)
{
using (lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrgId, DepartmentId, lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext.TransactionMode.ImmediateOpenConnection))
{
var Models = from t in dc.AssetModels where t.Id == ModelID && t.DepartmentId == DepartmentId select t;
var Model = Models.FirstOrNull();
if (Model == null)
{
return("Can not find specified asset model.");
}
string ModelName = Model.Model;
string ModelLinks = Model.Links;
Models = from t in dc.AssetModels where t.DepartmentId == DepartmentId && t.MakeId == MakeID && t.Model == ModelName select t;
Model = Models.FirstOrNull();
if (Model != null)
{
return("'" + ModelName + "' asset model already exists in destination asset make. Copy operation is not allowed.");
}
lib.bwa.bigWebDesk.LinqBll.Context.AssetModels NewModel = new lib.bwa.bigWebDesk.LinqBll.Context.AssetModels();
NewModel.MakeId = MakeID;
NewModel.DepartmentId = DepartmentId;
NewModel.Model = ModelName;
NewModel.Links = ModelLinks;
dc.AssetModels.InsertOnSubmit(NewModel);
dc.SubmitChanges();
return(null);
}
}
public static int?GetModelId(lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc, int DepartmentID, string Name, int?AssetMakeId)
{
if (string.IsNullOrEmpty(Name))
{
return(null);
}
IQueryable <int> IDs;
IDs = from d in dc.AssetModels where d.DepartmentId == DepartmentID && d.Model == Name select d.Id;
foreach (int ID in IDs)
{
return(ID);
}
if (AssetMakeId == null)
{
return(null);
}
lib.bwa.bigWebDesk.LinqBll.Context.AssetModels data = new lib.bwa.bigWebDesk.LinqBll.Context.AssetModels();
data.DepartmentId = DepartmentID;
data.Model = Name;
data.MakeId = (int)AssetMakeId;
dc.AssetModels.InsertOnSubmit(data);
dc.SubmitChanges();
return(data.Id);
}
public static string Copy(Guid OrgId, int DepartmentId, int ModelID, int MakeID)
{
using (lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrgId, DepartmentId, lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext.TransactionMode.ImmediateOpenConnection))
{
var Models = from t in dc.AssetModels where t.Id == ModelID && t.DepartmentId == DepartmentId select t;
var Model = Models.FirstOrNull();
if (Model == null) return "Can not find specified asset model.";
string ModelName = Model.Model;
string ModelLinks = Model.Links;
Models = from t in dc.AssetModels where t.DepartmentId == DepartmentId && t.MakeId == MakeID && t.Model == ModelName select t;
Model = Models.FirstOrNull();
if (Model != null) return "'" + ModelName + "' asset model already exists in destination asset make. Copy operation is not allowed.";
lib.bwa.bigWebDesk.LinqBll.Context.AssetModels NewModel = new lib.bwa.bigWebDesk.LinqBll.Context.AssetModels();
NewModel.MakeId = MakeID;
NewModel.DepartmentId = DepartmentId;
NewModel.Model = ModelName;
NewModel.Links = ModelLinks;
dc.AssetModels.InsertOnSubmit(NewModel);
dc.SubmitChanges();
return null;
}
}
public static int? GetModelId(lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc, int DepartmentID, string Name, int? AssetMakeId)
{
if (string.IsNullOrEmpty(Name)) return null;
IQueryable<int> IDs;
IDs = from d in dc.AssetModels where d.DepartmentId == DepartmentID && d.Model == Name select d.Id;
foreach (int ID in IDs) return ID;
if (AssetMakeId == null) return null;
lib.bwa.bigWebDesk.LinqBll.Context.AssetModels data = new lib.bwa.bigWebDesk.LinqBll.Context.AssetModels();
data.DepartmentId = DepartmentID;
data.Model = Name;
data.MakeId = (int)AssetMakeId;
dc.AssetModels.InsertOnSubmit(data);
dc.SubmitChanges();
return data.Id;
}