public IEnumerable <Vw_FileUploaded> GetUploadedFiles()
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return(context.Vw_FileUploaded.ToList().AsEnumerable());
}
}
public List <tblDepartment> GetDepartment()
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from a in context.tblDepartments select a).ToList());
}
}
public List <tbl_FileType> GetFileType()
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from a in context.tbl_FileType select a).ToList());
}
}
//public List<Branch> GetSubBranches(Company c)
//{
// DeadlineManagementContext context = new DeadlineManagementContext();
// u sing (context)
// return (from sc in context.branches
// .Include(x => x.company)
// where sc.company.Id == c.Id
// select sc).ToList();
//}
public List <tblBranch> GetBranch()
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from a in context.tblBranches select a).ToList());
}
}
public List <tblFileCategory> GetFileCategory()
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from a in context.tblFileCategories
select a).ToList());
}
}
public List <tblBranch> GetBranch(int c)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
return((from sc in context.tblBranches
where sc.Company_Id == c
select sc).ToList());
}
public List <tbl_FileType> GetFileType(int d)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
return((from sc in context.tbl_FileType
where sc.FileCategory_Id == d
select sc).ToList());
}
public List <tblDepartment> GetDepartment(int d)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
return((from sc in context.tblDepartments
where sc.Branch_Id == d
select sc).ToList());
}
public List <Vw_UploadedFileEdit> FindUploadedfile(int f)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from a in context.Vw_UploadedFileEdit
where a.FileUploadedId == f
select a).ToList());
}
}
public int GetBranchByDepartment(int departid)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from sc in context.tblDepartments
where sc.Id == departid
select sc.Branch_Id).FirstOrDefault());
}
}
public List <Vw_PendingFiles> GetPendingFiles(int filecategory)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return((from sc in context.Vw_PendingFiles
where sc.FileCategory_Id == filecategory
select sc).ToList());
}
}
public int GetFileDetail(int file, int department)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
return(Convert.ToInt32((from sc in context.tblToUploads
where sc.department_Id == department && sc.filetype_Id == file
select sc.Id).FirstOrDefault()));
}
}
public bool GetFilesUploaded(tblFileUploaded f)
{
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
using (context)
{
context.tblFileUploadeds.Add(f);
context.SaveChanges();
return(true);
}
}
}
//public List<Branch> GetBranch(Company c)
//{
// DeadlineManagementContext context = new DeadlineManagementContext();
// using (context)
// return (from sc in context.branches
// .Include(x => x.company)
// where sc.Id == c.Id
// select sc).ToList();
//}
public string GetUserexists(string name, string password)
{
string username;
ComfortComplianceDeadlineDBEntities1 context = new ComfortComplianceDeadlineDBEntities1();
using (context)
{
var userlist = (from u in context.tblUsers
where u.FirstName == name && u.Password == password
select u
).ToList().FirstOrDefault();
username = userlist.SecondName;
}
return(username);
}
