public PharmaVisitor(ExhibitionVisitor select_visitor, ExhibitionDataForContext context) { pId = select_visitor.Id; pSurName = select_visitor.LastName; pForName = select_visitor.FirstName; pConpany = context.Companies.Where(c => c.Id == select_visitor.CompanyId).Select(s => s.Name).FirstOrDefault(); pJobTitle = context.Positions.Where(p => p.Id == select_visitor.PositionId).Select(s => s.Name).FirstOrDefault(); pCustomerNo = select_visitor.PhoneNumber; pRowNumber = select_visitor.Email; pBarcode = select_visitor.BarCode; pDescription = context.Descriptions.Where(d => d.Id == select_visitor.DescriptionId).Select(s => s.Name).FirstOrDefault(); pRegDate = select_visitor.DateCreated.ToString(); pPaymentStatus = select_visitor.Payment_Status; pPaymentComment = select_visitor.Payment_Status_Comment; pStatus = select_visitor.Status; }
public void createForDatabase() { using (ExhibitionDataForContext context = new ExhibitionDataForContext()) { context.Database.Delete(); context.Companies.Add(new Company("none")); context.Positions.Add(new Position("none")); context.Descriptions.Add(new Description("none", "none")); context.Cities.Add(new City("none")); context.Exhibits.Add(new Exhibit("none")); context.Raports.Add(new Raport("none")); context.SaveChanges(); ExhibitionVisitor visitor = new ExhibitionVisitor(); visitor.LastName = "none"; visitor.FirstName = "none"; visitor.CompanyId = context.Companies.Where (co => co.Name.Equals("none")).Select(coc => coc.Id).FirstOrDefault(); visitor.PositionId = context.Positions.Where (p => p.Name.Equals("none")).Select(po => po.Id).FirstOrDefault(); visitor.PhoneNumber = "none"; visitor.Email = "none"; visitor.DescriptionId = context.Descriptions.Where (d => d.Name.Equals("none")).Select(dd => dd.Id).FirstOrDefault(); visitor.BarCode = "none"; visitor.CityId = context.Cities.Where (ci => ci.Name.Equals("none")).Select(cit => cit.Id).FirstOrDefault(); visitor.ExhibitId = context.Exhibits.Where (e => e.Name.Equals("none")).Select(ex => ex.Id).FirstOrDefault(); visitor.RaportId = context.Raports.Where(r => r.Name.Equals("none")) .Select(ra => ra.Id).FirstOrDefault(); visitor.Status = "none"; visitor.Payment_Status = "none"; visitor.Payment_Status_Comment = "none"; visitor.Source_Code = "none"; visitor.Event_Code = "none"; visitor.Event_Name = "none"; context.ExhibitionVisitors.Add(visitor); context.SaveChanges(); } status = "create database"; }
public BizVisitor(ExhibitionVisitor select_visitor, ExhibitionDataForContext context) { vId = select_visitor.Id; vLastName = select_visitor.LastName; vFirstName = select_visitor.FirstName; vPathronim = select_visitor.Pathronim; vConpany = context.Companies.Where(c => c.Id == select_visitor.CompanyId).Select(s => s.Name).FirstOrDefault(); vPosition = context.Positions.Where(p => p.Id == select_visitor.PositionId).Select(s => s.Name).FirstOrDefault(); vDescription = context.Descriptions.Where(d => d.Id == select_visitor.DescriptionId).Select(s => s.Name).FirstOrDefault(); vPhoneMobile = select_visitor.PhoneNumber; vPhoneWork = select_visitor.WorkPhone; vEmail = select_visitor.Email; vRegDate = select_visitor.DateCreated.ToString(); vExhibit = context.Exhibits.Where(e => e.Id == select_visitor.ExhibitId).Select(s => s.Name).FirstOrDefault(); vRaport = context.Raports.Where(r => r.Id == select_visitor.RaportId).Select(s => s.Name).FirstOrDefault(); vCity = context.Cities.Where(c => c.Id == select_visitor.CityId).Select(s => s.Name).FirstOrDefault(); vStatus = select_visitor.Status; vBarcode = select_visitor.BarCode; }
public void getForDataToDatabase() { for (int row = 0; row < excelWorksheetRow; row++) { using (ExhibitionDataForContext context = new ExhibitionDataForContext()) { var e_company = data[row, 2]; if (e_company.Length == 0 || e_company == " ") { e_company = "none"; } if (context.Companies.Where(cc => cc.Name.Equals(e_company)).ToList().Count() == 0) { context.Companies.Add(new Company(e_company)); } var e_position = data[row, 3]; if (e_position.Length == 0 || e_position == " ") { e_position = "none"; } if (context.Positions.Where(p => p.Name.Equals(e_position)).Count() == 0) { context.Positions.Add(new Position(e_position)); } var e_discription = data[row, 6]; if (e_discription.Length == 0 || e_discription == " ") { e_discription = "none"; } if (context.Descriptions.Where(d => d.Name.Equals(e_discription)).Count() == 0) { context.Descriptions.Add(new Description(e_discription, "White")); } if (context.Cities.Where(c => c.Name.Equals("none")).Count() == 0) { context.Cities.Add(new City("none")); } if (context.Exhibits.Where(e => e.Name.Equals("none")).Count() == 0) { context.Exhibits.Add(new Exhibit("none")); } if (context.Raports.Where(r => r.Name.Equals("none")).Count() == 0) { context.Raports.Add(new Raport("none")); } context.SaveChanges(); ExhibitionVisitor visitor = new ExhibitionVisitor(); visitor.LastName = data[row, 0]; visitor.FirstName = data[row, 1]; visitor.CityId = context.Cities.Where(ci => ci.Name.Equals ("none")).Select(c => c.Id).FirstOrDefault(); visitor.ExhibitId = context.Cities.Where(e => e.Name.Equals ("none")).Select(ex => ex.Id).FirstOrDefault(); visitor.RaportId = context.Cities.Where(r => r.Name.Equals ("none")).Select(ra => ra.Id).FirstOrDefault(); visitor.CompanyId = context.Companies.Where (co => co.Name.Equals(e_company)).Select(coc => coc.Id).FirstOrDefault(); visitor.PositionId = context.Positions.Where (p => p.Name.Equals(e_position)).Select(po => po.Id).FirstOrDefault(); visitor.PhoneNumber = data[row, 4]; visitor.Email = data[row, 5]; visitor.DescriptionId = context.Descriptions.Where (d => d.Name.Equals(e_discription)).Select(dd => dd.Id).FirstOrDefault(); visitor.BarCode = data[row, 7]; visitor.Payment_Status = data[row, 8]; visitor.Payment_Status_Comment = data[row, 9]; visitor.Source_Code = data[row, 10]; visitor.Event_Code = data[row, 11]; visitor.Event_Name = data[row, 12]; visitor.Status = "registered"; context.ExhibitionVisitors.Add(visitor); context.SaveChanges(); } } status = "get excel data to database"; }