void setForm(DataSet1.GOODSRow goodsData, DataSet1.CUSTOMERSRow customerData)
{
goodsTableAdapter1.Fill(dataSet11.GOODS);
goodstypeTableAdapter1.Fill(dataSet11.GOODSTYPE);
goodsunitTableAdapter1.Fill(dataSet11.GOODSUNIT);
goodsgradeTableAdapter1.Fill(dataSet11.GOODSGRADE);
tb_required.Text = "1";
tb_name.Text = customerData.C_NAME;
tb_item.Text = goodsData.GDS_NAME;
tb_vender.Text = goodstypeTableAdapter1.GetDataByNo(goodsData.GDSTYPE_NO)[0].GDSTYPE_DESC;
tb_model.Text = goodsData.GDS_MODEL;
tb_qty.Text = goodsData.GDS_QTY.ToString();
tb_unit.Text = goodsunitTableAdapter1.GetDataByNo(goodsData.GDSUNIT_ID)[0].GDSUNIT_DESC;
tb_grade.Text = goodsgradeTableAdapter1.GetDataByNo(goodsData.GDSGRADE_NO)[0].GDSGRADE_DESC;
tb_serial.Text = goodsData.GDS_ID.ToString();
dt_start.Value = getDateServerTime();
dt_end.Value = dt_start.Value;
dt_end.MinDate = dt_start.Value.AddDays(1); dt_end.MaxDate =
dt_start.Value.AddDays(
double.Parse(goodsgradeTableAdapter1.GetDataByNo(goodsData.GDSGRADE_NO)[0].GDSGRADE_PERIOD));
TimeSpan period = dt_end.Value - dt_start.Value;
tb_period.Text = period.Days.ToString();
decimal price = goodsData.GDS_PRICE;
decimal priceRate = goodsgradeTableAdapter1.GetDataByNo(goodsData.GDSGRADE_NO)[0].GDSGRADE_PRICERATE;
string days = tb_period.Text;
string required = tb_required.Text;
string fee = (Convert.ToInt64(price * priceRate) * int.Parse(days) * int.Parse(required)).ToString();
tb_fee.Text = fee;
}
public void makeReservation()
{
reservationsTableAdapter1.Fill(dataSet11.RESERVATIONS);
customersTableAdapter1.Fill(dataSet11.CUSTOMERS);
DataSet1.CUSTOMERSRow customersRow = customersTableAdapter1.GetDataByEmail(customersEmail)[0];
DataSet1.RESERVATIONSDataTable reservationsDataTable = reservationsTableAdapter1.GetData();
DataSet1.RESERVATIONSRow newReservationsRow =
reservationsDataTable.NewRESERVATIONSRow();
newReservationsRow.C_ID = customersRow.C_ID;
newReservationsRow.GDS_ID = goodsRow.GDS_ID;
newReservationsRow.RSV_DATE = getDateServerTime();
newReservationsRow.RSV_QTY = int.Parse(tb_qty.Text);
reservationsDataTable.Rows.Add(newReservationsRow);
int ret = reservationsTableAdapter1.Update(reservationsDataTable);
if (ret > 0)
{
MessageBox.Show("예약 성공");
this.Close();
}
else
{
MessageBox.Show("실패");
}
}
public RentForm(DataSet1.GOODSRow goodsRow, DataSet1.CUSTOMERSRow customersRow)
{
InitializeComponent();
oracleConnection1.Open();
this.goodsRow = goodsRow;
this.customersRow = customersRow;
setForm(goodsRow, customersRow);
}
public ReturnForm(DataSet1.RENTRow rentRow, DataSet1.CUSTOMERSRow customersRow)
{
InitializeComponent();
oracleConnection1.Open();
this.rentRow = rentRow;
this.customersRow = customersRow;
setForm();
setDropDownGrade();
}
public void setUI()
{
try
{
string name;
string tel;
string email;
customersTableAdapter1.Fill(dataSet11.CUSTOMERS);
DataSet1.CUSTOMERSRow customersRow = customersTableAdapter1.GetDataByEmail(customersEmail)[0];
this.customersRow = customersRow;
name = customersRow.C_NAME;
tel = customersRow.C_TEL;
email = customersRow.C_EMAIL;
tb_name.Text = name;
tb_tel.Text = tel;
tb_email.Text = email;
string item;
string vendor;
string model;
string serial;
string qty;
string unit;
goodsunitTableAdapter1.Fill(dataSet11.GOODSUNIT);
goodstypeTableAdapter1.Fill(dataSet11.GOODSTYPE);
item = goodsRow.GDS_NAME;
vendor = goodstypeTableAdapter1.GetDataByNo(goodsRow.GDSTYPE_NO)[0].GDSTYPE_DESC;
model = goodsRow.GDS_MODEL;
serial = goodsRow.GDS_ID.ToString();
qty = getQuantityCount(serial).ToString();
unit = goodsunitTableAdapter1.GetDataByNo(goodsRow.GDSTYPE_NO)[0].GDSUNIT_DESC;
tb_item.Text = item;
tb_vendor.Text = vendor;
tb_model.Text = model;
tb_serial.Text = serial;
tb_qty.Text = "1";
tb_unit.Text = unit;
pb_item.Image = (Image) new ImageConverter().ConvertFrom(goodsRow.GDS_IMG);
}
catch (Exception)
{
MessageBox.Show("시스템 오류입니다.\n나중에 다시 시도해 주세요.");
this.Close();
throw;
}
}
private void ActionCustomerSelect(object sender, DataGridViewCellMouseEventArgs e)
{
DataRowView view = cUSTOMERSBindingSource.Current as DataRowView;
DataSet1.CUSTOMERSRow row = view.Row as DataSet1.CUSTOMERSRow;
tb_tel.Text = row.C_TEL;
tb_email.Text = row.C_EMAIL;
tb_addr.Text = row.C_ADDR;
tb_birth.Text = row.C_BIRTH; tb_name.Text = row.C_NAME;
lb_code.Text = row.C_ID.ToString();
rENTTableAdapter.Fill(dataSet1.RENT);
DataSet1.RENTDataTable table = rENTTableAdapter.GetDataByCid(row.C_ID);
rENTBindingSource.DataSource = table;
resetState(table);
tb_item.Enabled = tb_model.Enabled = btn_search.Enabled = drbtn_slvs.Enabled = drbtn_vendor.Enabled = true;
}
private void ActionRentReturn(object sender, DataGridViewCellMouseEventArgs e)
{
DataRowView view = rENTBindingSource.Current as DataRowView;
DataSet1.RENTRow rentRow = view.Row as DataSet1.RENTRow;
if (rentRow.RNTSTATE_NO != "1")
{
DataRowView customersView = cUSTOMERSBindingSource.Current as DataRowView;
DataSet1.CUSTOMERSRow customersRow = customersView.Row as DataSet1.CUSTOMERSRow;
if (MessageBox.Show("반납을 진행합니다.", "알림", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
new ReturnForm(rentRow, customersRow).ShowDialog();
rENTBindingSource.DataSource = rENTTableAdapter.GetDataByCid(customersRow.C_ID);
rENTBindingSource.ResetBindings(true);
resetState(rENTBindingSource.DataSource as DataSet1.RENTDataTable);
}
}
else
{
MessageBox.Show("반납된 상품입니다.");
}
}
private void ActionGoodsRent(object sender, DataGridViewCellMouseEventArgs e)
{
DataSet1.GOODSRow goodsRow = gOODSBindingSource.Current as DataSet1.GOODSRow;
if (goodsRow == null)
{
DataRowView goodsView = gOODSBindingSource.Current as DataRowView;
goodsRow = goodsView.Row as DataSet1.GOODSRow;
}
DataSet1.CUSTOMERSRow customersRow = cUSTOMERSBindingSource.Current as DataSet1.CUSTOMERSRow;
if (customersRow == null)
{
DataRowView customersView = cUSTOMERSBindingSource.Current as DataRowView;
customersRow = customersView.Row as DataSet1.CUSTOMERSRow;
}
if (MessageBox.Show("대여를 진행합니다.", "알림", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
new RentForm(goodsRow, customersRow).ShowDialog();
rENTBindingSource.DataSource = rENTTableAdapter.GetDataByCid(customersRow.C_ID);
rENTBindingSource.ResetBindings(true);
resetState(rENTBindingSource.DataSource as DataSet1.RENTDataTable);
}
}
