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 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);
}
