/// <summary>
/// Delete the order
/// </summary>
/// <param name="repository"></param>
/// <param name="data"></param>
public void DeleteItemOrder(Repository.Repository repository, Models.ItemOrder data, InitPage parent)
{
string queryString = "update ItemOrder set isDeleted=true where id=" + data.ID;
Console.WriteLine(queryString);
repository.cmd.CommandText = queryString;
try
{
repository.cmd.ExecuteNonQuery();
for (int i = 0; i < data.listSP.Count; i++)
{
data.listSP[i].isImportOrder = false;
this.UpdateSanPham(repository, data.listSP[i]);
}
this.LoadSanPhamOrder(repository);
parent.LoadSPOrderCallback();
this.LoadSanPham(repository);
parent.dataSanPham = this.listSanPham;
parent.LoadSanPhamCallback();
parent.selectedBillIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show(
"Có lỗi xảy ra trong quá trình cập nhật dữ liệu, vui lòng thử lại!\nChi tiết: " + ex.StackTrace,
"Lỗi",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
/// <summary>
/// Handle event click Deselect All button
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnDeselectAll_Click(object sender, EventArgs e)
{
if (this.mode == MODE_APPROVE)
{
if (MessageBox.Show(
"Bạn có chắc chắn muốn từ chối đơn nhập hàng này?",
"Xác nhận",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
this.parent.quanLySanPhamBUS.DeleteItemOrder(
this.parent.conn,
this.parent.quanLySanPhamBUS.listSPOrder[this.selectedIndex]);
parent.LoadSPOrderCallback();
this.parent.quanLySanPhamBUS.LoadSanPham(this.parent.conn);
parent.dataSanPham = this.parent.quanLySanPhamBUS.listSanPham;
parent.LoadSanPhamCallback();
parent.selectedBillIndex = -1;
this.Close();
}
}
else
{
for (int i = 0; i < this.listSP.Items.Count; i++)
{
this.listSP.Items[i].Checked = false;
}
}
}
/// <summary>
/// Add SanPham's Import Order to DB
/// </summary>
/// <param name="repository"></param>
public void AddSanPhamImportOrder(Repository.Repository repository, Models.ItemOrder data, InitPage parent)
{
string queryString = "";
for (int i = 0; i < data.listSP.Count; i++)
{
data.listSP[i].isImportOrder = true;
this.UpdateSanPham(repository, data.listSP[i]);
}
queryString = "insert into ItemOrder(createddate, owner, type, listItem, isApproved) " +
"values('" + String.Format("{0:yyyy/MM/dd}", DateTime.Now) + "'," +
"'" + data.owner + "'," +
data.type + "," +
"'" + this.BuildListIDString(data.listSP) + "'" +
", false)";
Console.WriteLine(queryString);
repository.cmd.CommandText = queryString;
try
{
repository.cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(
"Có lỗi xảy ra trong quá trình thêm dữ liệu, vui lòng thử lại!\nChi tiết: " + ex.StackTrace,
"Lỗi",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
this.LoadSanPhamOrder(repository);
parent.LoadSPOrderCallback();
this.LoadSanPham(repository);
parent.dataSanPham = this.listSanPham;
parent.LoadSanPhamCallback();
}
