private void GetBojData()
{
this.isinfo = DbfTable.GetIsinfo(this.main_form.selected_comp);
using (LocalDbEntities db = DBX.DataSet(this.main_form.selected_comp))
{
this.boj5_header = db.boj5_header.FirstOrDefault();
if (this.boj5_header == null)
{
db.boj5_header.Add(new boj5_header
{
accSource = ACC_SOURCE.B.ToString(),
foreignShareholder = 0,
headerStatus = "A",
meetingNo = "",
meetingType = MEETING_TYPE.B.ToString(),
parValue = 0,
sourceDate = null,
thaiShareholder = 0,
totalCapital = 0,
totalForeignShare = 0,
totalShare = 0,
totalThaiShare = 0,
userId = "",
yearEnd = null
});
db.SaveChanges();
this.boj5_header = db.boj5_header.First();
}
this.boj5_detail = db.boj5_detail.Include("boj5_person").OrderBy(d => d.itemNo).ToList();
}
}
private void btnStop_Click(object sender, EventArgs e)
{
if (XMessageBox.Show("ยกเลิกการแก้ไขข้อมูล, ทำต่อหรือไม่?", "", MessageBoxButtons.OKCancel, XMessageBoxIcon.Question) == DialogResult.OK)
{
this.tmp_boj5_header = null;
this.GetBojData();
this.FillForm(this.boj5_header, this.boj5_detail);
this.ResetFormState(FORM_MODE.READ);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.tmp_boj5_header == null)
{
return;
}
try
{
using (LocalDbEntities db = DBX.DataSet(this.main_form.selected_comp))
{
var header_to_update = db.boj5_header.Find(1);
header_to_update.accSource = this.tmp_boj5_header.accSource;
header_to_update.foreignShareholder = this.tmp_boj5_header.foreignShareholder;
header_to_update.headerStatus = this.tmp_boj5_header.headerStatus;
header_to_update.meetingNo = this.tmp_boj5_header.meetingNo;
header_to_update.meetingType = this.tmp_boj5_header.meetingType;
header_to_update.parValue = this.tmp_boj5_header.parValue;
header_to_update.sourceDate = this.tmp_boj5_header.sourceDate;
header_to_update.thaiShareholder = this.tmp_boj5_header.thaiShareholder;
header_to_update.totalCapital = this.tmp_boj5_header.totalCapital;
header_to_update.totalForeignShare = this.tmp_boj5_header.totalForeignShare;
header_to_update.totalShare = this.tmp_boj5_header.totalShare;
header_to_update.totalThaiShare = this.tmp_boj5_header.totalThaiShare;
header_to_update.userId = this.tmp_boj5_header.userId;
header_to_update.yearEnd = this.tmp_boj5_header.yearEnd;
db.SaveChanges();
}
this.tmp_boj5_header = null;
this.ResetFormState(FORM_MODE.READ);
this.GetBojData();
this.FillForm(this.boj5_header, this.boj5_detail);
}
catch (Exception ex)
{
XMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error);
}
}
private void FillForm(boj5_header boj5_header_to_fill, List <boj5_detail> boj5_detail_to_fill)
{
if (this.isinfo != null)
{
this.cCompNam._Text = this.isinfo.thinam;
this.cTaxId._Text = this.isinfo.taxid;
}
if (boj5_header_to_fill != null)
{
var selected_accsource = this.cAccSource._Items.Cast <XDropdownListItem>().Where(i => (string)i.Value == boj5_header_to_fill.accSource).FirstOrDefault();
if (selected_accsource != null)
{
this.cAccSource._SelectedItem = selected_accsource;
}
this.cSourceDate._SelectedDate = boj5_header_to_fill.sourceDate;
this.cYearEnd._SelectedDate = boj5_header_to_fill.yearEnd;
this.cTotalCapital._Value = Convert.ToDecimal(boj5_header_to_fill.totalCapital);
this.cTotalShare._Value = Convert.ToDecimal(boj5_header_to_fill.totalShare);
this.cParValue._Value = Convert.ToDecimal(boj5_header_to_fill.parValue);
this.cThaiShareHolder._Value = Convert.ToDecimal(boj5_header_to_fill.thaiShareholder);
this.cTotalThaiShare._Value = Convert.ToDecimal(boj5_header_to_fill.totalThaiShare);
this.cForeignShareHolder._Value = Convert.ToDecimal(boj5_header_to_fill.foreignShareholder);
this.cTotalForeignShare._Value = Convert.ToDecimal(boj5_header_to_fill.totalForeignShare);
this.cMeetingTypeE.Checked = boj5_header_to_fill.meetingType == MEETING_TYPE.E.ToString() ? true : false;
this.cMeetingTypeC.Checked = boj5_header_to_fill.meetingType == MEETING_TYPE.C.ToString() ? true : false;
this.cMeetingTypeS.Checked = boj5_header_to_fill.meetingType == MEETING_TYPE.S.ToString() ? true : false;
this.cMeetingNo._Text = boj5_header_to_fill.meetingNo;
}
if (boj5_detail_to_fill != null)
{
this.boj5_detail_bindinglist = new BindingList <boj5_detail_VM>(this.boj5_detail.ToViewModel());
this.dgv.DataSource = this.boj5_detail_bindinglist;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
using (LocalDbEntities db = DBX.DataSet(this.main_form.selected_comp))
{
this.tmp_boj5_header = db.boj5_header.First();
this.FillForm(this.tmp_boj5_header, this.boj5_detail);
}
this.ResetFormState(FORM_MODE.EDIT);
this.cAccSource.Focus();
//using (LocalDbEntities db = DBX.DataSet(this.main_form.selected_comp))
//{
// db.glacc_match.Add(new glacc_match { accnum = "1234-56", depcod = "ขาย 2", taxodesc = "TAXO 1", taxodesc2 = "TAXO 2" });
// db.boj5_person.Add(new boj5_person { holderName = "วีรวัฒน์ ตรุเจตนารมย์", addrFull = "kanasiri" });
// db.boj5_person.Add(new boj5_person { holderName = "รฐา ตรุเจตนารมย์", addrFull = "kanasiri" });
// db.SaveChanges();
// var a = db.glacc_match.ToList();
// var b = db.boj5_detail.ToList();
// var c = db.boj5_header.ToList();
// var d = db.boj5_person.ToList();
// Console.WriteLine(" ==> ok");
//}
}