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";
}
