/* Author: Wenyu Zhang*/
public void createLLd_ATS(LLD_ATS ats)
{
using (var context = new MockERKSDb())
{
context.LLD_ATS.Add(ats);
context.SaveChanges();
}
}
/* Author: Wenyu Zhang*/
public void createLLD_PBL(LLD_PBL pbl)
{
using (var context = new MockERKSDb())
{
context.LLD_PBL.Add(pbl);
context.SaveChanges();
}
}
/* Author: Wenyu Zhang*/
public void createOperation(Operation oper)
{
using (var context = new MockERKSDb())
{
context.Operations.Add(oper);
context.SaveChanges();
}
}
/* Author: Wenyu Zhang*/
public void createLocation(Site_Address address)
{
using (var context = new MockERKSDb())
{
context.Site_Address.Add(address);
context.SaveChanges();
}
}
public void File_Add(Site_File item, int id)
{
using (var context = new MockERKSDb())
{
item.Organization_ID = id;
context.Site_File.Add(item);
context.SaveChanges();
}
}
public void Officer_Add(Officer item)
{
using (var context = new MockERKSDb())
{
//any business rules
context.Officers.Add(item);
context.SaveChanges();
}
}
public void Client_Update(Organization item)
{
using (var context = new MockERKSDb())
{
context.Entry(item).State =
System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Officer_Update(Officer item)
{
using (var context = new MockERKSDb())
{
context.Entry(item).State =
System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
/* Author: Wenyu Zhang */
public void file_update(int fileID, int organizationId)
{
using (var context = new MockERKSDb())
{
Site_File file = (from x in context.Site_File
where x.File_ID == fileID
select x).FirstOrDefault();
file.Organization_ID = organizationId;
context.Site_File.Attach(file);
context.Entry(file).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void File_Update(Site_File file)
{
using (var context = new MockERKSDb())
{
context.Site_File.Attach(file);
file.File_Status = string.IsNullOrEmpty(file.File_Status) ? null : file.File_Status;
context.Entry(file).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void RegisterOrganization(string organizationName, int description, string phone, string email, string userName)
{
using (var context = new MockERKSDb())
{
Organization newOrg = new Organization();
newOrg.Organization_Name = organizationName;
newOrg.Description_ID = description;
newOrg.Email = email;
newOrg.Phone = phone;
newOrg.User_Name = userName;
context.Organizations.Add(newOrg);
context.SaveChanges();
}
}
public void Client_Delete(int organizationId)
{
using (var context = new MockERKSDb())
{
var existing = context.Organizations.Find(organizationId);
if (existing == null)
{
throw new Exception("Client/Organization does not exists on database.");
}
context.Organizations.Remove(existing);
context.SaveChanges();
}
}
public void Officer_Delete(int Officerid)
{
using (var context = new MockERKSDb())
{
var existing = context.Officers.Find(Officerid);
if (existing == null)
{
throw new Exception("Officer does not exists on database.");
}
context.Officers.Remove(existing);
context.SaveChanges();
}
}
public void DeleteFile(int fileID)
{
using (var context = new MockERKSDb())
{
//TODO: Find the file
var file = context.Site_File.Find(fileID);
if (file == null)
{
throw new ArgumentException("This file doesn't exist");
}
//Getting rid of all the Foreign Key Associted with the class.
bool categoryMatch = context.Categories.Any(x => x.Category_ID == file.Category_ID);
if (!categoryMatch)
{
throw new Exception("No Category exists");
}
else
{
context.Categories.Remove(file.Category);
}
bool typeMatch = context.Document_Type.Any(x => x.Document_Type_ID == file.Document.Document_Type_ID);
if (!typeMatch)
{
throw new Exception("No Document Type Exists");
}
else
{
context.Document_Type.Remove(file.Document.Document_Type);
}
bool operMatch = context.Operations.Any(x => x.Operation_ID == file.Operation_ID);
if (!operMatch)
{
throw new Exception("No Operation is associated with that message.");
}
else
{
context.Operations.Remove(file.Operation);
}
bool orgMatch = context.Organizations.Any(x => x.Organization_ID == file.Organization_ID);
if (!orgMatch)
{
throw new Exception("No Organization is associated with that file.");
}
else
{
context.Organizations.Remove(file.Organization);
}
bool addressMatch = context.LLD_PBL.Any(x => x.PBL_ID == file.PBL_ID);
if (!addressMatch)
{
throw new Exception("No Address has been found....");
}
else
{
context.LLD_PBL.Remove(file.LLD_PBL);
}
bool filetypeMatch = context.File_Type.Any(x => x.Type_ID == file.Type_ID);
if (!filetypeMatch)
{
throw new Exception("No File Type has been found");
}
else
{
context.File_Type.Remove(file.File_Type);
}
context.Security_Classification.Remove(file.Security_Classification);
context.Site_File.Remove(file);
context.SaveChanges();
}
}
