public int Update(Phieu_Xuat_Tam_Vat_Tu pxt) { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); int temp = 0; using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { using (var context = help.ent) { context.Phieu_Xuat_Tam_Vat_Tu.Attach(pxt); context.Entry(pxt).State = EntityState.Modified; temp = help.ent.SaveChanges(); dbcxtransaction.Commit(); } } return temp; // DAL.BeginTransaction(); // m_dbConnection = DAL.m_conn; // if (m_dbConnection.State == ConnectionState.Closed) // m_dbConnection.Open(); // string sql = ""; // sql += "UPDATE Phieu_xuat_tam_vat_tu "; // sql += "Set ma_phieu_xuat_tam=@ma_phieu_xuat_tam,ID_kho=@ID_kho,ID_nhan_vien=@ID_nhan_vien,ngay_xuat=@ngay_xuat,Ly_do = @Ly_do "; // sql += "WHERE ma_phieu_xuat_tam=@ma_phieu_xuat_tam"; // SqlCommand command = new SqlCommand(sql, m_dbConnection,DAL.m_trans); // command.CommandType = CommandType.Text; // command.Parameters.Add(new SqlParameter("@ma_phieu_xuat_tam", Ma_phieu_xuat_tam)); // command.Parameters.Add(new SqlParameter("@ID_kho", ID_kho)); // command.Parameters.Add(new SqlParameter("@ngay_xuat", Ngay_xuat.ToString("yyyy-MM-dd"))); // command.Parameters.Add(new SqlParameter("@ID_nhan_vien", ID_Nhan_vien)); //// command.Parameters.Add(new SqlParameter("@so_hoa_don", So_hoa_don)); // command.Parameters.Add(new SqlParameter("@Ly_do", Ly_do)); // int result = command.ExecuteNonQuery(); // DAL.CommitTransaction(); // return result; }
public int Update(DatabaseHelper help) { try { { var item = new Phieu_Xuat_Tam_Vat_Tu(); item.ID_kho = this.ID_kho; item.ID_nhan_vien = this.ID_Nhan_vien; item.isGiuLai = this.isGiuLai; item.isHoanNhap = this.isHoanNhap; item.Ly_do = this.Ly_do; item.Cong_trinh = this.Cong_trinh; item.Dia_chi = this.Dia_chi; item.Ngay_xuat = this.Ngay_xuat; item.Ma_phieu_xuat_tam = this.Ma_phieu_xuat_tam; item.Da_duyet = this.Da_duyet; item.ID_phieu_xuat_tam = this.ID_phieu_xuat_tam; help.ent.Phieu_Xuat_Tam_Vat_Tu.Attach(item); help.ent.Entry(item).State = EntityState.Modified; help.ent.SaveChanges(); var ctpxt = new Chi_Tiet_Phieu_Xuat_Tam(); var dm = (from d in help.ent.Chi_Tiet_Phieu_Xuat_Tam where d.Ma_phieu_xuat_tam == item.Ma_phieu_xuat_tam select d ).ToList(); if (dm == null) { return 1; } for (int i = 0; i < dm.Count; i++) { help.ent.Chi_Tiet_Phieu_Xuat_Tam.Attach(dm[i]); help.ent.Chi_Tiet_Phieu_Xuat_Tam.Remove(dm[i]); help.ent.SaveChanges(); } return 1; } } catch (Exception ex) { return 0; } }
public int Insert() { try { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { var item = new Phieu_Xuat_Tam_Vat_Tu(); item.ID_kho = this.ID_kho; item.ID_nhan_vien = this.ID_Nhan_vien; item.isGiuLai = this.isGiuLai; item.isHoanNhap = this.isHoanNhap; item.Ly_do = this.Ly_do; item.Cong_trinh = this.Cong_trinh; item.Dia_chi = this.Dia_chi; item.Ngay_xuat = this.Ngay_xuat; item.Ma_phieu_xuat_tam = this.Ma_phieu_xuat_tam; item.Da_duyet = this.Da_duyet; help.ent.Phieu_Xuat_Tam_Vat_Tu.Add(item); help.ent.SaveChanges(); dbcxtransaction.Commit(); return 1; } } catch (Exception ex) { return 0; } }
public int Insert(DatabaseHelper help) { var item = new Phieu_Xuat_Tam_Vat_Tu(); item.ID_kho = this.ID_kho; item.ID_nhan_vien = this.ID_Nhan_vien; item.isGiuLai = this.isGiuLai; item.isHoanNhap = this.isHoanNhap; item.Ly_do = this.Ly_do; item.Cong_trinh = this.Cong_trinh; item.Dia_chi = this.Dia_chi; item.Ngay_xuat = this.Ngay_xuat; item.Ma_phieu_xuat_tam = this.Ma_phieu_xuat_tam; item.Da_duyet = this.Da_duyet; item.ID_phieu_xuat_tam = this.ID_phieu_xuat_tam; help.ent.Phieu_Xuat_Tam_Vat_Tu.Add(item); return help.ent.SaveChanges(); }
public int Delete(Phieu_Xuat_Tam_Vat_Tu pxt) { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); help.ent.Phieu_Xuat_Tam_Vat_Tu.Attach(pxt); help.ent.Phieu_Xuat_Tam_Vat_Tu.Remove(pxt); return help.ent.SaveChanges(); //DAL.BeginTransaction(); //m_dbConnection = DAL.m_conn; //if (m_dbConnection.State == ConnectionState.Closed) //m_dbConnection.Open(); //string sql = "Delete from Phieu_xuat_tam_vat_tu WHERE ma_phieu_xuat_tam=@ma_phieu_xuat_tam"; //SqlCommand command = new SqlCommand(sql, m_dbConnection, DAL.m_trans); //command.CommandType = CommandType.Text; //command.Parameters.Add(new SqlParameter("@ma_phieu_xuat_tam", Ma_phieu_xuat_tam)); //int result = command.ExecuteNonQuery(); //DAL.CommitTransaction(); //return result; }