public static String validateBeneficiary(Beneficiary beneficiary) { String error = ""; if (String.IsNullOrEmpty(beneficiary.Subsidiary)) { error += "Campo Sucursal Vacío "; } if (String.IsNullOrEmpty(beneficiary.SubsidiaryName)) { error += "Campo Nombre Sucursal Vacío "; } if (!EFTEC.RutChile.ValidarRut(beneficiary.Rut.ToString() + beneficiary.Div)) { error += "Campo Rut no es valido "; } if (String.IsNullOrEmpty(beneficiary.Name)) { error += "Campo Nombre Vacío "; } else if (beneficiary.Name.Length > 50) { error += "Campo Nombre Excede el Maximo "; } if (String.IsNullOrEmpty(beneficiary.SurnameFather)) { error += "Campo Apellido Paterno Vacío "; } else if (beneficiary.SurnameFather.Length > 50) { error += "Campo Apellido Paterno Excede el Maximo "; } if (String.IsNullOrEmpty(beneficiary.SurnameMother)) { error += "Campo Apellido Materno Vacío "; } else if (beneficiary.SurnameMother.Length > 50) { error += "Campo Apellido Materno Excede el Maximo "; } if (String.IsNullOrEmpty(beneficiary.Email)) { error += "Campo Email Vacío "; } else if (beneficiary.Email.Length > 100) { error += "Campo Email Excede el maximo "; } else if (EmailValidation.EmailValidator.Validate(beneficiary.Email)) { error += "Campo Email es invalido "; } return(error); }
public static void Main(string[] args) { Console.WriteLine("Hello World!"); using (var stream = File.Open(@"/Users/danielhernandez/Downloads/Tarjetas_Personalizadas-2.xlsx", FileMode.Open, FileAccess.Read)) { List <Beneficiary> beneficiaries = new List <Beneficiary>(); var dataSetConfiguration = new ExcelDataSetConfiguration() { UseColumnDataType = false }; using (var reader = ExcelReaderFactory.CreateReader(stream)) { DataTable table = reader.AsDataSet(dataSetConfiguration).Tables["Personalizadas"]; reader.Close(); foreach (DataRow row in table.Rows) { var rut = EFTEC.RutChile.ConvierteTipoRut(row[2].ToString(), 0, false, false); if (rut != null) { Beneficiary beneficiary = new Beneficiary(); beneficiary.Subsidiary = row[0].ToString(); beneficiary.SubsidiaryName = row[1].ToString(); beneficiary.Rut = int.Parse(rut); beneficiary.Div = EFTEC.RutChile.ObtenerDV(rut); beneficiary.Name = row[3].ToString(); beneficiary.SurnameFather = row[4].ToString(); beneficiary.SurnameMother = row[5].ToString(); beneficiary.Email = row[6].ToString(); beneficiary.Error = validateBeneficiary(beneficiary); beneficiaries.Add(beneficiary); } } } } }