public List<SelectListItem> DesignationList() { using (RecruitEntities Recruit = new RecruitEntities()) { List<SelectListItem> dList = Recruit.OutSourcingDesignations.Select(em => new SelectListItem { Value = em.DesignationCode, Text = em.DesignationCode + " -- " + em.DesignationName }).ToList(); return dList; } }
public List<SelectListItem> DepartmentList() { using (RecruitEntities Recruit = new RecruitEntities()) { List<SelectListItem> dList = Recruit.Department().Select(em => new SelectListItem { Value = em.DepartmentCode, Text = em.DepartmentCode + "--" + em.DepartmentName }).ToList(); return dList; } }
public List<SelectListItem> CoorNameList() { using (RecruitEntities recruit = new RecruitEntities()) { //modified by priya //var apl = recruit.AppointmentProjects.Select(a => new SelectListItem() { Text = a.PICode + "-" + a.PIName, Value = a.PICode }).ToList(); //return apl; var apl = recruit.AppointmentProjects.GroupBy(em => new { em.PICode, em.PIName }).OrderBy(g => g.Key).Select(g => g.Key).ToList(); return apl.Select(a => new SelectListItem() { Text = a.PICode + "-" + a.PIName, Value = a.PIName }).ToList(); //original //List<string> apl = recruit.AppointmentProjects.GroupBy(em => em.PICode).OrderBy(g=>g.Key).Select(g => g.Key).ToList(); //List<SelectListItem> cl = new List<SelectListItem>(); //modified by priya //apl.ForEach(delegate (string piCode) //{ // cl.Add(recruit.Coordinator(piCode).Select(em => new SelectListItem { Text = em.CoorCode + " - " + em.CoorName, Value = em.CoorCode }).FirstOrDefault()); //}); } }
static void Main(string[] args) { RecruitEntities olddb = new RecruitEntities(); RECRUITMENTEntities newdb = new RECRUITMENTEntities(); List <NEWADH> newadhoslist = olddb.NEWADH.ToList(); //foreach (var sin in newadhoslist) //{ // PAY_DETAIL pd = new PAY_DETAIL(); // pd.BAISC = sin.BASIC; // pd.FILENO = sin.FILENO; // pd.HRA = sin.HRA; // pd.INCR = sin.INCR; // pd.PAYBILL_ID = sin.paybill_id; // pd.PAYBILL_NO = sin.paybill_no; // newdb.PAY_DETAIL.Add(pd); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} //foreach (var din in newadhoslist) //{ // PERSONAL_INFO gd = new PERSONAL_INFO(); // gd.ADDRESS1 = din.ADDRESS1; // gd.ADDRESS2 = din.ADDRESS2; // gd.ADDRESS3 = din.ADDRESS3; // gd.ADDRESS4 = din.ADDRESS4; // gd.BLDGRP = din.BLDGRP; // gd.CITY = din.CITY; // gd.DOB = din.DOB; // gd.EMAIL_ID = din.email_id; // gd.FATHER = din.FATHER; // gd.FILENO = din.FILENO; // gd.NAME = din.NAME; // gd.PENSIONER = din.Pensioner; // gd.PHONE = din.PHONE; // gd.QUALIFICATION = din.Qualification; // gd.RH = din.RH; // gd.R_ADDR1 = din.R_ADDR1; // gd.R_ADDR2 = din.R_ADDR2; // gd.R_ADDR3 = din.R_ADDR3; // gd.R_ADDR4 = din.R_ADDR4; // gd.R_CITY = din.R_CITY; // gd.R_PHONE = din.R_PHONE; // gd.R_PIN = din.R_PIN; // gd.SCSTOS = din.SCSTOS; // gd.SEX = din.SEX; // newdb.PERSONAL_INFO.Add(gd); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} //foreach (var tin in newadhoslist) //{ // PROJECT_INFO sd = new PROJECT_INFO(); // sd.COO = tin.COO; // sd.COOR = tin.COOR; // sd.FILENO = tin.FILENO; // sd.PROJECTNO = tin.PROJECTNO; // sd.PTYPE = tin.PTYPE; // sd.SPON = tin.SPON; // sd.TITLE = tin.TITLE; // newdb.PROJECT_INFO.Add(sd); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} //foreach (var pin in newadhoslist) //{ // EMP_DETAIL dd = new EMP_DETAIL(); // dd.DEPARTMENT = pin.DEPARTMENT; // dd.DEPT = pin.DEPT; // dd.DESIG = pin.DESIG; // dd.DESIGN = pin.DESIGN; // dd.DRLF = pin.DRLF; // dd.DTAP = pin.DTAP; // dd.EXTN = pin.EXTN; // dd.EXTN_DATE = pin.extn_date; // dd.FILENO = pin.FILENO; // dd.OLD_FILENO = pin.OLD_FILENO; // dd.STAT = pin.STAT; // newdb.EMP_DETAIL.Add(dd); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} //foreach (var fin in newadhoslist) //{ // MS_PHD ss = new MS_PHD(); // ss.COURSE = fin.COURSE; // ss.FILENO = fin.FILENO; // ss.SEMESTER = fin.SEMESTER; // ss.YR = fin.YR; // newdb.MS_PHD.Add(ss); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} //foreach (var bin in newadhoslist) //{ // META aa = new META(); // aa.DT_CHG = bin.DT_CHG; // aa.DT_INP = bin.DT_INP; // aa.FILENO = bin.FILENO; // newdb.META.Add(aa); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} //foreach (var cin in newadhoslist) //{ // ADDITIONAL_INFO jj = new ADDITIONAL_INFO(); // jj.DINC = cin.DINC; // jj.FILENO = cin.FILENO; // jj.LDINC = cin.LDINC; // jj.MEDICAL = cin.MEDICAL; // jj.MONTH = cin.MONTH; // jj.PCODE = cin.PCODE; // jj.PFLAG = cin.PFLAG; // jj.PROVISIONAL = cin.PROVISIONAL; // jj.RATE = cin.RATE; // jj.REM = cin.REM; // newdb.ADDITIONAL_INFO.Add(jj); // try // { // newdb.SaveChanges(); // } // catch (Exception ex) // { // } //} foreach (var hin in newadhoslist) { RECRUIT_TYPE fin = new RECRUIT_TYPE(); fin.FILENO = hin.FILENO; fin.TYPE = 1; newdb.RECRUIT_TYPE.Add(fin); try { newdb.SaveChanges(); } catch (Exception ex) { } } }