public static int addVisitor(BLL.ViewModels.PreVisitors visitor)
{
try
{
using (var db = new DLL.Model.Context())
{
var hostdetail = db.Hosts.Find(visitor.host_id);
DateTime from = DateTime.ParseExact(visitor.from_Date, "d-M-yyyy", CultureInfo.InvariantCulture);
DateTime to = DateTime.ParseExact(visitor.to_date, "d-M-yyyy", CultureInfo.InvariantCulture);
int totaldays = to.Subtract(from).Days;
for (int i = 0; i <= totaldays; i++)
{
DateTime check = from.AddDays(i);
db.previsitors.Add(new DLL.Model.PreVisitors
{
VNIC = visitor.VNIC,
Vaddress = visitor.Vaddress,
Vcompany = visitor.Vcompany,
VfirstName = visitor.VfirstName,
VlastName = visitor.VlastName,
VphoneNo = visitor.VphoneNo,
Date = from.AddDays(i),
Time = visitor.Time,
hemail = visitor.host_email,
CreatedBy = visitor.CreatedBy,
hFirstName = hostdetail.hFirst,
hLastName = hostdetail.hLast,
// hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID,
hcompany = db.Company.Where(m => m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().CompanyName,
status = true
});
}
db.SaveChanges();
}
}
catch (Exception ex)
{
return(-1);
}
return(visitor.ID);
}
public static int editVisitor(BLL.ViewModels.PreVisitors visitor)
{
try
{
using (var db = new DLL.Model.Context())
{
var entity = db.previsitors.Find(visitor.ID);
var hostdetail = db.Hosts.Find(visitor.host_id);
if (entity != null)
{
entity.VNIC = visitor.VNIC;
entity.Vaddress = visitor.Vaddress;
entity.Vcompany = visitor.Vcompany;
entity.VfirstName = visitor.VfirstName;
entity.VlastName = visitor.VlastName;
entity.VphoneNo = visitor.VphoneNo;
entity.hemail = visitor.host_email;
entity.Time = visitor.Time;
entity.hFirstName = hostdetail.hFirst;
entity.hLastName = hostdetail.hLast;
entity.Date = DateTime.ParseExact(visitor.from_Date, "d-M-yyyy", CultureInfo.InvariantCulture);
// hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID,
entity.hcompany = db.Company.Where(m => m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().CompanyName;
entity.status = true;
db.SaveChanges();
return(entity.ID);
}
else
{
return(-1);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
public ActionResult EditVisitor(BLL.ViewModels.PreVisitors visitor)
{
BLL.PreVisitors.editVisitor(visitor);
return(RedirectToAction("ViewVisitor"));
}
public ActionResult AddPreVisitor(BLL.ViewModels.PreVisitors visitor)
{
visitor.CreatedBy = BLL.Admin.getUser(User.Identity.Name).userId.ToString();
BLL.PreVisitors.addVisitor(visitor);
return(RedirectToAction("AddPreVisitor"));
}
