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());
}
