public ActionResult ShowBill(int bill_Id)
{
var model = new BillModel();
model.GetBillDataWithAllUtilities(bill_Id);
return(View(model));
}
public ActionResult ShowBillPaidInfo(int bill_Id)
{
var model = new BillModel();
model.GetBillData(bill_Id);
return(View(model));
}
private async void sendUnpaidInvoiceReminderEmail(BillModel obj)
{
Singleton.getDialogueBox().showSearch(ConfigurationManager.AppSettings["wait_message"]);
ParamOrderToPdf paramOrderToPdf = new ParamOrderToPdf();
var paramEmail = new ParamEmail();
paramEmail.IsCopyToAgent = await Singleton.getDialogueBox().showAsync("Do you want to receive a copy?");
paramEmail.IsSendEmail = true;
paramOrderToPdf.BillId = obj.Bill.ID;
paramOrderToPdf.OrderId = obj.Bill.OrderId;
paramOrderToPdf.Lang = CultureInfo.CurrentCulture.Name.Split('-').FirstOrDefault() ?? "en";
paramOrderToPdf.ParamEmail = paramEmail;
var billNotPaidFoundList = BillNotPaidList.Where(x => x.Bill.ID == obj.Bill.ID).ToList();
var notificationFoundList = await Bl.BlNotification.searchNotificationAsync(new Notification { BillId = obj.Bill.ID }, QOBDCommon.Enum.ESearchOption.AND);
if (notificationFoundList.Count > 0)
{
// the first reminder of unpaid invoice
if (notificationFoundList[0].Reminder1 <= Utility.DateTimeMinValueInSQL2005 && notificationFoundList[0].Reminder2 <= Utility.DateTimeMinValueInSQL2005)
{
paramEmail.Reminder = 1;
notificationFoundList[0].Reminder1 = DateTime.Now;
// update the invoice notification
if (billNotPaidFoundList.Count > 0)
{
billNotPaidFoundList[0].TxtDateFirstReminder = notificationFoundList[0].Reminder1.ToString();
}
}
// the second reminder of unpaid invoice
else
{
paramEmail.Reminder = 2;
notificationFoundList[0].Reminder2 = DateTime.Now;
// update the invoice notification
if (billNotPaidFoundList.Count > 0)
{
billNotPaidFoundList[0].TxtDateSecondReminder = notificationFoundList[0].Reminder2.ToString();
}
}
// save that a reminder has been sent
var savedNotificationList = await Bl.BlNotification.UpdateNotificationAsync(new List <Notification> {
notificationFoundList[0]
});
// generate and send the invoice
Bl.BlOrder.GeneratePdfOrder(paramOrderToPdf);
}
Singleton.getDialogueBox().IsDialogOpen = false;
}
public void UpdateBill(BillModel billModel)
{
var b = GetBillById(billModel.IdBill);
var sql = "UPDATE GroupBillsMembers " +
"SET Payed = 1 " +
"WHERE PhoneNumber=@phoneNumber and IdBill = @i";
_dbConnection.Query(sql, new { phoneNumber = billModel.PhoneNumber, i = billModel.IdBill });
}
/// <summary>
///
/// </summary>
/// <param name="DataAccess"></param>
/// <param name="Bill"></param>
/// <param name="BillDetail"></param>
//private static void SetBillDetail( List<BillDetailModel> BillDetail)
//{
// BillDetail?.ForEach(row =>
// {
// });
//}
/// <summary>
///
/// </summary>
/// <param name="DataAccess"></param>
/// <param name="Bill"></param>
/// <param name="BillReceiptDetail"></param>
private static void SetBillReceiptDetail(BillModel Bill, List <BillReceiptDetailModel> BillReceiptDetail)
{
Bill.HadPayAmount = 0m;
BillReceiptDetail?.ForEach(row =>
{
Bill.HadPayAmount += row.ReceiptBill.PayAmount;
});
Bill.PayStatus = GetPayStatus(Bill.PayAmount, Bill.HadPayAmount);
}
public IActionResult SaveEntity(BillModel billVm)
{
if (billVm.Id == 0)
{
_billService.Create(billVm);
}
_billService.Save();
return(new OkObjectResult(billVm));
}
public int Delete(BillModel model)
{
string sqlDelete = "DELETE FROM Bill WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlDelete, model));
}
}
private void SendFile(BillModel bill, string emailDestination)
{
EmailSender sender = new EmailSender("*****@*****.**", "Diamond1234", emailDestination);
sender.CreateMailMessage($"Bill For {bill.Month}-{bill.Year}", "Bill Via Email");
sender.AddAttachment($"C:\\pdfFiles\\bill{bill.CustomerName}{bill.Month}{bill.Year}.pdf");
sender.AddSmtp();
sender.SendEmail();
}
public BillBusiness(string type, decimal amount, DateTime dueDate, int homeId)
{
billModel = new BillModel {
BillType = type,
Amount = amount,
PaymentDueDate = dueDate,
HomeId = homeId
};
}
public virtual ActionResult Save(long id, BillModel model)
{
if (!SaveImpl(id, model))
{
return(View("Preview", model));
}
return(RedirectToAction(MVC.Admin.Bill.Preview(id)));
}
/// <summary>
/// 刷新第二屏幕数据
/// </summary>
public void RefreshSecondMonitorList(BillModel model)
{
if (!_isInitialized)
{
return;
}
_webBrowser.Document.InvokeScript("ChangeListAndPriceInfo", new object[] { JsonConvert.SerializeObject(model, jsonSettings) });
}
public void PostVoucher(BillModel bill)
{
VoucherModel voucher = new VoucherModel()
{
User = bill.User,
Offer = bill.Offer,
IsUsed = false,
ExpirationDate = DateTime.UtcNow.AddDays(7)
};
}
public VoucherModel PostVoucherOnPaidBill(int billId, int userId, int offerId, VoucherModel voucher)
{
BillModel bill = db.BillModelRepository.GetByID(billId);
if (bill.PaymentMade == true)
{
db.VoucherModelRepository.Insert(voucher);
}
return(voucher);
}
public int Update(BillModel model)
{
string sqlUpdate = "UPDATE Bill SET DateOfIssue = @DateOfIssue, ReservationId = @ReservationId, " +
"PaymentMethodId = @PaymentMethodId, DiscountId = @DiscountId, EmployeeId= @EmployeeId WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlUpdate, model));
}
}
/// <summary>
/// 修改bill
/// </summary>
/// <param name="billInfo"></param>
public void UpdateBill(BillModel billInfo)
{
string sql = "update t_bill "
+ " set unit_id= '" + billInfo.UnitId + "', bill_status= '" + billInfo.Status + "', bill_code= '" + billInfo.Code + "', work_month= '" + billInfo.WorkMonth + "', "
+ " work_date= '" + billInfo.WorkDate + "', bill_remark= '" + billInfo.Remark + "', bill_money= '" + billInfo.Money + "', "
+ " modify_user_id= '" + billInfo.ModifyUserId + "', modify_time= '" + billInfo.ModifyDate + "' "
+ " where bill_id= '" + billInfo.Id + "'; ";
this.SQLHelper.ExecuteNonQuery(sql);
}
public ActionResult ShowFoundBills(string searchString)
{
var model = new BillModel();
model.FindBills(searchString);
ViewBag.SearchString = searchString;
return(View(model));
}
public void CheckShowFoundBills_WithWrongCity()
{
var model = new BillModel();
string searchString = "New York";
model.FindBills(searchString);
Assert.AreEqual(0, model.Bills.Count);
}
public void CheckShowFoundBills_WithCorrectCity()
{
var model = new BillModel();
string searchString = "Kolding";
model.FindBills(searchString);
Assert.AreNotEqual(0, model.Bills.Count);
}
public ActionResult Edit([Bind(Include = "BillId,BillName,BillCompany,BillPrice,BillDueDate,BillStatus")] BillModel billModel)
{
if (ModelState.IsValid)
{
db.Entry(billModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(billModel));
}
public BillModel CreateBill(BillModel bill)
{
bill.PaymentMade = false;
bill.PaymentCanceled = false;
db.BillsRepository.Insert(bill);
db.Save();
return(bill);
}
public IHttpActionResult GetBillById(int id)
{
BillModel bill = billService.GetById(id);
if (bill == null)
{
return(NotFound());
}
return(Ok(bill));
}
public IHttpActionResult DeleteBill(int id)
{
BillModel bill = billService.DeleteBill(id);
if (bill == null)
{
return(NotFound());
}
return(Ok(bill));
}
public int Insert(BillModel model)
{
string sqlInsert = "INSERT INTO Bill (Id,DateOfIssue, ReservationId, PaymentMethodId, DiscountId, EmployeeId) " +
"Values (@Id, @DateOfIssue, @ReservationId, @PaymentMethodId, @DiscountId, @EmployeeId)";
using (_connection)
{
return(_connection.Execute(sqlInsert, model));
}
}
public ActionResult Delete(BillModel model)
{
if (ModelState.IsValid)
{
DeleteBill(model.ID);
UpdatePayments(model.Amount);
return(RedirectToAction("ViewBillsWithAssigned"));
}
return(View());
}
/// <summary>
/// 插入Bill
/// </summary>
/// <param name="billInfo"></param>
public void InsertBill(BillModel billInfo)
{
string sql = " insert into t_bill (bill_id, unit_id, bill_kind_id, bill_Status, bill_code, work_month, "
+ " work_date, bill_remark, bill_money, add_user_id, add_time) "
+ " values "
+ " ('" + billInfo.Id + "', '" + billInfo.UnitId + "', '" + billInfo.KindId + "', '" + billInfo.Status + "', '" + billInfo.Code + "', '" + billInfo.WorkMonth + "', "
+ " '" + billInfo.WorkDate + "', '" + billInfo.Remark + "','" + billInfo.Money + "', '" + billInfo.AddUserId + "', '" + billInfo.AddDate + "') ;";
this.SQLHelper.ExecuteNonQuery(sql);
}
public ActionResult Create(BillModel b)
{
if (ModelState.IsValid)
{
DataProcessor.CreateBill(b.Name, b.Amount, b.DueDate);
return(RedirectToAction("ViewBills"));
}
return(View());
}
public ActionResult EditBillActual(Guid id, BillModel Model)
{
var bill = DB.Bills.Find(id);
bill.Actual = Model.Actual;
bill.Project.Log += string.Format("[{0}] {1}修改了支出\n", DateTime.Now.ToString("yyyy-MM-dd HH:mm"), CurrentUser.Username);
DB.SaveChanges();
return(RedirectToAction("Bill", "Project", new { id = bill.ProjectID }));
}
/// <summary>
/// 新建一个Bill
/// </summary>
/// <param name="loggingSession">当前登录用户的Session信息</param>
/// <param name="bill">Bill</param>
/// <returns>操作的状态</returns>
public BillOperateStateService InsertBill(LoggingSessionInfo loggingSession, BillModel bill)
{
//获取表单类别
BillKindModel billKind = GetBillKindById(loggingSession, bill.KindId);
if (billKind == null)
{
return(BillOperateStateService.NotExistKind);
}
//获取表单状态
BillStatusModel beginBillStatus = GetBillBeginStatus(loggingSession, bill.KindId);
if (beginBillStatus == null)
{
return(BillOperateStateService.NotSetBeginStatus);
}
BillActionModel billCreateAction = GetBillAction(loggingSession, bill.KindId, BillActionType.Create);
if (billCreateAction == null)
{
return(BillOperateStateService.NotSetCreateAction);
}
Hashtable hashTable = new Hashtable();
hashTable.Add("RoleId", GetBasicRoleId(loggingSession.CurrentUserRole.RoleId));
hashTable.Add("BillKindId", bill.KindId);
hashTable.Add("BillActionId", billCreateAction.Id);
hashTable.Add("PreviousBillStatus", beginBillStatus.Status);
hashTable.Add("LanguageKindId", loggingSession.CurrentLanguageKindId);
BillActionRoleModel billCreateActionRole = cSqlMapper.Instance(loggingSession.CurrentLoggingManager).QueryForObject <BillActionRoleModel>("BillActionRole.SelectByKindIdAndActionIdAndRoleIdAndPreviousStatus", hashTable);
if (billCreateActionRole == null)
{
return(BillOperateStateService.NotAllowCreate);
}
////判断是否超出系统设置时间
//if (billCreateActionRole.ValidateDate == 0)
//{
// return BillOperateStateService.OutDateTime;
//}
if (billKind.MoneyFlag == 1)
{
if ((bill.Money < billCreateActionRole.MinMoney) || (bill.Money > billCreateActionRole.MaxMoney))
{
return(BillOperateStateService.OutOfMoneyScope);
}
}
bill.AddUserId = loggingSession.CurrentUser.User_Id;
bill.AddDate = GetCurrentDateTime();
bill.Status = billCreateActionRole.CurrentStatus;
cSqlMapper.Instance(loggingSession.CurrentLoggingManager).Insert("Bill.Insert", bill);
InsertBillActionLog(loggingSession, bill, billCreateAction, billCreateActionRole, null);
return(BillOperateStateService.CreateSuccessful);
}
// GET api/product/5
public ActionResult GetBillData(string url)
{
BillModel model = null;
using (var client = new WebClient())
{
var jsonData = client.DownloadString(url); //"http://safe-plains-5453.herokuapp.com/bill.json"
model = JsonConvert.DeserializeObject <BillModel>(jsonData, new IsoDateTimeConverter());
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public virtual ActionResult Send(long id, BillModel model)
{
if (!SaveImpl(id, model, true))
{
return(View("Preview", model));
}
_manager.Send(id, _identity.Id);
return(RedirectToAction(MVC.Admin.Bill.Sent(id)));
}
public void InsertBill(BillModel bill)
{
_hkDB.TableBill.InsertOnSubmit(bill);
if (bill.DetailItems != null)
{
_hkDB.TableDetailItem.InsertAllOnSubmit(bill.DetailItems);
}
_hkDB.SubmitChanges();
}
public void DeleteBill(BillModel bill)
{
if (bill.DetailItems != null)
{
_hkDB.TableDetailItem.DeleteAllOnSubmit(bill.DetailItems);
}
_hkDB.TableBill.DeleteOnSubmit(bill);
_hkDB.SubmitChanges();
}
