public ActionResult Create(AgentViewModel vm)
{
if (ModelState.IsValid)
{
db = new VirsagiContext();
var agent = new Agent
{
RLName = vm.RLName,
RLNo = vm.RLNo,
RLAddress = vm.RLAddress,
ContactNumber = vm.ContactNumber,
Email = vm.Email,
CreatedDate = vm.CreatedDate
};
db.Agents.Add(agent);
db.SaveChanges();
TempData["isSuccess"] = 1;
return(RedirectToAction("Index"));
}
TempData["isSuccess"] = 0;
return(View("Index", vm));
}
public ActionResult Create(WorkerRequestViewModel vm)
{
if (ModelState.IsValid)
{
db = new VirsagiContext();
var workerRequest = new WorkerRequest
{
RequestType = vm.RequestType,
ContactPerson = vm.ContactPerson,
ContactNumber = vm.ContactNumber,
CompanyUENNumber = vm.CompanyUENNumber,
CompanyName = vm.CompanyName,
Email = vm.Email,
Details = vm.Details,
SpecialRequest = vm.SpecialRequest,
CreatedDate = vm.CreatedDate
};
db.WorkerRequests.Add(workerRequest);
db.SaveChanges();
TempData["isSuccess"] = 1;
return(RedirectToAction("Index"));
}
TempData["isSuccess"] = 0;
return(View("Index", vm));
}
public ActionResult IPASave(IPAViewModel ipaVM)
{
db = new VirsagiContext();
var ipa = new IPA
{
IPAID = ipaVM.IPAID,
PassportNo = ipaVM.PassportNo,
WorkerName = ipaVM.WorkerName,
Employer = ipaVM.Employer,
WorkPermitNo = ipaVM.WorkPermitNo,
ReferenceNo = ipaVM.ReferenceNo,
IssuanceDate = ipaVM.IssuanceDate
};
if (ipaVM.IPAID == 0)
{
db.IPAs.Add(ipa);
db.SaveChanges();
}
else
{
db.IPAs.Add(ipa);
db.Entry(ipa).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("IPA"));
}
public ActionResult Index(string workPermitNo)
{
var fromDate = DateTime.Now.AddDays(-14);
var toDate = DateTime.Now;
db = new VirsagiContext();
var query = (from s in db.IPAs
select new IPAViewModel
{
IPAID = s.IPAID,
PassportNo = s.PassportNo,
WorkerName = s.WorkerName,
Employer = s.Employer,
WorkPermitNo = s.WorkPermitNo,
ReferenceNo = s.ReferenceNo,
IssuanceDate = s.IssuanceDate
}).AsQueryable();
query = query.Where(x => x.IssuanceDate >= fromDate && x.IssuanceDate <= toDate);
if (!String.IsNullOrEmpty(workPermitNo))
{
query = query.Where(x => x.WorkPermitNo == workPermitNo);
}
var data = query.AsEnumerable();
return(View(data));
}
public ActionResult IPA(DateTime?fromDate, DateTime?toDate)
{
db = new VirsagiContext();
var query = (from s in db.IPAs
select new IPAViewModel
{
IPAID = s.IPAID,
PassportNo = s.PassportNo,
WorkerName = s.WorkerName,
Employer = s.Employer,
WorkPermitNo = s.WorkPermitNo,
ReferenceNo = s.ReferenceNo,
IssuanceDate = s.IssuanceDate
}).AsQueryable();
if (fromDate != null && toDate != null)
{
query = query.Where(x => x.IssuanceDate >= fromDate && x.IssuanceDate <= toDate);
}
var data = query.AsEnumerable();
return(View(data));
}
public ActionResult EditNews()
{
db = new VirsagiContext();
var data = db.News.FirstOrDefault();
return(View(data));
}
public ActionResult Dashboard()
{
db = new VirsagiContext();
var data = db.HitCounters.FirstOrDefault();
ViewBag.totalCount = data.TotalCount;
ViewBag.monthlyCount = data.MonthlyCount;
return(View());
}
public ActionResult EditNews(News news)
{
db = new VirsagiContext();
news.LastUpdatedBy = DateTime.Now;
db.News.Add(news);
db.Entry(news).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(View(news));
}
private void AddHitCount()
{
using (VirsagiContext db = new VirsagiContext())
{
var hitCounter = db.HitCounters.FirstOrDefault();
hitCounter.TotalCount++;
hitCounter.MonthlyCount++;
if (DateTime.Now.Day == 1)
{
hitCounter.MonthlyCount = 1;
}
db.HitCounters.Add(hitCounter);
db.Entry(hitCounter).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult Index()
{
db = new VirsagiContext();
var news = (from s in db.News
select new NewsViewModel
{
NewsID = s.NewsID,
NewsHeadline1 = s.NewsHeadline1,
NewsDetails1 = s.NewsDetails1,
NewsHeadline2 = s.NewsHeadline2,
NewsDetails2 = s.NewsDetails2,
NewsHeadline3 = s.NewsHeadline3,
NewsDetails3 = s.NewsDetails3
}).FirstOrDefault();
return(View(news));
}
public ActionResult GetAllRequests(DateTime?filterDate)
{
db = new VirsagiContext();
List <WorkerRequestViewModel> data;
if (filterDate == null)
{
data = (from s in db.WorkerRequests
select new WorkerRequestViewModel
{
RequestTypeString = s.RequestType == 1 ? "Company" : "Agent",
ContactPerson = s.ContactPerson,
ContactNumber = s.ContactNumber,
CompanyUENNumber = s.CompanyUENNumber,
CompanyName = s.CompanyName,
Email = s.Email,
Details = s.Details,
SpecialRequest = s.SpecialRequest,
CreatedDate = s.CreatedDate
}).ToList();
}
else
{
data = (from s in db.WorkerRequests
where DbFunctions.TruncateTime(s.CreatedDate) == filterDate
select new WorkerRequestViewModel
{
RequestTypeString = s.RequestType == 1 ? "Company" : "Agent",
ContactPerson = s.ContactPerson,
ContactNumber = s.ContactNumber,
CompanyUENNumber = s.CompanyUENNumber,
CompanyName = s.CompanyName,
Email = s.Email,
Details = s.Details,
SpecialRequest = s.SpecialRequest,
CreatedDate = s.CreatedDate
}).ToList();
}
return(View(data));
}
public ActionResult GetAllAgents(DateTime?filterDate)
{
db = new VirsagiContext();
List <AgentViewModel> data;
if (filterDate == null)
{
data = (from s in db.Agents
select new AgentViewModel
{
AgentID = s.AgentID,
RLName = s.RLName,
RLNo = s.RLNo,
RLAddress = s.RLAddress,
ContactNumber = s.ContactNumber,
Email = s.Email,
CreatedDate = s.CreatedDate ?? DateTime.Now
}).ToList();
}
else
{
data = (from s in db.Agents
where DbFunctions.TruncateTime(s.CreatedDate) == filterDate
select new AgentViewModel
{
AgentID = s.AgentID,
RLName = s.RLName,
RLNo = s.RLNo,
RLAddress = s.RLAddress,
ContactNumber = s.ContactNumber,
Email = s.Email,
CreatedDate = s.CreatedDate ?? DateTime.Now
}).ToList();
}
return(View(data));
}
public ActionResult IPASave(int?id)
{
if (id != null && id != 0)
{
db = new VirsagiContext();
var data = (from s in db.IPAs
where s.IPAID == id
select new IPAViewModel
{
IPAID = s.IPAID,
PassportNo = s.PassportNo,
WorkerName = s.WorkerName,
Employer = s.Employer,
WorkPermitNo = s.WorkPermitNo,
ReferenceNo = s.ReferenceNo,
IssuanceDate = s.IssuanceDate
}).SingleOrDefault();
return(View(data));
}
return(View());
}
