/// <summary> /// Update ALL /// </summary> /// <returns></returns> public int Update(DM_Vat_Tu vt) { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); int temp = 0; using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { using (var context = help.ent) { context.DM_Vat_Tu.Attach(vt); context.Entry(vt).State = EntityState.Modified; temp = help.ent.SaveChanges(); dbcxtransaction.Commit(); } } return temp; ////Mở //m_dbConnection.Open(); ////Chuẩn bị //string sql = ""; //sql += "UPDATE DM_Vat_Tu "; //sql += "Set Ma_vat_tu=@Ma_vat_tu, "; //sql += "Ten_vat_tu=@Ten_vat_tu, "; //sql += "ID_Don_vi_tinh=@ID_Don_vi_tinh, "; //sql += "Mo_ta=@Mo_ta "; //sql += "WHERE Ma_vat_tu=@old_Ma_vat_tu"; //SqlCommand command = new SqlCommand(sql, m_dbConnection); //command.Parameters.Add("@Ma_vat_tu", SqlDbType.VarChar, 50).Value = Ma_vat_tu; //command.Parameters.Add("@old_Ma_vat_tu", SqlDbType.VarChar, 50).Value = old_Ma_vat_tu; //command.Parameters.Add("@Ten_vat_tu", SqlDbType.NVarChar, 50).Value = Ten_vat_tu; //command.Parameters.Add("@ID_Don_vi_tinh", SqlDbType.Int).Value = ID_Don_vi_tinh; //command.Parameters.Add("@Mo_ta", SqlDbType.NVarChar, 50).Value = Mo_ta; //command.CommandType = CommandType.Text; ////Run //int result = command.ExecuteNonQuery(); ////Đóng //m_dbConnection.Close(); //return result; }
/// <summary> /// Xoa by ID /// </summary> /// <returns>bool</returns> public int Delete(DM_Vat_Tu vt) { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { help.ent.DM_Vat_Tu.Attach(vt); help.ent.DM_Vat_Tu.Remove(vt); help.ent.SaveChanges(); dbcxtransaction.Commit(); return 1; } ////Mở //m_dbConnection.Open(); ////Chuẩn bị //string sql = ""; //sql += "Delete from DM_Vat_Tu "; //sql += "WHERE Ma_vat_tu=@Ma_vat_tu"; //SqlCommand command = new SqlCommand(sql, m_dbConnection); //command.Parameters.Add("@Ma_vat_tu", SqlDbType.VarChar, 50).Value = Ma_vat_tu; //command.CommandType = CommandType.Text; ////Run //int result = command.ExecuteNonQuery(); ////Đóng //m_dbConnection.Close(); //return result; }