private void AddItemVoidReport()
{
COrderManager tempOrderManager = new COrderManager();
CResult oResult = tempOrderManager.OrderInfoByOrderID(m_orderID);
COrderInfo tempOrderInfo = new COrderInfo();
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderInfo = (COrderInfo)oResult.Data;
}
ItemVoid aItemVoid=new ItemVoid();
aItemVoid.OrderId = (int)m_orderID;
aItemVoid.Creator_Id = tempOrderInfo.UserID;
aItemVoid.RemoverId = RMS.RMSGlobal.m_iLoginUserID;
ReasonForm aReasonForm = new ReasonForm();
aReasonForm.ShowDialog();
aItemVoid.Reason = aReasonForm.reason;
aItemVoid.VoidDate = DateTime.Now;
foreach (ListViewItem lsvItem in lsvRemovable.Items)
{
try
{
aItemVoid.Quantity = Convert.ToDouble(lsvItem.SubItems[1].Text);
aItemVoid.ItemName = lsvItem.SubItems[0].Text;
int id = Convert.ToInt32(lsvItem.SubItems[3].Text);
CCategory3 aCategory3 = new CCategory3();
CCategory3DAO aCategory3Dao = new CCategory3DAO();
aCategory3 = aCategory3Dao.GetAllCategory3ByCategory3ID(id);
aItemVoid.Amount = aItemVoid.Quantity * aCategory3.Category3TablePrice;
OrderVoidDAO aOrderVoidDao = new OrderVoidDAO();
aOrderVoidDao.InsertItemForVoid(aItemVoid);
}
catch (Exception)
{
}
}
}
public void InsertItemForVoid(ItemVoid aItemVoid)
{
try
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.InsertItemForVoid), aItemVoid.OrderId, aItemVoid.Creator_Id, aItemVoid.RemoverId,
aItemVoid.ItemName, aItemVoid.Quantity, aItemVoid.Amount, aItemVoid.VoidDate, aItemVoid.Reason);
this.ExecuteNonQuery(sqlCommand);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in AddNewOnlineProducts()", LogLevel.Error, "Database");
throw new Exception("Exception occure at AddNewOnlineProducts()", ex);
}
finally
{
this.CloseConnection();
}
}
private ItemVoid ItemvoidReader(IDataReader oReader)
{
ItemVoid oItem = new ItemVoid();
try
{
oItem.OrderId = Convert.ToInt32(oReader["order_id"]);
}
catch (Exception)
{
}
try
{
oItem.CreatorName = (oReader["creatorname"]).ToString();
}
catch (Exception)
{
}
try
{
oItem.RemoverName = (oReader["removername"]).ToString();
}
catch (Exception)
{
}
try
{
oItem.Amount= Convert.ToDouble(oReader["amount"]);
}
catch (Exception)
{
}
try
{
oItem.Quantity = Convert.ToDouble(oReader["item_quantity"]);
}
catch (Exception)
{
}
try
{
oItem.VoidDate = Convert.ToDateTime(oReader["time"]);
}
catch (Exception)
{
}
try
{
oItem.Reason = (oReader["reason"]).ToString();
}
catch (Exception)
{
}
try
{
oItem.ItemName = (oReader["item_name"]).ToString();
}
catch (Exception)
{
}
return oItem;
}