public static string getResult(string recordId)
{
using (var db = new AIUniversityEntities())
{
var query1 = from url in db.User_Result_Log
where url.UserLog_ID == recordId
orderby url.sort
join univer in db.University
on url.University_ResultId equals univer.University_ID.ToString()
join enroll in db.University_Enroll_Status
on univer.University_ID.ToString() equals enroll.University_ID
into temp
from tt in temp.DefaultIfEmpty()
select new
{
univer.University_ID,
univer.Country_ID,
univer.UniversityName_CN,
univer.UniversityName_EN,
univer.Rank_World,
univer.CountryName,
univer.DistrictName,
Picture = univer.Picture.Replace("www.", ""),
US_NEWS_Rank = tt.US_NEWS_排名,
zhouwaiMoney = tt.总体花费_州外,
weizhi = tt.地理位置,
url.type
};
return(Obj2Json(new
{
schoolList = query1.ToList(),
result = 1
}));
}
}
public static string getSchoolById(string schoolId)
{
using (var db = new AIUniversityEntities())
{
var query1 = from univer in db.University
where univer.Country_ID.ToString() == schoolId
join enroll in db.University_Enroll_Status
on univer.University_ID.ToString() equals enroll.University_ID
into temp
from tt in temp.DefaultIfEmpty()
orderby tt.QS_排名
select new
{
univer.University_ID,
univer.Country_ID,
univer.UniversityName_CN,
univer.UniversityName_EN,
univer.Rank_World,
univer.CountryName,
univer.DistrictName,
Picture = univer.Picture.Replace("www.", ""),
US_NEWS_Rank = tt.QS_排名,
zhouwaiMoney = tt.总体花费_州外,
weizhi = tt.地理位置
};
return(Obj2Json(new
{
schoolList = query1.Take(100).ToList(),
result = 1
}));
}
}
public static string getRecord(string userId)
{
using (var db = new AIUniversityEntities())
{
var query1 = from u in db.User_Result_Log
where u.User_ID == userId
group u by new
{
u.UserLog_ID,
u.Insert_Date
}
into g
orderby g.Key.Insert_Date descending
select new
{
count = g.Count(),
g.Key.UserLog_ID,
g.Key.Insert_Date
};
var ret = new
{
result = 1,
recordList = query1.ToList()
};
return(Obj2Json(ret));
}
}
public static string schoolSearch(string name, string english)
{
using (var db = new AIUniversityEntities())
{
return(Obj2Json(new
{
schoolList = db.University_Master_CN
.Where(s => s.UniversityName_CN.Contains(name) || s.UniversityName_EN.Contains(english))
.ToList(),
result = 1
}));
}
}
public static string getPicker()
{
using (var db = new AIUniversityEntities())
{
return(Obj2Json(new
{
schoolDetail = (from u in db.University select u.UniversityName_CN).ToList(),
majorList = (from u in db.MajorGroup select u.MajorGroup_Name).ToList(),
countryList = (from u in db.Country select u.Country_Name).ToList(),
periodList = (from u in db.Period select u.Period_Time).ToList(),
result = 1
}));
}
}
public static string getSchool()
{
using (var db = new AIUniversityEntities())
{
var countrys = db.Country.OrderBy(s => s.Country_ID).ToList();
var country_first = countrys[0];
var query1 = from u in db.University
where u.Country_ID == country_first.Country_ID
select new
{
University_ID_INT = u.University_ID,
University_ID_STR = u.University_ID.ToString(),
u.Country_ID,
u.UniversityName_CN,
u.UniversityName_EN,
u.Rank_World,
u.CountryName,
u.DistrictName,
u.Picture
};
var query2 = from univer in query1
join enroll in db.University_Enroll_Status
on univer.University_ID_STR equals enroll.University_ID into temp
from tt in temp.DefaultIfEmpty()
orderby tt.QS_排名
select new
{
University_ID = univer.University_ID_INT,
univer.Country_ID,
univer.UniversityName_CN,
univer.UniversityName_EN,
univer.Rank_World,
univer.CountryName,
univer.DistrictName,
Picture = univer.Picture.Replace("www.", ""),
US_NEWS_Rank = univer.Rank_World,
zhouwaiMoney = tt.总体花费_州外,
weizhi = univer.DistrictName
};
var list = query2.Take(50).ToList();
var ret = new
{
schoolList = list,
result = 1,
data = countrys
};
return(Obj2Json(ret));
}
}
public static string search(string name, string english)
{
using (var db = new AIUniversityEntities())
{
var query1 = from c in db.Country
orderby c.Country_ID
select new
{
c.Country_ID,
c.Country_Name,
c.Region_Name
};
var query2 = from u in db.University
where u.UniversityName_CN.Contains(name) || u.UniversityName_EN.Contains(english)
select u;
var query3 = from univer in query2
join enroll in db.University_Enroll_Status
on univer.University_ID.ToString() equals enroll.University_ID into temp
from tt in temp.DefaultIfEmpty()
orderby tt.US_NEWS_排名
select new
{
University_ID = univer.University_ID.ToString(),
univer.Country_ID,
univer.UniversityName_CN,
univer.UniversityName_EN,
univer.Rank_World,
univer.CountryName,
univer.DistrictName,
Picture = univer.Picture.Replace("www.", ""),
US_NEWS_Rank = univer.Rank_World,
zhouwaiMoney = tt.总体花费_州外,
weizhi = tt.地理位置
};
var ret = new
{
result = 1,
schoolList = query3.ToList(),
data = query1.ToList()
};
return(Obj2Json(ret));
}
}
public static string register(string openId, string nickName, string avatarUrl, string sex)
{
try
{
using (var db = new AIUniversityEntities())
{
var user = db.User.FirstOrDefault(s => s.OpenID == openId);
if (user == null)
{
user = new User();
user.ID = Guid.NewGuid().ToString().Replace("-", "").ToLower();
user.Name = nickName;
user.Picture = avatarUrl;
user.OpenID = openId;
user.CreateTime = DateTime.Now;
user.Sex = sex;
db.User.Add(user);
db.SaveChanges();
}
var ret = new
{
data = user,
result = 1
};
return(Obj2Json(ret));
}
}
catch (Exception e)
{
LogHelper.WriteException(e);
return(Obj2Json(new
{
result = -1,
errmsg = e.Message
}));
}
}
public static string updateUser(string userId, string nickName, string mobile, string xueli, string zhuanye, string age)
{
using (var db = new AIUniversityEntities())
{
var user = db.User.SingleOrDefault(s => s.ID == userId);
if (user != null)
{
if (nickName != null && nickName != "")
{
user.Name = nickName;
}
if (mobile != null && mobile != "")
{
user.Phone = mobile;
}
if (xueli != null && xueli != "")
{
user.Xueli = xueli;
}
if (zhuanye != null && zhuanye != "")
{
user.Zhuanye = zhuanye;
}
if (age != null && age != "")
{
user.Age = age;
}
}
var ret = new
{
user,
result = db.SaveChanges()
};
return(Obj2Json(ret));
}
}
public static string insertBachelorData(
string userId,
string targetCountry,
float GPA,
string GPAType,
int language,
string languageType,
int standardization,
string standardizationType,
string toSchool,
string inclination,
string graduation,
string rank,
string recommend,
string prize,
string summer,
string volunteer)
{
float GPA_Four = 0.0f;
float GPA_Hundred = 0.0f;
int TOEFL = 0;
int IELTS = 0;
int GRE_Score = 0;
int CMAT_Score = 0;
if (GPAType == "四分制")
{
GPA_Four = GPA;
GPA_Hundred = 0.0f;
}
else
{
GPA_Four = 0.0f;
GPA_Hundred = GPA;
}
if (languageType == "托福")
{
TOEFL = language;
IELTS = 0;
}
else
{
TOEFL = 0;
IELTS = language;
}
if (standardizationType == "SAT")
{
GRE_Score = standardization;
CMAT_Score = 0;
}
else if (standardizationType == "ACT")
{
GRE_Score = 0;
CMAT_Score = standardization;
}
else
{
GRE_Score = 0;
CMAT_Score = 0;
}
string id = Guid.NewGuid().ToString().Replace("-", "").ToLower();
DateTime dt_now = DateTime.Now;
using (var db = new AIUniversityEntities())
{
db.User_Bachelor_Log.Add(
new User_Bachelor_Log
{
ID = id,
User_ID = userId,
Target_Country = targetCountry,
GPA_Four = GPA_Four,
GPA_Hundred = GPA_Hundred,
TOEFL = TOEFL,
IELTS = IELTS,
SAT = GRE_Score,
ACT = CMAT_Score,
Target_JoinTime = toSchool,
Prefed_SchoolType = inclination,
MiddleSchool_Type = graduation,
MiddleSchool_GradeLevel = rank,
Recommendation = recommend,
Award = prize,
Summer_Program = summer,
Volunteer_Experience = volunteer,
Insert_Date = dt_now
});
var query = from univer in db.University
where univer.CountryName == targetCountry
join enroll in db.University_Enroll_Status
on univer.University_ID.ToString() equals enroll.University_ID
into temp
from tt in temp.DefaultIfEmpty()
orderby tt.录取难度
orderby tt.录取率
select new
{
univer.University_ID
};
var resultList = query.ToList();
int type = 0;
for (int i = 0; i < resultList.Count; i++)
{
if (i < 2)
{
type = 1;
}
else if (i <= 3)
{
type = 2;
}
else
{
type = 3;
}
db.User_Result_Log.Add(
new User_Result_Log
{
User_ID = userId,
UserLog_ID = id,
University_ResultId = resultList[i].University_ID.ToString(),
Insert_Date = dt_now,
type = type,
sort = i + 1
});
}
db.SaveChanges();
return(Obj2Json(new
{
data = id,
result = 1
}));
}
}
public static string getSchoolDetail(string schoolId)
{
using (var db = new AIUniversityEntities())
{
var obj = db.University_Enroll_Status.FirstOrDefault(s => s.University_ID == schoolId);
if (obj != null)
{
return(Obj2Json(new
{
schoolDetail = new
{
obj.University_ID,
yuanxiaojianjie = obj.院校简介,
xuexiaoleixing = obj.公立_私立,
xiaoyuanweizhi = obj.校园位置,
fanzuilv = obj.犯罪率_犯罪数量_学生数量_,
diliweizhi = obj.地理位置,
xiaoyuan = obj.校园,
sushe = obj.宿舍,
US_NEWS_Rank = obj.US_NEWS_排名,
TIMES_Rank = obj.TIMES_排名,
QS_Rank = obj.QS_排名,
ARWU_Rank = obj.ARWU_排名,
luqunandu = obj.录取难度,
luqulv = obj.录取率,
luqushuliang = obj.录取数量,
luquhouruxuebili = obj.录取后入学比例,
qianwushibili = obj.申请者高中成绩前50_比例,
qianshibili = obj.申请者高中成绩前10_比例,
satyuyangao = obj.SAT语言_GAO,
satyuyandi = obj.SAT语言_DI,
stashuxuegao = obj.SAT数学_GAO,
satshuxuedi = obj.SAT数学_DI,
satxiezuogao = obj.SAT写作_GAO,
satxiezuodi = obj.SAT写作_DI,
actzonghegao = obj.ACT综合_GAO,
actzonghedi = obj.ACT综合_DI,
zhouwaixueshengbili = obj.州外学生比例,
benkeshengshuliang = obj.本科生数量,
yanjiushengshuliang = obj.研究生数量,
xueshengzuzhishuliang = obj.学生组织数量,
xiongdihuishuliang = obj.兄弟会数量,
jiemeihuishuliang = obj.姐妹会数量,
xueshuzuyifenbubai = obj.学术族裔分布_白,
xueshuzuyifenbuyazhou = obj.学术族裔分布_亚洲,
xueshuzuyifenbuhei = obj.学术族裔分布_黑,
xuezafeizhounei = obj.学杂费_州内_,
zongtihuafeizhounei = obj.总体花费_州内_,
xuezafeizhouwai = obj.学杂费_州外_,
zongtihuafeizhouwai = obj.总体花费_州外,
shishi = obj.事实,
zhimingxiaoyou = obj.知名校友,
yiyu = obj.体育,
tupian = obj.图片,
obj.update_date
},
result = 1
}));
}
else
{
return(Obj2Json(new
{
result = 0
}));
}
}
}
public static string insertMasterData(
string userId,
string targetCountry,
string school,
string major1,
string major2,
float GPA,
string GPAType,
int language,
string languageType,
int standardization,
string standardizationType,
string toSchool,
string experience,
string paper,
string recommendation,
string overseas,
string practice)
{
DateTime createTime = DateTime.Now;
float GPA_Four = 0.0f;
float GPA_Hundred = 0.0f;
int TOEFL = 0;
int IELTS = 0;
int GRE_Score = 0;
int CMAT_Score = 0;
string id = Guid.NewGuid().ToString().Replace("-", "").ToLower();
if (GPAType == "四分制")
{
GPA_Four = GPA;
GPA_Hundred = 0.0f;
}
else
{
GPA_Four = 0.0f;
GPA_Hundred = GPA;
}
if (languageType == "托福")
{
TOEFL = language;
IELTS = 0;
}
else
{
TOEFL = 0;
IELTS = language;
}
if (standardizationType == "GRE")
{
GRE_Score = standardization;
CMAT_Score = 0;
}
else if (standardizationType == "GMAT")
{
GRE_Score = 0;
CMAT_Score = standardization;
}
else
{
GRE_Score = 0;
CMAT_Score = 0;
}
using (var db = new AIUniversityEntities())
{
db.User_Master_Log.Add(new User_Master_Log
{
ID = id,
User_ID = userId,
Target_Country = targetCountry,
Current_University = school,
Current_Major = major1,
Target_Major = major2,
GPA_Four = GPA_Four,
GPA_Hundred = GPA_Hundred,
TOEFL = TOEFL,
IELTS = IELTS,
GRE_Score = GRE_Score,
CMAT_Score = CMAT_Score,
Target_JoinTime = toSchool,
Research_Experience = experience,
Paper_Publish = paper,
Recommendation = recommendation,
Abroad_Experience = overseas,
Working_Experience = practice,
Insert_Date = createTime
});
var query = from univer in db.University
where univer.CountryName == targetCountry
join enroll in db.University_Enroll_Status
on univer.University_ID.ToString() equals enroll.University_ID
into temp
from tt in temp.DefaultIfEmpty()
orderby tt.录取难度 descending
select new
{
univer.University_ID
};
var resultList = query.ToList();
int type = 0;
for (int i = 0; i < resultList.Count; i++)
{
if (i < 2)
{
type = 1;
}
else if (i <= 3)
{
type = 2;
}
else
{
type = 3;
}
db.User_Result_Log.Add(
new User_Result_Log
{
User_ID = userId,
UserLog_ID = id,
University_ResultId = resultList[i].University_ID.ToString(),
Insert_Date = createTime,
type = type,
sort = i + 1
});
}
db.SaveChanges();
}
throw new NotImplementedException();
}