示例#1
0
        public void CreateEmployees(List <EmployeeRequestDetail> detailLst)
        {
            if (detailLst.Any())
            {
                DataTable dt = new DataTable();
                dt.TableName = "CoreEmployee";

                dt.Columns.Add("FirstName", typeof(string));
                dt.Columns.Add("LastName", typeof(string));
                dt.Columns.Add("Pan", typeof(string));
                dt.Columns.Add("BirthDate", typeof(DateTime)).AllowDBNull = true;
                dt.Columns.Add("AddedBy", typeof(string));
                dt.Columns.Add("AddedOn", typeof(DateTime));

                DateTime now = DateTime.Now;
                foreach (var detail in detailLst)
                {
                    DataRow row = dt.NewRow();

                    row["FirstName"] = detail.FirstName;
                    row["LastName"]  = detail.LastName;
                    row["Pan"]       = detail.Pan;
                    row["BirthDate"] = detail.DateOfBirth.HasValue ? (object)detail.DateOfBirth.Value : DBNull.Value;
                    row["AddedBy"]   = detail.Token;
                    row["AddedOn"]   = now;

                    dt.Rows.Add(row);
                }

                _employeeDao.CreateEmployees(dt);
            }
        }