private void NewBill() { try { if (Orders.Count > 0 && OrderSummary.BillNo == 0) { MessageBoxResult result = System.Windows.MessageBox.Show("Are you sure you want to create New Bill?", "Warning Message", MessageBoxButton.YesNoCancel, MessageBoxImage.Question, MessageBoxResult.No); if (result == MessageBoxResult.No || result == MessageBoxResult.Cancel) { return; } } Orders.Clear(); SelectedPaymentMode = null; SelectedPaymentMode = new PaymentMode(); SelectedPaymentMode = PaymentModes.Where(x => x.PaymentModeId == 1).FirstOrDefault(); NotifyPropertyChanged("SelectedPaymentMode"); OrderSummary.Clear(); Customer.Clear(); Add(); } catch (Exception ex) { MessageBox.Show("Error Occured: " + ex.Message + " " + ex.Source + " " + ex.StackTrace); } }
public PaymentModesResponse Post(PaymentModes request) { if (request.PaymentMode.Id > 0) { Bm2s.Data.Common.BLL.Trade.PaymentMode item = Datas.Instance.DataStorage.PaymentModes[request.PaymentMode.Id]; item.Code = request.PaymentMode.Code; item.EndingDate = request.PaymentMode.EndingDate; item.Name = request.PaymentMode.Name; item.StartingDate = request.PaymentMode.StartingDate; Datas.Instance.DataStorage.PaymentModes[request.PaymentMode.Id] = item; } else { Bm2s.Data.Common.BLL.Trade.PaymentMode item = new Data.Common.BLL.Trade.PaymentMode() { Code = request.PaymentMode.Code, EndingDate = request.PaymentMode.EndingDate, Name = request.PaymentMode.Name, StartingDate = request.PaymentMode.StartingDate }; Datas.Instance.DataStorage.PaymentModes.Add(item); request.PaymentMode.Id = item.Id; } PaymentModesResponse response = new PaymentModesResponse(); response.PaymentModes.Add(request.PaymentMode); return response; }
public PaymentModes Update(string json, string ownerId) { PaymentModes paymentMode = JsonConvert.DeserializeObject <PaymentModes>(json); paymentMode.OwnerId = ownerId; collections.Save(paymentMode); return(paymentMode); }
public PaymentModes Insert(string json, string ownerId) { PaymentModes paymentMode = JsonConvert.DeserializeObject <PaymentModes>(json); paymentMode._id = Guid.NewGuid(); paymentMode.OwnerId = ownerId; collections.Save(paymentMode); return(paymentMode); }
private void BindPendingPaymentModes() { DataTable table = new PaymentModes().SelectAll(); drpPendingPaymentMode.DataSource = table; drpPendingPaymentMode.DataTextField = table.Columns["PaymentMode"].ToString(); drpPendingPaymentMode.DataValueField = table.Columns["PaymentMode_ID"].ToString(); drpPendingPaymentMode.DataBind(); }
public ActionResult Edit(AirlineCappingModel model, Int64 id) { model.cappingId = id; var gdsList = ent.ServiceProviders.ToList(); ServiceProviders gdsSelect = new ServiceProviders() { ServiceProviderId = -1, ServiceProviderName = "--Select--" }; gdsList.Insert(0, gdsSelect); var airLineList = ent.Airlines.ToList(); Airlines airlineSelect = new Airlines() { AirlineId = -1, AirlineName = "--Select--" }; airLineList.Insert(0, airlineSelect); var bankList = ent.Banks.ToList(); Banks bankSelect = new Banks() { BankId = -1, BankName = "--Select--" }; bankList.Insert(0, bankSelect); var paymentList = ent.PaymentModes.ToList(); PaymentModes paymentSelect = new PaymentModes() { PaymentModeId = -1, ModeName = "--Select--" }; paymentList.Insert(0, paymentSelect); ViewData["GDSList"] = gdsList; //defaultProvider.GetGDSInformationList(); ViewData["AirlineList"] = airLineList; //defaultProvider.GetAirlineList(); ViewData["BankList"] = bankList; //defaultProvider.GetBankList(); ViewData["PaymentModeList"] = paymentList; //defaultProvider.GetPaymentModeList(); //ViewData["GDSList"] = defaultProvider.GetGDSInformationList(); //ViewData["AirlineList"] = defaultProvider.GetAirlineList(); //ViewData["BankList"] = defaultProvider.GetBankList(); //ViewData["PaymentModeList"] = defaultProvider.GetPaymentModeList(); if (ModelState.IsValid) { airlineCappingProvider.Edit(model); return(View(model)); } else { return(View()); } }
public PaymentModesResponse Delete(PaymentModes request) { Bm2s.Data.Common.BLL.Trade.PaymentMode item = Datas.Instance.DataStorage.PaymentModes[request.PaymentMode.Id]; item.EndingDate = DateTime.Now; Datas.Instance.DataStorage.PaymentModes[item.Id] = item; PaymentModesResponse response = new PaymentModesResponse(); response.PaymentModes.Add(request.PaymentMode); return response; }
private void BindPaymentModes() { DataTable table = new PaymentModes().SelectAll(); drpPaymentModes.DataSource = table; drpPaymentModes.DataTextField = table.Columns["PaymentMode"].ToString(); drpPaymentModes.DataValueField = table.Columns["PaymentMode_ID"].ToString(); drpPaymentModes.DataBind(); drpPaymentModes.Items.Insert(0, new ListItem("Select a Payment Mode...", "-1")); }
private void BindPaymenModes() { drpPaymentModes.ClearSelection(); DataTable table = new PaymentModes().SelectAll(); drpPaymentModes.DataSource = table; drpPaymentModes.DataTextField = table.Columns["PaymentMode"].ToString(); drpPaymentModes.DataValueField = table.Columns["PaymentMode_ID"].ToString(); drpPaymentModes.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { string error = string.Empty; Model.PaymentModes paymentmode = new PaymentModes(); paymentmode.Id = this.txtNumber.Text.Trim(); paymentmode.PaymentMode = this.txtPaymentMode.Text.Trim(); if (string.IsNullOrEmpty(paymentmode.Id) || string.IsNullOrEmpty(paymentmode.PaymentMode)) { lbSubmit.Text = "请将带*号的内容填写完整!"; return; } if (PaymentModeManager.CheckHave(paymentmode.PaymentMode)) { lbSubmit.Text = "已经有该付款方式,请重新填写!"; return; } else { bool result; if (btnSubmit.Text.Equals("添加")) { result = PaymentModeManager.AddPaymentMode(paymentmode, ref error); lbSubmit.Text = result == true ? "添加成功" : "添加失败!原因:" + error; if (result) { Tool.WriteLog(Tool.LogType.Operating, "增加付款方式" + paymentmode.Id, "增加成功"); ToolCode.Tool.ResetControl(this.Controls); return; } else { Tool.WriteLog(Tool.LogType.Operating, "增加付款方式" + paymentmode.Id, "增加失败!原因" + error); return; } } else { result = PaymentModeManager.EditPaymentMode(paymentmode, ref error); lbSubmit.Text = result == true ? "修改成功" : "修改失败!原因:" + error; if (result) { Tool.WriteLog(Tool.LogType.Operating, "编辑付款方式" + paymentmode.Id, "编辑成功"); lbSubmit.Text = "修改成功!"; } else { Tool.WriteLog(Tool.LogType.Operating, "编辑付款方式" + paymentmode.Id, "编辑失败!原因" + error); lbSubmit.Text = "修改失败!"; return; } } } }
/// <summary> /// DataTable 转对象 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static PaymentModes ConvertDataTableToModel(string sql) { error = string.Empty; DataTable dt = SqlHelper.GetTable(sql, ref error); DataRow dr = dt.Rows[0]; PaymentModes paymentmode = new PaymentModes(); paymentmode.Id = dr["Id"] == null ? "" : dr["Id"].ToString(); paymentmode.PaymentMode = dr["PaymentMode"] == null ? "" : dr["PaymentMode"].ToString(); return(paymentmode); }
private void UpdatePaymentMethods() { PaymentModes.Add("Cash"); using (var context = new ERPContext()) { var bankAccounts = context.Ledger_Accounts .Where(account => account.Name.Contains("Bank") && !account.Name.Contains("Expense")); foreach (var bank in bankAccounts) { PaymentModes.Add(bank.Name); } } }
public PaymentModesResponse Get(PaymentModes request) { PaymentModesResponse response = new PaymentModesResponse(); List<Bm2s.Data.Common.BLL.Trade.PaymentMode> items = new List<Data.Common.BLL.Trade.PaymentMode>(); if (!request.Ids.Any()) { items.AddRange(Datas.Instance.DataStorage.PaymentModes.Where(item => (string.IsNullOrWhiteSpace(request.Code) || item.Code.ToLower().Contains(request.Code.ToLower())) && (string.IsNullOrWhiteSpace(request.Name) || item.Name.ToLower().Contains(request.Name.ToLower())) && (!request.Date.HasValue || (request.Date >= item.StartingDate && (!item.EndingDate.HasValue || request.Date < item.EndingDate.Value))) )); } else { items.AddRange(Datas.Instance.DataStorage.PaymentModes.Where(item => request.Ids.Contains(item.Id))); } var collection = (from item in items select new Bm2s.Poco.Common.Trade.PaymentMode() { Code = item.Code, EndingDate = item.EndingDate, Id = item.Id, Name = item.Name, StartingDate = item.StartingDate }).AsQueryable().OrderBy(request.Order, !request.DescendingOrder); response.ItemsCount = collection.Count(); if (request.PageSize > 0) { response.PaymentModes.AddRange(collection.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize)); } else { response.PaymentModes.AddRange(collection); } try { response.PagesCount = collection.Count() / response.PaymentModes.Count + (collection.Count() % response.PaymentModes.Count > 0 ? 1 : 0); } catch { response.PagesCount = 1; } return response; }
public List <PaymentModes> GetAllPaymentModes() { List <PaymentModes> PaymentModesList = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[Accounts].[GetAllPaymentModes]"; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { PaymentModesList = new List <PaymentModes>(); while (sdr.Read()) { PaymentModes _pmObj = new PaymentModes(); { _pmObj.Code = (sdr["Code"].ToString() != "" ? (sdr["Code"].ToString()) : _pmObj.Code); _pmObj.Description = (sdr["Description"].ToString() != "" ? sdr["Description"].ToString() : _pmObj.Description); } PaymentModesList.Add(_pmObj); } } } } } } catch (Exception ex) { throw ex; } return(PaymentModesList); }
private void LoadPage() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select * from PaymentMode where Id='{0}' ", ToolManager.GetQueryString("Id")); //sql = string.Format(@" select * from PaymentMode where Id='{0}' ", "1"); this.trNumber.Visible = false; PaymentModes paymentmodel = PaymentModeManager.ConvertDataTableToModel(sql); this.txtNumber.Text = paymentmodel.Id; this.txtPaymentMode.Text = paymentmodel.PaymentMode; btnSubmit.Text = "修改"; } else { btnSubmit.Text = "添加"; } }
public ActionResult Create() { var gdsList = ent.ServiceProviders.OrderBy(x => x.ServiceProviderName).ToList(); ServiceProviders gdsSelect = new ServiceProviders() { ServiceProviderId = -1, ServiceProviderName = "--Select--" }; gdsList.Insert(0, gdsSelect); var airLineList = ent.Airlines.ToList(); Airlines airlineSelect = new Airlines() { AirlineId = -1, AirlineName = "--Select--" }; airLineList.Insert(0, airlineSelect); var bankList = ent.Banks.ToList(); Banks bankSelect = new Banks() { BankId = -1, BankName = "--Select--" }; bankList.Insert(0, bankSelect); var paymentList = ent.PaymentModes.ToList(); PaymentModes paymentSelect = new PaymentModes() { PaymentModeId = -1, ModeName = "--Select--" }; paymentList.Insert(0, paymentSelect); ViewData["GDSList"] = gdsList; //defaultProvider.GetGDSInformationList(); ViewData["AirlineList"] = airLineList; //defaultProvider.GetAirlineList(); ViewData["BankList"] = bankList; //defaultProvider.GetBankList(); ViewData["PaymentModeList"] = paymentList; //defaultProvider.GetPaymentModeList(); return(View()); }
public PaymentModeModule() { this.RequiresAuthentication(); Post["/createpaymentmode"] = p => { try { var paymentmode = this.Request.Form.paymentmode; PaymentModes paymentMode = this.PaymentModeService().Insert(paymentmode, this.CurrentAccount().OwnerId); return(Response.AsJson(paymentMode)); } catch (Exception e) { return(Response.AsJson(new { error = true, message = e })); } }; Get["/findpaymentmodebyid/{id}"] = p => { try { PaymentModes paymentMode = this.PaymentModeQuery().Get(p.id, this.CurrentAccount().OwnerId); return(Response.AsJson(paymentMode)); } catch (Exception e) { return(Response.AsJson(new { error = true, message = e })); } }; Get["/findallpaymentmode"] = p => { try { PaymentModes[] paymentModes = this.PaymentModeQuery().FindAll(this.CurrentAccount().OwnerId); return(Response.AsJson(paymentModes)); } catch (Exception e) { return(Response.AsJson(new { error = true, message = e })); } }; Post["/updatepaymentmode"] = p => { try { PaymentModes paymentMode = this.PaymentModeService().Update(this.Request.Form.paymentmode, this.CurrentAccount().OwnerId); return(Response.AsJson(paymentMode)); } catch (Exception e) { return(Response.AsJson(new { error = true, message = e })); } }; Post["/UpdateStatusInvoice/{id}"] = p => { try { Guid invoiceId = p.id; Invoices invoice = this.InvoicesQueryRepository().FindById(invoiceId, this.CurrentAccount().OwnerId); invoice.InvoiceStatusSudahLunas(); this.InvoiceService().Update(this.Request.Form.invoice, this.CurrentAccount().OwnerId); return(Response.AsJson(new { error = false })); } catch (Exception e) { return(Response.AsJson(new { error = true, message = e })); } }; Post["/deletepaymentmode/{id}"] = p => { try { this.PaymentModeService().Delete(p.id); return(Response.AsJson(new { error = false })); } catch (Exception e) { return(Response.AsJson(new { error = true, message = e })); } }; }
/// <summary> /// 编辑付款方式 /// </summary> /// <param name="user"></param> /// <param name="error"></param> /// <returns></returns> public static bool EditPaymentMode(PaymentModes paymentmode, ref string error) { sql = string.Format(@" update PaymentMode set PaymentMode='{0}' where Id='{1}'", paymentmode.PaymentMode, paymentmode.Id); return(SqlHelper.ExecuteSql(sql, ref error)); }