private static void Call(DBManager db, AssortmentProcedure proc) { try { var parameters = db.CallProcedure(proc); } catch (AssortmentException e) { Console.Error.WriteLine("Log Write Error: " + proc.Name + "; Message: " + e.Message); } }
/// <summary> /// Gets merch list /// </summary> /// <exception cref="AssortmentException"></exception> /// <param name="db">DbManager object</param> /// <returns>Merch list</returns> public static SortedList<string, string> GetMerchList(DBManager db) { var parameters = db.CallProcedure(AssortmentProcedure.GetMerchList); var merchList = new SortedList<string, string>(); var merches = parameters["o_recordset"] as List<Dictionary<string, object>>; if (merches != null) { if (merches.Count == 0) throw new AssortmentException("Список менеджеров пуст"); foreach (var t in merches) { merchList.Add(t["MERCH_NAME"].ToString(), t["MERCH_FAX"].ToString()); } } else { throw new AssortmentException("Ошибка при получении списка пользователей"); } return merchList; }
/// <summary> /// Gets merch info /// </summary> /// <exception cref="AssortmentException"></exception> /// <param name="db">DbManager object</param> public void GetMerchInfo(DBManager db) { var parameters = db.CallProcedure(AssortmentProcedure.GetMerch); ID = Convert.ToInt32(parameters["o_merch"].ToString()); MerchName = parameters["o_merch_name"].ToString(); }