public int Insert(object obj)
{
KifuEvent kifuEvent = (KifuEvent)obj;
SqlParameter[] parameters = new SqlParameter[2];
string query = "INSERT INTO KifuEvent VALUES((SELECT MAX(KifuID) FROM Kifu),@position,@comment)";
parameters[0] = new SqlParameter("@position", kifuEvent.Position);
parameters[1] = new SqlParameter("@comment", kifuEvent.Comment);
return(SqlHelper.ExecuteNonQuery(query, parameters));
}
public static int NewKifu(string kifuContent, string username)
{
//insert general information
string rule = CommonService.GetContentInBracket(kifuContent, "RU");
string size = CommonService.GetContentInBracket(kifuContent, "SZ");
string komi = CommonService.GetContentInBracket(kifuContent, "KM");
string gameName = CommonService.GetContentInBracket(kifuContent, "GN");
string gameEvent = CommonService.GetContentInBracket(kifuContent, "EV");
string whitePlayer = CommonService.GetContentInBracket(kifuContent, "PW");
string blackPlayer = CommonService.GetContentInBracket(kifuContent, "PB");
string blackLevel = CommonService.GetContentInBracket(kifuContent, "BR");
string whiteLevel = CommonService.GetContentInBracket(kifuContent, "WR");
string date = CommonService.GetContentInBracket(kifuContent, "DT");
if (date.Equals(""))
{
date = DateTime.Now.ToShortDateString();
}
string result = CommonService.GetContentInBracket(kifuContent, "RE");
Kifu kifu = new Kifu(rule, Int32.Parse(size), float.Parse(komi), gameName, gameEvent,
whitePlayer, blackPlayer, whiteLevel, blackLevel, DateTime.Parse(date), result, username);
new KifuDAL().Insert(kifu);
//insert kifu event
string[] kiEvent = kifuContent.Split(';');
ArrayList steps = new ArrayList();
KifuEventDAL kifuEventDAL = new KifuEventDAL();
for (int i = 2; i < kiEvent.Length; i++)
{
if (kiEvent[i].Contains("B") || kiEvent[i].Contains("W"))
{
string position = CommonService.GetContentInBracket(kiEvent[i], "[BW]");
string comment = (kiEvent[i].Split('C').Length > 2) ? kiEvent[i].Split('C')[1] : "";
KifuEvent kifuEvent = new KifuEvent(position, comment);
kifuEventDAL.Insert(kifuEvent);
steps.Add(position);
}
}
int kifuID = GetLastKifuID();
IdentifyOpening(kifuID, steps, blackPlayer, whitePlayer);
return(0);
}
public int Update(object obj)
{
KifuEvent kifuEvent = (KifuEvent)obj;
throw new NotImplementedException();
}