public CompanyModel Save(CompanyModel company)
{
var dc = new SQLLINQ.Models.FMSContext();
var dbCompany = new SQLLINQ.Models.Company();
if (company.CompanyID == -1)
{
dbCompany.CompanyName = company.CompanyName;
dbCompany.CompanyLogo = company.CompanyLogo;
dbCompany.Address = company.Address;
dbCompany.ContactNumber = company.ContactNumber;
dbCompany.Email = company.Email;
dc.Company.Add(dbCompany);
}
else
{
dbCompany = dc.Company.Where(x => x.CompanyId == company.CompanyID).SingleOrDefault();
if (dbCompany != null)
{
dbCompany.CompanyId = company.CompanyID;
dbCompany.CompanyName = company.CompanyName;
dbCompany.CompanyLogo = company.CompanyLogo;
dbCompany.Address = company.Address;
dbCompany.ContactNumber = company.ContactNumber;
dbCompany.Email = company.Email;
}
}
dc.SaveChanges();
return(company);
}
public static new List <SQLLINQ.Models.CompanyFile> List()
{
var dc = new SQLLINQ.Models.FMSContext();
var dbFile = dc.CompanyFile.Where(x => x.IsDeleted == false).ToList();
var fileList = new List <SQLLINQ.Models.CompanyFile>();
//var compId = dc.Company.Where(x => x.CompanyId);
foreach (var compFile in dbFile)
{
var model = new SQLLINQ.Models.CompanyFile();
model.FileId = compFile.FileId;
model.CompanyId = compFile.CompanyId;
model.FileName = compFile.FileName;
model.FileType = compFile.FileType;
model.RawFileName = compFile.RawFileName;
model.Description = compFile.Description;
model.Size = compFile.Size;
model.UploadDate = compFile.UploadDate;
model.ModifiedDate = compFile.ModifiedDate;
model.Favorite = compFile.Favorite;
fileList.Add(model);
}
return(fileList.OrderBy(x => x.FileName).ToList());
}
public static double getTotalFileSize(long companyID)
{
var dc = new SQLLINQ.Models.FMSContext();
var sum = dc.CompanyFile.Where(x => x.CompanyId == companyID & x.IsDeleted == false).Sum(x => x.Size);
return(sum);
}
public static new List <SQLLINQ.Models.Company> List()
{
var dc = new SQLLINQ.Models.FMSContext();
var dbCompany = dc.Company.Where(x => x.IsDeleted == false).ToList();
var companyList = new List <SQLLINQ.Models.Company>();
foreach (var comp in dbCompany)
{
var model = new SQLLINQ.Models.Company();
model.CompanyId = comp.CompanyId;
model.CompanyName = comp.CompanyName;
model.CompanyLogo = comp.CompanyLogo;
model.Address = comp.Address;
model.ContactNumber = comp.ContactNumber;
model.Email = comp.Email;
companyList.Add(model);
}
return(companyList.OrderBy(x => x.CompanyName).ToList());
}
public static bool setDeleted(string id)
{
try
{
var dc = new SQLLINQ.Models.FMSContext();
var dbCompany = new SQLLINQ.Models.Company();
dbCompany = dc.Company.Where(x => x.CompanyId == Convert.ToInt64(id)).SingleOrDefault();
if (dbCompany != null)
{
dbCompany.IsDeleted = true;
}
dc.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static bool setRestore(string id)
{
try
{
var dc = new SQLLINQ.Models.FMSContext();
var dbFile = new SQLLINQ.Models.CompanyFile();
dbFile = dc.CompanyFile.Where(x => x.FileId == Convert.ToInt64(id)).SingleOrDefault();
if (dbFile != null)
{
dbFile.IsDeleted = false;
}
dc.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public FileModel Save(FileModel file)
{
var dc = new SQLLINQ.Models.FMSContext();
var dbFile = new SQLLINQ.Models.CompanyFile();
if (file.FileID == -1)
{
dbFile.CompanyId = file.CompanyID;
dbFile.FileName = file.FileName;
dbFile.FileType = file.FileType;
dbFile.RawFileName = file.RawFileName;
dbFile.Description = file.Description;
dbFile.Size = file.Size;
dbFile.UploadDate = file.UploadDate;
dbFile.ModifiedDate = file.ModifiedDate;
dbFile.Favorite = file.Favorite;
dc.CompanyFile.Add(dbFile);
}
else
{
dbFile = dc.CompanyFile.Where(x => x.FileId == file.FileID).FirstOrDefault();
if (dbFile != null)
{
dbFile.FileId = file.FileID;
dbFile.CompanyId = file.CompanyID;
dbFile.FileName = file.FileName;
dbFile.FileType = file.FileType;
dbFile.RawFileName = file.RawFileName;
dbFile.Description = file.Description;
dbFile.Size = file.Size;
dbFile.UploadDate = file.UploadDate;
dbFile.ModifiedDate = file.ModifiedDate;
dbFile.Favorite = file.Favorite;
}
}
dc.SaveChanges();
return(file);
}
public static bool setFavorite(string id)
{
var dc = new SQLLINQ.Models.FMSContext();
var dbFile = new SQLLINQ.Models.CompanyFile();
var fav = 0;
dbFile = dc.CompanyFile.Where(x => x.FileId == Convert.ToInt64(id)).SingleOrDefault();
if (dbFile != null)
{
if (dbFile.Favorite != 1)
{
fav = 1;
}
}
if (dbFile.Favorite != 0)
{
fav = 0;
}
dbFile.Favorite = fav;
dc.SaveChanges();
return(true);
}
