/// <summary>
/// 初始化
/// </summary>
private async void InitCategories()
{
try
{
if (!Tools.IsNetConnective())
{
CrossToastPopUp.Current.ShowToastError("无网络连接，请检查网络。", ToastLength.Long);
return;
}
//RestSharpService _restSharpService = new RestSharpService();
CategoryRD categoryRD = await RestSharpService.GetCategories();
List <Category> categoryList = categoryRD.result;
foreach (var item in categoryList)
{
if (!item.isParent)
{
SubCategoryList.Add(item);
}
}
}
catch (Exception)
{
throw;
}
}
public MainPageViewModel()
{
MainCategoryChangeCommand = new DelegateCommand(() =>
{
if (string.IsNullOrEmpty(SelectedMainCategory) == false)
{
SubCategoryList.Clear();
}
for (int i = 0; i < 50; i++)
{
SubCategoryList.Add($"{SelectedMainCategory} - {i}");
}
});
CustMainCategoryChangeCommand = new DelegateCommand(() =>
{
if (string.IsNullOrEmpty(CustSelectedMainCategory) == false)
{
CustSubCategoryList.Clear();
}
for (int i = 0; i < 50; i++)
{
CustSubCategoryList.Add($"{CustSelectedMainCategory} - {i}");
}
});
}
public EventToCommandBehaviorPageViewModel(INavigationService navigationService)
{
#region 相依性服務注入的物件
_navigationService = navigationService;
#endregion
#region 頁面中綁定的命令
MainCategoryChangeCommand = new DelegateCommand(() =>
{
if (string.IsNullOrEmpty(SelectedMainCategory) == false)
{
SubCategoryList.Clear();
}
for (int i = 0; i < 50; i++)
{
SubCategoryList.Add($"{SelectedMainCategory} - {i}");
}
});
#endregion
#region 事件聚合器訂閱
#endregion
}
public MainPageViewModel(INavigationService navigationService)
{
#region 相依性服務注入的物件
_navigationService = navigationService;
#endregion
#region 頁面中綁定的命令
變更工作名稱Command = new DelegateCommand(() =>
{
fooMyTask.Name = $"現在時間:{DateTime.Now.ToString()}";
});
MainCategoryChangeCommand = new DelegateCommand(() =>
{
SubCategoryList.Clear();
for (int i = 0; i < 50; i++)
{
SubCategoryList.Add($"{SelectedMainCategory} - {i}");
}
});
使用EventToCommandBehaviorCommand = new DelegateCommand(async() =>
{
await _navigationService.NavigateAsync("EventToCommandBehaviorPage");
});
#endregion
#region 事件聚合器訂閱
#endregion
}
/// <summary>
/// To Get Sub Category
/// </summary>
/// <returns></returns>
public SubCategoryList GetSubCategory()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SEL_SUB_CATG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SubCategoryBO SubCategoryBOobj = null;
SubCategoryList SubCategoryListobj = new SubCategoryList();
while (dr.Read())
{
SubCategoryBOobj = new SubCategoryBO();
SubCategoryBOobj.BGT_SUBCATEGORYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("bgt_subcategoryid")));
SubCategoryBOobj.BGT_SUBCATEGORYNAME = dr.GetString(dr.GetOrdinal("bgt_subcategoryname"));
SubCategoryBOobj.ACCOUNTCODE = dr.GetString(dr.GetOrdinal("accountcode"));
SubCategoryBOobj.ISDELETED = dr.GetString(dr.GetOrdinal("isdeleted"));
SubCategoryListobj.Add(SubCategoryBOobj);
}
dr.Close();
return(SubCategoryListobj);
}
/// <summary>
/// Used to display the SubCategory Data List
/// </summary>
/// <returns></returns>
public ActionResult Index(int subCategoryId = 0)
{
var subCategoryList = SubCategoryList.GetSubCategoryListView(subCategoryId);
ViewBag.SubCategoryName = SubCategoryList.GetSubCategoryInformation(subCategoryId);
return(View(subCategoryList));
}
/// <summary>
/// Method to Get the Product Structures(Hierachie) to fill the Category and Subcategory Combobox
/// </summary>
public void GetProductStructure()
{
if (CategoryList.Count() > 0)
{
CategoryList.Clear();
}
if (SubCategoryList.Count() > 0)
{
SubCategoryList.Clear();
}
using (var db = new DataSmartDBContext())
{
var structure = db.ProductStructure.ToList();
if (structure != null)
{
foreach (var d in structure)
{
CategoryList.Add(d.Category_1);
SubCategoryList.Add(d.Category_2);
}
CategoryList = CategoryList.Distinct().ToList();
SubCategoryList = SubCategoryList.Distinct().ToList();
}
}
}
public IActionResult AddNewSubCategory(SubCategoryList _subcategory) //submit new SubCategory
{
if (ModelState.IsValid)
{
var doesSubCategoryExists = _db.SubCategory.Include(s => s.Category).Where(s => s.Name == _subcategory.SubCategory.Name && s.Category.Id == _subcategory.SubCategory.CategoryId);
if (doesSubCategoryExists.Count() > 0)
{
//ERROR DOESEN'T WORK
StatusMessage = "Error: SubCategory already exist under " + doesSubCategoryExists.First().Category.Name + " category. Please use another name.";
}
else
{
_db.SubCategory.Add(_subcategory.SubCategory);
_db.SaveChanges();
return(Redirect(nameof(SubCategoryList)));
}
}
SubCategoryList _subCategoryVM = new SubCategoryList()
{
CategoryList = _db.Category.ToList(),
SubCategory = _subcategory.SubCategory,
SubCategoryLists = _db.SubCategory.OrderBy(p => p.Name).Select(p => p.Name).ToList(),
StatusMessage = StatusMessage
};
return(View("CreateNewSubCategory"));
}
public async Task <IActionResult> SubCategoryList() //display SubCategory List
{
SubCategoryList results = new SubCategoryList();
var SubCategories = await _db.SubCategory.Include(s => s.Category).ToListAsync();
results.SubCategories = SubCategories;
return(View(results));
}
public SubCategoryList GetFilteredSubcategory(int ParentID)
{
SubCategoryList SCList = new SubCategoryList();
SubCategoryFilter SCFilter = new SubCategoryFilter();
SCFilter.SubCategory.ParentID = ParentID;
SCList = MaadSun_Interface.MaadSun_In.GetFilteredSubCategory(SCFilter);
return(SCList);
}
public async Task <IActionResult> CreateNewSubCategory() //create New SubCategory
{
SubCategoryList results = new SubCategoryList()
{
CategoryList = await _db.Category.ToListAsync(),
SubCategory = new Models.SubCategory(),
SubCategoryLists = await _db.SubCategory.OrderBy(p => p.Name).Select(p => p.Name).Distinct().ToListAsync()
};
return(View(results));
}
/// <summary>
/// 获取二级目录
/// </summary>
/// <param name="index"></param>
public void GetSubCategories(int parentId)
{
SubCategoryList.Clear();
foreach (var item in categoryList)
{
if (item.parentId == parentId)
{
SubCategoryList.Add(item);
}
}
}
public MainPageViewModel(INavigationService navigationService)
{
this.navigationService = navigationService;
MainCategoryChangeCommand = new DelegateCommand(() =>
{
if (string.IsNullOrEmpty(SelectedMainCategory) == false)
{
SubCategoryList.Clear();
}
for (int i = 0; i < 50; i++)
{
SubCategoryList.Add($"{SelectedMainCategory} - {i}");
}
});
}
public SubCategoryList GetFilteredSubCategories(SubCategoryFilter SCFilter)
{
SqlDataReader dataReader = null;
SubCategoryList SCList = null;
try
{
SqlCommand sqlCommand = ProjectConnection.CreateCommand();
sqlCommand.CommandText = GETFILTERED_SUBCategory_SP;
sqlCommand.Parameters.Add(new SqlParameter(SUBCATEGORY_PARENTID_PARAM, SqlDbType.Int)).Value = SCFilter.SubCategory.ParentID;
sqlCommand.CommandType = CommandType.StoredProcedure;
ProjectConnection.Open();
dataReader = sqlCommand.ExecuteReader();
SCList = new SubCategoryList();
while (dataReader.Read())
{
SubCategory I = new SubCategory();
I.FillForObject(dataReader);
SCList.Rows.Add(I);
}
dataReader.Close();
ProjectConnection.Close();
}
catch (Exception ex)
{
throw new Exception("SUBCATEGORY", ex);
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (ProjectConnection.State == ConnectionState.Open)
{
ProjectConnection.Close();
}
}
return(SCList);
}
/// <summary>
/// To Get Sub Category By Id
/// </summary>
/// <param name="SubCATEGORYID"></param>
/// <returns></returns>
public SubCategoryBO GetSubCategoryById(int SubCATEGORYID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_SUB_CATG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("BGT_SUBCATEGORYID_", SubCATEGORYID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SubCategoryBO SubCategoryBOobj = null;
SubCategoryList SubCategoryListobj = new SubCategoryList();
SubCategoryBOobj = new SubCategoryBO();
while (dr.Read())
{
if (ColumnExists(dr, "BGT_SUBCATEGORYNAME") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYNAME")))
{
SubCategoryBOobj.BGT_SUBCATEGORYNAME = dr.GetString(dr.GetOrdinal("BGT_SUBCATEGORYNAME"));
}
if (ColumnExists(dr, "ACCOUNTCODE") && !dr.IsDBNull(dr.GetOrdinal("ACCOUNTCODE")))
{
SubCategoryBOobj.ACCOUNTCODE = dr.GetString(dr.GetOrdinal("ACCOUNTCODE"));
}
if (ColumnExists(dr, "BGT_SUBCATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYID")))
{
SubCategoryBOobj.BGT_SUBCATEGORYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_SUBCATEGORYID")));
}
}
dr.Close();
return(SubCategoryBOobj);
}
public async Task <IActionResult> DeleteSubCategory(int?id) //Delete SubCategory
{
if (id == null)
{
return(NotFound());
}
var subCategory = await _db.SubCategory.SingleOrDefaultAsync(m => m.Id == id);
if (subCategory == null)
{
return(NotFound());
}
SubCategoryList results = new SubCategoryList()
{
CategoryList = await _db.Category.ToListAsync(),
SubCategory = subCategory,
SubCategoryLists = await _db.SubCategory.OrderBy(p => p.Name).Select(p => p.Name).Distinct().ToListAsync()
};
return(View(results));
}
