public List <TheKho> AddTheKhoName(List <TheKho> datas)
{
// Lấy dữ liệu hàng hóa
var ItemsList = ItemsDAO.GetItems().ToDictionary(o => o.ItemID, o => o);
var WHList = GetWarehouses().ToDictionary(o => o.WarehouseListID, o => o);
// Thêm name vào danh sách
foreach (var data in datas)
{
Items item = null;
if (data.ItemID != null && ItemsList.ContainsKey(data.ItemID))
{
item = ItemsList[data.ItemID];
}
WarehouseList wh = null;
if (data.WarehouseListID != null && WHList.ContainsKey(data.WarehouseListID))
{
wh = WHList[data.WarehouseListID];
}
data.WarehouseListName = wh?.WarehouseListName;
data.WHLSEQ = wh?.WHLSEQ ?? 0;
data.ItemName = item?.ItemName;
data.ItemSName = item?.ItemSName;
}
return(datas);
}
//constructor
public ItemsController()
{
errorLogPath = ConfigurationManager.AppSettings["errorLogPath"];
connectionString = ConfigurationManager.ConnectionStrings["dataSource"].ConnectionString;
_ItemsDAO = new ItemsDAO(connectionString, errorLogPath);
Logger.errorLogPath = errorLogPath;
}
protected void btnBookOut_Click(object sender, EventArgs e)
{
item.itemID = lblItemID.Text;
item.dateOut = calBookOut.SelectedDate.ToShortDateString();
ItemsDAO dao = new ItemsDAO();
dao.bookOutItem(item);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ItemsDTO dto = (ItemsDTO)Session["ItemsDTO"];
ModelFacade facade = new ModelFacade();
Items item = facade.createItem(dto);
ItemsDAO dao = new ItemsDAO();
dao.bookInItem(item);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
protected void ddlItems_SelectedIndexChanged(object sender, EventArgs e)
{
int itemId = 0;
itemId = int.Parse(ddlItems.SelectedValue);
Session["DsItemHist"] = new ItemsDAO().GetItemHistoryByItemId(itemId);
gvItemsTransactionHistory.DataSource = (DataSet)Session["DsItemHist"];
gvItemsTransactionHistory.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
item.itemID = lblNewID.Text;
item.custID = dropDownCustID.SelectedValue;
item.barcode = dropDownCustID.SelectedValue + " " + lblNewID.Text;
item.itemType = dropDrownType.SelectedValue;
item.description = txtDescription.Text;
item.model = txtModel.Text;
item.issue = txtIssue.Text;
item.dateIn = calDateIn.SelectedDate.ToShortDateString();
ItemsDAO dao = new ItemsDAO();
dao.updateItem(item);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["DsItemHist"] = null;
DataSet dsItems = new ItemsDAO().GetAllItems();
Master.BindDropdown("ItemDescription", "ItemId", dsItems, ddlItems);
ddlItems.DataBind();
ddlItems.Items.Add(new ListItem("", "0"));
ddlItems.SelectedValue = "0";
}
if (IsCallback)
{
gvItemsTransactionHistory.DataSource = (DataSet)Session["DsItemHist"];
gvItemsTransactionHistory.DataBind();
}
}
/// <summary>
/// Lấy dữ liệu nhập xuất kho
/// </summary>
/// <param name="fromDate">ngày bắt đầu</param>
/// <param name="toDate">ngày kết thúc</param>
/// <param name="warehouseID">mã kho</param>
/// <param name="isPhatSinh">chỉ lấy PS</param>
/// <returns></returns>
public List <GetTongHopKho> AddNameTongHopKho(List <GetTongHopKho> datas)
{
// Lấy dữ liệu hàng hóa
var ItemsList = ItemsDAO.GetItems().ToDictionary(o => o.ItemID, o => o);
var ItemUnitList = ItemsDAO.GetItemUnit().ToDictionary(o => o.ItemUnitID, o => o);
var ItemTypeList = ItemsDAO.GetItemType().ToDictionary(o => o.ItemTypeID, o => o);
var WHList = GetWarehouses().ToDictionary(o => o.WarehouseListID, o => o);
// Thêm name vào danh sách
foreach (var data in datas)
{
if (ItemsList.ContainsKey(data.ItemID))
{
var item = ItemsList[data.ItemID];
data.ItemName = item?.ItemName;
data.ItemSName = item?.ItemSName;
data.ItemTypeID = item?.ItemTypeID;
data.ItemUnitID = item?.ItemUnitID;
if (ItemUnitList.ContainsKey(item.ItemUnitID))
{
var itemUnit = ItemUnitList[item.ItemUnitID];
data.ItemUnitName = itemUnit?.ItemUnitName;
}
if (ItemTypeList.ContainsKey(item.ItemTypeID))
{
var itemType = ItemTypeList[item.ItemTypeID];
data.ItemTypeName = itemType?.ItemTypeName;
data.ItemTypeSName = itemType?.ItemTypeSName;
}
}
if (WHList.ContainsKey(data.WarehouseListID))
{
var wh = WHList[data.WarehouseListID];
data.WarehouseListName = wh?.WarehouseListName;
data.WarehouseListManageCode = wh?.WarehouseListManageCode;
data.WHLSEQ = wh?.WHLSEQ ?? -1;
}
}
return(datas);
}
public int SearchData(ItemsDTO searchDto, out DataTable dtResult)
{
int returnCode = ItemsDAO.SearchData(searchDto as ItemsDTO, out dtResult);
return(returnCode);
}
public int CheckCode(ItemsDTO searchDto)
{
int returnCode = ItemsDAO.CheckCode(searchDto as ItemsDTO);
return(returnCode);
}
public int CountPage(ItemsDTO searchDto)
{
int returnCode = ItemsDAO.CountPage(searchDto as ItemsDTO);
return(returnCode);
}
public int DeleteData(int?id)
{
int returnCode = ItemsDAO.DeleteData(id);
return(returnCode);
}
public int UpdateData(ItemsDTO inputData)
{
int returnCode = ItemsDAO.UpdateData(inputData);
return(returnCode);
}
public int InsertData(ItemsDTO inputData)
{
int returnCode = ItemsDAO.InsertData(inputData);
return(returnCode);
}
public int SearchID(int?id, out ItemsDTO dtResult)
{
int returnCode = ItemsDAO.SearchID(id, out dtResult);
return(returnCode);
}
