public ActionResult EmployeeSetup(int empCode = 0)
{
//CRM.Models.clsSubmitModel oSubmit = new CRM.Models.clsSubmitModel();
EmployeeSetup frm = new EmployeeSetup();
var vwDept = from a in db.studdets where a.studType == 11 orderby a.studName select new { itgpName = a.studName, itgpcode = a.studCode };
ViewBag.mstDept = new SelectList(vwDept, "itgpcode", "itgpName");
var vwDesi = from a in db.studdets where a.studType == 1233 orderby a.studName select new { itgpName = a.studName, itgpcode = a.studCode };
ViewBag.iEAcc_empodesg = new SelectList(vwDesi, "itgpcode", "itgpName");
var vwState = from a in db.citydets where a.cityType == 67 && a.cityrute == 3 select new { a.citycode, a.cityname };
ViewBag.vwState = new SelectList(vwState, "citycode", "cityname");
ViewBag.vwBank = new SelectList(from a in db.studdets where a.studType == 163 select new { a.studCode, a.studName }, "studCode", "studName");
if (empCode > 0)
{
frm = oSubmit.GetEmployeeDet("select empCode iEmp_empcode , empname sEmp_empname, PAN sEmp_PAN, Gender iEmp_Gender, ProofNo sEmp_ProofNo, AcNo sEmp_AcNo, Official_No sOfficial_No,Residential_No sResidential_No,ReferenceNm sReferenceNm , ReferenceNo sReferenceNo,FatherNo sFatherNo, TemporaryAdd sTemporaryAdd, PermanentAdd sPermanentAdd,EmailID sEmailID ,BirthDt dEAcc_BirthDt ,Father ,Aadhar ,IFSC ,DegreeNM ,DegreeID ,empcity iEmp_empcity ,empStat sEmp_empstat ,BloodGroup sBloodGroup ,PfAcNo ,BankID ,empDepa mstDept,empDesi iEAcc_empodesg , IMG_Path sPath, IMG_Path ,AadharCard , VoterId , Licence , Passport , Statement , Degree from employee where empcode = " + empCode);
if (frm.IMG_Path != null && frm.IMG_Path.ToString() != "")
{
ViewBag.vbImgPath = frm.IMG_Path;
}
else
{
ViewBag.vbImgPath = "../../img/avatar.png";
}
frm.dEAcc_BirthDts = Convert.ToDateTime(frm.dEAcc_BirthDt).ToString("dd/MM/yyyy");
frm.isEdit = true;
}
else
{
DataTable dt;
dt = oSubmit.GetData("select isnull(max(empcode),0)+1 empcode from employee", true);
frm.iEmp_empcode = Convert.ToInt32(dt.Rows[0]["empcode"]);
ViewBag.vbImgPath = "../../img/avatar.png";
frm.isEdit = false;
}
//frm.lstEmployeeSetup = oSubmit.EmployeeList("select empCode iEmp_empcode , empname sEmp_empname, PAN sEmp_PAN, Gender iEmp_Gender, ProofNo sEmp_ProofNo, AcNo sEmp_AcNo, Official_No sOfficial_No,Residential_No sResidential_No,ReferenceNm sReferenceNm , ReferenceNo sReferenceNo,FatherNo sFatherNo, TemporaryAdd sTemporaryAdd, PermanentAdd sPermanentAdd,EmailID sEmailID from employee");
return(PartialView(frm));
}