public static Dictionary <string, string> RetrieveUserMap(string machine = "", string username = "")
{
var ret = new Dictionary <string, string>();
var sql = "select machine,username from machineusermap where 1 = 1";
if (!string.IsNullOrEmpty(machine))
{
sql = sql + " and machine = '<machine>'";
sql = sql.Replace("<machine>", machine);
}
if (!string.IsNullOrEmpty(username))
{
sql = sql + " and username = '******'";
sql = sql.Replace("<username>", username);
}
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
foreach (var line in dbret)
{
var tempvm = new MachineUserMap();
tempvm.machine = Convert.ToString(line[0]);
tempvm.username = Convert.ToString(line[1]);
if (!ret.ContainsKey(tempvm.machine))
{
ret.Add(tempvm.machine, tempvm.username);
}
}
return(ret);
}
public static void StoreUserScore(string ma, string iname, string vid, string cans, string uans, string usc)
{
var uname = iname.Split(new string[] { "@" }, StringSplitOptions.RemoveEmptyEntries)[0].ToUpper().Trim();
MachineUserMap.TryAddMachineUserMap(ma, uname);
if (ScoreExist(uname, vid).Count == 0)
{
var videos = TechVideoVM.RetrieveVideoByID(vid);
if (videos.Count > 0)
{
UpdateUserRank(uname, usc);
var sql = @"insert into VTestScore(MACHINE,UserName,VID,VSubject,CorrectiveAnswer,UserAnswer,UserScore,UpdateTime)
values(@MACHINE,@UserName,@VID,@VSubject,@CorrectiveAnswer,@UserAnswer,@UserScore,@UpdateTime)";
var param = new Dictionary <string, string>();
param.Add("@MACHINE", ma);
param.Add("@UserName", uname);
param.Add("@VID", vid);
param.Add("@VSubject", videos[0].VSubject);
param.Add("@CorrectiveAnswer", cans);
param.Add("@UserAnswer", uans);
param.Add("@UserScore", usc);
param.Add("@UpdateTime", DateTime.Now.ToString());
DBUtility.ExeLocalSqlNoRes(sql, param);
}
}
}