//[Authorize(Roles="GetProductViewModelByCategory")]
public async Task <IEnumerable <PrdProductViewModel> > GetProductsByCategory(string id)
{
List <PrdProductViewModel> list = new List <PrdProductViewModel>();
try
{
string cmd = $"dbo.PRD_CATEGORY_DT_Search @p_CATEGORY_ID='{id}'";
var rel = _context.PrdCategoryDt.FromSql(cmd);
if (!(rel.Count() > 0))
{
list.Add(new PrdProductViewModel()
{
ListCategory = new List <TreeViewItem>(),
ListPlugins = new List <PrdPlugin>(),
ListSelectedCategory = new List <TreeViewItem>(),
ListSources = new List <PrdSource>(),
ListTemplates = new List <PrdTemplate>(),
PrdProduct = new PrdProductMaster()
});
}
foreach (PrdCategoryDt dt in rel)
{
PrdProductsController con = new PrdProductsController(_context);
PrdProductViewModel pv = await con.GetProductById(dt.PRODUCT_ID);
list.Add(pv);
}
}
catch (Exception ex)
{
}
return(list);
}
//[Authorize(Roles ="UpdateProduct")]
public async Task <ObjectResult> Put(string id, [FromBody] PrdProductViewModel prdProductViewModel)
{
GenericResult rs = new GenericResult();
try
{
string productByIdCommand = $"dbo.PRD_PRODUCT_MASTER_ById @PRODUCT_ID = '{prdProductViewModel.PrdProduct.ProductId}'";
var productResult = await this._context.PrdProductMaster.FromSql(productByIdCommand).SingleAsync();
List <PrdProductDt> listProductDetail = new List <PrdProductDt>();
foreach (var item in prdProductViewModel.ListPlugins)
{
PrdProductDt productDetail = new PrdProductDt();
productDetail.ProductDtId = 0;
productDetail.ProductId = "";
productDetail.Type = "P";
productDetail.ComponentId = item.PluginId;
productDetail.RecordStatus = item.RecordStatus;
listProductDetail.Add(productDetail);
}
foreach (var item in prdProductViewModel.ListSources)
{
PrdProductDt productDetail = new PrdProductDt();
productDetail.ProductDtId = 0;
productDetail.ProductId = "";
productDetail.Type = "S";
productDetail.ComponentId = item.SourceId;
productDetail.RecordStatus = item.RecordStatus;
listProductDetail.Add(productDetail);
}
foreach (var item in prdProductViewModel.ListTemplates)
{
PrdProductDt productDetail = new PrdProductDt();
productDetail.ProductDtId = 0;
productDetail.ProductId = "";
productDetail.Type = "T";
productDetail.ComponentId = item.TemplateId;
productDetail.RecordStatus = item.RecordStatus;
listProductDetail.Add(productDetail);
}
XElement xmlProductDetail = new XElement("Root");
foreach (var item in listProductDetail)
{
XElement childElement = new XElement("PrdProductDt", new XElement("PRODUCT_ID", item.ProductId),
new XElement("TYPE", item.Type),
new XElement("COMPONENT_ID", item.ComponentId),
new XElement("NOTES", item.Notes),
new XElement("RECORD_STATUS", item.RecordStatus),
new XElement("MAKER_ID", item.MakerId),
new XElement("CREATE_DT", item.CreateDt != null? item.CreateDt.Value.Date.ToString("dd/MM/yyyy"):null),
new XElement("AUTH_STATUS", "U"),
new XElement("CHECKER_ID", item.CheckerId),
new XElement("APPROVE_DT", null),
new XElement("EDITOR_ID", prdProductViewModel.PrdProduct.EditorId),
new XElement("EDIT_DT", DateTime.Now.Date.ToString("dd/MM/yyyy")));
xmlProductDetail.Add(childElement);
}
XElement xmlCategoryDetail = new XElement("Root");
var listInsertCategoryDetail = prdProductViewModel.ListSelectedCategory.Where(dt => dt.data.RECORD_STATUS.Equals("1")).ToList();
foreach (var item in listInsertCategoryDetail)
{
XElement childElement = new XElement("PrdCategoryDt", new XElement("CATEGORY_ID", item.data.CATEGORY_ID),
new XElement("PRODUCT_ID", prdProductViewModel.PrdProduct.ProductId),
new XElement("NOTES", item.data.NOTES),
new XElement("RECORD_STATUS", "1"),
new XElement("AUTH_STATUS", "U"),
new XElement("MAKER_ID", prdProductViewModel.PrdProduct.MakerId),
new XElement("CREATE_DT", DateTime.Now.Date.ToString("dd/MM/yyyy")),
new XElement("CHECKER_ID", item.data.CHECKER_ID),
new XElement("APPROVE_DT", null),
new XElement("EDITOR_ID", item.data.EDITOR_ID),
new XElement("EDIT_DT", DateTime.Now.Date.ToString("dd/MM/yyyy")));
xmlCategoryDetail.Add(childElement);
}
string command = $"dbo.PRD_PRODUCT_MASTER_Upd @p_PRODUCT_ID = '{prdProductViewModel.PrdProduct.ProductId}', @p_PRODUCT_CODE='{prdProductViewModel.PrdProduct.ProductCode}',@p_PRODUCT_NAME=N'{prdProductViewModel.PrdProduct.ProductName}',@p_PRODUCT_LOCATION=N'{prdProductViewModel.PrdProduct.ProductLocation}',@p_PRODUCT_TYPE=N'{prdProductViewModel.PrdProduct.ProductType}', @p_PRICE={prdProductViewModel.PrdProduct.Price??0}, @p_PRICE_VAT={prdProductViewModel.PrdProduct.PriceVat??0}, @p_VAT={prdProductViewModel.PrdProduct.Vat??0}, @p_DISCOUNT_AMT={prdProductViewModel.PrdProduct.DiscountAmt??0}, @p_SCRIPTS=N'{prdProductViewModel.PrdProduct.Scripts}',@p_NOTES=N'{prdProductViewModel.PrdProduct.Notes}',@p_RECORD_STATUS='1',@p_MAKER_ID='{prdProductViewModel.PrdProduct.MakerId}',@p_CREATE_DT='{DateTime.Now.Date}',@p_AUTH_STATUS='U',@p_CHECKER_ID='',@p_APPROVE_DT='',@p_EDITOR_ID='',@p_EDIT_DT='',@PRODUCT_DT='{xmlProductDetail}',@CATEGORY_DT='{xmlCategoryDetail}'";
var result = await _context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
if (result > 0)
{
rs.Succeeded = true;
rs.Message = "Cập nhật sản phẩm thành công";
}
else
{
rs.Succeeded = false;
rs.Message = "Đã có lỗi xảy ra";
}
ObjectResult objRes = new ObjectResult(rs);
//context.Dispose();
return(objRes);
}
catch (Exception ex)
{
rs.Succeeded = false;
rs.Message = ex.Message;
ObjectResult objRes = new ObjectResult(rs);
//context.Dispose();
return(objRes);
}
}
//[Authorize(Roles = "GetProductById")]
public async Task <PrdProductViewModel> GetProductById(string id)
{
try
{
PrdProductViewModel prdProductViewModel = new PrdProductViewModel();
string command = $"dbo.PRD_PRODUCT_MASTER_ById @PRODUCT_ID = '{id}'";
var product = await this._context.PrdProductMaster.FromSql(command).SingleOrDefaultAsync();
var productDetailCommand = $"dbo.PRD_PRODUCT_DT_Search @p_PRODUCT_DT_ID='',@p_PRODUCT_ID='{product.ProductId}',@p_TYPE='',@p_COMPONENT='',@p_NOTES='',@p_RECORD_STATUS='',@p_MAKER_ID='',@p_CREATE_DT='',@p_AUTH_STATUS='',@p_CHECKER_ID='',@p_APPROVE_DT='',@p_EDITOR_ID='',@p_EDIT_DT='',@p_TOP='' ";
var listProductDetail = await this._context.PrdProductDt.FromSql(productDetailCommand).ToListAsync();
if (product != null)
{
string productCategoryDtCommand = $"dbo.PRD_CATEGORY_DT_Search @p_PRODUCT_ID = '{id}', @p_TOP=''";
var listCategoryDt = await this._context.PrdCategoryDt.FromSql(productCategoryDtCommand).ToListAsync();
string categoryMasterSearchCommand = $"dbo.PRD_CATEGORY_MASTER_Search @p_TOP=''";
var listCategoryMaster = await this._context.PrdCategoryMaster.FromSql(categoryMasterSearchCommand).ToListAsync();
listCategoryMaster.ForEach(cat => cat.RECORD_STATUS = "0");
if (listCategoryDt != null)
{
if (listCategoryDt.Count > 0)
{
foreach (var item in listCategoryMaster)
{
item.RECORD_STATUS = listCategoryDt.Any(dt => dt.CATEGORY_ID.Equals(item.CATEGORY_ID))? "1":"0";
}
}
}
listCategoryMaster = listCategoryMaster.OrderBy(cat => cat.CATEGORY_LEVEL.Value).ToList();
List <TreeViewItem> treeViewData = new List <TreeViewItem>();
Dictionary <string, List <TreeViewItem> > listTemp = new Dictionary <string, List <TreeViewItem> >();
prdProductViewModel.ListSelectedCategory = new List <TreeViewItem>();
foreach (var item in listCategoryMaster)
{
if (String.IsNullOrEmpty(item.PARENT_ID))
{
TreeViewItem treeItem = new TreeViewItem();
treeItem.id = item.CATEGORY_ID;
treeItem.data = item;
treeItem.name = item.CATEGORY_NAME;
treeViewData.Add(treeItem);
if (item.RECORD_STATUS.Equals("1"))
{
prdProductViewModel.ListSelectedCategory.Add(treeItem);
}
listTemp.Add(treeItem.data.CATEGORY_ID, treeItem.children);
}
else
{
TreeViewItem treeItem = new TreeViewItem();
treeItem.id = item.CATEGORY_ID;
treeItem.data = item;
treeItem.name = item.CATEGORY_NAME;
if (item.RECORD_STATUS.Equals("1"))
{
prdProductViewModel.ListSelectedCategory.Add(treeItem);
}
listTemp[item.PARENT_ID].Add(treeItem);
listTemp.Add(treeItem.data.CATEGORY_ID, treeItem.children);
}
}
prdProductViewModel.ListCategory = treeViewData;
prdProductViewModel.PrdProduct = product;
var pluginCommand = $"dbo.PRD_PLUGIN_Search @p_TOP='' ";
prdProductViewModel.ListPlugins = await _context.PrdPlugin.FromSql(pluginCommand).ToListAsync();
var sourceCommand = $"dbo.PRD_SOURCE_Search @p_TOP=''";
var templateCommand = $"dbo.PRD_TEMPLATE_Search @p_TOP=''";
prdProductViewModel.ListSources = await _context.PrdSource.FromSql(sourceCommand).ToListAsync();
prdProductViewModel.ListTemplates = await _context.PrdTemplate.FromSql(templateCommand).ToListAsync();
prdProductViewModel.ListSources.ForEach(item => item.RecordStatus = "0");
prdProductViewModel.ListTemplates.ForEach(item => item.RecordStatus = "0");
prdProductViewModel.ListPlugins.ForEach(item => item.RecordStatus = "0");
//prdProductViewModel.ListPlugins=prdProductViewModel.ListPlugins.Where(plg => !listProductDetail.Exists(dt => dt.ComponentId.Equals(plg.PluginId) && dt.Type.Equals("P"))).ToList();
//prdProductViewModel.ListTemplates=prdProductViewModel.ListTemplates.Where(temp => !listProductDetail.Exists(dt => dt.ComponentId.Equals(temp.TemplateId) && dt.Type.Equals("T"))).ToList();
//prdProductViewModel.ListSources=prdProductViewModel.ListSources.Where(src => !listProductDetail.Exists(dt => dt.ComponentId.Equals(src.SourceId) && dt.Type.Equals("S"))).ToList();
foreach (var item in listProductDetail)
{
if (item.Type.Equals("P"))
{
prdProductViewModel.ListPlugins.Single(plg => plg.PluginId.Equals(item.ComponentId)).RecordStatus = item.RecordStatus;
}
if (item.Type.Equals("S"))
{
prdProductViewModel.ListSources.Single(src => src.SourceId.Equals(item.ComponentId)).RecordStatus = item.RecordStatus;
}
if (item.Type.Equals("T"))
{
prdProductViewModel.ListTemplates.Single(src => src.TemplateId.Equals(item.ComponentId)).RecordStatus = item.RecordStatus;
}
}
// prdProductViewModel.ListPlugins =
}
prdProductViewModel.ListPlugins.RemoveAll(plg => plg.RecordStatus.Equals("0"));
prdProductViewModel.ListSources.RemoveAll(src => src.RecordStatus.Equals("0"));
prdProductViewModel.ListTemplates.RemoveAll(temp => temp.RecordStatus.Equals("0"));
return(prdProductViewModel);
}
catch (Exception ex)
{
return(new PrdProductViewModel());
}
}