protected void ButtonAddStatus_Click(object sender, EventArgs e)
{
StatusDb status = new StatusDb()
{
StatusName = this.add_TextBoxStatusName.Text
};
this.GridViewStatus.DataSource = OperationManager.Singleton.izvrsiOperaciju(new OpStatusInsert()
{
Status = status
}).DbItems.Cast <StatusDb>().ToArray();
this.GridViewStatus.DataBind();
}
/// <summary>
/// Метод сохраняет массив типа Object[] в БД
/// </summary>
/// <param name="arrayOfFigures"></param>
public static void SaveFiguresToDb(ref Object[] arrayOfFigures)
{
if (arrayOfFigures == null)
{
throw new ArgumentNullException(nameof(arrayOfFigures));
}
using (DbManager db = new DbManager())
{
StatusDb statusSave = db.SaveToDb(arrayOfFigures);
ConsoleWriteColorText((statusSave == StatusDb.Ok) ? "Фигуры сохранены в БД!\n" :
"Не удалось сохранить фигуры в БД!\n",
(statusSave == StatusDb.Ok) ? ConsoleColor.DarkYellow :
ConsoleColor.DarkRed);
}
}
protected void ButtonUpdateStatus_Click(object sender, EventArgs e)
{
StatusDb status = new StatusDb()
{
IdStatus = Convert.ToInt32(this.LabelStatusId.Text),
StatusName = this.tbStatusName.Text
};
this.GridViewStatus.DataSource = OperationManager.Singleton.izvrsiOperaciju(new OpStatusUpdate()
{
Status = status
}).DbItems.Cast <StatusDb>().ToArray();
this.GridViewStatus.DataBind();
this.LabelStatusId.Text = "";
}
public WSR_Result DeleteStatus(string idstatus)
{
object data = null;
WSR_Result result = null;
if (result == null)
{
StatusDb db = new StatusDb();
data = db.DeleteStatus(Convert.ToInt32(idstatus));
return(new WSR_Result(data, true));
}
else
{
return(result);
}
}
public WSR_Result GetStatus()
{
object data = null;
WSR_Result result = null;
if (result == null)
{
StatusDb db = new StatusDb();
data = db.GetAll();
return(new WSR_Result(data, true));
}
else
{
return(result);
}
}
public WSR_Result SaveStatus(WSR_Param param)
{
StatusDTO status = null;
object data = null;
WSR_Result result = null;
result = VerifParamType(param, "save", out status);
if (result == null)
{
status = (StatusDTO)param["save"];
StatusDb db = new StatusDb();
db.SaveStatus(ref status);
data = status;
return(new WSR_Result(data, true));
}
else
{
return(result);
}
}
/// <summary>
/// Функция загружает фигуры из БД и возвращает массив типа Object[]
/// </summary>
public static Object[] LoadFiguresFromDb()
{
using (DbManager db = new DbManager())
{
Console.WriteLine("Содержимое БД:");
int[] arrayEntryId = null;
StatusDb statusView = db.ViewDb(ref arrayEntryId);
if (statusView != StatusDb.Ok)
{
ConsoleWriteColorText(StatusDbMsg.Msg[(int)statusView],
ConsoleColor.DarkRed);
return(null);
}
foreach (var entryId in arrayEntryId)
{
ConsoleWriteColorText("ID:", ConsoleColor.Yellow);
Console.WriteLine(" {0}", entryId);
}
Console.WriteLine("Сохранение с каким ID просмотреть?");
StatusDb statusLoad;
Object[] arrayOfFigures;
do
{
int viewId = GetIntFromConsole();
statusLoad = db.LoadFromDb(viewId, out arrayOfFigures);
string msgError = (statusLoad == StatusDb.ErrorId) ? StatusDbMsg.Msg[(int)statusLoad] +
"\nВводите ID из предложенного списка!\n" :
StatusDbMsg.Msg[(int)statusLoad] + "\n";
ConsoleWriteColorText(msgError, (statusLoad != StatusDb.Ok) ? ConsoleColor.DarkRed :
ConsoleColor.DarkGreen);
} while (statusLoad == StatusDb.ErrorId);
return(arrayOfFigures);
}
}
public void SelecionaStatus()
{
if (MembroSelecionado == null && LojaSelecionada != null)
{
StatusSelecionados = new ObservableCollection <Models.StatusMembro>(StatusDb.Find(w => w.LojaId == LojaSelecionada.Id).ToList());
}
else if (MembroSelecionado != null && LojaSelecionada == null)
{
StatusSelecionados = new ObservableCollection <Models.StatusMembro>(StatusDb.Find(w => w.MembroId == MembroSelecionado.Id).ToList());
}
else if (MembroSelecionado != null && LojaSelecionada != null)
{
StatusSelecionados = new ObservableCollection <Models.StatusMembro>(StatusDb.Find(w => w.MembroId == MembroSelecionado.Id && w.LojaId == LojaSelecionada.Id).ToList());
}
if (StatusSelecionados != null)
{
foreach (var status in StatusSelecionados)
{
status.NomeMembro = MembrosDb.FindById(status.MembroId).Nome;
}
}
}
