public ActionResult VisaReport()
{
EmpVisaItem data = TempData["data"] as EmpVisaItem;
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(data));
}
public ActionResult Create()
{
int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
objVisas = new EmpVisaService();
ViewBag.Empid = Empid;
List <EmpVisaItem> listVisa = new List <EmpVisaItem>();
listVisa = objVisas.VisaListData(Empid);
EmpVisaItem objlistVisaitem = new EmpVisaItem();
objlistVisaitem.ListVisa = new List <EmpVisaItem>();
objlistVisaitem.ListVisa.AddRange(listVisa);
List <clsMasterData> lstMData = new List <clsMasterData>();
lstMData = objVisas.GetVisaStatus();
objlistVisaitem.MasterDetails = new List <clsMasterData>();
objlistVisaitem.MasterDetails.AddRange(lstMData);
listVisa = objVisas.GetVisaDoc(Empid);
objlistVisaitem.ListVisaDoc = new List <EmpVisaItem>();
objlistVisaitem.ListVisaDoc.AddRange(listVisa);
#region For Emirates Bind
List <clsMasterData> lstEmirates = new List <clsMasterData>();
lstEmirates = objVisas.GetEmiratesStatus();
objlistVisaitem.EmiratesList = new List <clsMasterData>();
objlistVisaitem.EmiratesList.AddRange(lstEmirates);
#endregion
#region Bind DropDown Country
List <clsMasterData> lstMasters = new List <clsMasterData>();
lstMasters = objVisas.getCountry();
objlistVisaitem.ListCountry = new List <clsMasterData>();
objlistVisaitem.ListCountry.AddRange(lstMasters);
#endregion
#region ddl company
List <CompanyItem> objCompany = new List <CompanyItem>();
CompanyService objListCompany = new CompanyService();
objCompany = objListCompany.GetALL();
EmployeeItem objEmpItem = new EmployeeItem();
objlistVisaitem.ListComp = new List <CompanyItem>();
objlistVisaitem.ListComp.AddRange(objCompany);
#endregion
#region ddl visa type
List <clsMasterData> lstMData1 = new List <clsMasterData>();
lstMData1 = objVisas.GetVisaType();
objlistVisaitem.ListVisaType = new List <clsMasterData>();
objlistVisaitem.ListVisaType.AddRange(lstMData1);
#endregion
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(objlistVisaitem));
}
public int Update(EmpVisaItem model)
{
Mapper.CreateMap <EmpVisaItem, EmployeeVisa>();
EmployeeVisa objVisa = DbContext.EmployeeVisas.SingleOrDefault(m => m.VId == model.VId);
objVisa = Mapper.Map(model, objVisa);
return(DbContext.SaveChanges());
}
public EmpVisaItem GetById(int id)
{
Mapper.CreateMap <EmployeeVisa, EmpVisaItem>();
EmployeeVisa objVisa = DbContext.EmployeeVisas.SingleOrDefault(m => m.VId == id);
EmpVisaItem objVisaItem = Mapper.Map <EmpVisaItem>(objVisa);
return(objVisaItem);
}
public ActionResult View(int id, int VId)
{
objVisas = new EmpVisaService();
EmpVisaItem objVisaItem = new EmpVisaItem();
objVisaItem = objVisas.GetById(VId);
//ViewBag.empid = objVisaItem.EmpId;
//Session["Empid"] = objPassItem.EmpId;
List <EmpVisaItem> lstPassport = new List <EmpVisaItem>();
objVisaItem.ListVisa = new List <EmpVisaItem>();
objVisaItem.ListVisa.AddRange(lstPassport);
List <clsMasterData> lstMData = new List <clsMasterData>();
lstMData = objVisas.GetVisaStatus();
objVisaItem.ListVisa = new List <EmpVisaItem>();
objVisaItem.ListVisa.AddRange(lstPassport);
objVisaItem.MasterDetails = new List <clsMasterData>();
objVisaItem.MasterDetails.AddRange(lstMData);
ViewBag.Menuid = Request.QueryString["menuId"];
#region Bind DropDown Country
List <clsMasterData> lstMasters = new List <clsMasterData>();
lstMasters = objVisas.getCountry();
objVisaItem.ListCountry = new List <clsMasterData>();
objVisaItem.ListCountry.AddRange(lstMasters);
#endregion
#region For Emirates Bind
List <clsMasterData> lstEmirates = new List <clsMasterData>();
lstEmirates = objVisas.GetEmiratesStatus();
objVisaItem.EmiratesList = new List <clsMasterData>();
objVisaItem.EmiratesList.AddRange(lstEmirates);
#endregion
#region ddl company
List <CompanyItem> objCompany = new List <CompanyItem>();
CompanyService objListCompany = new CompanyService();
objCompany = objListCompany.GetALL();
EmployeeItem objEmpItem = new EmployeeItem();
objVisaItem.ListComp = new List <CompanyItem>();
objVisaItem.ListComp.AddRange(objCompany);
#endregion
#region ddl visa type
List <clsMasterData> lstMData1 = new List <clsMasterData>();
lstMData1 = objVisas.GetVisaType();
objVisaItem.ListVisaType = new List <clsMasterData>();
objVisaItem.ListVisaType.AddRange(lstMData1);
#endregion
return(View(objVisaItem));
}
public int Insert(EmpVisaItem model)
{
try
{
Mapper.CreateMap <EmpVisaItem, EmployeeVisa>();
EmployeeVisa objVisa = Mapper.Map <EmployeeVisa>(model);
DbContext.EmployeeVisas.Add(objVisa);
return(DbContext.SaveChanges());
}
catch (Exception ex)
{
throw;
}
}
public ActionResult VisaReport(EmpVisaItem model)
{
string expdt;
if (Convert.ToString(model.withinDays) != "")
{
expdt = "";
}
else
{
expdt = Convert.ToString(model.ExpiryDate);
}
EmpVisaItem objAllItem = new EmpVisaItem();
ReportService objclsmethod = new ReportService();
int cid = 0;
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
if (expdt != "")
{
DateTime date = Convert.ToDateTime(model.ExpiryDate);
string day = Convert.ToString(model.withinDays);
List <EmpVisaItem> objMaster = objclsmethod.getVisaRpt(date, cid);
objAllItem.ListVisa = new List <EmpVisaItem>();
objAllItem.ListVisa.AddRange(objMaster);
}
else if (Convert.ToString(model.withinDays) != "")
{
string day = Convert.ToString(model.withinDays);
List <EmpVisaItem> objMaster = objclsmethod.getVisabyDay(day, cid);
objAllItem.ListVisa = new List <EmpVisaItem>();
objAllItem.ListVisa.AddRange(objMaster);
}
else
{
List <EmpVisaItem> objMaster = objclsmethod.getVisaAllRpt(cid);
objAllItem.ListVisa = new List <EmpVisaItem>();
objAllItem.ListVisa.AddRange(objMaster);
}
TempData["data"] = objAllItem;
//return View(objAllItem);
return(RedirectToAction("VisaReport", new { @menuId = model.Viewbagidformenu }));
}
public ActionResult delete(int id, int VId, int menuid)
{
//int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
EmpVisaService objService = new EmpVisaService();
List <EmpVisaItem> lstItem = new List <EmpVisaItem>();
EmpVisaItem objDoc = new EmpVisaItem();
objDoc = objService.GetById(VId);
db.EmployeeVisas.Remove(db.EmployeeVisas.Find(VId));
db.SaveChanges();
//ViewBag.Empid = Empid;
ViewBag.Menuid = Request.QueryString["menuId"];
return(RedirectToAction("Create", new { @id = id, @menuId = Request.QueryString["menuId"] }));
}
public ActionResult Edit(EmpVisaItem model)
{
int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
model.EmpId = Empid;
string uid = null;
if (Session["UserId"] != null)
{
uid = Session["UserId"].ToString();
}
model.UpdatedBy = uid;
model.UpdatedDate = System.DateTime.Now;
objVisas = new EmpVisaService();
model.CreatedDate = System.DateTime.Now;
objVisas.Update(model);
ViewBag.Empid = Empid;
return(RedirectToAction("Create", new { @id = Empid, @menuId = model.Viewbagidformenu }));
}
