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 addVisitorToFact(ExhibitionVisitor select_visitor, string status)
{
this.select_visitor = select_visitor;
if (context.ExhibitionVisitors.Where(s => s.BarCode == select_visitor.BarCode).Select(v => v).Count() == 0)
{
bs.Add(new PharmaVisitor(select_visitor, context));
// bs.Add(new BizVisitor(select_visitor, context));
}
context.ExhibitionVisitors.AddOrUpdate(select_visitor);
context.SaveChanges();
var cl = context.Descriptions.Where(d => d.Id == select_visitor.DescriptionId).Select(s => s.Color).FirstOrDefault();
var col = Color.FromName(cl);
var count = context.ExhibitionVisitors.Where(v => v.Status != "registered").Select(s => s).Count() - 1;
lb_count.Text = count.ToString();
pb_color.BackColor = col;
string pcl = "Black";
if (select_visitor.Payment_Status == "UNPAID")
{
pcl = "Red";
}
if (select_visitor.Payment_Status == "PAID")
{
pcl = "Green";
}
if (select_visitor.Payment_Status == "FOC")
{
pcl = "Blue";
}
var pcol = Color.FromName(pcl);
lbl_payment_status.ForeColor = pcol;
lbl_payment_status.Text = select_visitor.Payment_Status;
lbl_payment_status.Visible = true;
List <PharmaVisitor> dgv = null;
initialDataGread(dgv);
printVisitor();
}
public СhoiceForm(GeneralForm form, ExhibitionVisitor visitor)
{
InitializeComponent();
g_form = form;
this.visitor = visitor;
this.biz_visitor = new BizVisitor();
biz_visitor.vId = visitor.Id;
biz_visitor.vLastName = visitor.LastName;
biz_visitor.vFirstName = visitor.FirstName;
biz_visitor.vPathronim = visitor.Pathronim;
biz_visitor.vConpany = context.Companies.Where(c => c.Id == visitor.CompanyId).Select(s => s.Name).FirstOrDefault();
biz_visitor.vPosition = context.Positions.Where(p => p.Id == visitor.PositionId).Select(s => s.Name).FirstOrDefault();
biz_visitor.vDescription = context.Descriptions.Where(d => d.Id == visitor.DescriptionId).Select(s => s.Name).FirstOrDefault();
biz_visitor.vPhoneMobile = visitor.PhoneNumber;
biz_visitor.vPhoneWork = visitor.WorkPhone;
biz_visitor.vEmail = visitor.Email;
biz_visitor.vRegDate = visitor.DateCreated.ToString();
biz_visitor.vExhibit = context.Exhibits.Where(e => e.Id == visitor.ExhibitId).Select(s => s.Name).FirstOrDefault();
biz_visitor.vRaport = context.Raports.Where(r => r.Id == visitor.RaportId).Select(s => s.Name).FirstOrDefault();
biz_visitor.vCity = context.Cities.Where(c => c.Id == visitor.CityId).Select(s => s.Name).FirstOrDefault();
biz_visitor.vStatus = visitor.Status;
biz_visitor.vBarcode = 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";
}
