public static void postReceivedProduct(List <ReceivedProductHistory> histories)
{
var username = HttpContext.Current.Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
RegisterProductController.InsertReceivedProduct(histories, acc);
}
public static void updateRegisterProduct(List <RegisterProductSession> data)
{
var username = HttpContext.Current.Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
// Update session khi mà thực thi update thông phi đăng ký nhập hàng
SessionController.updateRegisterProductSession(acc, data);
RegisterProductController.Update(data, acc);
}
public static void updateRegister(Models.RegisterProduct item)
{
string username = HttpContext.Current.Request.Cookies["loginHiddenPage"].Value;
var acc = AccountController.GetByUsername(username);
var now = DateTime.Now;
item.ModifiedBy = acc.ID;
item.ModifiedDate = now;
RegisterProductController.Update(item);
}
public void LoadData()
{
string username = Request.Cookies["loginHiddenPage"].Value;
var acc = AccountController.GetByUsername(username);
DateTime DateConfig = new DateTime(2019, 12, 15);
var config = ConfigController.GetByTop1();
if (config.ViewAllOrders == 1)
{
DateConfig = new DateTime(2018, 6, 22);
}
DateTime fromDate = DateConfig;
DateTime toDate = DateTime.Now;
if (!String.IsNullOrEmpty(Request.QueryString["orderfromdate"]))
{
fromDate = Convert.ToDateTime(Request.QueryString["orderfromdate"]);
}
if (!String.IsNullOrEmpty(Request.QueryString["ordertodate"]))
{
toDate = Convert.ToDateTime(Request.QueryString["ordertodate"]).AddDays(1).AddMinutes(-1);
}
rFromDate.SelectedDate = fromDate;
rFromDate.MinDate = DateConfig;
rFromDate.MaxDate = DateTime.Now;
rToDate.SelectedDate = toDate;
rToDate.MinDate = DateConfig;
rToDate.MaxDate = DateTime.Now;
string textSearch = "";
int categoryID = 0;
int registerStatus = 0;
int Page = 1;
if (Request.QueryString["textsearch"] != null)
{
textSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["categoryid"] != null)
{
categoryID = Request.QueryString["categoryid"].ToInt();
}
if (Request.QueryString["registerstatus"] != null)
{
registerStatus = Request.QueryString["registerstatus"].ToInt(0);
}
if (Request.QueryString["Page"] != null)
{
Page = Request.QueryString["Page"].ToInt();
}
txtSearchProduct.Text = textSearch;
ddlCategory.SelectedValue = categoryID.ToString();
ddlRegisterStatus.SelectedValue = registerStatus.ToString();
// Create order fileter
var filter = new RegisterProductFilterModel()
{
search = textSearch,
category = categoryID,
status = registerStatus,
createdBy = acc.Username,
fromDate = fromDate,
toDate = toDate
};
// Create pagination
var page = new PaginationMetadataModel()
{
currentPage = Page,
pageSize = 30
};
List <RegisterProductList> rs = new List <RegisterProductList>();
rs = RegisterProductController.Filter(filter, ref page);
pagingall(rs, page);
ltrHeading.Text = "Danh sách đặt hàng (" + page.totalCount.ToString() + ")";
ltrAccount.Text = "Tài khoản: <strong>" + acc.Username + "</strong>";
}
public static void removeRegister(int registerID)
{
RegisterProductController.Delete(registerID);
}
public void LoadData()
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
DateTime DateConfig = new DateTime(2019, 12, 15);
var config = ConfigController.GetByTop1();
if (config.ViewAllOrders == 1)
{
DateConfig = new DateTime(2018, 6, 22);
}
DateTime fromDate = DateConfig;
DateTime toDate = DateTime.Now;
if (!String.IsNullOrEmpty(Request.QueryString["orderfromdate"]))
{
fromDate = Convert.ToDateTime(Request.QueryString["orderfromdate"]);
}
if (!String.IsNullOrEmpty(Request.QueryString["ordertodate"]))
{
toDate = Convert.ToDateTime(Request.QueryString["ordertodate"]).AddDays(1).AddMinutes(-1);
}
rFromDate.SelectedDate = fromDate;
rFromDate.MinDate = DateConfig;
rFromDate.MaxDate = DateTime.Now;
rToDate.SelectedDate = toDate;
rToDate.MinDate = DateConfig;
rToDate.MaxDate = DateTime.Now;
string textSearch = String.Empty;
int registerStatus = 0;
string createdBy = String.Empty;
string color = String.Empty;
string size = String.Empty;
var isRegisterProductSession = false;
int Page = 1;
if (Request.QueryString["textsearch"] != null)
{
textSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["registerstatus"] != null)
{
registerStatus = Request.QueryString["registerstatus"].ToInt(0);
}
if (Request.QueryString["createdby"] != null)
{
createdBy = Request.QueryString["createdby"];
}
if (Request.QueryString["color"] != null)
{
color = Request.QueryString["color"];
}
if (Request.QueryString["size"] != null)
{
size = Request.QueryString["size"];
}
if (Request.QueryString["isregisterproductsession"] != null)
{
isRegisterProductSession = true;
}
if (Request.QueryString["Page"] != null)
{
Page = Request.QueryString["Page"].ToInt();
}
txtSearchOrder.Text = textSearch;
ddlRegisterStatus.SelectedValue = registerStatus.ToString();
ddlCreatedBy.SelectedValue = createdBy.ToString();
// Create order fileter
var filter = new RegisterProductFilterModel()
{
search = textSearch,
status = registerStatus,
createdBy = createdBy,
fromDate = fromDate,
toDate = toDate,
color = color,
size = size,
selected = isRegisterProductSession,
account = acc
};
// Create pagination
var page = new PaginationMetadataModel()
{
currentPage = Page
};
List <RegisterProductList> rs = new List <RegisterProductList>();
rs = RegisterProductController.Filter(filter, ref page);
var data = SessionController.getRegisterProductSession(acc);
hdfSession.Value = JsonConvert.SerializeObject(data);
pagingall(rs, page);
ltrNumberOfOrder.Text = page.totalCount.ToString();
}
}
public static List <ReceivedProductHistory> getReceivedProductHistories(int registerID, string sku)
{
return(RegisterProductController.GetReceivedProductHistory(registerID, sku));
}
public static List <GoodsReceipt> getGoodsReceiptInfo(string sku, DateTime registerDate)
{
return(RegisterProductController.GetGoodsReceiptInfo(sku, registerDate));
}
public void pagingall(List <RegisterProductList> acs, PaginationMetadataModel page)
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
StringBuilder html = new StringBuilder();
html.AppendLine("<thead>");
html.AppendLine("<tr>");
html.AppendLine(" <th class='col-checkbox'><input id='checkRegisterAll' type='checkbox'/></th>");
html.AppendLine(" <th class='col-image'>Ảnh</th>");
html.AppendLine(" <th class='col-customer'>Khách hàng</th>");
html.AppendLine(" <th class='col-product'>Sản phẩm</th>");
html.AppendLine(" <th class='col-color'>Màu</th>");
html.AppendLine(" <th class='col-size'>Size</th>");
html.AppendLine(" <th class='col-quantity-request'>Đặt</th>");
html.AppendLine(" <th class='col-quantity-in'>Về</th>");
html.AppendLine(" <th class='col-status'>Trạng thái</th>");
html.AppendLine(" <th class='col-createdby'>Nhân viên</th>");
html.AppendLine(" <th class='col-createddate'>Ngày đặt</th>");
html.AppendLine(" <th class='col-datein'>Ngày về</th>");
html.AppendLine(" <th class='col-action'></th>");
html.AppendLine("</tr>");
html.AppendLine("</thead>");
html.AppendLine("<tbody>");
if (acs.Count > 0)
{
PageCount = page.totalPages;
Int32 Page = page.currentPage;
foreach (var item in acs)
{
var receivedProduct = RegisterProductController.GetReceivedProductHistory(item.id)
.GroupBy(g => new
{
registerID = g.RegisterID,
sku = g.SKU,
image = g.Image,
color = g.Color,
size = g.Size
})
.Select(x => new
{
registerID = x.Key.registerID,
sku = x.Key.sku,
image = x.Key.image,
color = x.Key.color,
size = x.Key.size,
quantity = x.Sum(s => s.Quantity),
receivedDate = x.Max(m => m.ReceivedDate)
})
.ToList();
// Insert transfer bank info for tr tag
var TrTag = new StringBuilder();
TrTag.AppendLine("<tr class='parent-row'");
TrTag.AppendLine(String.Format("data-registerid='{0}' ", item.id));
TrTag.AppendLine(String.Format("data-customer='{0}' ", item.customer));
TrTag.AppendLine(String.Format("data-status='{0}' ", item.status));
TrTag.AppendLine(String.Format("data-variableid='{0}' ", item.variableID));
TrTag.AppendLine(String.Format("data-sku='{0}' ", item.sku));
TrTag.AppendLine(String.Format("data-productstyle='{0}' ", item.productStyle));
TrTag.AppendLine(String.Format("data-numberchild='{0:#,###}' ", item.numberchild));
TrTag.AppendLine(String.Format("data-quantity='{0:#,###}' ", item.quantity));
TrTag.AppendLine(String.Format("data-expecteddate='{0:dd/MM/yyyy HH:mm}' ", item.expectedDate));
TrTag.AppendLine(String.Format("data-note1='{0}' ", item.note1));
TrTag.AppendLine(String.Format("data-note2='{0}' ", item.note2));
TrTag.AppendLine("/>");
html.AppendLine(TrTag.ToString());
html.AppendLine(" <td><input type='checkbox' onchange='checkRegister($(this))'/></td>");
html.AppendLine(" <td data-title='Ảnh'><a target='_blank' href='/xem-san-pham?sku=" + item.sku + "'><img src='" + Thumbnail.getURL(item.image, Thumbnail.Size.Small) + "'></a></td>");
html.AppendLine(" <td data-title='Khách hàng' class='customer-td'><span class='name'>" + item.customer.ToTitleCase() + "</span>");
html.AppendLine(String.Format(" <br><span class='note1'>{0}</span>", String.IsNullOrEmpty(item.note1) ? String.Empty: "<strong>Nhân viên</strong>: " + item.note1));
html.AppendLine(String.Format(" <br><span class='note2'>{0}</span>", String.IsNullOrEmpty(item.note2) ? String.Empty : "<strong>Quản lý</strong>: " + item.note2));
html.AppendLine(" </td>");
html.AppendLine(" <td data-title='Sản phẩm'>" + item.sku + "<br/><a target='_blank' href='/xem-san-pham?sku=" + item.sku + "'>" + item.title + "</a></td>");
html.AppendLine(" <td data-title='Màu'>" + item.color + "</td>");
html.AppendLine(" <td data-title='Size'>" + item.size + "</td>");
if (item.productStyle == 2 && item.variableID == 0)
{
html.AppendLine(String.Format(" <td class='totalQuantity' data-title='Số lượng hàng đặt'>{0:#,###}<br/>({1})</td>", item.numberchild * item.quantity, item.quantity));
}
else
{
html.AppendLine(" <td class='totalQuantity' data-title='Số lượng hàng đặt'>" + String.Format("{0:#,###}", item.quantity) + "</td>");
}
html.AppendLine(" <td class='totalReceivedQuantity' data-title='Số lượng hàng về'>" + String.Format("{0:#,###}", receivedProduct.Sum(s => s.quantity)) + "</td>");
html.AppendLine(" <td id='status' data-title='Trạng thái'>");
switch (item.status)
{
case (int)RegisterProductStatus.Approve:
html.AppendLine(" <span class='bg-green'>" + item.statusName + "</span>");
break;
case (int)RegisterProductStatus.Ordering:
html.AppendLine(" <span class='bg-yellow'>" + item.statusName + "</span>");
break;
case (int)RegisterProductStatus.Done:
html.AppendLine(" <span class='bg-blue'>" + item.statusName + "</span>");
break;
default:
html.AppendLine(" <span class='bg-red'>" + item.statusName + "</span>");
break;
}
html.AppendLine(" </td>");
html.AppendLine(" <td data-title='Nhân viên'>" + item.staffName + "</td>");
html.AppendLine(" <td data-title='Ngày đặt'>" + String.Format("{0:dd/MM}", item.createdDate) + "</td>");
if (receivedProduct.Count > 0)
{
html.AppendLine(" <td id='expectedDate' data-title='Ngày về dự kiến'>" + String.Format("{0:dd/MM}", receivedProduct.Max(m => m.receivedDate)) + "</td>");
}
else
{
html.AppendLine(" <td id='expectedDate' data-title='Ngày về dự kiến'>" + String.Format("{0:dd/MM}", item.expectedDate) + "</td>");
}
html.AppendLine(" <td data-title='Thao tác' class='update-button' id='updateButton'>");
html.AppendLine(" <button type='button' class='btn primary-btn h45-btn' data-toggle='modal' data-target='#RegisterProductModal' data-backdrop='static' data-keyboard='false' title='Cập nhật thông yêu cầu nhập hàng'>");
html.AppendLine(" <span class='glyphicon glyphicon-edit'></span>");
html.AppendLine(" </button>");
if (acc.RoleID == 0)
{
html.AppendLine(" <button type='button' class='btn primary-btn remove-btn h45-btn' title='Hủy yêu cầu nhập hàng' onclick='removeRegister(" + item.id + ")'>");
html.AppendLine(" <span class='glyphicon glyphicon-trash'></span>");
html.AppendLine(" </button>");
}
html.AppendLine(" <br/>");
if (item.productStyle == 2 && item.variableID == 0)
{
html.AppendLine(" <button type='button'");
html.AppendLine(" class='btn primary-btn btn-blue h45-btn show-sub-product'");
html.AppendLine(" title='Xem thông tin sản phẩm con'");
html.AppendLine(" data-status='false'");
if (receivedProduct.Count == 0)
{
html.AppendLine(" style='display:none;'");
}
html.AppendLine(" >");
html.AppendLine(" <span class='glyphicon glyphicon-chevron-down'></span>");
html.AppendLine(" </button>");
}
else
{
html.AppendLine(" <button type='button'");
html.AppendLine(" class='btn primary-btn btn-blue h45-btn show-received-product-histories'");
html.AppendLine(" title='Xem thông tin nhận hàng'");
html.AppendLine(String.Format(" onclick='showReceivedProductHistories({0}, `{1}`)'", item.id, item.sku));
if (receivedProduct.Count == 0)
{
html.AppendLine(" style='display:none;'");
}
html.AppendLine(" >");
html.AppendLine(" <span class='glyphicon glyphicon-list-alt'></span>");
html.AppendLine(" </button>");
}
html.AppendLine(" <button type='button'");
html.AppendLine(" class='btn primary-btn btn-insert h45-btn'");
html.AppendLine(" title='Insert thông tin nhận hàng'");
html.AppendLine(String.Format(" onclick='getReceivedProduct({0}, `{1}`, `{2:yyyy-MM-dd}`)'", item.id, item.sku, item.createdDate));
html.AppendLine(" >");
html.AppendLine(" <span class='glyphicon glyphicon-import'></span>");
html.AppendLine(" </button>");
html.AppendLine(" </td>");
html.AppendLine("</tr>");
var subHTML = new StringBuilder();
foreach (var subItem in receivedProduct)
{
subHTML.AppendLine("<tr class='child-row'");
subHTML.AppendLine(" data-registerid='" + subItem.registerID + "'");
subHTML.AppendLine(" data-sku='" + subItem.sku + "'");
subHTML.AppendLine(" style='display: none;'");
subHTML.AppendLine(" >");
subHTML.AppendLine(" <td></td>");
subHTML.AppendLine(" <td data-title='Ảnh'>");
subHTML.AppendLine(" <a target='_blank' href='/xem-san-pham?sku=" + subItem.sku + "'>");
subHTML.AppendLine(" <img src='/uploads/images/85x113/" + subItem.image + "' style='width: auto'>");
subHTML.AppendLine(" </a>");
subHTML.AppendLine(" </td>");
subHTML.AppendLine(" <td data-title='Mã'>" + subItem.sku + "</td>");
subHTML.AppendLine(" <td></td>");
subHTML.AppendLine(" <td data-title='Màu'>" + subItem.color + "</td>");
subHTML.AppendLine(" <td data-title='Size'>" + subItem.size + "</td>");
subHTML.AppendLine(" <td></td>");
subHTML.AppendLine(String.Format(" <td class='totalReceivedQuantity' data-title='Số lượng hàng về'>{0:#,###}</td>", subItem.quantity));
subHTML.AppendLine(" <td></td>");
subHTML.AppendLine(" <td></td>");
subHTML.AppendLine(" <td></td>");
subHTML.AppendLine(String.Format(" <td class='receivedDate' data-title='Ngày nhận hàng'>{0:dd/MM}</td>", subItem.receivedDate));
subHTML.AppendLine(" <td data-title='Thao tác' class='update-button' id='updateButton'>");
subHTML.AppendLine(" <button type='button'");
subHTML.AppendLine(" class='btn primary-btn btn-blue h45-btn'");
subHTML.AppendLine(" title='Xem thông tin lịch nhập hàng'");
subHTML.AppendLine(" onclick='showReceivedProductHistories(" + subItem.registerID + ", `" + subItem.sku + "`)'");
subHTML.AppendLine(" >");
subHTML.AppendLine(" <span class='glyphicon glyphicon-list-alt'></span>");
subHTML.AppendLine(" </button>");
subHTML.AppendLine(" </td>");
subHTML.AppendLine("</tr>");
}
if (item.productStyle == 2 && item.variableID == 0 && !String.IsNullOrEmpty(subHTML.ToString()))
{
html.AppendLine(subHTML.ToString());
}
}
}
else
{
if (acc.RoleID == 0)
{
html.AppendLine("<tr><td colspan=\"14\">Không tìm thấy đơn hàng...</td></tr>");
}
else
{
html.AppendLine("<tr><td colspan=\"13\">Không tìm thấy đơn hàng...</td></tr>");
}
}
html.AppendLine("</tbody>");
ltrList.Text = html.ToString();
}
