public float getSoDuConLaiLoaiTien(LoaiTien loaiTien) { float result = 0; LoaiTienManagement loaiTienManagement = new LoaiTienManagement(); DonHangManagement donHangManagement = new DonHangManagement(); result = loaiTien.HanMuc.Value - donHangManagement.tongGiaTriGiaoDich(" where IDLoaiTien=" + loaiTien.ID + " and TrangThai=N'DaChuyenCoin'"); return(result); }
public LoaiTien getLoaiTienById(int iD) { try { LoaiTien LoaiTien = (LoaiTien)session.Get <LoaiTien>(iD); return(LoaiTien); } catch (Exception ex) { return(null); } }
protected void btnLuu_Click(object sender, EventArgs e) { loaiTien = new LoaiTien(); loaiTien.TenLoaiTien = txtTenLoaiTien.Text; loaiTien.GiaMua = float.Parse(txtGiaMua.Text); loaiTien.GiaBan = float.Parse(txtGiaBan.Text); loaiTien.TrangThai = ddlTrangThai.SelectedValue; loaiTien.AutoLoad = ddlAutoLoad.SelectedValue; loaiTien.ThuTu = int.Parse(txtThuTu.Text); loaiTien.HanMuc = float.Parse(txtHanMuc.Text); loaiTien.ThongBaoHetHanMuc = txtThongBaoHetHanMuc.Text; //upanh FileCommon fileCommon = new FileCommon(); HttpFileCollection httpFileCollection = Page.Request.Files; if (httpFileCollection[0] != null && httpFileCollection[0].ContentLength > 0) { loaiTien.LinkIcon = fileCommon.UploadFile("/Style/images/Uploads/Money/", httpFileCollection[0]); } if (chkHienThiBox.Checked == true) { loaiTien.ThuTuHienThiBox = int.Parse(txtThuTuHienThiBox.Text); } else { loaiTien.ThuTuHienThiBox = -1; } loaiTien.MaLoaiTien = txtMaLoaiTien.Text; if (txtPhuPhiBan.Text == "") { loaiTien.PhuPhiBan = 0; } else { loaiTien.PhuPhiBan = float.Parse(txtPhuPhiBan.Text); } if (txtPhuPhiMua.Text == "") { loaiTien.PhuPhiMua = 0; } else { loaiTien.PhuPhiMua = float.Parse(txtPhuPhiMua.Text); } loaiTienManagement.themLoaiTien(loaiTien); Response.Redirect("/Views/Backend/QuanTri/QuanLyLoaiTien/DanhSachLoaiTien.aspx"); }
public void xoaLoaiTien(LoaiTien LoaiTien) { sessionManager.BeginTransaction(); try { session.Delete(LoaiTien); sessionManager.CommitTransaction(); } catch (HibernateException ex) { throw new DataException(ex.Message, ex); } }
public void themLoaiTien(LoaiTien LoaiTien) { sessionManager.BeginTransaction(); try { session.Save(LoaiTien); sessionManager.CommitTransaction(); //session.Close(); } catch (HibernateException ex) { throw new DataException(ex.Message, ex); } }
public LoaiTien LayMenhGiaTien(string maTien) { LoaiTien tien = new LoaiTien(); string query = @"SELECT [MaTien] ,[GiaTriTien] FROM [M_ATM].[dbo].[LoaiTien] where MaTien = @ma"; DataTable dt = DataProvider.Instance.ExcuteQuery(query, new object[] { maTien }); if (dt.Rows.Count > 0) { tien.MaTien = dt.Rows[0][0].ToString(); tien.GiaTriTien = int.Parse(dt.Rows[0][1].ToString()); } return(tien); }
public async Task <IActionResult> PostLoaiTien([FromBody] LoaiTien loaitien) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var user = User.Identity.Name; var userId = Utilities.GetUserId(this.User); loaitien.NgayNgap = DateTime.Now; loaitien.NguoiNhap = user; _context.LoaiTiens.Add(loaitien); await _context.SaveChangesAsync(); return(CreatedAtAction("GetLoaiTien", new { id = loaitien.LoaiTienId }, loaitien)); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Request.QueryString["iDLoaiTien"] != null) { string iDLoaiTien = HttpContext.Current.Request.QueryString["iDLoaiTien"].ToString(); try { loaiTien = loaiTienManagement.getLoaiTien("where ID=N'" + iDLoaiTien + "'")[0]; if (!this.IsPostBack) { initializeDataInControl(); } } catch (Exception ex) { loaiTien = null; } } }
public async Task <IActionResult> PutLoaiTien([FromRoute] int id, [FromBody] LoaiTien loaitien) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != loaitien.LoaiTienId) { return(BadRequest()); } var user = User.Identity.Name; var userId = Utilities.GetUserId(this.User); loaitien.NgaySua = DateTime.Now; loaitien.NguoiSua = user; _context.Entry(loaitien).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LoaiTienExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }