private async void PostPhieuNhap() { PhieuNhapSach pn = new PhieuNhapSach(); pn.NgayNhap = dateTimePicker1.Value; pn.Saches = saches; StringContent content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(pn), Encoding.UTF8, "application/json"); using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:5001/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.PostAsync("api/phieunhapsach", content); if (response.IsSuccessStatusCode) { if (response.StatusCode == System.Net.HttpStatusCode.OK) { MessageBox.Show("Lưu phiếu thành công", "Lưu phiếu thành công", MessageBoxButtons.OK); button1_Click(null, null); } else { MessageBox.Show("Lưu phiếu thất bại", "Lưu phiếu thất bại", MessageBoxButtons.OK); } } else { MessageBox.Show(string.Format("{0} ({1})", (int)response.StatusCode, response.ReasonPhrase)); } } }
private void phiếuNhậpSáchToolStripMenuItem1_Click(object sender, EventArgs e) { PhieuNhapSach f = new PhieuNhapSach(); f.MdiParent = this; f.Show(); }
public bool AddRow(PhieuNhapSach obj) { try { if (_connection.State != ConnectionState.Open) { _connection.Open(); } string sql = "INSERT INTO [dbo].[PhieuNhapSach]\n" + " ([MaPhieuNhapSach]\n" + " ,[NgayNhap]\n" + " ,[MaNhanVien])\n" + " VALUES\n" + " (@MaPhieuNhapSach\n" + " ,@NgayNhap\n" + " ,@MaNhanVien)"; SqlCommand cmd = new SqlCommand(sql, _connection); cmd.Parameters.Add("@MaPhieuNhapSach", SqlDbType.Char).Value = obj.MaPhieuNhapSach; cmd.Parameters.Add("@NgayNhap", SqlDbType.Date).Value = obj.NgayNhap; cmd.Parameters.Add("@MaNhanVien", SqlDbType.Char).Value = obj.MaNhanVien; cmd.ExecuteNonQuery(); _connection.Close(); return(true); } catch (Exception ex) { _connection.Close(); Console.WriteLine(ex.Message); } return(false); }
public bool UpdateRow(PhieuNhapSach obj) { try { if (_connection.State != ConnectionState.Open) { _connection.Open(); } string sql = "UPDATE [dbo].[PhieuNhapSach]\n" + " SET [NgayNhap] = @NgayNhap\n" + " ,[MaNhanVien] = @MaNhanVien\n" + " WHERE [MaPhieuNhapSach] = @MaPhieuNhapSach"; var cmd = new SqlCommand(sql, _connection); cmd.Parameters.Add("@MaPhieuNhapSach", SqlDbType.Char).Value = obj.MaPhieuNhapSach; cmd.Parameters.Add("@NgayNhap", SqlDbType.Date).Value = obj.NgayNhap; cmd.Parameters.Add("@MaNhanVien", SqlDbType.Char).Value = obj.MaNhanVien; cmd.ExecuteNonQuery(); _connection.Close(); return(true); } catch (Exception ex) { _connection.Close(); Console.WriteLine(ex.Message); } return(false); }
public PhieuNhapSach GetRow(string maPhieuNhapSach) { try { var obj = new PhieuNhapSach(); if (_connection.State != ConnectionState.Open) { _connection.Open(); } SqlCommand command = new SqlCommand("SELECT * FROM PhieuNhapSach WHERE MaPhieuNhapSach = @maphieunhapsach", _connection); command.Parameters.Add("@maphieunhapsach", SqlDbType.Char).Value = maPhieuNhapSach; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { obj.MaPhieuNhapSach = reader["MaPhieuNhapSach"].ToString(); obj.MaNhanVien = reader["MaNhanVien"].ToString(); obj.NgayNhap = (DateTime)reader["NgayNhap"]; reader.Close(); } return(obj); } catch (Exception ex) { _connection.Close(); Console.WriteLine(ex.Message); } return(null); }
public PhieuNhapDTO ConvertPhieuNhapToPhieuNhapDTO(PhieuNhapSach coupon) { PhieuNhapDTO dto = new PhieuNhapDTO(); dto.Id = coupon.Id; dto.IdNxb = (int)coupon.IdNxb; dto.TenNXB = db.NhaXuatBan.Where(n => n.Id == coupon.IdNxb).FirstOrDefault().TenNxb; dto.NgayNhap = coupon.NgayNhap.Value.ToShortDateString(); dto.TongTien = GetPriceForCoupon(coupon.Id); return(dto); }
public void Insert(PhieuNhapSach info) { string sqlQuery = "insert into PhieuNhapSach values ('" + info.MaPN + "','" + info.MaSach + "','" + info.MaNCC + "'," + info.SoLuong + ",'" + info.NgayNhap.ToShortDateString() + "')"; ExecuteNonQuery(sqlQuery); }
public void Update(PhieuNhapSach info) { string sqlQuery = "update PhieuNhapSach" + " set MaSach='" + info.MaSach + "'," + "MaNCC='" + info.MaNCC + "'" + "SoLuong=" + info.SoLuong + "NgayNhap='" + info.NgayNhap.ToShortDateString() + "'" + "where MaPN='" + info.MaPN + "'"; ExecuteNonQuery(sqlQuery); }
public bool AddPhieuNhap(PhieuNhapSach pn) { if (!objPhieuNhap.IsRowExists(pn.MaPhieuNhapSach)) { return(objPhieuNhap.AddRow(pn)); } else { return(UpdatePhieuNhap(pn)); } }
// Chuyển giá trị trong Textbox thành PhieuNhapSach public PhieuNhapSach Textbox_To_PhieuNhapSach() { try { PhieuNhapSach result = new PhieuNhapSach(); result.id = (int)this.numbid.Value; result.id_tblSach = (int)this.numbid_tblSach.Value; result.soLuong = (int)this.numbsoLuong.Value; result.ngay = this.datengay.Value; return(result); } catch (Exception ex) { ShowMessage(ex.Message, false); } // Không load được hoặc xảy ra lỗi return(null); }
public bool UpdatePhieuNhap(PhieuNhapSach pn) { if (objPhieuNhap.IsRowExists(pn.MaPhieuNhapSach)) { ChiTietPhieuNhapSachBus ctb = new ChiTietPhieuNhapSachBus(); foreach (string ct in ctb.GetMaCTPNList(pn.MaPhieuNhapSach)) { if (ctb.DeleteChiTietPN(ct)) { Console.WriteLine("Delete: {0}", ct); } } return(objPhieuNhap.UpdateRow(pn)); } else { return(false); } }
public void CretaCoupon(NhaXuatBan nxb, List <ChiTietPhieuNhapSach> listChiTiet) { PhieuNhapSach coupon = new PhieuNhapSach(); coupon.NgayNhap = DateTime.Now.Date; string id = "PNS" + nxb.Id + DateTime.Now.ToBinary().ToString(); coupon.IdNxb = nxb.Id; coupon.Id = id; db.PhieuNhapSach.Add(coupon); db.SaveChanges(); foreach (ChiTietPhieuNhapSach item in listChiTiet) { item.IdPhieuNhap = id; Sach book = sachBL.GetBookById((int)item.IdSach); book.SoLuong += (int)item.SoLuong; db.Sach.Update(book); db.ChiTietPhieuNhapSach.Add(item); } db.SaveChanges(); }
public ActionResult ThemPhieuNhap() { PhieuNhapSach pn = new PhieuNhapSach(); pn.IDPhieuNhapSach = ""; pn.NgayNhap = DateTime.Now.Date; pn.TongSoLuong = 0; pn.TongDongia = 0; db.PhieuNhapSaches.Add(pn); db.SaveChanges(); string ma = ""; var phieu = db.PhieuNhapSaches.OrderByDescending(x => x.IDPhieuNhapSach).ToList(); foreach (var item in phieu) { ma = item.IDPhieuNhapSach; break; } return(PartialView(db.PhieuNhapSaches.Find(ma))); }
public List <PhieuNhapSach> GetList() { List <PhieuNhapSach> list = new List <PhieuNhapSach>(); string sqlQuery = "select * from PhieuNhapSach"; reader = ExecuteReader(sqlQuery); while (reader.Read()) { PhieuNhapSach phieuNhapSach = new PhieuNhapSach(); phieuNhapSach.MaPN = reader["MaPN"].ToString(); phieuNhapSach.MaSach = reader["MaSach"].ToString(); phieuNhapSach.MaNCC = reader["MaNCC"].ToString(); phieuNhapSach.SoLuong = (int)reader["SoLuong"]; phieuNhapSach.NgayNhap = (DateTime)reader["NgayNhap"]; list.Add(phieuNhapSach); } return(list); }
// Chuyển giá trị trong DataGridView thành PhieuNhapSach public PhieuNhapSach DataGridView_To_PhieuNhapSach(int index) { try { PhieuNhapSach result = new PhieuNhapSach(); var id = this.dgvData.Rows[index].Cells["id"].Value; if (id != null) { result.id = int.Parse(id.ToString()); } var id_tblSach = this.dgvData.Rows[index].Cells["id_tblSach"].Value; if (id_tblSach != null) { result.id_tblSach = (id_tblSach == null ? null : (int?)int.Parse(id_tblSach.ToString())); } var soLuong = this.dgvData.Rows[index].Cells["soLuong"].Value; if (soLuong != null) { result.soLuong = (soLuong == null ? null : (int?)int.Parse(soLuong.ToString())); } var ngay = this.dgvData.Rows[index].Cells["ngay"].Value; if (ngay != null) { result.ngay = (ngay == null ? null : (DateTime?)DateTime.Parse(ngay.ToString())); } return(result); } catch (Exception ex) { ShowMessage(ex.Message, false); } // Không load được hoặc xảy ra lỗi return(null); }
public void Update(PhieuNhapSach info) { data.Update(info); }
public void Insert(PhieuNhapSach info) { data.Insert(info); }