public static DataSet bindGridView(string flag, [Optional] string districtid, [Optional] string ForceId_)
{
ActivityClass ac = new ActivityClass();
DataSet ds = new DataSet();
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlDataAdapter cmdda = new SqlDataAdapter(ac.USP_BIND_GRIDVIEW, conn))
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
if (flag == "LocationDetails" || flag == "GetAttackDetails")
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.DISTRICT_ID, districtid);
}
if (flag == "CivilianCasuality" || flag == "ForceCasuality" || flag == "CivilianInjury" || flag == "ForceInjury" || flag == "TerroristArrestedL" || flag == "TerroristArrestedNL" || flag == "TerroristInjuryL" || flag == "TerroristInjuryNL" || flag == "TerroristDeathL" || flag == "TerroristDeathNL" || flag == "BindSubDetails")
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.AttackId, districtid);
}
cmdda.SelectCommand.CommandType = CommandType.StoredProcedure;
using (ds = new DataSet())
{
cmdda.Fill(ds, "tg");
}
}
}
return(ds);
}
public static DataSet getdetails(string flag, [Optional] string district, [Optional] string tehsil)
{
ActivityClass ac = new ActivityClass();
DataSet ds = new DataSet();
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlDataAdapter cmdda = new SqlDataAdapter(ac.USP_REPORT, conn))
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
if (district != "")
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.DISTRICT_ID, district);
}
if (tehsil != "")
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.TEHSIL_ID, tehsil);
}
cmdda.SelectCommand.CommandType = CommandType.StoredProcedure;
using (ds = new DataSet())
{
cmdda.Fill(ds, "report");
}
}
}
return(ds);
}
public static string insertLocations(string incidentName_, [Optional] string districtid)
{
string m = "";
ActivityClass ac = new ActivityClass();
string str = dbConstr.connectionString();
try
{
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlCommand cmd = new SqlCommand(ac.USP_INSERT, conn))
{
cmd.Parameters.AddWithValue(ac.FLAG_PARAM, "IncidentType");
//cmd.Parameters.AddWithValue(ac.DISTRICT_ID, districtid);
cmd.Parameters.AddWithValue(ac.IncidentName, incidentName_);
cmd.Parameters.Add("@msg", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
int j = cmd.ExecuteNonQuery();
m = cmd.Parameters["@msg"].Value.ToString();
conn.Close();
}
}
}
catch (Exception)
{
m = "";
}
return(m);
}
public static string insertSubDetailsArrested(string flag, string Attackid, string NumberOfCasuality)
{
string m = "";
ActivityClass ac = new ActivityClass();
string str = dbConstr.connectionString();
try
{
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlCommand cmd = new SqlCommand(ac.USP_INSERT, conn))
{
cmd.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
cmd.Parameters.AddWithValue(ac.CasualityType, flag);
cmd.Parameters.AddWithValue(ac.AttackId, Attackid);
cmd.Parameters.AddWithValue(ac.NumberofCasuality, NumberOfCasuality);
cmd.Parameters.Add("@msg", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
int j = cmd.ExecuteNonQuery();
m = cmd.Parameters["@msg"].Value.ToString();
conn.Close();
}
}
}
catch (Exception)
{
m = "";
}
return(m);
}
public static string updateGroup(string flag, string group_, string GroupId_)
{
string m = "";
ActivityClass ac = new ActivityClass();
string str = dbConstr.connectionString();
try
{
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlCommand cmd = new SqlCommand(ac.USP_UPDATE, conn))
{
cmd.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
cmd.Parameters.AddWithValue(ac.GroupName, group_);
cmd.Parameters.AddWithValue(ac.GroupId, GroupId_);
cmd.Parameters.Add("@msg", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
int j = cmd.ExecuteNonQuery();
m = cmd.Parameters["@msg"].Value.ToString();
conn.Close();
}
}
}
catch (Exception)
{
m = "";
}
return(m);
}
public static string updateSubDetails(string CasualityCivilianLocal, string CasualityCivilianNonLocal,
string CasualityForceCRPF, string CasualityForceCISF, string CasualityForceJKP,
string CasualityForceITBP, string CasualityForceBSF, string CasualityForceSSB,
string InjuryCivilianLocal, string InjuryCivilianNonLocal, string InjuryForceCRPF,
string InjuryForceCISF, string InjuryForceJKP, string InjuryForceITBP,
string InjuryForceBSF, string InjuryForceSSB, string TerroristDeathLocal,
string TerroristDeathNonLocal, string TerroristInjuryLocal, string TerroristInjuryNonLocal,
string TerroristArrestedLocal, string TerroristArrestedNonLocal, string AttackId_, string flag)
{
string m = "";
ActivityClass ac = new ActivityClass();
string str = dbConstr.connectionString();
try
{
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlCommand cmd = new SqlCommand(ac.USP_UPDATE, conn))
{
cmd.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
//cmd.Parameters.AddWithValue(ac.DISTRICT_ID, districtid);
cmd.Parameters.AddWithValue(ac.AttackId, AttackId_);
cmd.Parameters.AddWithValue(ac.CasualityCivilianLocal, ((CasualityCivilianLocal == "") ? "0" : CasualityCivilianLocal));
cmd.Parameters.AddWithValue(ac.CasualityCivilianNonLocal, ((CasualityCivilianNonLocal == "") ? "0" : CasualityCivilianNonLocal));
cmd.Parameters.AddWithValue(ac.CasualityForceCRPF, ((CasualityForceCRPF == "") ? "0" : CasualityForceCRPF));
cmd.Parameters.AddWithValue(ac.CasualityForceCISF, ((CasualityForceCISF == "") ? "0" : CasualityForceCISF));
cmd.Parameters.AddWithValue(ac.CasualityForceJKP, ((CasualityForceJKP == "") ? "0" : CasualityForceJKP));
cmd.Parameters.AddWithValue(ac.CasualityForceITBP, ((CasualityForceITBP == "") ? "0" : CasualityForceITBP));
cmd.Parameters.AddWithValue(ac.CasualityForceBSF, ((CasualityForceBSF == "") ? "0" : CasualityForceBSF));
cmd.Parameters.AddWithValue(ac.CasualityForceSSB, ((CasualityForceSSB == "") ? "0" : CasualityForceSSB));
cmd.Parameters.AddWithValue(ac.InjuryCivilianLocal, ((InjuryCivilianLocal == "") ? "0" : InjuryCivilianLocal));
cmd.Parameters.AddWithValue(ac.InjuryCivilianNonLocal, ((InjuryCivilianNonLocal == "") ? "0" : InjuryCivilianNonLocal));
cmd.Parameters.AddWithValue(ac.InjuryForceCRPF, ((InjuryForceCRPF == "") ? "0" : InjuryForceCRPF));
cmd.Parameters.AddWithValue(ac.InjuryForceCISF, ((InjuryForceCISF == "") ? "0" : InjuryForceCISF));
cmd.Parameters.AddWithValue(ac.InjuryForceJKP, ((InjuryForceJKP == "") ? "0" : InjuryForceJKP));
cmd.Parameters.AddWithValue(ac.InjuryForceITBP, ((InjuryForceITBP == "") ? "0" : InjuryForceITBP));
cmd.Parameters.AddWithValue(ac.InjuryForceBSF, ((InjuryForceBSF == "") ? "0" : InjuryForceBSF));
cmd.Parameters.AddWithValue(ac.InjuryForceSSB, ((InjuryForceSSB == "") ? "0" : InjuryForceSSB));
cmd.Parameters.AddWithValue(ac.TerroristDeathLocal, ((TerroristDeathLocal == "") ? "0" : TerroristDeathLocal));
cmd.Parameters.AddWithValue(ac.TerroristDeathNonLocal, ((TerroristDeathNonLocal == "") ? "0" : TerroristDeathNonLocal));
cmd.Parameters.AddWithValue(ac.TerroristInjuryLocal, ((TerroristInjuryLocal == "") ? "0" : TerroristInjuryLocal));
cmd.Parameters.AddWithValue(ac.TerroristInjuryNonLocal, ((TerroristInjuryNonLocal == "") ? "0" : TerroristInjuryNonLocal));
cmd.Parameters.AddWithValue(ac.TerroristArrestedLocal, ((TerroristArrestedLocal == "") ? "0" : TerroristArrestedLocal));
cmd.Parameters.AddWithValue(ac.TerroristArrestedNonLocal, ((TerroristArrestedNonLocal == "") ? "0" : TerroristArrestedNonLocal));
cmd.Parameters.Add("@msg", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
int j = cmd.ExecuteNonQuery();
m = cmd.Parameters["@msg"].Value.ToString();
conn.Close();
}
}
}
catch (Exception)
{
m = "";
}
return(m);
}
public ActionResult DeleteConfirmed(int id)
{
ActivityClass activityClass = db.ActivityClasses.Find(id);
var courseId = db.ModuleClasses.Find(activityClass.ModuleClassId).CourseClassId;
db.ActivityClasses.Remove(activityClass);
db.SaveChanges();
//var courseid = x.CourseClassId;
return(RedirectToAction("Details", "Course", new { id = courseId }));
}
public ActionResult Edit([Bind(Include = "Id,Name,Description,StartTime,EndTime,ModuleClassId")] ActivityClass activityClass)
{
if (ModelState.IsValid)
{
db.Entry(activityClass).State = EntityState.Modified;
db.SaveChanges();
var courseId = db.ModuleClasses.Find(activityClass.ModuleClassId).CourseClassId;
return(RedirectToAction("Details", "Course", new { id = courseId }));
}
ViewBag.ModuleClassId = new SelectList(db.ModuleClasses, "Id", "Name", activityClass.ModuleClassId);
return(View(activityClass));
}
// GET: ActivityClasses/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ActivityClass activityClass = db.ActivityClasses.Find(id);
if (activityClass == null)
{
return(HttpNotFound());
}
return(View(activityClass));
}
// GET: ActivityClasses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ActivityClass activityClass = db.ActivityClasses.Find(id);
if (activityClass == null)
{
return(HttpNotFound());
}
ViewBag.ModuleClassId = new SelectList(db.ModuleClasses, "Id", "Name", activityClass.ModuleClassId);
return(View(activityClass));
}
public ActionResult Create([Bind(Include = "Id,Name,Description,StartTime,EndTime,ModuleClassId")] ActivityClass activityClass, int id)
{
if (ModelState.IsValid)
{
activityClass.ModuleClassId = id;
db.ActivityClasses.Add(activityClass);
db.SaveChanges();
var courseId = db.ModuleClasses.Find(activityClass.ModuleClassId).CourseClassId;
//var courseid = x.CourseClassId;
return(RedirectToAction("Details", "Course", new { id = courseId }));
}
//ViewBag.ModuleClassId = new SelectList(db.ModuleClasses, "Id", "Name", activityClass.ModuleClassId);
//ViewBag.ActivityClassId = new SelectList(db.ActivityClasses, "Id", "Name", activityClass.ModuleClassId);
return(View(activityClass));
}
public static string updateAttackDetails(string flag, string districtid, [Optional] string tehsilid, string location, string incidentid, string dt, string terroristgroupinvolved, string numberofterroristinvolved, string ammorecovered, string infectedarea, string remarks, string AttackId_)
{
string m = "";
ActivityClass ac = new ActivityClass();
string str = dbConstr.connectionString();
try
{
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlCommand cmd = new SqlCommand(ac.USP_UPDATE, conn))
{
cmd.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
cmd.Parameters.AddWithValue(ac.DISTRICT_ID, districtid);
if (tehsilid == "")
{
cmd.Parameters.AddWithValue(ac.TEHSIL_ID, (Object)DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue(ac.TEHSIL_ID, tehsilid);
}
cmd.Parameters.AddWithValue(ac.LocationName, location);
cmd.Parameters.AddWithValue(ac.INCIDENT_ID, incidentid);
cmd.Parameters.AddWithValue(ac.DateAndTimeOfIncident, dt);
cmd.Parameters.AddWithValue(ac.TerroristGroupInvolved, terroristgroupinvolved);
cmd.Parameters.AddWithValue(ac.NumberOfTerroristInvolved, numberofterroristinvolved);
cmd.Parameters.AddWithValue(ac.AmmunitionRecovered, ammorecovered);
cmd.Parameters.AddWithValue(ac.InfectedArea, infectedarea);
cmd.Parameters.AddWithValue(ac.Remarks, remarks);
cmd.Parameters.AddWithValue(ac.AttackId, AttackId_);
cmd.Parameters.Add("@msg", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
int j = cmd.ExecuteNonQuery();
m = cmd.Parameters["@msg"].Value.ToString();
conn.Close();
}
}
}
catch (Exception)
{
m = "";
}
return(m);
}
public static DataSet getDistrict()
{
ActivityClass ac = new ActivityClass();
DataSet ds = new DataSet();
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlDataAdapter cmdda = new SqlDataAdapter(ac.USP_DROPDOWN, conn))
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.FLAG_PARAM, "district");
cmdda.SelectCommand.CommandType = CommandType.StoredProcedure;
using (ds = new DataSet())
{
cmdda.Fill(ds, "district");
}
}
}
return(ds);
}
public static DataSet getattackDetails(string flag, string AttackId_)
{
ActivityClass ac = new ActivityClass();
DataSet ds = new DataSet();
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlDataAdapter cmdda = new SqlDataAdapter(ac.USP_BIND_GRIDVIEW, conn))
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.FLAG_PARAM, flag);
cmdda.SelectCommand.Parameters.AddWithValue(ac.DISTRICT_ID, AttackId_);
cmdda.SelectCommand.CommandType = CommandType.StoredProcedure;
using (ds = new DataSet())
{
cmdda.Fill(ds, "teh");
}
}
}
return(ds);
}
public static DataTable getGraphData([Optional] String flag_, [Optional] String param2_)
{
ActivityClass ac = new ActivityClass();
DataTable dt = new DataTable();
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlDataAdapter cmdda = new SqlDataAdapter(ac.USP_REPORT, conn))
{
if (flag_ != "")
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.FLAG_PARAM, flag_);
}
cmdda.SelectCommand.CommandType = CommandType.StoredProcedure;
using (dt = new DataTable())
{
cmdda.Fill(dt);
}
}
}
return(dt);
}
public static DataSet getDashboard(String flag_)
{
ActivityClass ac = new ActivityClass();
DataSet dset = new DataSet();
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlDataAdapter cmdda = new SqlDataAdapter(ac.USP_REPORT, conn))
{
if (flag_ != "")
{
cmdda.SelectCommand.Parameters.AddWithValue(ac.FLAG_PARAM, flag_);
}
cmdda.SelectCommand.CommandType = CommandType.StoredProcedure;
using (dset = new DataSet())
{
cmdda.Fill(dset);
}
}
}
return(dset);
}
public static string getSaltValue()
{
ActivityClass ac = new ActivityClass();
string s = string.Empty;
string str = dbConstr.connectionString();
using (SqlConnection conn = new SqlConnection(str))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = ac.USP_LOGIN;
cmd.Parameters.AddWithValue(ac.FLAG_PARAM, "S");
cmd.Connection = conn;
conn.Open();
Object obj = cmd.ExecuteScalar();
if (obj != null)
{
s = obj.ToString();
}
}
}
return(s);
}
protected override void Seed(R2DEV2.Models.ApplicationDbContext context)
{
RoleStore <IdentityRole> roleStore = new RoleStore <IdentityRole>(context);
RoleManager <IdentityRole> roleManager = new RoleManager <IdentityRole>(roleStore);
string[] roleNames = new[] { "Teacher", "Student" };
foreach (string roleName in roleNames)
{
if (!context.Roles.Any(r => r.Name == roleName))
{
IdentityRole role = new IdentityRole {
Name = roleName
};
IdentityResult result = roleManager.Create(role);
if (!result.Succeeded)
{
throw new Exception(string.Join("\n", result.Errors));
}
}
}
CourseClass[] course = new CourseClass[]
{
new CourseClass // Endast för Lärare
{
Name = "Lärare",
Description = "Lärare i R2DEV2:s databas.",
StartTime = new DateTime(1900, 01, 01),
EndTime = new DateTime(2900, 01, 01),
},
new CourseClass
{
Name = ".NET Höst",
Description = "Hamburger laboris shank, swine dolore in kevin magna pork chop fugiat occaecat pig exercitation andouille. Et pork andouille pancetta veniam burgdoggen sirloin alcatra pariatur duis picanha boudin shoulder. Short loin voluptate incididunt enim deserunt. Dolor non salami pariatur bacon t-bone beef ribs commodo aliqua bresaola culpa veniam leberkas meatball laboris. Porchetta et frankfurter mollit, biltong prosciutto sed proident. Prosciutto cupidatat meatloaf chicken enim rump. Chuck quis dolor et dolore, ground round sint tempor laboris excepteur meatloaf in. Corned beef elit ut filet mignon ea eiusmod tail turducken anim irure flank ball tip. Laboris dolor chuck picanha sint landjaeger velit meatball turducken pancetta elit adipisicing irure short ribs. Irure laborum alcatra kevin mollit hamburger consequat laboris.",
StartTime = new DateTime(2015, 09, 11),
EndTime = new DateTime(2015, 12, 11),
},
new CourseClass
{
Name = "Ny programmeringskurs",
Description = "Vi lär dig allt om programmering. Bacon ipsum dolor amet pariatur nulla id pork belly dolore dolor consequat aute tempor jerky brisket. Aliquip cupidatat laborum elit pork belly pastrami non magna pork tail. Leberkas frankfurter alcatra capicola meatball, picanha exercitation. Pig salami elit, minim biltong fatback flank ground round ea pork belly esse. Cupidatat beef cillum shankle tri-tip, picanha tempor.",
StartTime = new DateTime(2019, 02, 06),
EndTime = new DateTime(2019, 08, 23),
},
new CourseClass
{
Name = "Shoppingkurs",
Description = "Handla fina saker på stan och ONLINE!",
StartTime = new DateTime(2017, 02, 06),
EndTime = new DateTime(2017, 09, 11),
},
new CourseClass
{
Name = "Fotbollskurs",
Description = "Lorem Ipsum Ham hock meatloaf consectetur, dolore sint pork belly turducken ut shankle picanha laborum dolor eu minim. Ut turducken pariatur sausage jowl drumstick dolor. Tongue ut tri-tip landjaeger cillum culpa bacon ea. Laboris tenderloin ad reprehenderit pariatur, quis id frankfurter sirloin boudin ribeye ham hock sausage. Laborum picanha aliquip dolore filet mignon. Eu ex est culpa.",
StartTime = new DateTime(2017, 04, 26),
EndTime = new DateTime(2017, 10, 14),
},
};
context.CourseClasses.AddOrUpdate(c => c.Name, course);
context.SaveChanges();
ModuleClass[] module = new ModuleClass[]
{
new ModuleClass
{
Name = "AngularJS",
Description = "Beef deserunt anim aute frankfurter lorem doner andouille ham hock laboris meatloaf eu cupim. Minim lorem ball tip porchetta tempor, shoulder ea salami esse turducken nostrud nisi non labore. Landjaeger jerky in ipsum. Velit capicola pancetta spare ribs dolore.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[1].Id,
},
new ModuleClass
{
Name = "Databasdesign",
Description = "Biltong enim cupidatat labore, turducken tri-tip eu duis shank ipsum t-bone excepteur non quis kevin. Occaecat adipisicing eu qui pancetta burgdoggen consectetur pastrami. Excepteur culpa pork ea frankfurter, t-bone capicola aliqua eiusmod et spare ribs shankle. Tempor sunt jerky, do meatball kevin strip steak doner sausage proident pastrami pork belly. Ex burgdoggen andouille labore, velit ut short ribs sed ham landjaeger cupim biltong cillum. Eu labore sint salami, turkey dolore fatback pariatur proident mollit minim pancetta fugiat chicken sunt. Sirloin salami filet mignon ground round pancetta pig. Beef ribs brisket tri-tip short loin sirloin burgdoggen boudin swine biltong. Brisket beef ribs turducken kielbasa ground round prosciutto cupim rump. Burgdoggen doner shank, t-bone venison jerky rump.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[1].Id,
},
new ModuleClass
{
Name = "Bootstrap & CSS",
Description = "Lär dig pynta din sida med lite basic bootstrap och css.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[2].Id,
},
new ModuleClass
{
Name = "C#",
Description = "Lär dig grunderna för C# programmering.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[2].Id,
},
new ModuleClass
{
Name = "JavaScript",
Description = "Lär dig grunderna för utveckling med JavaScript.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[2].Id,
},
new ModuleClass
{
Name = "PHP",
Description = "Lär dig PHP.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[2].Id,
},
new ModuleClass
{
Name = "Python",
Description = "Lär dig grunderna för Python utveckling.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[2].Id,
},
new ModuleClass
{
Name = "Onlineshopping",
Description = "Lär dig handla kläder, elektronik och annat kul ONLINE!",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[3].Id,
},
new ModuleClass
{
Name = "Butikshopping",
Description = "Lär dig gå och strosa runt på stan som en kung.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[3].Id,
},
new ModuleClass
{
Name = "Springa",
Description = "Spicy jalapeno bacon ipsum dolor amet salami capicola bresaola leberkas pastrami. Landjaeger jowl tail andouille, short loin kevin sirloin swine kielbasa picanha. Sausage spare ribs boudin picanha ham hock pastrami porchetta doner chicken venison. Frankfurter swine porchetta shankle beef ribs.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[4].Id,
},
new ModuleClass
{
Name = "Dribbla",
Description = "Meatball andouille ground round bresaola shankle swine. Picanha ham hock meatloaf jowl flank chuck. Prosciutto turkey drumstick alcatra shank pork belly. Ham hock doner short loin, ball tip beef hamburger drumstick tenderloin bresaola beef ribs tri-tip flank fatback cow. Cupim venison prosciutto kevin. Porchetta cow strip steak pancetta. Kevin strip steak bacon, sirloin pig short ribs frankfurter hamburger.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[4].Id,
},
new ModuleClass
{
Name = "Skjuta",
Description = "Sirloin salami filet mignon ground round pancetta pig. Beef ribs brisket tri-tip short loin sirloin burgdoggen boudin swine biltong. Brisket beef ribs turducken kielbasa ground round prosciutto cupim rump. Burgdoggen doner shank, t-bone venison jerky rump.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 11, 14),
CourseClassId = course[4].Id,
},
};
context.ModuleClasses.AddOrUpdate(m => m.Name, module);
context.SaveChanges();
ActivityClass[] activity = new ActivityClass[]
{
new ActivityClass
{
Name = "Introduction",
Description = "Sirloin salami filet mignon ground round pancetta pig. Beef ribs brisket tri-tip short loin sirloin burgdoggen boudin swine biltong. Brisket beef ribs turducken kielbasa ground round prosciutto cupim rump. Burgdoggen doner shank, t-bone venison jerky rump. Swine jowl hamburger corned beef short ribs. Beef ribs meatloaf short loin swine brisket hamburger. Tongue bresaola tri-tip, ball tip capicola ground round drumstick jerky corned beef alcatra fatback shoulder rump picanha sirloin. Rump t-bone brisket spare ribs biltong, cupim tenderloin boudin filet mignon tongue. Cow tri-tip frankfurter jowl, ribeye ham hock cupim short loin swine turkey shankle fatback.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[0].Id
},
new ActivityClass
{
Name = "AngularJS",
Description = "Bacon jerky alcatra biltong ham prosciutto. Biltong pig short ribs fatback kevin rump. Shoulder drumstick ribeye cow, leberkas pork loin meatloaf salami. Cupim alcatra t-bone swine, ham hock corned beef strip steak beef ribs turducken short ribs. Shank sirloin shoulder t-bone, pig pastrami turkey pork ball tip pancetta kevin pork loin alcatra.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[0].Id
},
new ActivityClass
{
Name = "Fundamentals",
Description = "Hamburger t-bone kevin, biltong pork salami venison tail. Sirloin fatback meatloaf shoulder capicola. Bacon short ribs sausage capicola beef, leberkas tail ball tip. Corned beef cow spare ribs ground round ribeye pork belly brisket porchetta boudin tail chicken tongue hamburger ham hock sausage. Bacon ball tip t-bone turkey rump, meatball short loin fatback shoulder doner prosciutto salami biltong beef tenderloin. Pork beef turkey pig rump pork loin shank drumstick pork chop tail doner.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[0].Id
},
new ActivityClass
{
Name = "Best Practices",
Description = "Bacon ipsum dolor amet meatball turkey pork chop, capicola jerky kevin prosciutto swine ground round burgdoggen t-bone porchetta beef short ribs rump. Tongue shankle corned beef pork loin short ribs ham hock. Spare ribs bresaola porchetta, rump frankfurter kielbasa filet mignon. Doner pastrami spare ribs pancetta kevin shoulder pork chop turkey bresaola hamburger. Filet mignon pancetta pig bresaola brisket, flank biltong jerky ball tip ribeye landjaeger cow ham prosciutto frankfurter. Pancetta short loin ham hock, turducken doner brisket biltong prosciutto turkey tail. Tenderloin prosciutto kevin rump jerky, ribeye frankfurter tongue filet mignon fatback ham hock chicken turkey tri-tip.",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[0].Id
},
new ActivityClass
{
Name = "Database storage",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[1].Id
},
new ActivityClass
{
Name = "E-learning",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[1].Id
},
new ActivityClass
{
Name = "Style with CSS5",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[2].Id
},
new ActivityClass
{
Name = "Responsive Website",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[2].Id
},
new ActivityClass
{
Name = "Style with Bootstrap",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[2].Id
},
new ActivityClass
{
Name = "Aktivitet 1",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 2",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 3",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 4",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 5",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 6",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 7",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 8",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 9",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 10",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 11",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 12",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 13",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Aktivitet 14",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[3].Id
},
new ActivityClass
{
Name = "Uppgift 1",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[4].Id
},
new ActivityClass
{
Name = "Uppgift 2",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[4].Id
},
new ActivityClass
{
Name = "Uppgift 3",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[4].Id
},
new ActivityClass
{
Name = "Uppgift 4",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[4].Id
},
new ActivityClass
{
Name = "Uppdrag 1",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[5].Id
},
new ActivityClass
{
Name = "Uppdrag 2",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[5].Id
},
new ActivityClass
{
Name = "Uppdrag 3",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[5].Id
},
new ActivityClass
{
Name = "Uppdrag 4",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[5].Id
},
new ActivityClass
{
Name = "Uppdrag 5",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[5].Id
},
new ActivityClass
{
Name = "Activity 1",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[6].Id
},
new ActivityClass
{
Name = "Activity 2",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[6].Id
},
new ActivityClass
{
Name = "Activity 3",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[6].Id
},
new ActivityClass
{
Name = "Onlinepizza",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[7].Id
},
new ActivityClass
{
Name = "AliExpress",
Description = "Det här är en beskrivning till Uppgift 1",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[7].Id
},
new ActivityClass
{
Name = "Zalando",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[7].Id
},
new ActivityClass
{
Name = "Pizzeria Glada Hudik",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[8].Id
},
new ActivityClass
{
Name = "Thai-vagnen",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[8].Id
},
new ActivityClass
{
Name = "Hemköp",
Description = "Det här är en beskrivning till Uppgift 5",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[8].Id
},
new ActivityClass
{
Name = "Konditionsträning",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[9].Id
},
new ActivityClass
{
Name = "Tunnla Zlatan",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[10].Id
},
new ActivityClass
{
Name = "Dribbla förbi hela Malmö FF",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[10].Id
},
new ActivityClass
{
Name = "Hörnor",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[11].Id
},
new ActivityClass
{
Name = "Frisparkar",
Description = "Det här är en beskrivning till Uppgift 3",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[11].Id
},
new ActivityClass
{
Name = "Straffar",
Description = "Det här är en beskrivning till Uppgift 4",
StartTime = new DateTime(2015, 10, 14),
EndTime = new DateTime(2015, 10, 14),
ModuleClassId = module[11].Id
}
};
context.ActivityClasses.AddOrUpdate(a => a.Name, activity);
context.SaveChanges();
UserStore <ApplicationUser> userStore = new UserStore <ApplicationUser>(context);
UserManager <ApplicationUser> userManager = new UserManager <ApplicationUser>(userStore);
string[] emails = new[] { "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "messi@lexicon", "*****@*****.**" };
string[] firstName = new[] { "Teacher", "John", "Dimitris", "Bob", "Hans", "Olle", "Marcus", "Johan", "Gigar", "Victor", "Mats", "Anton", "Andres", "Henrik", "Thomas", "Zlatan", "Neymar", "Steven", "Leo", "Cristiano" };
string[] lastName = new[] { "Lexicon", "Hellman", "Björlingh", "Bobsson", "Andersen", "Oren", "Broman", "Bengter", "Khalil", "Berglund", "Danhard", "Olsson", "Pontio", "Forslin", "Myrsten", "Ibrahimovic", "Jr", "Gerrard", "Messi", "Ronaldo" };
int i = 0;
foreach (string email in emails)
{
if (!context.Users.Any(u => u.UserName == email))
{
if (i < 3)
{
ApplicationUser user = new ApplicationUser {
UserName = email, Email = email, FirstName = firstName[i], LastName = lastName[i], TimeOfRegistration = DateTime.Now, CourseClassId = course[0].Id
};
var result = userManager.Create(user, "password");
if (!result.Succeeded)
{
throw new Exception(string.Join("\n", result.Errors));
}
}
else if (i < 6)
{
ApplicationUser user = new ApplicationUser {
UserName = email, Email = email, FirstName = firstName[i], LastName = lastName[i], TimeOfRegistration = DateTime.Now, CourseClassId = course[2].Id
};
var result = userManager.Create(user, "password");
if (!result.Succeeded)
{
throw new Exception(string.Join("\n", result.Errors));
}
}
else if (i < 15)
{
ApplicationUser user = new ApplicationUser {
UserName = email, Email = email, FirstName = firstName[i], LastName = lastName[i], TimeOfRegistration = DateTime.Now, CourseClassId = course[1].Id
};
var result = userManager.Create(user, "password");
if (!result.Succeeded)
{
throw new Exception(string.Join("\n", result.Errors));
}
}
else
{
ApplicationUser user = new ApplicationUser {
UserName = email, Email = email, FirstName = firstName[i], LastName = lastName[i], TimeOfRegistration = DateTime.Now, CourseClassId = course[4].Id
};
var result = userManager.Create(user, "password");
if (!result.Succeeded)
{
throw new Exception(string.Join("\n", result.Errors));
}
}
}
i++;
}
ApplicationUser Teacher = userManager.FindByName("*****@*****.**");
userManager.AddToRole(Teacher.Id, "Teacher");
Teacher = userManager.FindByName("*****@*****.**");
userManager.AddToRole(Teacher.Id, "Teacher");
Teacher = userManager.FindByName("*****@*****.**");
userManager.AddToRole(Teacher.Id, "Teacher");
foreach (ApplicationUser user in userManager.Users.ToList().Where(u => (u.Email != "*****@*****.**" && u.Email != "*****@*****.**" && u.Email != "*****@*****.**")))
{
userManager.AddToRole(user.Id, "Student");
}
context.SaveChanges();
}
public int ChemByZanyatsya(ActivityClass.activites[] activities, Stats stats, int e, clavisher clav)
{
int j,i,h,k,jj;
bool weapon;
bool change=false;
h = 0;
while ((e!=stats.stats.employment)||(change))
{
change=false;
e=stats.stats.employment;
j=-1;
for (i=activities.Length-1; i>=0; i--)
{
k=0;
if (activities[i].hasOwnActivities)
{
if ((activities[i].weapon!=null))
k=ChemByZanyatsya(activities[i].weapon.moveset, stats, 12, clav);
if (k==1)
{
h=k;
break;
}
}
else if (ClaveComparation(activities[i].why.claves,clav))
if (FComparation(Mathf.Abs(stats.gameObject.rigidbody2D.velocity.x),activities[i].why.speedX*1f)&&
FComparation(Mathf.Abs(stats.gameObject.rigidbody2D.velocity.y),activities[i].why.speedY*1f)&&
IntComparation(stats.direction+2, activities[i].why.direction)&&
IntComparation(stats.stats.groundness,activities[i].why.groundness)&&
IntComparation(stats.stats.obstacleness,activities[i].why.obstacleness)&&
IntComparation(stats.stats.groundness,activities[i].why.groundness)&&
ComprFunctionality(stats.stats.maxInteraction,activities[i].why.maxinteraction)&&
ComprFunctionality(stats.stats.interaction,activities[i].why.interaction)&&
IntComparation(stats.stats.upness,activities[i].why.upness)&&
IntComparation(stats.stats.specialness,activities[i].why.specialness))
{
if (activities[i].weapon==null)
weapon=true;
else
weapon=ComprFunctionality(activities[i].weapon.ready,activities[i].why.weaponReady);
if (weapon)
{
if (i+1<activities.Length)
{
if ((activities[i+1].change)&&(activities[i].why.employment<=stats.stats.employment+activities[i+1].why.employment))
{
change=true;
j=i;
break;
}
else if ((activities[i].why.employment<=stats.stats.employment)&&
(!activities[i].chosen))
{
j=i;
break;
}
}
if ((activities[i].why.employment<=stats.stats.employment)&&
(!activities[i].chosen))
{
j=i;
break;
}
}
}
}
if ((change)&&(j>=0))
{
for (jj=0;jj<stats.gameObject.GetComponent<RootCharacterController>().whatToEmploy.Count;jj++)
if (stats.gameObject.GetComponent<RootCharacterController>().whatToEmploy[jj].name.Equals(activities[j+1].name))
break;
if (jj<stats.gameObject.GetComponent<RootCharacterController>().whatToEmploy.Count)
{
stats.gameObject.GetComponent<RootCharacterController>().whatToEmploy.Remove(stats.gameObject.GetComponent<RootCharacterController>().whatToEmploy[jj]);
activities[j+1].chosen=false;
activities[j+1].change=false;
stats.stats.employment+=activities[j+1].employ;
}
}
if (j>=0)
{
stats.gameObject.GetComponent<RootCharacterController>().whatToEmploy.Add (activities[j]);
activities[j].timer=activities[j].timeOfAction;
stats.stats.employment-=activities[j].employ;
if (activities[j].soWhat.groundness>=0) stats.stats.groundness=activities[j].soWhat.groundness;
if (activities[j].soWhat.obstacleness>=0) stats.stats.obstacleness=activities[j].soWhat.obstacleness;
if (activities[j].soWhat.interaction>=0)stats.stats.interaction=activities[j].soWhat.interaction;
if (activities[j].soWhat.upness>0)stats.stats.upness=activities[j].soWhat.upness-1;
if (activities[j].soWhat.specialness>=0)stats.stats.specialness=activities[j].soWhat.specialness;
activities[j].chosen=true;
h=1;
}
}
return h;
}
public int AddActivity(ActivityClass.activites[] activities, ActivityClass.activites activity, int numb)
{
activities [numb] = activity;
numb++;
return numb;
}
public int DeleteActivity(ActivityClass.activites[] activities, int del, int numb)
{
for (int i=del+1;i<numb;i++)
activities[i-1]=activities[i];
numb--;
return numb;
}
public int EmployTime(ActivityClass.activites act, ActivityClass.activites[] acts)
{
if (act.weapon == null)
return acts [act.numb].timer;
else
return act.weapon.moveset [act.numb].timer;
}
/// <summary>
/// Set ActivityClass field</summary>
/// <param name="activityClass_">Nullable field value to be set</param>
public void SetActivityClass(ActivityClass? activityClass_)
{
SetFieldValue(17, 0, activityClass_, Fit.SubfieldIndexMainField);
}
public void ChangeTimer(int timer, ActivityClass.activites act, ActivityClass.activites[] acts)
{
if (act.weapon == null)
acts [act.numb].timer = timer;
else
act.weapon.moveset [act.numb].timer = timer;
}
