public string AddReceiptDetails(ReceiptVM receipt)
{
using (ReceiptDAL reciptDal = new ReceiptDAL())
{
return(reciptDal.AddReceiptDetails(receipt));
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
var cart = e.Parameter as ShoppingCartVM;
ReceiptVM = new ReceiptVM(cart);
this.DataContext = ReceiptVM;
}
public async Task <IHttpActionResult> GetRemindByAccount(int recid)
{
var receipt = await db.Receipts.FindAsync(recid);
if (receipt == null)
{
return(NotFound());
}
if (receipt.ConfirmTime != null && receipt.ConfirmTime.Value.Date >= DateTime.UtcNow.Date)
{
return(BadRequest());
}
receipt.ConfirmTime = DateTime.UtcNow;
db.Entry(receipt).State = EntityState.Modified;
var sid = User.Identity.GetUserId <string>();
var senduser = db.Users.Find(sid);
var recer = await db.PostUsers.FindAsync(receipt.PostUserId);
var receiveuser = db.Users.Find(recer.UserId);
try
{
if (UserManager.SmsService != null)
{
var message = new SmsMessage
{
Destination = receiveuser.PhoneNumber,
Body = "公司财务:" + senduser.Name,
TemplateId = 32472
};
// message.setRecord(1, number);
// db.SmsRecords.Add(message.Record);
//await db.SaveChangesAsync();
await UserManager.SmsService.SendAsync(message);
}
await db.SaveChangesAsync();
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
var result = new ReceiptVM()
{
Id = receipt.Id,
PostUserId = receipt.PostUserId,
ConfirmerID = null,
CreateTime = receipt.CreateTime,
ConfirmTime = receipt.ConfirmTime,
State = receipt.State,
Value = 0,
PosterName = receiveuser.Name,
CheckUserId = 0
};
return(Ok(result));
}
public IActionResult Edit(ReceiptVM receiptVM, int Id)
{
var edit = _receiptRepository.Edit(receiptVM, Id);
if (edit > 0)
{
return(Ok(edit));
}
return(BadRequest("Can't be edited"));
}
public IActionResult Create(ReceiptVM receiptVM)
{
var create = _receiptRepository.Create(receiptVM);
if (create > 0)
{
return(Ok(create));
}
return(BadRequest("Can't be created"));
}
public int Create(ReceiptVM receiptVM)
{
using (SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("MyConnection")))
{
var procName = "SP_Insert_Receipt";
parameters.Add("OrderDate", receiptVM.OrderDate);
parameters.Add("itemId", receiptVM.itemId);
parameters.Add("Quantity", receiptVM.Quantity);
parameters.Add("TotalPrice", receiptVM.TotalPrice);
parameters.Add("buyerId", receiptVM.buyerId);
var Insert = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure);
return(Insert);
}
}
public string AddReceiptDetails(ReceiptVM receipt)
{
SqlConnection connection = dbInstance.GetDBConnection();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
cmd = new SqlCommand("Insert_Receipt", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ReceiptData", JsonConvert.SerializeObject(receipt));
da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds.Tables[0].Rows[0]["Id"].ToString());
}
// GET: ParkedVehicles/Unpark/5
public ActionResult Receipt(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ParkedVehicle parkedVehicle = db.ParkedVehicles.Find(id);
if (parkedVehicle == null)
{
return(HttpNotFound());
}
ReceiptVM receipt = new ReceiptVM(parkedVehicle);
receipt.CheckOut = DateTime.Now;
return(View("Receipt", receipt));
}
public ActionResult Receipt(decimal orderID)
{
var order = OrderService.GetByPKAndUserID(orderID,
AuthService.CurrentUser.UserID);
if (order == null)
{
return(RedirectToAction <HomeController>(c => c.Index()));
}
var orgBank = GetOrgBank(order);
var model = new ReceiptVM {
Order = order,
OurOrg = orgBank.Item1,
OurOrgBank = orgBank.Item2,
};
return(View(ViewNames.Receipt, model));
}
public JsonResult InsertOrUpdate(ReceiptVM receiptVM)
{
var myContent = JsonConvert.SerializeObject(receiptVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
if (receiptVM.Id == 0)
{
var result = client.PostAsync("Receipts", byteContent).Result;
return(Json(result));
}
else
{
var result = client.PutAsync("Receipts/" + receiptVM.Id, byteContent).Result;
return(Json(result));
}
}
public JsonResult GetById(int Id)
{
ReceiptVM receiptVM = null;
var responseTask = client.GetAsync("Receipts/" + Id);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var json = JsonConvert.DeserializeObject(result.Content.ReadAsStringAsync().Result).ToString();
receiptVM = JsonConvert.DeserializeObject <ReceiptVM>(json);
}
else
{
ModelState.AddModelError(string.Empty, "Server Error");
}
return(Json(receiptVM));
}
private static ReceiptVM ConvertEntityToViewModel(Racun entity)
{
ReceiptVM viewModel = new ReceiptVM();
viewModel.Id = entity.IDRacun;
viewModel.Code = entity.BrojRacuna;
viewModel.Date = entity.DatumIzdavanja.ToShortDateString();
if (entity.KreditnaKartica != null)
{
viewModel.CreditCardNumber = Utils.CheckIfNull(entity.KreditnaKartica.Broj);
viewModel.CreditCardType = Utils.CheckIfNull(entity.KreditnaKartica.Tip);
}
if (entity.Komercijalist != null)
{
viewModel.ShopAssistant = Utils.CheckIfNull(entity.Komercijalist.Prezime)
+ " " + Utils.CheckIfNull(entity.Komercijalist.Ime);
}
viewModel.TotalPrice = entity.Stavka.Select(s => s.UkupnaCijena).Sum();
viewModel.CustomerId = entity.Kupac.IDKupac;
return(viewModel);
}
private DataTable AddValiesToDataTable(ReceiptVM receipt)
{
int i = 1;
ReceiptReportData receiptData = new ReceiptReportData();
DataTable dt = receiptData.Tables["ReportData"];
foreach (ProductReceiptMapVM productReceipt in receipt.Products)
{
DataRow row = dt.NewRow();
row["Code"] = productReceipt.product.Code;
row["Item"] = productReceipt.product.Name;
row["Price"] = productReceipt.ItemPrice;
row["Discounted Price"] = productReceipt.ItemDiscountedPrice;
row["Qty"] = productReceipt.Quantity;
row["Amount"] = productReceipt.ItemDiscountedPrice * productReceipt.Quantity;
row["Ln"] = i;
dt.Rows.Add(row);
i++;
}
return(dt);
}
private void btnSubmitAll_Click(object sender, EventArgs e)
{
decimal GAmount = 0;
decimal DAmount = 0;
decimal TotalAmount = 0;
decimal GridTotalAmount = 0;
List <ProductReceiptMapVM> productReceiptMapVMs = new List <ProductReceiptMapVM>();
ProductReceiptMapVM tempProductReceipt;
ReceiptVM receipt = new ReceiptVM()
{
Id = 0,
BSPId = this.selectedBSP.Id,
Remark = "",
Products = new List <ProductReceiptMapVM>(),
};
foreach (DataGridViewRow row in receiptGridView.Rows)
{
tempProductReceipt = new ProductReceiptMapVM();
ProductVM product = JsonConvert.DeserializeObject <ProductVM>(row.Cells[9].Value.ToString());
GridTotalAmount += Convert.ToDecimal(row.Cells[8].Value);
tempProductReceipt.ProductId = product.Id;
tempProductReceipt.product = product;
tempProductReceipt.ReceiptId = 0;
tempProductReceipt.Quantity = Convert.ToInt32(row.Cells[4].Value);
tempProductReceipt.ItemPrice = Convert.ToDecimal(row.Cells[5].Value);
tempProductReceipt.ItemDiscountedPrice = Convert.ToDecimal(row.Cells[7].Value);
productReceiptMapVMs.Add(tempProductReceipt);
GAmount += tempProductReceipt.ItemPrice.Value * tempProductReceipt.Quantity;
DAmount += (tempProductReceipt.ItemPrice.Value - tempProductReceipt.ItemDiscountedPrice.Value) * tempProductReceipt.Quantity;
TotalAmount += tempProductReceipt.ItemDiscountedPrice.Value * tempProductReceipt.Quantity;
}
receipt.TotalAmount = GridTotalAmount;
receipt.Products = productReceiptMapVMs;
using (var amountValidation = new AmountValidationPopup(receipt, this))
using (var reportBll = new ReportHandler())
{
var result = amountValidation.ShowDialog();
if (result == DialogResult.OK)
{
int returnValue = amountValidation.retrunValue;
string returnReference = amountValidation.retrunReference;
if (returnValue > 0)
{
DataTable dt = this.AddValiesToDataTable(receipt);
/* print report */
var reportParameters = this.GetParameterJsonObject(returnReference);
reportBll.ViewReport("billReceipt", reportParameters, dt);
/* Refresh page */
this.clearProductForm();
this.ProductFormFieldValidation();
isReceiptFormEnable = false;
cmbPhoneNumber.Enabled = true;
txtName.Enabled = true;
txtAddress.Enabled = true;
this.initializeProductDropdowns();
this.initializeReceptTable();
this.bspFormReset();
this.resetTable();
}
else
{
MessageBox.Show("Some error happen. Please try again");
}
}
}
}
public Checkout()
{
this.InitializeComponent();
ReceiptVM = new ReceiptVM(new ShoppingCartVM());
this.DataContext = ReceiptVM;
}
public AmountValidationPopup(ReceiptVM newReceipt, Receipting newReceiptForm)
{
receipt = newReceipt;
receiptForm = newReceiptForm;
InitializeComponent();
}
