public void LessonAdder() { using (DB_Proj db = new DB_Proj()) { string[] RMajor = new string[] { "Computer", "Barq", "Omran", "Mechanic", "Shimi", "Memari" }; int d = 0; for (int i = 0; i < 6; i++) { for (int j = 0; j < 5; j++) { db.Lessons.Add(new MajorsLessons { Major = RMajor[i], Lesson = Lessons[d], Type = "Ekhtesasi", Unit = 3 }); db.SaveChanges(); d++; } } for (int i = 0; i < 2; i++) { for (int j = 0; j < 5; j++) { db.Lessons.Add(new MajorsLessons { Major = RMajor[j], Lesson = Lessons[i + 30], Type = "Omumi", Unit = 1 } ); db.Lessons.Add(new MajorsLessons { Major = RMajor[j], Lesson = Lessons[i + 32], Type = "Paye", Unit = 2 }); db.SaveChanges(); } } db.Lessons.Add(new MajorsLessons { Major = "Memari", Lesson = "Andishe", Type = "Omumi", Unit = 1 }); db.Lessons.Add(new MajorsLessons { Major = "Memari", Lesson = "Adabiat", Type = "Omumi", Unit = 1 }); db.SaveChanges(); } }
public string ChangePass(int Code, string OPass, string NPass, string Who) { using (DB_Proj db = new DB_Proj()) { if (Who == "Student") { var ST = db.St_InfM.Where(i => i.UniCode == Code).FirstOrDefault(); if (ST.Password == OPass) { ST.Password = NPass; db.SaveChanges(); return("Seuccess"); } else { return("PassWrong"); } } if (Who == "Manager") { var Mg = db.Mg_InfM.Where(i => i.OrgCode == Code).FirstOrDefault(); if (Mg.Password == OPass) { Mg.Password = NPass; db.SaveChanges(); return("Seuccess"); } else { return("PassWrong"); } } if (Who == "Teacher") { var Tch = db.Tch_InfM.Where(i => i.OrgCode == Code).FirstOrDefault(); if (Tch.Password == OPass) { Tch.Password = NPass; db.SaveChanges(); return("Seuccess"); } else { return("PassWrong"); } } return("CodeWrong"); } }
public void RegMg(List <Mg_Models> UReg) { using (DB_Proj db = new DB_Proj()) { db.Mg_InfM.AddRange(UReg); db.SaveChanges(); } }
public void RegTch(List <Tch_Models> UReg) { using (DB_Proj db = new DB_Proj()) { db.Tch_InfM.AddRange(UReg); db.SaveChanges(); } }
public void CMOmran(int UCode, List <Marks.OmranM> MarkList) { using (DB_Proj db = new DB_Proj()) { int STID = (from item in db.St_InfM where item.UniCode == UCode select item.St_ModelsId).FirstOrDefault(); var ST = db.OmranD.Where(i => i.St_ModelsId == STID).FirstOrDefault(); ST.Adabiat = MarkList[0].Adabiat; ST.Andishe = MarkList[0].Andishe; ST.Moadelat = MarkList[0].Moadelat; ST.OBotons = MarkList[0].OBotons; ST.ODinamik = MarkList[0].ODinamik; ST.OMasaleh = MarkList[0].OMasaleh; ST.ONaqshe = MarkList[0].ONaqshe; ST.OStatik = MarkList[0].OStatik; ST.Riazi1 = MarkList[0].Riazi1; db.SaveChanges(); } }
// public string ChangeMark(int UCode,string Maj,List) public void CMComp(int UCode, List <Marks.CompM> MarkList) { using (DB_Proj db = new DB_Proj()) { int STID = (from item in db.St_InfM where item.UniCode == UCode select item.St_ModelsId).FirstOrDefault(); var ST = db.CompD.Where(i => i.St_ModelsId == STID).FirstOrDefault(); ST.Adabiat = MarkList[0].Adabiat; ST.Andishe = MarkList[0].Andishe; ST.CDatabase = MarkList[0].CDatabase; ST.CGosaste = MarkList[0].CGosaste; ST.CInteligence = MarkList[0].CInteligence; ST.CManteqi = MarkList[0].CManteqi; ST.CProgramming = MarkList[0].CProgramming; ST.Moadelat = MarkList[0].Moadelat; ST.Riazi1 = MarkList[0].Riazi1; db.SaveChanges(); } }
public void CMMemari(int UCode, List <Marks.MemM> MarkList) { using (DB_Proj db = new DB_Proj()) { int STID = (from item in db.St_InfM where item.UniCode == UCode select item.St_ModelsId).FirstOrDefault(); var ST = db.MemD.Where(i => i.St_ModelsId == STID).FirstOrDefault(); ST.Adabiat = MarkList[0].Adabiat; ST.Andishe = MarkList[0].Andishe; ST.Moadelat = MarkList[0].Moadelat; ST.MeDekor = MarkList[0].MeDekor; ST.MeFazas = MarkList[0].MeFazas; ST.MeNama = MarkList[0].MeNama; ST.MeNaqshe = MarkList[0].MeNaqshe; ST.MeTarahi = MarkList[0].MeTarahi; ST.Riazi1 = MarkList[0].Riazi1; db.SaveChanges(); } }
public void CMShimi(int UCode, List <Marks.ShimiM> MarkList) { using (DB_Proj db = new DB_Proj()) { int STID = (from item in db.St_InfM where item.UniCode == UCode select item.St_ModelsId).FirstOrDefault(); var ST = db.ShimiD.Where(i => i.St_ModelsId == STID).FirstOrDefault(); ST.Adabiat = MarkList[0].Adabiat; ST.Andishe = MarkList[0].Andishe; ST.Moadelat = MarkList[0].Moadelat; ST.SHGaz = MarkList[0].SHGaz; ST.SHHararat = MarkList[0].SHHararat; ST.SHJerm = MarkList[0].SHJerm; ST.SHMavad = MarkList[0].SHMavad; ST.SHSinema = MarkList[0].SHSinema; ST.Riazi1 = MarkList[0].Riazi1; db.SaveChanges(); } }
public void CMMech(int UCode, List <Marks.MechM> MarkList) { using (DB_Proj db = new DB_Proj()) { int STID = (from item in db.St_InfM where item.UniCode == UCode select item.St_ModelsId).FirstOrDefault(); var ST = db.MechD.Where(i => i.St_ModelsId == STID).FirstOrDefault(); ST.Adabiat = MarkList[0].Adabiat; ST.Andishe = MarkList[0].Andishe; ST.Moadelat = MarkList[0].Moadelat; ST.MControl = MarkList[0].MControl; ST.MFizik = MarkList[0].MFizik; ST.MMashin = MarkList[0].MMashin; ST.MSayalat = MarkList[0].MSayalat; ST.MTermo = MarkList[0].MTermo; ST.Riazi1 = MarkList[0].Riazi1; db.SaveChanges(); } }
public void CMBarq(int UCode, List <Marks.BarqM> MarkList) { using (DB_Proj db = new DB_Proj()) { int STID = (from item in db.St_InfM where item.UniCode == UCode select item.St_ModelsId).FirstOrDefault(); var ST = db.BarqD.Where(i => i.St_ModelsId == STID).FirstOrDefault(); ST.Adabiat = MarkList[0].Adabiat; ST.Andishe = MarkList[0].Andishe; ST.Moadelat = MarkList[0].Moadelat; ST.BCmos = MarkList[0].BCmos; ST.BElectro = MarkList[0].BElectro; ST.BMadar = MarkList[0].BMadar; ST.BQodrat = MarkList[0].BQodrat; ST.BVLSI = MarkList[0].BVLSI; ST.Riazi1 = MarkList[0].Riazi1; db.SaveChanges(); } }
public void InfMg(List <Mg_Models> EIS, int OC) { using (DB_Proj db = new DB_Proj()) { for (int j = 0; j < EIS.Count(); j++) { var STI = db.Mg_InfM.Where(i => i.OrgCode == OC).ToList(); STI[j].Name = EIS[j].Name; STI[j].LastName = EIS[j].LastName; STI[j].MeliCode = EIS[j].MeliCode; STI[j].Password = EIS[j].Password; STI[j].Phone = EIS[j].Phone; STI[j].Age = EIS[j].Age; STI[j].BirthDate = EIS[j].BirthDate; STI[j].Email = EIS[j].Email; STI[j].OrgCode = EIS[j].OrgCode; db.SaveChanges(); } } }
public void InfSt(List <St_Models> EIS, int UC) { using (DB_Proj db = new DB_Proj()) { for (int j = 0; j < EIS.Count(); j++) { var STI = db.St_InfM.Where(i => i.UniCode == UC).ToList(); STI[j].Name = EIS[j].Name; STI[j].LastName = EIS[j].LastName; STI[j].Major = EIS[j].Major; STI[j].MeliCode = EIS[j].MeliCode; STI[j].Password = EIS[j].Password; STI[j].Phone = EIS[j].Phone; STI[j].Age = EIS[j].Age; STI[j].Birthdate = EIS[j].Birthdate; STI[j].Email = EIS[j].Email; STI[j].UniCode = EIS[j].UniCode; STI[j].UniLog = EIS[j].UniLog; STI[j].Vahedha = EIS[j].Vahedha; db.SaveChanges(); } } }
public void AddUser() { using (var Db = new DB_Proj()) { List <string> Users = new List <string>() { "mohammad", "mohsen", "hossein", "ahmad", "soheil", "babak", "ramin", "amin", "rahim", "amir", "asqar", "akbar", "armin", "iman", "erfan", "reza", "nima", "saeid", "saber", "masoud", "karim", "baqer", "naeim", "jalil", "jalal", "aziz", "saman", "navid", "vahid", "farid", "hamid", "hamed", "sajad", "mahmud", "sattar" }; string[] Major = new string[] { "Computer", "Barq", "Omran", "Mechanic", "Memari", "Shimi" }; int CN = 1, ON = 1, MN = 1, MeN = 1, ShN = 1, BN = 1; int[] arrn = new int[] { 20, 5, 17, 4, 19, 13, 7, 18, 2, 6, 14, 11, 8 }; for (int i = 0; i < Users.Count; i++) { for (int j = 0; j < Users.Count; j++) { string reshte = Major[j % 6]; if (reshte == "Computer") { Db.St_InfM.Add(new St_Models { Name = Users[i], Password = (Users[i] + "123"), LastName = Users[j] + "i", UniLog = (62 + i), UniCode = ((62 + i) * 100 + i + j), Email = "@gmail.com", Birthdate = 1398 - (62 + i), Major = "Computer", Phone = 021, MeliCode = 0022, Vahedha = 0, AMarks = new List <AllMarks> { new CompM { Riazi1 = arrn[i % 13], Adabiat = arrn[(i * 7) % 13], Andishe = arrn[(i + 3) % 13], Moadelat = arrn[(3 * i + 1) % 13], Major = reshte, CompMId = CN } }, }); CN++; } else if (reshte == "Omran") { Db.St_InfM.Add(new St_Models { Name = Users[i], Password = (Users[i] + "123"), LastName = Users[j] + "i", UniLog = (62 + i), UniCode = ((62 + i) * 100 + i + j), Email = "@gmail.com", Birthdate = 1398 - (62 + i), Major = "Omran", Phone = 021, MeliCode = 0022, Vahedha = 0, AMarks = new List <AllMarks> { new OmranM { Riazi1 = arrn[(3 * i + 1) % 13], Adabiat = arrn[(i * 7) % 13], Andishe = arrn[(i + 3) % 13], Moadelat = arrn[i % 13], Major = reshte, OmranMId = ON } }, }); ON++; } else if (reshte == "Barq") { Db.St_InfM.Add(new St_Models { Name = Users[i], Password = (Users[i] + "123"), LastName = Users[j] + "i", UniLog = (62 + i), UniCode = ((62 + i) * 100 + i + j), Email = "@gmail.com", Birthdate = 1398 - (62 + i), Major = "Barq", Phone = 021, MeliCode = 0022, Vahedha = 0, AMarks = new List <AllMarks> { new BarqM { Riazi1 = arrn[(i + 1) % 13], Adabiat = arrn[(i + 9) % 13], Andishe = arrn[(3 * i) % 13], Moadelat = arrn[(i * 4) % 13], Major = reshte, BarqMId = BN } }, }); BN++; } else if (reshte == "Memari") { Db.St_InfM.Add(new St_Models { Name = Users[i], Password = (Users[i] + "123"), LastName = Users[j] + "i", UniLog = (62 + i), UniCode = ((62 + i) * 100 + i + j), Email = "@gmail.com", Birthdate = 1398 - (62 + i), Major = "Memari", Phone = 021, MeliCode = 0022, Vahedha = 0, AMarks = new List <AllMarks> { new MemM { Adabiat = arrn[(i * 7) % 13], Andishe = arrn[(3 * i + 1) % 13], Major = reshte, MemMId = MeN } }, }); MeN++; } else if (reshte == "Shimi") { Db.St_InfM.Add(new St_Models { Name = Users[i], Password = (Users[i] + "123"), LastName = Users[j] + "i", UniLog = (62 + i), UniCode = ((62 + i) * 100 + i + j), Email = "@gmail.com", Birthdate = 1398 - (62 + i), Major = "Shimi", Phone = 021, MeliCode = 0022, Vahedha = 0, AMarks = new List <AllMarks> { new ShimiM { Riazi1 = arrn[i % 13], Adabiat = arrn[(i * 7) % 13], Andishe = arrn[(3 * i + 1) % 13], Moadelat = arrn[(i + 3) % 13], Major = reshte, ShimiMId = ShN } }, }); ShN++; } else if (reshte == "Mechanic") { Db.St_InfM.Add(new St_Models { Name = Users[i], Password = (Users[i] + "123"), LastName = Users[j] + "i", UniLog = (62 + i), UniCode = ((62 + i) * 100 + i + j), Email = "@gmail.com", Birthdate = 1398 - (62 + i), Major = "Mechanic", Phone = 021, MeliCode = 0022, Vahedha = 0, AMarks = new List <AllMarks> { new MechM { Riazi1 = arrn[(3 * i) % 13], Adabiat = arrn[(i * 4) % 13], Andishe = arrn[(i + 1) % 13], Moadelat = arrn[(i + 9) % 13], Major = reshte, MechMId = MN } }, }); MN++; } } } Db.Mg_InfM.Add(new Mg_Models { Name = "Mahdi", LastName = "Kariman", OrgCode = 97216, Password = "******", Age = 19, BirthDate = 1378, MeliCode = 00225, Phone = 77950, Email = "@gmail.com", Post = "Admin", Education = "P.h Compuer" }); for (int j = 0; j < 34; j++) { Db.Tch_InfM.Add(new Tch_Models { Name = Users[j], Password = (Users[j] + "1234"), LastName = Users[(j + 2) % 34] + "i", OrgCode = ((62 + j) * 100 + j), BirthDate = 1398 - (42 + j), Age = 98 - 42 - j, MeliCode = 0022, Phone = 021, Email = "@gmail.com", TeachingLesson = Lessons[j], Education = "dr." + Major[j % 6] }); } Db.SaveChanges(); } }
public void MarkAdder() { using (DB_Proj db = new DB_Proj()) { var Barqia = db.BarqD.ToList(); var Mechia = db.MechD.ToList(); var Memaria = db.MemD.ToList(); var Shimia = db.ShimiD.ToList(); var Omrania = db.OmranD.ToList(); var Compia = db.CompD.ToList(); int[] arrM = new int[] { 20, 14, 2, 13, 16, 5, 19, 15, 8, 13, 4, 11, 9, 7, 18, 6, 12, 3, 1, 17 }; foreach (BarqM item in Barqia) { int i = item.BarqMId % 20; if (item.BarqMId % 2 == 0) { item.BCmos = arrM[i]; item.BElectro = arrM[i + 1]; } else if (item.BarqMId % 2 == 1) { item.BQodrat = arrM[(2 * i + 1) % 20]; item.BVLSI = arrM[(5 * i) % 20]; } item.BMadar = arrM[(i * 7) % 20]; } db.SaveChanges(); foreach (CompM item in Compia) { int i = (item.CompMId + 1) % 8; if (item.CompMId % 2 == 0) { item.CDatabase = arrM[i]; item.CGosaste = arrM[i + 1]; } else if (item.CompMId % 2 == 1) { item.CProgramming = arrM[(2 * i + 1) % 20]; item.CInteligence = arrM[(5 * i) % 20]; } item.CManteqi = arrM[(i * 7) % 20]; } foreach (OmranM item in Omrania) { int i = item.OmranMId % 8; if (item.OmranMId % 2 == 0) { item.OBotons = arrM[(2 * i + 1) % 20]; item.ODinamik = arrM[i + 1]; } else if (item.OmranMId % 2 == 1) { item.ONaqshe = arrM[i]; item.OStatik = arrM[(5 * i) % 20]; } item.OMasaleh = arrM[(i * 7) % 20]; } foreach (MemM item in Memaria) { int i = item.MemMId % 8; if (item.MemMId % 2 == 0) { item.MeDekor = arrM[(2 * i + 1) % 20]; item.MeFazas = arrM[i + 1]; } else if (item.MemMId % 2 == 1) { item.MeNama = arrM[(5 * i) % 20]; item.MeNaqshe = arrM[i]; } item.MeTarahi = arrM[(i * 7) % 20]; } foreach (ShimiM item in Shimia) { int i = item.ShimiMId % 8; if (item.ShimiMId % 2 == 0) { item.SHGaz = arrM[(i * 7) % 20]; item.SHHararat = arrM[(2 * i + 1) % 20]; } else if (item.ShimiMId % 2 == 1) { item.SHJerm = arrM[i + 1]; item.SHMavad = arrM[(5 * i) % 20]; } item.SHSinema = arrM[i]; } foreach (MechM item in Mechia) { int i = item.MechMId % 8; if (item.MechMId % 2 == 0) { item.MFizik = arrM[(2 * i + 1) % 20]; item.MMashin = arrM[(i * 7) % 20]; } else if (item.MechMId % 2 == 1) { item.MSayalat = arrM[(5 * i) % 20]; item.MTermo = arrM[i]; } item.MControl = arrM[(2 * i + 1) % 20]; } db.SaveChanges(); } }