private void ReturnVideo()
{
if (lbxRendVideo.SelectedItems == null || lbxRendVideo.SelectedItems.Count < 1)
{
MessageBox.Show("반환할 회원의 대여 비디오를 먼저 선택해 주십시오.", "비디오 반환안내");
lbxVideo.Focus();
return;
}
int idx = lbxRendVideo.SelectedItems[0].Index;
int id = Convert.ToInt32(lbxRendVideo.Items[idx].Name);
VRSDataSet.tblRentVideoRow row = vrsDataSet.tblRentVideo.FindById(id);
if (row != null && MessageBox.Show("반환하시겠습니까?", "반환확인안내") == DialogResult.OK)
{
row.BeginEdit();
row.ReturnDate = DateTime.Now;
row.IsReturn = true;
row.EndEdit();
this.Validate();
this.tblRentVideoTableAdt.Update(row);
SetMemberListView();
SetVideoListView();
SetRendVideoListView();
}
}
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();
}
}
