public bool SaveResOrder(ResOrderDto resOrderDto)
{
try
{
ResOrder resOrder = new ResOrder()
{
Id = resOrderDto.Id,
MenuId = resOrderDto.MenuId,
BillId = resOrderDto.BillId,
Amount = resOrderDto.Amount,
Discount = resOrderDto.Discount,
CreatedBy = resOrderDto.CreatedBy,
CreatedDate = DateTime.Now,
UpdatedBy = resOrderDto.UpdatedBy,
UpdatedDate = DateTime.Now
};
m_PersistenceManager.Save <ResOrder>(resOrder);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
private void btnThemMonAn_Click(object sender, EventArgs e)
{
if (!IsValidInputData())
{
return;
}
var resOrderDto = new ResOrderDto();
resOrderDto.MenuId = long.Parse(MControlUtil.GetValueFromCombobox(cboMonAn));
resOrderDto.BillId = GetSelectedBillId();
resOrderDto.Amount = long.Parse(txtSoLuong.Text);
var disCount = 0.0f;
if (!"".Equals(txtChietKhau.Text))
{
disCount = long.Parse(txtChietKhau.Text) / 100.0f;
}
resOrderDto.Discount = disCount;
string currentUserName = _danhSachUser.GetCurrentUserName();
resOrderDto.CreatedBy = currentUserName;
resOrderDto.UpdatedBy = currentUserName;
_billingDao.AddNewResOrder(resOrderDto);
dgvHoaDon_SelectionChanged(null, null);
}
public List <ResOrderDto> GetAllResOrderBy(long billId)
{
using (ISession session = m_SessionFactory.OpenSession())
{
var query = session.CreateQuery("select new ResOrder(o.Id, m.Name, o.Amount, o.Discount, u.Name, m.Price)"
+ " from ResOrder o, Menu m, Unit u where o.MenuId = m.Id and m.UnitId = u.Id and o.BillId = :billId");
query.SetParameter("billId", billId);
// Get the matching objects
var allResOrders = query.List();
// Update Role info
var listResOrderDtos = new List <ResOrderDto>();
foreach (ResOrder resOrder in allResOrders)
{
var resOrderDto = new ResOrderDto()
{
Id = resOrder.Id,
MenuName = resOrder.MenuName,
Amount = resOrder.Amount,
Discount = resOrder.Discount,
UnitName = resOrder.UnitName,
MenuPrice = resOrder.MenuPrice
};
listResOrderDtos.Add(resOrderDto);
}
return(listResOrderDtos);
}
}
private void AddOneSellRow(ResOrderDto dto)
{
int index = sellDataGridView.Rows.Add();
var r = sellDataGridView.Rows[index];
r.Cells["menu"].Value = dto.MenuName;
r.Cells["unit"].Value = dto.UnitName;
r.Cells["amount"].Value = dto.Amount;
r.Cells["total"].Value = dto.Total.ToString("#,###,###");
}
private void AddOneResOrderRow(ResOrderDto dto, out float oneTotal)
{
oneTotal = dto.Amount * dto.MenuPrice * (1 - dto.Discount);
int index = dgvThucDon.Rows.Add();
var r = dgvThucDon.Rows[index];
r.Cells["MON_AN"].Value = dto.MenuName;
r.Cells["SO_LUONG"].Value = dto.Amount;
r.Cells["DON_VI"].Value = dto.UnitName;
r.Cells["DON_GIA"].Value = dto.MenuPrice.ToString("#,###,###") + " VNĐ";
r.Cells["CHIET_KHAU"].Value = (dto.Discount * 100) + "%";
r.Cells["THANH_TIEN"].Value = oneTotal.ToString("#,###,###") + " VNĐ";
r.Cells["ResOrderId"].Value = dto.Id;
}
public bool AddNewResOrder(ResOrderDto resOrderDto)
{
return(_controller.SaveResOrder(resOrderDto));
}
public List <ResOrderDto> GetAllResOrderDto(StatisticMenuSearchDto dto)
{
using (ISession session = m_SessionFactory.OpenSession())
{
string sqlQuery = "select new ResOrder(o.Id, m.Name, o.Amount, o.Discount, u.Name, m.Price)"
+ " from ResOrder o, Menu m, Unit u where o.MenuId = m.Id and m.UnitId = u.Id";
var mapParams = new Hashtable();
if (!String.IsNullOrEmpty(dto.FromDate))
{
sqlQuery += " and o.CreatedDate >= :fromDate";
mapParams.Add("fromDate", DateUtil.GetDateTime(dto.FromDate));
}
if (!String.IsNullOrEmpty(dto.ToDate))
{
sqlQuery += " and o.CreatedDate < :toDate";
mapParams.Add("toDate", ((DateTime)DateUtil.GetDateTime(dto.ToDate)).AddDays(1));
}
if (!String.IsNullOrEmpty(dto.Thang))
{
DateTime fromDate = (DateTime)DateUtil.GetDateTime("01/" + dto.Thang);
sqlQuery += " and o.CreatedDate >= :fromDate";
mapParams.Add("fromDate", fromDate);
DateTime toDate = fromDate.AddMonths(1);
sqlQuery += " and o.CreatedDate < :toDate";
mapParams.Add("toDate", toDate);
}
if (!String.IsNullOrEmpty(dto.Nam))
{
DateTime fromDate = (DateTime)DateUtil.GetDateTime("01/01/" + dto.Nam);
sqlQuery += " and o.CreatedDate >= :fromDate";
mapParams.Add("fromDate", fromDate);
DateTime toDate = fromDate.AddYears(1);
sqlQuery += " and o.CreatedDate < :toDate";
mapParams.Add("toDate", toDate);
}
if (!String.IsNullOrEmpty(dto.Quy))
{
var quater = int.Parse(dto.Quy.Substring(0, 1));
var year = dto.Quy.Substring(2);
DateTime fromDate;
switch (quater)
{
case 1:
fromDate = (DateTime)DateUtil.GetDateTime("01/01/" + year);
break;
case 2:
fromDate = (DateTime)DateUtil.GetDateTime("01/04/" + year);
break;
case 3:
fromDate = (DateTime)DateUtil.GetDateTime("01/07/" + year);
break;
default:
fromDate = (DateTime)DateUtil.GetDateTime("01/10/" + year);
break;
}
sqlQuery += " and o.CreatedDate >= :fromDate";
mapParams.Add("fromDate", fromDate);
DateTime toDate = fromDate.AddMonths(3);
sqlQuery += " and o.CreatedDate < :toDate";
mapParams.Add("toDate", toDate);
}
var query = session.CreateQuery(sqlQuery);
foreach (DictionaryEntry param in mapParams)
{
query.SetParameter(param.Key.ToString(), param.Value);
}
// Get the matching objects
var allResOrders = query.List();
// Update Role info
var listResOrderDtos = new List <ResOrderDto>();
var mapResOrder = new Hashtable();
foreach (ResOrder resOrder in allResOrders)
{
var total = resOrder.Amount * resOrder.MenuPrice * (1 - resOrder.Discount);
string key = resOrder.MenuName + "|" + resOrder.UnitName;
if (mapResOrder.ContainsKey(key))
{
var resOrderdto = (ResOrderDto)mapResOrder[key];
resOrderdto.Amount += resOrder.Amount;
resOrderdto.Total += total;
}
else
{
var resOrderdto = new ResOrderDto()
{
MenuName = resOrder.MenuName,
UnitName = resOrder.UnitName,
Amount = resOrder.Amount,
Total = total
};
listResOrderDtos.Add(resOrderdto);
mapResOrder.Add(key, resOrderdto);
}
}
return(listResOrderDtos);
}
}
