private void btnsave_Click(object sender, EventArgs e)
{
if (!Ischeck())
{
#region ADD/EDIT
if (modes == "new")
{
DataRow dr = dcore.GetSearchPeople("", txtrank.Text.Trim(), txtbooknumber.Text.Trim());
if (dr != null)
{
if (dr["rank"].ToString() == txtrank.Text.Trim() && dr["book_number"].ToString() == txtbooknumber.Text.Trim())
{
MessageBox.Show("ลำดับเล่มที่" + txtbooknumber.Text.Trim() + " ลำดับที่" + txtrank.Text.Trim() + "มีอยู่แล้วในระบบ");
}
}
else
{
DataRow param = dcore.GetListPeople("", "", "").NewRow();
param["id13"] = txtid13.Text.Trim();
param["navyid"] = navyid;
param["people_name"] = txtpeoole_name.Text.Trim();
param["people_lname"] = txtpeoole_name.Text.Trim();
param["address_in"] = txtaddress_old.Text.Trim();
param["address_in"] = txtaddress_old.Text.Trim();
param["address_mu_in"] = txtaddress_mu_old.Text.Trim();
param["address_soid_in"] = txtaddress_soid_old.Text.Trim();
param["address_road_in"] = txtaddress_road_old.Text.Trim();
if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old)))
{
param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old)))
{
param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old)))
{
param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old);
}
param["book_number"] = txtbooknumber.Text.Trim();
param["rank"] = txtrank.Text.Trim();
param["status"] = "1";
param["type_out"] = "26";
if (this.dp_indate.CustomFormat != " " && dp_indate.Value.Date != DateTime.Now)
{
param["in_date"] = dp_indate.Value.Date;
}
if (dcore.InsertPeople(param))
{
MessageBox.Show("บันทึกสำเร็จ");
ClearControl();
}
else
{
MessageBox.Show("บันทึกผิดพลาด");
}
}
}
else
{
DataRow param = dcore.GetSearchPeople(cardid, "", "");
if (param != null)
{
param["id13"] = txtid13.Text.Trim();
param["navyid"] = param["navyid"].ToString();
param["people_name"] = txtpeoole_name.Text.Trim();
param["people_lname"] = txtpeople_lname.Text.Trim();
param["address_in"] = txtaddress_old.Text.Trim();
param["address_mu_in"] = txtaddress_mu_old.Text.Trim();
param["address_soid_in"] = txtaddress_soid_old.Text.Trim();
param["address_road_in"] = txtaddress_road_old.Text.Trim();
if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old)))
{
param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old)))
{
param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old)))
{
param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old);
}
param["book_number"] = txtbooknumber.Text.Trim();
param["rank"] = txtrank.Text.Trim();
param["type_out"] = "26";
param["status"] = "1";
if (chkout.Checked)
{
param["address_out"] = txtaddress.Text.Trim();
param["address_mu_out"] = txtaddress_mu.Text.Trim();
param["address_soid_out"] = txtaddress_soid.Text.Trim();
param["address_road_out"] = txtaddress_road.Text.Trim();
if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district)))
{
param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict)))
{
param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince)))
{
param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince);
}
param["status"] = DataControls.GetSelectedValueComboBoxToString(cmbselect_out);
if (this.dp_outdate.CustomFormat != " " && dp_indate.Value.Date != DateTime.Now)
{
param["out_date"] = dp_outdate.Value.Date;
}
param["type_out"] = DataControls.GetSelectedValueComboBoxToString(cmbselectaddress);
}
if (dcore.UpdatePeople(param))
{
MessageBox.Show("บันทึกสำเร็จ");
this.Close();
}
else
{
MessageBox.Show("บันทึกผิดพลาด");
}
}
}
#endregion
}
}
