public UnitOfWork()
{
var buider = new DbContextOptionsBuilder <CTContext>();
buider.UseSqlServer(Configuration.ConnectionString);
context = new CTContext(buider.Options);
}
public static void Initialize(CTContext context)
{
context.Database.EnsureCreated();
if (context.UserMedic.Any())
{
return;
}
Medic m1 = new Medic("2770111123456", "Coste", "Claudia", "*****@*****.**", "0742345678");
Medic m2 = new Medic("2661223654321", "Dordai", "Raul", "*****@*****.**", "0785123456");
UserMedic um1 = new UserMedic("ioana", "12345");
UserMedic um2 = new UserMedic("raul", "12345");
var usersM = new UserMedic[]
{
um1, um2
};
var medici = new Medic[] { m1, m2 };
foreach (UserMedic um in usersM)
{
context.UserMedic.Add(um);
}
foreach (Medic m in medici)
{
context.Medic.Add(m);
}
context.SaveChanges();
context.UserMedic.Find(1).Medic = context.Medic.Find(1);
context.Medic.Find(1).UserMedic = context.UserMedic.Find(1);
context.UserMedic.Find(2).Medic = context.Medic.Find(2);
context.Medic.Find(2).UserMedic = context.UserMedic.Find(2);
context.SaveChanges();
}
public static void InitializeMedic(CTContext context)
{
if (context.Medic.Any())
{
return;
}
Medic m1 = new Medic("2770111123456", "Coste", "Claudia", "*****@*****.**", "0742345678");
Medic m2 = new Medic("2661223654321", "Dordai", "Raul", "*****@*****.**", "0785123456");
var medici = new Medic[] { m1, m2 };
foreach (Medic m in medici)
{
context.Medic.Add(m);
}
UserMedic um1 = new UserMedic("ioana", "0d20326e6155cae6bb2b510bfc2cc01e"); //parola=medic
UserMedic um2 = new UserMedic("raul", "0d20326e6155cae6bb2b510bfc2cc01e"); //parola = medic
var usersM = new UserMedic[] { um1, um2 };
foreach (UserMedic um in usersM)
{
context.UserMedic.Add(um);
}
context.SaveChanges();
context.UserMedic.Find(1).Medic = context.Medic.Find(1);
context.Medic.Find(1).UserMedic = context.UserMedic.Find(1);
context.UserMedic.Find(2).Medic = context.Medic.Find(2);
context.Medic.Find(2).UserMedic = context.UserMedic.Find(2);
context.SaveChanges();
}
private static void InitializeAnaliza(CTContext context)
{
if (context.Analiza.Any())
{
return;
}
Analiza a1 = new Analiza(GrupaSange.OI, TipRh.Pozitiv, false, false, false, false, false, 2)
{
PungaSange = context.PungaSange.Find(1), Donator = context.PungaSange.Find(1).Donator
};
Analiza a2 = new Analiza(GrupaSange.AII, TipRh.Negativ, true, false, false, false, false, 2)
{
PungaSange = context.PungaSange.Find(2), Donator = context.PungaSange.Find(2).Donator
};
Analiza a3 = new Analiza(GrupaSange.BIII, TipRh.Pozitiv, false, false, false, false, false, 2)
{
PungaSange = context.PungaSange.Find(3), Donator = context.PungaSange.Find(3).Donator
};
var analize = new Analiza[] { a3 };
foreach (Analiza a in analize)
{
context.Analiza.Add(a);
}
context.SaveChanges();
}
private static void InitializePungaSange(CTContext context)
{
if (context.PungaSange.Any())
{
return;
}
PungaSange p1 = new PungaSange(DateTime.Parse("2018-05-25 21:50:48"), 300, 30, 20, 10)
{
TraseuPunga = context.TraseuPunga.Find(1), Donator = context.Donator.Find(1), CentruTransfuzie = context.CentruTransfuzie.Find(1)
};
PungaSange p2 = new PungaSange(DateTime.Parse("2017-12-24"), 200, 20, 20, 10)
{
TraseuPunga = context.TraseuPunga.Find(2), Donator = context.Donator.Find(1), CentruTransfuzie = context.CentruTransfuzie.Find(1)
};
PungaSange p3 = new PungaSange(DateTime.Parse("2018-05-25 19:12:48"), 200, 20, 20, 10)
{
TraseuPunga = context.TraseuPunga.Find(3), Donator = context.Donator.Find(2), CentruTransfuzie = context.CentruTransfuzie.Find(2)
};
PungaSange p4 = new PungaSange(DateTime.Parse("2017-12-24"), 200, 20, 20, 10)
{
TraseuPunga = context.TraseuPunga.Find(4), Donator = context.Donator.Find(2), CentruTransfuzie = context.CentruTransfuzie.Find(2)
};
var pungi = new PungaSange[] { p1, p2, p3, p4 };
foreach (PungaSange p in pungi)
{
context.PungaSange.Add(p);
}
context.SaveChanges();
}
public static void createArtifact(Artifact artifact, string username)
{
CTContext db = new CTContext();
artifact.User = db.Users.FirstOrDefault(u => u.UserName == username);
db.Artifacts.Add(artifact);
db.SaveChanges();
}
public ControlTowerRepository()
{
CTDB = new CTContext();
ProcessesDTOs = new List <ProcessDTO>();
CheckPointsDTOs = new List <CheckpointDTO>();
FlightsDTOs = new List <FlightDTO>();
}
static void Main(string[] args)
{
using (var db = new CTContext(new DbContextOptions <CTContext>()))
{
DbInitializer.Initialize(db);
}
}
private static void InitializeTraseuPunga(CTContext context)
{
if (context.TraseuPunga.Any())
{
return;
}
TraseuPunga t1 = new TraseuPunga {
Prelevata = true
};
TraseuPunga t2 = new TraseuPunga {
Prelevata = true
};
TraseuPunga t3 = new TraseuPunga {
Prelevata = true
};
TraseuPunga t4 = new TraseuPunga {
Prelevata = true
};
var traseu = new TraseuPunga[] { t1, t2, t3, t4 };
foreach (TraseuPunga tp in traseu)
{
context.TraseuPunga.Add(tp);
}
context.SaveChanges();
}
private static void InitializeAdmin(CTContext context)
{
if (context.Admin.Any())
{
return;
}
context.Admin.Add(new Admin("admin", "21232f297a57a5a743894a0e4a801fc3")); //parola=admin
context.Admin.Add(new Admin("admin1", "e00cf25ad42683b3df678c61f42c6bda")); //parola=admin1
context.SaveChanges();
}
static void Main()
{
using (var db = new CTContext(new DbContextOptions <CTContext>()))
{
DbInitializer.Initialize(db);
}
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new FormLogareDonator(new DonatorService()));
}
public static Artifact getArtifact(int id, string username)
{
CTContext db = new CTContext();
Artifact art = db.Artifacts.FirstOrDefault(a => a.ID == id);
if (art.User.UserName != username)
{
art = null;
}
return art;
}
public static void deleteArtifact(int id, string username)
{
CTContext db = new CTContext();
Artifact artifact = db.Artifacts.Find(id);
if (artifact.User.UserName.Equals(username))
{
FileDeletion(artifact.Location, username);
db.Artifacts.Remove(artifact);
db.SaveChanges();
}
}
public static void Initialize(CTContext context)
{
context.Database.Migrate();
InitializeMedic(context);
InitializeCereri(context);
InitializeDonatori(context);
InitializeStoc(context);
InitializeCentre(context);
InitializeAdmin(context);
//InitializeTraseuPunga(context);
//InitializePungaSange(context);
//InitializeAnaliza(context);
InitializeNotificari(context);
InitializeSpitale(context);
}
private static void InitializeSpitale(CTContext context)
{
if (context.Spital.Any())
{
return;
}
CentruTransfuzie c1 = context.CentruTransfuzie.Find(3);
CentruTransfuzie c2 = context.CentruTransfuzie.Find(4);
Spital sp1 = new Spital(c1, "Str. Salcamilor nr. 98", "Iasi", "Iasi");
Spital sp2 = new Spital(c2, "Str. Alunei nr. 637", "Arad", "Arad");
context.Spital.Add(sp1);
context.Spital.Add(sp2);
context.SaveChanges();
}
private static void InitializeStoc(CTContext context)
{
if (context.Stoc.Any())
{
return;
}
context.Stoc.Add(new Stoc(GrupaSange.OI, TipRh.Pozitiv));
context.Stoc.Add(new Stoc(GrupaSange.OI, TipRh.Negativ));
context.Stoc.Add(new Stoc(GrupaSange.AII, TipRh.Pozitiv));
context.Stoc.Add(new Stoc(GrupaSange.AII, TipRh.Negativ));
context.Stoc.Add(new Stoc(GrupaSange.BIII, TipRh.Pozitiv));
context.Stoc.Add(new Stoc(GrupaSange.BIII, TipRh.Negativ));
context.Stoc.Add(new Stoc(GrupaSange.ABIV, TipRh.Pozitiv));
context.Stoc.Add(new Stoc(GrupaSange.ABIV, TipRh.Negativ));
context.SaveChanges();
}
private static void InitializeNotificari(CTContext context)
{
if (context.Notificari.Any())
{
return;
}
Notificari n1 = new Notificari(2, 1);
Notificari n2 = new Notificari(1, 2);
Notificari n3 = new Notificari(1, 1);
Notificari n4 = new Notificari(3, 2);
var notificari = new Notificari[] { n1, n2, n3, n4 };
foreach (Notificari n in notificari)
{
context.Notificari.Add(n);
}
context.SaveChanges();
}
static void InitializeCereri(CTContext context)
{
if (context.Cerere.Any())
{
return;
}
Cerere c1 = new Cerere("1-1-2018", 5, 1, 3, 1, true, context.Medic.Find(1), GrupaSange.AII, TipRh.Pozitiv);
Cerere c2 = new Cerere("2-1-2018", 7, 2, 1, 4, false, context.Medic.Find(2), GrupaSange.AII, TipRh.Pozitiv);
c1.Prioritate = GradUrgenta.Mediu;
c2.Prioritate = GradUrgenta.Ridicat;
var cereri = new Cerere[] { c1, c2 };
foreach (Cerere c in cereri)
{
context.Cerere.Add(c);
}
context.SaveChanges();
}
static void InitializeDonatori(CTContext context)
{
if (context.Donator.Any())
{
return;
}
Donator d1 = new Donator("Dobrovat", "Mihai", "M", DateTime.Parse("1996-02-22"), "Str. Buftea", "Cluj-Napoca", "Cluj", "Str. Buftea", "Cluj-Napoca", "Cluj", "0723456799", "*****@*****.**");
d1.Activ = "T";
Donator d2 = new Donator("Marin", "Andrei", "M", DateTime.Parse("1997-11-23"), "Str. Garii", "Iasi", "Iasi", "Str. Garii", "Iasi", "Iasi", "0723456789", "*****@*****.**");
Donator d3 = new Donator("Acatrinei", "Maria", "F", DateTime.Parse("1998-12-24"), "Str. Lacu Rosu", "Cluj-Napoca", "Cluj", "Str. Lacu Rosu", "Cluj-Napoca", "Cluj", "0723456787", "*****@*****.**");
Donator d4 = new Donator("Popescu", "Ion", "M", DateTime.Parse("1998-02-12"), "Cluj-Napoca", "Cluj-Napoca", "Cluj", null, null, null, "0712121212", "*****@*****.**");
UserDonator ud1 = new UserDonator("Dmihai", "f63ed3300797216784db8387a2deaff0"); //parola=parola1
UserDonator ud2 = new UserDonator("Mandrei", "a1442bfc190d52303727e63719962ed6"); //parola=parola2
UserDonator ud3 = new UserDonator("Amaria", "93a7ffba27902537651fb3dbca8ae802"); //parola=parola3
UserDonator ud4 = new UserDonator("popescu", "8287458823facb8ff918dbfabcd22ccb"); // parola este "parola"
var donatori = new Donator[] { d1, d2, d3, d4 };
foreach (Donator d in donatori)
{
context.Donator.Add(d);
}
var usersD = new UserDonator[] { ud1, ud2, ud3, ud4 };
foreach (UserDonator ud in usersD)
{
context.UserDonator.Add(ud);
}
context.SaveChanges();
context.UserDonator.Find(1).Donator = context.Donator.Find(1);
context.Donator.Find(1).UserDonator = context.UserDonator.Find(1);
context.UserDonator.Find(2).Donator = context.Donator.Find(2);
context.Donator.Find(2).UserDonator = context.UserDonator.Find(2);
context.SaveChanges();
}
public SimpleMembershipInitializer()
{
Database.SetInitializer<CTContext>(null);
try
{
using (var context = new CTContext())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
static void Main()
{
using (var db = new CTContext(new DbContextOptions <CTContext>()))
{
DbInitializer.Initialize(db);
}
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new FormLogareCentru(new CentruService()));
Application.Run(new FormLogareDonator(new Service.DonatorService()));
//Application.Run(new FormDonator(new Service.DonatorService(), "popescu"));
//Application.Run(new FormLogareMedic(new Service.UserMedicService()));
//Application.Run(new FormMedic(new Service.UserMedicService(),1, "ioana"));
//Application.Run(new FormCentru(new Service.DonatorService()));
// Application.Run(new FormCentru(new Service.DonatorService(), "Centru Donare Sange Cluj"));
//Application.Run(new FormDonator(new Service.DonatorService(), "Mandrei"));
//Application.Run(new FormLogareMedic(new Service.UserMedicService()));
//Application.Run(new FormMedic(new Service.UserMedicService(),1, "ioana"));
//Application.Run(new FormCentru(new Service.DonatorService()));
//Application.Run(new FormCentru(new Service.DonatorService(), "Centru Donare Sange Cluj"));
//Application.Run(new FormAdminLogare(new AdminService()));
//Application.Run(new FormAdmin(new AdminService()));
//Application.Run(new FormAnalizeSange());
//Application.Run(new FormRegisterDonator());
}
static void InitializeCentre(CTContext context)
{
if (context.CentruTransfuzie.Any())
{
return;
}
CentruTransfuzie c1 = new CentruTransfuzie("Centru Donare Sânge Cluj", "Piața Mihai Viteazu", "Cluj-Napoca", "Cluj");
CentruTransfuzie c2 = new CentruTransfuzie("Centru Donare Sânge București", "Militari", "Bucuresti", "Ilfov");
CentruTransfuzie c3 = new CentruTransfuzie("CentruTransfuzieIasi", "Moldova", "Iasi", "Iasi", "8287458823facb8ff918dbfabcd22ccb"); //parola=parola
CentruTransfuzie c4 = new CentruTransfuzie("CentruTransfuzieArad", "Banat", "Arad", "Arad", "8287458823facb8ff918dbfabcd22ccb"); //parola=parola
context.CentruTransfuzie.Add(c1);
context.CentruTransfuzie.Add(c2);
c1.Parola = "e2a7b5972479f8c59ade36a15e5b6146"; //parola=ParolaCluj
c2.Parola = "311e8c89c2e7f24e3ac63265496297a7"; //parola=ParolaBucuresti
var centre = new CentruTransfuzie[] { c1, c2, c3, c4 };
foreach (CentruTransfuzie c in centre)
{
context.CentruTransfuzie.Add(c);
}
context.SaveChanges();
}
public ActionResult OrderInfo(string UserName, string Phone, string Adress)
{
using (CTContext cc = new CTContext())
{
var result = cc.Users.Where(o => o.UserName == Phone && o.IsVip == 1).ToList();
if (result.Count() > 0)
{
//生成订单ID
var id = MD5Helper.getMd5Hash(Phone + DateTime.Now.ToString());
if (string.IsNullOrWhiteSpace(UserName))
{
Response.Write("<script languge='javascript'>alert('名字不能为空！');</script>");
return(View());
}
if (string.IsNullOrWhiteSpace(Phone))
{
Response.Write("<script languge='javascript'>alert('手机号码不能为空！');</script>");
return(View());
}
//电信手机号码正则
string dianxin = @"^1[3578][01379]\d{8}$";
Regex dReg = new Regex(dianxin);
//联通手机号正则
string liantong = @"^1[34578][01256]\d{8}$";
Regex tReg = new Regex(liantong);
//移动手机号正则
string yidong = @"^(134[012345678]\d{7}|1[34578][012356789]\d{8})$";
Regex yReg = new Regex(yidong);
if (!dReg.IsMatch(Phone) && !tReg.IsMatch(Phone) && !yReg.IsMatch(Phone))
{
Response.Write("<script languge='javascript'>alert('手机号码错误，请填写正确号码！');</script>");
return(View());
}
if (string.IsNullOrWhiteSpace(Adress))
{
Response.Write("<script languge='javascript'>alert('手机号码不能为空alert('地址不能为空！');</script>");
return(View());
}
using (SBIContext sc = new SBIContext())
{
try
{
var model = sc.ordersinfo.Where(o => o.Phone == Phone && o.PayStatus == 1).FirstOrDefault();
if (model == null)
{
ordersinfo os = new ordersinfo();
os.ID = id;
os.Name = UserName;
os.Phone = Phone;
os.Adress = Adress;
os.DateTime = DateTime.Now;
os.Money = 0.01;
os.OExtension = "茶叶运送邮费";
var obj = JsonConvert.SerializeObject(os);
Session["OrderInfo"] = obj;
sc.ordersinfo.Add(os);
sc.SaveChanges();
AliPlay(os);
}
else
{
Response.Write("<script languge='javascript'>alert('该用户已申请过，不可重复申请！');</script>");
return(View());
}
}
catch (Exception e)
{
Session["Error"] = e.Message;
Response.Redirect("default/Error");
}
}
return(View());
}
else
{
Response.Write("<script languge='javascript'>alert('手机号码与注册手机号不符，请用开通VIP的账号来领取礼品！');</script>");
return(View());
}
}
}
public CasesRepository(CTContext context)
{
_context = context;
}
public PungaSangeRepo(CTContext ctx) : base(ctx)
{
}
public MedicRepo(CTContext ctx) : base(ctx)
{
}
public GenericRepository(CTContext ctx)
{
this.context = ctx;
dbset = context.Set <E>();
}
//private static CTContext db = new CTContext();
public static List<Artifact> getUserArtifacts(string username)
{
CTContext db = new CTContext();
return db.Artifacts.Where(a => a.User.UserName == username).ToList();
}
