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 Tch_Models Tchsign(int usern, string pass) { using (var Db = new DB_Proj()) { var login = Db.Tch_InfM.Where (i => i.OrgCode == usern && i.Password == pass).FirstOrDefault(); return(login); } }
public List <Mg_Models> MgFilter(string TCS) { using (DB_Proj db = new DB_Proj()) { var login = db.Mg_InfM.Where(i => i.OrgCode.ToString().StartsWith(TCS)); var list = login.ToList(); return(list); } }
public St_Models STSearch(int usern) { using (var Db = new DB_Proj()) { var login = Db.St_InfM.Where (i => i.UniCode == usern).FirstOrDefault(); return(login); } }
public List <St_Models> STFilter(string UCS) { using (var Db = new DB_Proj()) { var login = Db.St_InfM.Where(i => i.UniCode.ToString().StartsWith(UCS)); var SList = login.ToList(); return(SList); } }
public Tch_Models TchSearch(int usern) { using (var Db = new DB_Proj()) { var login = Db.Tch_InfM.Where (i => i.OrgCode == usern).FirstOrDefault(); return(login); } }
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 List <MajorsLessons> AuChart(string RMajor) { using (DB_Proj db = new DB_Proj()) { var EkhChart = db.Lessons.Where(i => i.Major == RMajor); var OmChart = db.Lessons.Where(i => i.Major == "Omumi"); var PaChart = db.Lessons.Where(i => i.Major == "Paye"); List <MajorsLessons> MLPer = new List <MajorsLessons>(); foreach (var item in EkhChart) { MLPer.Add(new MajorsLessons { Lesson = item.Lesson, Type = item.Type, Unit = item.Unit }); } foreach (var item in OmChart) { MLPer.Add(new MajorsLessons { Lesson = item.Lesson, Type = item.Type, Unit = item.Unit }); } if ((RMajor == "Computer") || (RMajor == "Barq") || (RMajor == "Omran") || (RMajor == "Mechanic") || (RMajor == "Shimi") || (RMajor == "Memari")) { foreach (var item in PaChart) { MLPer.Add(new MajorsLessons { Lesson = item.Lesson, Type = item.Type, Unit = item.Unit }); } } return(MLPer); } }
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 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 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 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 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 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 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 List <Marks.MemM> MeMark(int STID) { using (DB_Proj db = new DB_Proj()) { var STRow = db.St_InfM.Where(i => i.UniCode == STID).FirstOrDefault(); var MRow = db.MemD.Where(i => i.St_ModelsId == STRow.St_ModelsId).FirstOrDefault(); List <Marks.MemM> MeMark = new List <Marks.MemM>(); MeMark.Add(new Marks.MemM { MeDekor = MRow.MeDekor, MeFazas = MRow.MeFazas, MeNama = MRow.MeNama, MeNaqshe = MRow.MeNaqshe, MeTarahi = MRow.MeTarahi, Adabiat = MRow.Adabiat, Andishe = MRow.Andishe, Riazi1 = MRow.Riazi1 }); return(MeMark); } }
public List <Marks.CompM> CompMark(int STID) { using (DB_Proj db = new DB_Proj()) { var STRow = db.St_InfM.Where(i => i.UniCode == STID).FirstOrDefault(); var MRow = db.CompD.Where(i => i.St_ModelsId == STRow.St_ModelsId).FirstOrDefault(); List <Marks.CompM> ComMark = new List <Marks.CompM>(); ComMark.Add(new Marks.CompM { CManteqi = MRow.CManteqi, CDatabase = MRow.CDatabase, CGosaste = MRow.CGosaste, CInteligence = MRow.CInteligence, CProgramming = MRow.CProgramming, Riazi1 = MRow.Riazi1, Adabiat = MRow.Adabiat, Andishe = MRow.Andishe, Moadelat = MRow.Moadelat }); return(ComMark); } }
public List <Marks.ShimiM> ShiMark(int STID) { using (DB_Proj db = new DB_Proj()) { var STRow = db.St_InfM.Where(i => i.UniCode == STID).FirstOrDefault(); var MRow = db.ShimiD.Where(i => i.St_ModelsId == STRow.St_ModelsId).FirstOrDefault(); List <Marks.ShimiM> ShiMark = new List <Marks.ShimiM>(); ShiMark.Add(new Marks.ShimiM { SHGaz = MRow.SHGaz, SHHararat = MRow.SHHararat, SHJerm = MRow.SHJerm, SHMavad = MRow.SHMavad, SHSinema = MRow.SHSinema, Riazi1 = MRow.Riazi1, Adabiat = MRow.Adabiat, Andishe = MRow.Andishe, Moadelat = MRow.Moadelat }); return(ShiMark); } }
public List <Marks.BarqM> BarqMark(int STID) { using (DB_Proj db = new DB_Proj()) { var STRow = db.St_InfM.Where(i => i.UniCode == STID).FirstOrDefault(); var MRow = db.BarqD.Where(i => i.St_ModelsId == STRow.St_ModelsId).FirstOrDefault(); List <Marks.BarqM> BarqMark = new List <Marks.BarqM>(); BarqMark.Add(new Marks.BarqM { BCmos = MRow.BCmos, BElectro = MRow.BElectro, BVLSI = MRow.BVLSI, BQodrat = MRow.BQodrat, BMadar = MRow.BMadar, Riazi1 = MRow.Riazi1, Adabiat = MRow.Adabiat, Andishe = MRow.Andishe, Moadelat = MRow.Moadelat, }); return(BarqMark); } }
public List <Marks.MechM> MechMark(int STID) { using (DB_Proj db = new DB_Proj()) { var STRow = db.St_InfM.Where(i => i.UniCode == STID).FirstOrDefault(); var MRow = db.MechD.Where(i => i.St_ModelsId == STRow.St_ModelsId).FirstOrDefault(); List <Marks.MechM> MechMark = new List <Marks.MechM>(); MechMark.Add(new Marks.MechM { MControl = MRow.MControl, MFizik = MRow.MFizik, MMashin = MRow.MMashin, MSayalat = MRow.MSayalat, MTermo = MRow.MTermo, Riazi1 = MRow.Riazi1, Adabiat = MRow.Adabiat, Andishe = MRow.Andishe, Moadelat = MRow.Moadelat, }); return(MechMark); } }
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 List <Marks.OmranM> OmrMark(int STID) { using (DB_Proj db = new DB_Proj()) { var STRow = db.St_InfM.Where(i => i.UniCode == STID).FirstOrDefault(); var MRow = db.OmranD.Where(i => i.St_ModelsId == STRow.St_ModelsId).FirstOrDefault(); List <Marks.OmranM> OmrMark = new List <Marks.OmranM>(); OmrMark.Add(new Marks.OmranM { OBotons = MRow.OBotons, ODinamik = MRow.ODinamik, OMasaleh = MRow.OMasaleh, ONaqshe = MRow.ONaqshe, OStatik = MRow.OStatik, Riazi1 = MRow.Riazi1, Adabiat = MRow.Adabiat, Andishe = MRow.Andishe, Moadelat = MRow.Moadelat, }); return(OmrMark); } }
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 List <string> NullLessons(int UC, string Maj) { List <string> NuLLess = new List <string>(); using (DB_Proj db = new DB_Proj()) { var StInfo = db.St_InfM.Where(a => a.UniCode == UC).FirstOrDefault(); var Omumi = db.Marks.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); //var OLN = Omumi.GetType().GetProperties().Where(a => a.GetValue(Omumi) == null).Select(b => b.Name).ToList(); //for (int i = 0; i < OLN.Count(); i++) //{ // NuLLess.Add(OLN[i]); //} if (Maj == "Computer") { var ComRow = db.CompD.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); var LLN = ComRow.GetType().GetProperties().Where(a => a.GetValue(ComRow) == null).Select(b => b.Name).ToList(); for (int i = 0; i < LLN.Count(); i++) { NuLLess.Add(LLN[i]); } return(NuLLess); } if (Maj == "Barq") { var ComRow = db.BarqD.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); var LLN = ComRow.GetType().GetProperties().Where(a => a.GetValue(ComRow) == null).Select(b => b.Name).ToList(); for (int i = 0; i < LLN.Count(); i++) { NuLLess.Add(LLN[i]); } return(NuLLess); } if (Maj == "Mechanic") { var ComRow = db.MechD.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); var LLN = ComRow.GetType().GetProperties().Where(a => a.GetValue(ComRow) == null).Select(b => b.Name).ToList(); for (int i = 0; i < LLN.Count(); i++) { NuLLess.Add(LLN[i]); } return(NuLLess); } if (Maj == "Omran") { var ComRow = db.OmranD.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); var LLN = ComRow.GetType().GetProperties().Where(a => a.GetValue(ComRow) == null).Select(b => b.Name).ToList(); for (int i = 0; i < LLN.Count(); i++) { NuLLess.Add(LLN[i]); } return(NuLLess); } if (Maj == "Shimi") { var ComRow = db.ShimiD.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); var LLN = ComRow.GetType().GetProperties().Where(a => a.GetValue(ComRow) == null).Select(b => b.Name).ToList(); for (int i = 0; i < LLN.Count(); i++) { NuLLess.Add(LLN[i]); } return(NuLLess); } if (Maj == "Memari") { var ComRow = db.MemD.Where(i => i.St_ModelsId == StInfo.St_ModelsId).FirstOrDefault(); var LLN = ComRow.GetType().GetProperties().Where(a => a.GetValue(ComRow) == null).Select(b => b.Name).ToList(); for (int i = 0; i < LLN.Count(); i++) { NuLLess.Add(LLN[i]); } return(NuLLess); } return(NuLLess); } }
// search dar list asatid public List <ett> Ent(string Less, string Maj) { List <ett> Test = new List <ett>(); using (DB_Proj db = new DB_Proj()) { if (Maj == "Barq") { var f = db.BarqD.ToList(); for (int i = 0; i < db.BarqD.Count() - 1; i++) { var s = f[i].GetType().GetProperties().Where(a => a.Name == Less && a.GetValue(f[i]) != null).FirstOrDefault(); if (s != null) { var y = db.St_InfM.Where(a => a.St_ModelsId == f[i].St_ModelsId).FirstOrDefault(); Test.Add(new ett { Mark = Convert.ToInt16(s.GetValue(f[i])), Lesson = Less, Name = y.Name, LastName = y.LastName, Major = y.Major, UniCode = y.UniCode, Unilog = y.UniLog }); } } return(Test); } if (Maj == "Computer") { var f = db.CompD.ToList(); for (int i = 0; i < db.CompD.Count() - 1; i++) { var s = f[i].GetType().GetProperties().Where(a => a.Name == Less && a.GetValue(f[i]) != null).FirstOrDefault(); if (s != null) { var y = db.St_InfM.Where(a => a.St_ModelsId == f[i].St_ModelsId).FirstOrDefault(); Test.Add(new ett { Mark = Convert.ToInt16(s.GetValue(f[i])), Lesson = Less, Name = y.Name, LastName = y.LastName, Major = y.Major, UniCode = y.UniCode, Unilog = y.UniLog }); } } return(Test); } if (Maj == "Shimi") { var f = db.ShimiD.ToList(); for (int i = 0; i < db.ShimiD.Count() - 1; i++) { var s = f[i].GetType().GetProperties().Where(a => a.Name == Less && a.GetValue(f[i]) != null).FirstOrDefault(); if (s != null) { var y = db.St_InfM.Where(a => a.St_ModelsId == f[i].St_ModelsId).FirstOrDefault(); Test.Add(new ett { Mark = Convert.ToInt16(s.GetValue(f[i])), Lesson = Less, Name = y.Name, LastName = y.LastName, Major = y.Major, UniCode = y.UniCode, Unilog = y.UniLog }); } } return(Test); } if (Maj == "Mechanic") { var f = db.MechD.ToList(); for (int i = 0; i < db.MechD.Count() - 1; i++) { var s = f[i].GetType().GetProperties().Where(a => a.Name == Less && a.GetValue(f[i]) != null).FirstOrDefault(); if (s != null) { var y = db.St_InfM.Where(a => a.St_ModelsId == f[i].St_ModelsId).FirstOrDefault(); Test.Add(new ett { Mark = Convert.ToInt16(s.GetValue(f[i])), Lesson = Less, Name = y.Name, LastName = y.LastName, Major = y.Major, UniCode = y.UniCode, Unilog = y.UniLog }); } } return(Test); } if (Maj == "Omran") { var f = db.OmranD.ToList(); for (int i = 0; i < db.OmranD.Count() - 1; i++) { var s = f[i].GetType().GetProperties().Where(a => a.Name == Less && a.GetValue(f[i]) != null).FirstOrDefault(); if (s != null) { var y = db.St_InfM.Where(a => a.St_ModelsId == f[i].St_ModelsId).FirstOrDefault(); Test.Add(new ett { Mark = Convert.ToInt16(s.GetValue(f[i])), Lesson = Less, Name = y.Name, LastName = y.LastName, Major = y.Major, UniCode = y.UniCode, Unilog = y.UniLog }); } } return(Test); } if (Maj == "Memari") { var f = db.MemD.ToList(); for (int i = 0; i < db.BarqD.Count() - 1; i++) { var s = f[i].GetType().GetProperties().Where(a => a.Name == Less && a.GetValue(f[i]) != null).FirstOrDefault(); if (s != null) { var y = db.St_InfM.Where(a => a.St_ModelsId == f[i].St_ModelsId).FirstOrDefault(); Test.Add(new ett { Mark = Convert.ToInt16(s.GetValue(f[i])), Lesson = Less, Name = y.Name, LastName = y.LastName, Major = y.Major, UniCode = y.UniCode, Unilog = y.UniLog }); } } return(Test); } return(Test); } }
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(); } }