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