/// <summary>
/// Handle event click Select All button
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSelectAll_Click(object sender, EventArgs e)
{
if (this.mode == MODE_APPROVE)
{
if (MessageBox.Show(
"Bạn có chắc chắn muốn phê duyệt đơn nhập hàng này?",
"Xác nhận",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
ItemOrderDTO temp = this.parent.quanLySanPhamBUS.listSPOrder[this.selectedIndex];
temp.isApproved = true;
this.parent.quanLySanPhamBUS.UpdateItemOrder(
this.parent.conn,
temp);
this.parent.quanLySanPhamBUS.AddSanPhamAfterApproveOrder(this.parent.conn, temp.listSP);
this.parent.LoadSPOrderCallback();
this.parent.quanLySanPhamBUS.LoadSanPham(this.parent.conn);
this.parent.dataSanPham = this.parent.quanLySanPhamBUS.listSanPham;
this.parent.LoadSanPhamCallback();
this.parent.selectedBillIndex = -1;
this.Close();
}
}
else
{
for (int i = 0; i < this.listSP.Items.Count; i++)
{
this.listSP.Items[i].Checked = true;
}
}
}
public bool UpdateItemOrder(Connection conn, ItemOrderDTO data)
{
string queryString = "update ItemOrder set owner='" + data.owner +
"',type=" + data.type +
",listItem='" + data.listItemID +
"',isApproved=" + data.isApproved.ToString() +
" where id=" + data.ID;
Console.WriteLine(queryString);
conn.cmd.CommandText = queryString;
try
{
conn.cmd.ExecuteNonQuery();
for (int i = 0; i < data.listSP.Count; i++)
{
ItemDAO itemDAO = new ItemDAO();
data.listSP[i].isImportOrder = false;
itemDAO.UpdateItem(conn, data.listSP[i]);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(false);
}
return(true);
}
/// <summary>
/// Load current order data
/// </summary>
/// <param name="order"></param>
private void LoadOrderData(ItemOrderDTO order)
{
this.data = order.listSP;
this.txtDate.Text = String.Format("{0:MM/dd/yyyy}", order.date);
this.txtOwner.Text = order.owner;
this.LoadData();
}
public List <ItemOrderDTO> LoadApprovedImport(Connection conn)
{
List <ItemOrderDTO> temp = new List <ItemOrderDTO>();
string queryString = "select* from ItemOrder where isApproved = true and isDeleted = false";
conn.cmd.CommandText = queryString;
using (DbDataReader reader = conn.cmd.ExecuteReader())
{
if (!reader.HasRows)
{
return(new List <ItemOrderDTO>());
}
else
{
while (reader.Read())
{
ItemOrderDTO data = new ItemOrderDTO(
reader.GetInt32(0),
reader.GetDateTime(1),
reader.GetString(2),
reader.GetInt32(3),
reader.GetString(4),
reader.GetBoolean(5));
temp.Add(data);
}
}
}
return(temp);
}
public bool AddItemOrder(Connection conn, ItemOrderDTO data)
{
string queryString = "";
for (int i = 0; i < data.listSP.Count; i++)
{
ItemDAO itemDAO = new ItemDAO();
data.listSP[i].isImportOrder = true;
itemDAO.UpdateItem(conn, 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);
conn.cmd.CommandText = queryString;
try
{
conn.cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(false);
}
return(true);
}
public CreateSanPhamImportOrder(InitPage parent, int mode, ItemOrderDTO order, int itemOrder)
{
this.InitializeComponent();
this.parent = parent;
this.selectedIndex = itemOrder;
this.mode = mode;
this.InitFormSetting();
this.LoadOrderData(order);
}
/// <summary>
/// Add SanPham's Import Order to DB
/// </summary>
/// <param name="repository"></param>
public void AddSanPhamImportOrder(Connection conn, ItemOrderDTO data)
{
if (this.itemOrderDAO.AddItemOrder(conn, data))
{
this.LoadSanPhamOrder(conn);
}
else
{
MessageBox.Show(
"Có lỗi xảy ra trong quá trình thêm dữ liệu, vui lòng thử lại!",
"Lỗi",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public List <ItemOrderDTO> getAllItemOrder(Connection conn)
{
List <ItemOrderDTO> result = new List <ItemOrderDTO>();
string queryString = "select* from ItemOrder where isApproved = false and isDeleted = false";
conn.cmd.CommandText = queryString;
using (DbDataReader reader = conn.cmd.ExecuteReader())
{
if (!reader.HasRows)
{
return(new List <ItemOrderDTO>());
}
else
{
while (reader.Read())
{
ItemOrderDTO temp = new ItemOrderDTO(
reader.GetInt32(0),
reader.GetDateTime(1),
reader.GetString(2),
reader.GetInt32(3),
reader.GetString(4),
reader.GetBoolean(5));
result.Add(temp);
}
}
}
for (int i = 0; i < result.Count; i++)
{
string[] listSPID = result[i].listItemID.Trim().Split(' ');
List <ItemDTO> listOrderItem = new List <ItemDTO>();
for (int j = 0; j < listSPID.Length; j++)
{
ItemDAO itemDAO = new ItemDAO();
if (itemDAO.getItemByID(conn, Convert.ToInt32(listSPID[j])).ID != -1)
{
listOrderItem.Add(itemDAO.getItemByID(conn, Convert.ToInt32(listSPID[j])));
}
}
result[i].listSP = listOrderItem;
}
return(result);
}
/// <summary>
/// Handle event click Confirm button
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnOK_Click(object sender, EventArgs e)
{
if (this.mode == MODE_CREATE_IMPORT)
{
if (MessageBox.Show(
"Bạn có chắc muốn lập đơn nhập hàng này?",
"Xác nhận",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
// Get all selected Item
List <ItemDTO> selectedItem = new List <ItemDTO>();
for (int i = 0; i < this.listSP.Items.Count; i++)
{
if (this.listSP.Items[i].Checked)
{
selectedItem.Add(this.data[i]);
}
}
ItemOrderDTO temp = new ItemOrderDTO(
DateTime.Now,
this.parent.currentUser.name,
ItemOrderDTO.IMPORT,
selectedItem,
false);
this.parent.quanLySanPhamBUS.AddSanPhamImportOrder(this.parent.conn, temp);
this.parent.LoadSPOrderCallback();
this.parent.quanLySanPhamBUS.LoadSanPham(this.parent.conn);
this.parent.dataSanPham = this.parent.quanLySanPhamBUS.listSanPham;
this.parent.LoadSanPhamCallback();
}
this.Close();
}
else if (this.mode == MODE_CREATE_RETURN)
{
}
else if (this.mode == MODE_APPROVE)
{
}
}
public bool DeleteItemOrder(Connection conn, ItemOrderDTO data)
{
string queryString = "update ItemOrder set isDeleted=true where id=" + data.ID;
Console.WriteLine(queryString);
conn.cmd.CommandText = queryString;
try
{
conn.cmd.ExecuteNonQuery();
for (int i = 0; i < data.listSP.Count; i++)
{
ItemDAO itemDAO = new ItemDAO();
data.listSP[i].isImportOrder = false;
itemDAO.UpdateItem(conn, data.listSP[i]);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(false);
}
return(true);
}
