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