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();
}
}
