public ActionResult PassportReport()
{
EmpPassportItem data = TempData["data"] as EmpPassportItem;
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(data));
}
public ActionResult Create()
{
int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
objpassport = new EmpPassportService();
List <EmpPassportItem> listRel = new List <EmpPassportItem>();
listRel = objpassport.PassportListData(Empid);
ViewBag.Empid = Empid;
EmpPassportItem objPasitem = new EmpPassportItem();
objPasitem.ListPassport = new List <EmpPassportItem>();
objPasitem.ListPassport.AddRange(listRel);
listRel = objpassport.GetPassportDoc(Empid);
objPasitem.ListPassportDoc = new List <EmpPassportItem>();
objPasitem.ListPassportDoc.AddRange(listRel);
#region Bind DropDown Nationality
List <clsMasterData> lstMasters = new List <clsMasterData>();
lstMasters = objpassport.getNationality();
objPasitem.ListNationality = new List <clsMasterData>();
objPasitem.ListNationality.AddRange(lstMasters);
#endregion
#region Bind DropDown Country
//List<clsMasterData> lstMasters = new List<clsMasterData>();
lstMasters = objpassport.getCountry();
objPasitem.ListCountry = new List <clsMasterData>();
objPasitem.ListCountry.AddRange(lstMasters);
#endregion
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(objPasitem));
}
public ActionResult View(int id, int PasId)
{
EmpPassportService objPassService = new EmpPassportService();
EmpPassportItem objPassItem = new EmpPassportItem();
objPassItem = objPassService.GetById(PasId);
//Session["Empid"] = objPassItem.EmpId;
List <EmpPassportItem> lstPassport = new List <EmpPassportItem>();
objPassItem.ListPassport = new List <EmpPassportItem>();
objPassItem.ListPassport.AddRange(lstPassport);
#region Bind DropDown Nationality
List <clsMasterData> lstMasters = new List <clsMasterData>();
lstMasters = objpassport.getNationality();
objPassItem.ListNationality = new List <clsMasterData>();
objPassItem.ListNationality.AddRange(lstMasters);
#endregion
#region Bind DropDown Country
//List<clsMasterData> lstMasters = new List<clsMasterData>();
lstMasters = objpassport.getCountry();
objPassItem.ListCountry = new List <clsMasterData>();
objPassItem.ListCountry.AddRange(lstMasters);
#endregion
ViewBag.PId = PasId;
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(objPassItem));
}
public int Update(EmpPassportItem model)
{
Mapper.CreateMap <EmpPassportItem, EmployeePassport>();
EmployeePassport objPass = DbContext.EmployeePassports.SingleOrDefault(m => m.Id == model.Id);
objPass = Mapper.Map(model, objPass);
return(DbContext.SaveChanges());
}
public EmpPassportItem GetById(int id)
{
Mapper.CreateMap <EmployeePassport, EmpPassportItem>();
EmployeePassport objPassport = DbContext.EmployeePassports.SingleOrDefault(m => m.Id == id);
EmpPassportItem objPassItem = Mapper.Map <EmpPassportItem>(objPassport);
return(objPassItem);
}
public int Insert(EmpPassportItem model)
{
try
{
Mapper.CreateMap <EmpPassportItem, EmployeePassport>();
EmployeePassport objEmpPassport = Mapper.Map <EmployeePassport>(model);
DbContext.EmployeePassports.Add(objEmpPassport);
return(DbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult PassportReport(EmpPassportItem model)
{
string expdt;
if (Convert.ToString(model.withinDays) != "")
{
expdt = "";
}
else
{
expdt = Convert.ToString(model.ExpiryDate);
}
EmpPassportItem objAllItem = new EmpPassportItem();
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 <EmpPassportItem> objMaster = objclsmethod.getPassportRpt(date, cid);
objAllItem.ListPassRpt = new List <EmpPassportItem>();
objAllItem.ListPassRpt.AddRange(objMaster);
}
else if (Convert.ToString(model.withinDays) != "")
{
string day = Convert.ToString(model.withinDays);
List <EmpPassportItem> objMaster = objclsmethod.getPassportbyDay(day, cid);
objAllItem.ListPassRpt = new List <EmpPassportItem>();
objAllItem.ListPassRpt.AddRange(objMaster);
}
else
{
List <EmpPassportItem> objMaster = objclsmethod.getPassportAllRpt(cid);
objAllItem.ListPassRpt = new List <EmpPassportItem>();
objAllItem.ListPassRpt.AddRange(objMaster);
}
TempData["data"] = objAllItem;
return(RedirectToAction("PassportReport", new { @menuId = model.Viewbagidformenu }));
}
public ActionResult delete(int id, int PId, int menuid)
{
//int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
EmpPassportService objService = new EmpPassportService();
List <EmpPassportItem> lstItem = new List <EmpPassportItem>();
EmpPassportItem objDoc = new EmpPassportItem();
objDoc = objService.GetById(PId);
db.EmployeePassports.Remove(db.EmployeePassports.Find(PId));
db.SaveChanges();
//ViewBag.Empid = Empid;
ViewBag.Menuid = Request.QueryString["menuId"];
return(RedirectToAction("Create", new { @id = id, @menuId = Request.QueryString["menuId"] }));
}
public ActionResult Create(EmpPassportItem model)
{
model.Status = "Active";
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.CreatedBy = uid;
model.CreatedDate = System.DateTime.Now;
objpassport = new EmpPassportService();
objpassport.Insert(model);
return(RedirectToAction("Create", new { @menuId = model.Viewbagidformenu }));
}
public ActionResult Edit(EmpPassportItem model)
{
model.Id = model.PasId;
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;
EmpPassportService objPass = new EmpPassportService();
objPass.Update(model);
ViewBag.Empid = Empid;
return(RedirectToAction("Create", new { id = Empid, @menuId = model.Viewbagidformenu }));
}
public List <EmpAllItem> GetALLDetails(int FID, int cid)
{
// Mapper.Initialize(cfg =>
// {
// cfg.CreateMap<EmployeeContact, EmpContactItem>();
// cfg.CreateMap<EmployeePassport, EmpPassportItem>();
// cfg.CreateMap<EmployeeRelative, EmpRelativeItem>();
// });
// List<EmpAllItem> a = new List<EmpAllItem>();
// return a ;
EmpContactItem ContactItem = new EmpContactItem();
EmpPassportItem PassportItem = new EmpPassportItem();
List <EmployeeItem> a = new List <EmployeeItem>();
var ab = (from Emp in DbContext.employee_master
join Contact in DbContext.EmployeeContacts on Emp.id equals Contact.EmpId into Contact1
from C in Contact1.DefaultIfEmpty()
join Passport in DbContext.EmployeePassports on Emp.id equals Passport.EmpId into Passport1
from P in Passport1.DefaultIfEmpty()
join Relative in DbContext.EmployeeRelatives on Emp.id equals Relative.EmpId into Relative1
from R in Relative1.DefaultIfEmpty()
join Company in DbContext.Company_master on Emp.Compid equals Company.id into Company1
from Companys in Company1.DefaultIfEmpty()
join Branch in DbContext.Branch_master on Emp.Branchid equals Branch.id into BranchMst
from Branchs in BranchMst.DefaultIfEmpty()
//where Emp.Compid == (Compid == 0 ? Emp.Compid : Compid)
where Emp.WorkingStatus == (FID == 0 ? Emp.WorkingStatus : FID) && Emp.Compid == (cid == 0 ? Emp.Compid : cid)
select new EmpAllItem
{
//EmpContactItem = new EmpContactItem()
//{
// Area = C.Area,
// City = C.City,
//},
EmployeeItem = new EmployeeItem()
{
Empno = Emp.Empno,
Empname = Emp.Empname,
Mobile = Emp.Mobile,
id = Emp.id,
JobTitle = Emp.JobTitle
},
//EmpPassportItem = new EmpPassportItem()
//{
// PassportNo = P.PassportNo
//},
//EmpRelativeItem = new EmpRelativeItem()
//{
// RName = R.RName,
// RAddress = R.RAddress
//},
CompanyItem = new CompanyItem()
{
CompName = Companys.CompName,
},
BranchItem = new BranchItem()
{
BranchName = Branchs.BranchName
}
//Company = Companys.CompName
}
).Distinct().ToList();
return(ab);
//
}
