private void SetVideoData(DAL.Video dlgData, ref VRSDataSet.tblVideoRow row) { if (row.IsNull("Title") || !row.Title.Equals(dlgData.Title)) { row.Title = dlgData.Title; } if (row.IsNull("Stock") || !row.Stock.Equals(dlgData.Stock)) { row.Stock = dlgData.Stock; } if (row.IsNull("Producer") || !row.Producer.Equals(dlgData.Producer)) { row.Producer = dlgData.Producer; } if (row.IsNull("Director") || !row.Director.Equals(dlgData.Director)) { row.Director = dlgData.Director; } if (row.IsNull("Starring") || !row.Starring.Equals(dlgData.Starring)) { row.Starring = dlgData.Starring; } if (row.IsNull("ProductionYear") || !row.ProductionYear.Equals(dlgData.ProductionYear)) { row.ProductionYear = dlgData.ProductionYear; } if (row.IsNull("Description") || !row.Description.Equals(dlgData.Description)) { row.Description = dlgData.Description; } if (row.IsNull("VideoCode") || !row.VideoCode.Equals(dlgData.VideoType)) { row.VideoCode = dlgData.VideoType; } }
private void RemoveVideo() { if (lbxVideo.SelectedItems == null || lbxVideo.SelectedItems.Count < 1) { MessageBox.Show("삭제할 비디오를 먼저 선택해 주십시오.", "비디오삭제 안내"); lbxVideo.Focus(); return; } int idx = lbxVideo.SelectedItems[0].Index; int id = Convert.ToInt32(lbxVideo.Items[idx].Name); int rent = vrsDataSet.tblRentVideo.Count(o => o.VideoId == id); if (rent < 1) { if (MessageBox.Show("정말 삭제하시겠습니까?", "비디오정보 삭제안내") == DialogResult.OK) { VRSDataSet.tblVideoRow row = vrsDataSet.tblVideo.FindById(id); row.Delete(); this.tblVideoTableAdt.Update(row); SetVideoListView(); } } else { MessageBox.Show("대여기록이 있는 비디오는 삭제할 수 없습니다.", "비디오정보 삭제안내"); } }
private void ModifyVideo() { if (lbxVideo.SelectedItems == null || lbxVideo.SelectedItems.Count < 1) { MessageBox.Show("수정할 비디오를 먼저 선택해 주십시오.", "비디오정보 수정안내"); lbxVideo.Focus(); return; } int idx = lbxVideo.SelectedItems[0].Index; VRSVideoForm dlg = new VRSVideoForm(); dlg.Text = "비디오정보 수정"; dlg.m_Video = lbxVideo.Items[idx].Tag as Video; if (dlg.ShowDialog() == DialogResult.OK) { int id = Convert.ToInt32(lbxVideo.Items[idx].Name); VRSDataSet.tblVideoRow row = vrsDataSet.tblVideo.FindById(id); SetVideoData(dlg.m_Video, ref row); if (row.RowState == DataRowState.Modified) { //데이터소스에 반영 this.Validate(); this.tblVideoTableAdt.Update(row); SetVideoListView(); } } }
private void RendVideo() { if (lbxMembership.SelectedItems == null || lbxMembership.SelectedItems.Count < 1 || lbxVideo.SelectedItems == null || lbxVideo.SelectedItems.Count < 1) { MessageBox.Show("대여할 회원과 비디오를 먼저 선택해 주십시오.", "비디오 대여안내"); lbxVideo.Focus(); return; } int idxMember = lbxMembership.SelectedItems[0].Index; int idxVideo = lbxVideo.SelectedItems[0].Index; int memberId = Convert.ToInt32(lbxMembership.Items[idxMember].Name); int videoId = Convert.ToInt32(lbxVideo.Items[idxVideo].Name); VRSDataSet.tblVideoRow rowVideo = vrsDataSet.tblVideo.FindById(videoId); VRSDataSet.tblMembershipRow rowMember = vrsDataSet.tblMembership.FindById(memberId); if (rowVideo == null || rowMember == null) { MessageBox.Show("회원정보와 비디오정보를 확인해 주십시오", "대여정보 확인안내"); lbxVideo.Focus(); return; } if (rowVideo.Stock - vrsDataSet.tblRentVideo.Count(o => o.VideoId == rowVideo.Id && !o.IsReturn) < 0) { MessageBox.Show("대여할 비디오가 없습니다.", "대여정보 확인안내"); lbxVideo.Focus(); return; } if (MessageBox.Show("대여하시겠습니까?", "대여확인안내") == DialogResult.OK) { VRSDataSet.tblRentVideoRow row = vrsDataSet.tblRentVideo.NewtblRentVideoRow(); row.BeginEdit(); row.MemberId = memberId; row.VideoId = videoId; row.RentDate = DateTime.Now; row.IsReturn = false; row.EndEdit(); vrsDataSet.tblRentVideo.Rows.Add(row); //데이터소스에 반영 this.Validate(); this.tblRentVideoTableAdt.Update(row); SetMemberListView(); SetVideoListView(); SetRendVideoListView(); } }
private void CreateVideo() { VRSVideoForm dlg = new VRSVideoForm(); dlg.Text = "비디오정보 등록"; if (dlg.ShowDialog() == DialogResult.OK) { VRSDataSet.tblVideoRow row = vrsDataSet.tblVideo.NewtblVideoRow(); SetVideoData(dlg.m_Video, ref row); vrsDataSet.tblVideo.Rows.Add(row); //데이터소스에 반영 this.Validate(); this.tblVideoTableAdt.Update(row); SetVideoListView(); } }