public ActionResult Create([Bind(Include = "ProductID,ProductName,QuantityPerUnit,UnitPrice,UnitInStock,UnitInOrder,ReorderLevel,ProductDescription,Remarks,CategoryID,SupplierID,OwnerID")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", product.CategoryID);
ViewBag.OwnerID = new SelectList(db.OwnerCompanies, "OwnerID", "Owner", product.OwnerID);
ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "SupplierName", product.SupplierID);
return(View(product));
}
public void Load <T>(IEnumerable <T> ts, bool save) where T : class
{
using (var context = new AccountingContext())
{
var dbSet = context
.GetType()
.GetProperty(this.pluralizationService.Pluralize(typeof(T).Name))
.GetValue(context, null) as DbSet <T>;
if (dbSet == null)
{
throw new Exception("could not cast to DbSet<T> for T = " + typeof(T).Name);
}
foreach (var t in ts)
{
dbSet.AddOrUpdate(t);
}
if (save)
{
context.SaveChanges();
}
}
}
public ActionResult SaveOrder(Order inputModel)
{
string message = string.Format("Created user '{0}' in the system.", inputModel.CustomerID);
int orderId = 0;
try
{
db.Orders.Add(inputModel);
db.SaveChanges();
orderId = inputModel.OrderID;
}
catch (Exception ex) {
message = ex.ToString();
}
return(Json(new OrderViewModel {
Message = message, OrderID = orderId
}));
}
public ActionResult Index(HttpPostedFileBase file, UploadedFileInfo upload)
{
//check file extension
string extension = Path.GetExtension(Request.Files[0].FileName).ToLower();
if (extension != ".xls" && extension != ".xlsx")
{
ModelState.AddModelError("uploadError", "Supported file extensions: .xls, .xlsx");
return(View());
}
// extract only the filename
var fileName = Path.GetFileName(file.FileName);
//display adding date
var currentDate = DateTime.Now.ToString("d");
// store the file inside ~/App_Data/uploads folder
var path = Path.Combine(Server.MapPath("~/App_Data/uploads"), currentDate + fileName);
using (AccountingContext context = new AccountingContext())
{
// Verify that the user selects a file
if (file != null && file.ContentLength > 0)
{
file.SaveAs(path);
// save the filename and path in UploadedFilesInfo table
upload.FileName = fileName;
upload.FilePath = path;
context.UploadedFiles.Add(upload);
context.SaveChanges();
}
else
{
ModelState.AddModelError("blankFileError", "You're trying to attach blank file.");
return(View());
}
ExcelHandler excelHandler = new ExcelHandler();
FileInfo fi1 = new FileInfo(path);
var queryId = from customer in context.UploadedFiles
select customer.UploadedFileInfoId;
int?currentId = queryId.ToList().Last();
var id = currentId++ ?? 1;
excelHandler.SelectDataFromFile(fi1, id);
}
// redirect back to the index action to show the form once again
return(RedirectToAction("Index"));
}
public IActionResult Index(string shopName, DateTime dateTime, string description, string[] itemName, decimal[] itemCost, decimal[] itemCount, string[] itemsDiscount)
{
Shop shop = db.Shops.FirstOrDefault(i => i.Name == shopName);
if (shop == null)
{
shop = new Shop {
Name = shopName
};
db.Shops.Add(shop);
}
User user = db.Users.FirstOrDefault(i => i.Login == "CHUKIN");
Purchase purchase = new Purchase {
Shop = shop, User = user, Date = dateTime, Descriprion = description
};
db.Purchases.Add(purchase);
for (int i = 0; i < itemName.Count(); i++)
{
Item item = db.Items.FirstOrDefault(j => j.Name == itemName[i]);
if (item == null)
{
item = new Item {
Name = itemName[i]
};
db.Items.Add(item);
}
bool discount = itemsDiscount.Contains(item.Name);
Price price = new Price {
Date = dateTime, Discount = discount, Cost = itemCost[i], Shop = shop, Item = item
};
db.Prices.Add(price);
PurchaseItem purchaseItem = new PurchaseItem {
Purchase = purchase, Item = item, Price = price, Count = itemCount[i]
};
db.PurchaseItems.Add(purchaseItem);
}
db.SaveChanges();
return(View());
}
public void GatherTransaction()
{
string path = @"D:\apps\accounting";
DirectoryInfo di = new DirectoryInfo(path);
FileInfo[] files = di.GetFiles("*.json");
foreach (FileInfo file in files)
{
using (StreamReader r = new StreamReader(file.FullName))
{
string json = r.ReadToEnd();
List <Transaction> items = JsonConvert.DeserializeObject <List <Transaction> >(json);
if (items == null)
{
continue;
}
foreach (Transaction t in items)
{
bool exists = false;
if (t.Bank.Equals("Amazon"))
{
exists = _dbContext.Transactions.Where(b => b.Detail.Equals(t.Detail)).Any();
}
if (!exists)
{
exists = _dbContext.Transactions.Where(b =>
b.Bank.Equals(t.Bank) &&
b.Amount == t.Amount &&
b.Date.Year.Equals(t.Date.Year) &&
b.Date.Month.Equals(t.Date.Month) &&
b.Date.Day.Equals(t.Date.Day) &&
b.Description.Equals(t.Description) &&
b.Detail.Equals(t.Detail)
).Any();
}
if (!exists)
{
_dbContext.Transactions.Add(t);
_dbContext.SaveChanges();
}
}
}
}
}
public void Service__UpdatesAccount()
{
// Arrange
var id = 49203841098409218UL;
var hasCard = true;
var oldName = "test_value1";
var oldFunds = 123;
var oldBalance = 456;
var newName = "test_value2";
var newFunds = 123123;
var newBalance = 456456;
var oldAccount = GetMockAccount(id, oldName, oldFunds, oldBalance, hasCard);
var newAccount = GetMockAccount(id, newName, newFunds, newBalance, hasCard);
var options = new DbContextOptionsBuilder <AccountingContext>()
.UseInMemoryDatabase(databaseName: "UpdatesAccount")
.Options;
// Act
using (var context = new AccountingContext(options))
{
_service = new AccountService(context);
context.Add(oldAccount);
context.SaveChanges();
_service.Update(id, newAccount);
var updatedAccount = context.Accounts.Find(id);
// Assert
Assert.Equal(newAccount.Name, updatedAccount.Name);
Assert.Equal(newAccount.Balance, updatedAccount.Balance);
Assert.Equal(newAccount.AvailableFunds, updatedAccount.AvailableFunds);
Assert.Equal(newAccount.HasCard, updatedAccount.HasCard);
}
}
public void SaveBtn()
{
using (var ctx = new AccountingContext())
{
//Voucher stud = new Voucher() { ModeOfPayment = "Cash" };
//ctx.Vouchers.Add(stud);
Voucher fundClusterNumber = new Voucher()
{
FundCluster = _fundCluster,
DVNumber = _dvNumber,
DateTIme1 = _dateTime1,
ModeOfPayment = _modeOfPayment,
TinOrEmployeeNumber = _tinOrEmployeeNumber,
OrsOrBurs = _orsOrBurs,
Particulars = _particulars,
MFOPAP = _mFOPAP,
Amount = _amount1,
AccountTitle = _accountTitle,
UacsCode = _uacsCode,
Debit = _debit,
Credit = _credit,
AFName = _aFname,
AMName = _aMName,
ALName = _aLName,
AJobPosition = _aJobPosition,
CheckAda = _checkAda,
DateTime2 = _dateTime2,
JevNumber = _jevNo,
DateTim3 = _dateTime3
};
ctx.Vouchers.Add(fundClusterNumber);
ctx.SaveChanges();
ClearBtn();
MessageBox.Show("Saved");
}
}
public void SaveIgp()
{
using (var ctx = new AccountingContext())
{
//Voucher stud = new Voucher() { ModeOfPayment = "Cash" };
//ctx.Vouchers.Add(stud);
IGPs igpInfo = new IGPs()
{
IGPsName = _igpName,
IGPsZone = _igpName
};
//Voucher dvNumber = new Voucher() { DVNumber = _dvNumber };
ctx.IGPss.Add(igpInfo);
ctx.SaveChanges();
ClearIgp();
}
}
public void Save()
{
context.SaveChanges();
}
public static void Initialize(AccountingContext context)
{
var email = "*****@*****.**";
var adminRoleId = string.Empty;
var userId = string.Empty;
if (context.Users.Any(r => r.Email.Equals(email)))
{
userId = context.Users.First(r => r.Email.Equals(email)).Id;
}
if (!userId.Equals(string.Empty))
{
if (!context.Banks.Any())
{
var banks = new List <Bank>
{
new Bank {
Code = "001",
Name = "Ngân hàng Đông Á",
Address = "120 Lý Tự Trọng P. Bến Thành Q1 TP.HCM",
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0)
},
new Bank {
Code = "002",
Name = "Ngân hàng BIDV",
Address = "140 Trần Hưng Đạo P. Bến Nghé Q1 TP.HCM",
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0)
}
};
context.Banks.AddRange(banks);
context.SaveChanges();
}
}
if (!context.CustomerTypes.Any())
{
var customerTypes = new List <CustomerType>
{
new CustomerType {
Code = "001",
Name = "Khách hàng công ty",
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0)
},
new CustomerType {
Code = "002",
Name = "Khách hàng lẻ",
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0)
}
};
context.CustomerTypes.AddRange(customerTypes);
context.SaveChanges();
}
if (!context.ReceiptTypes.Any())
{
var receiptTypes = new List <ReceiptType>
{
new ReceiptType {
Code = "001",
ReceiptTypeInVietnamese = "Thu tiền nợ khách hàng",
ReceiptTypeInSecondLanguage = "Customer Receipt",
ShowReceiptTypeInVietNamese = true,
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0)
},
new ReceiptType {
Code = "002",
ReceiptTypeInVietnamese = "Thu tiền nội bộ",
ReceiptTypeInSecondLanguage = "Internal Receipt",
ShowReceiptTypeInVietNamese = true,
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0)
}
};
context.ReceiptTypes.AddRange(receiptTypes);
context.SaveChanges();
}
if (!context.ReceiptBatches.Any())
{
var receiptBatches = new List <ReceiptBatch>
{
new ReceiptBatch
{
ReceiptBatchNo = "BR00000001",
ReceiptBatchDate = new DateTime(2019, 10, 10, 0, 0, 0),
DescriptionInVietNamese = "Batch No created by Hang",
BatchStatus = true,
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
},
new ReceiptBatch
{
ReceiptBatchNo = "BR00000002",
ReceiptBatchDate = new DateTime(2019, 10, 10, 0, 0, 0),
DescriptionInVietNamese = "Batch No created by Nga",
BatchStatus = false,
CreatedBy = "admin",
CreatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
UpdatedBy = "admin",
UpdatedDate = new DateTime(2019, 12, 8, 12, 0, 0),
}
};
}
}
public void Add(Transaction newTransaction)
{
_context.Add(newTransaction);
_context.SaveChanges();
}
public void AddDoc(AccountingDocument inputData)
{
_context.AccountingDocumentSet.Add(inputData);
_context.SaveChanges();
}
