public PopupCompanyInsure()
{
try
{
InitializeComponent();
if (DataCommon.Exists("COMPANY_EDIT"))
{
item = (InsureCompanyData)DataCommon.Get("COMPANY_EDIT");
txtCompantCode.Text = item.COMPANY_CODE;
txtCompantFullName.Text = item.COMPANY_FULLNAME;
//txtPicPath.Text = item.COMPANY_PATH_PIC;
txtRemark.Text = item.COMPANY_REMARK;
//txtShortName.Text = item.COMPANY_SHORTNAME;
cbbStatus.SelectedIndex = item.COMPANY_STATUS == "A" ? 0 : 1;
}
else
{
txtCompantCode.IsEnabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public InsureCompanyData GetItem(string code)
{
try
{
DBbase.Connect();
string sql = "SELECT COMPANY_CODE,COMPANY_FULLNAME,COMPANY_PATH_PIC,COMPANY_REMARK,COMPANY_SHORTNAME,COMPANY_STATUS FROM MA_INSURE_COMPANY WHERE COMPANY_CODE = '" + code + "'";
SqlCommand cmd = new SqlCommand(sql, DBbase.con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
InsureCompanyData item = new InsureCompanyData();
item.COMPANY_CODE = reader["COMPANY_CODE"].ToString();
item.COMPANY_FULLNAME = reader["COMPANY_FULLNAME"].ToString();
item.COMPANY_PATH_PIC = reader["COMPANY_PATH_PIC"].ToString();
item.COMPANY_REMARK = reader["COMPANY_REMARK"].ToString();
item.COMPANY_SHORTNAME = reader["COMPANY_SHORTNAME"].ToString();
item.COMPANY_STATUS = reader["COMPANY_STATUS"].ToString();
reader.Close();
DBbase.DisConnect();
return(item);
}
else
{
DBbase.DisConnect();
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Insert(InsureCompanyData item)
{
try
{
MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER");
DBbase.Connect();
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO MA_INSURE_COMPANY (COMPANY_CODE,COMPANY_FULLNAME,COMPANY_PATH_PIC,COMPANY_REMARK,COMPANY_SHORTNAME,COMPANY_STATUS,CREATE_DATE,CREATE_USER,UPDATE_DATE,UPDATE_USER) VALUES (");
sql.Append(" '" + item.COMPANY_CODE.ToUpper() + "',");
sql.Append(" '" + item.COMPANY_FULLNAME + "',");
sql.Append(" '" + item.COMPANY_PATH_PIC + "',");
sql.Append(" '" + item.COMPANY_REMARK + "',");
sql.Append(" '" + item.COMPANY_SHORTNAME + "',");
sql.Append(" '" + item.COMPANY_STATUS + "',");
sql.Append(" '" + DateTime.Now + "',");
sql.Append(" '" + member.MEMBER_USER + "',");
sql.Append(" '" + DateTime.Now + "',");
sql.Append(" '" + member.MEMBER_USER + "')");
SqlCommand cmd = new SqlCommand(sql.ToString(), DBbase.con);
cmd.ExecuteNonQuery();
DBbase.DisConnect();
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(InsureCompanyData item)
{
try
{
MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER");
DBbase.Connect();
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE MA_INSURE_COMPANY SET COMPANY_CODE = '" + item.COMPANY_CODE.ToUpper() + "',");
sql.Append(" COMPANY_FULLNAME = '" + item.COMPANY_FULLNAME + "',");
sql.Append(" COMPANY_PATH_PIC = '" + item.COMPANY_PATH_PIC + "',");
sql.Append(" COMPANY_REMARK = '" + item.COMPANY_REMARK + "',");
sql.Append(" COMPANY_SHORTNAME = '" + item.COMPANY_SHORTNAME + "',");
sql.Append(" COMPANY_STATUS = '" + item.COMPANY_STATUS.ToUpper() + "',");
sql.Append(" UPDATE_DATE = '" + DateTime.Now + "',");
sql.Append(" UPDATE_USER = '******'");
sql.Append(" WHERE COMPANY_CODE = '" + item.COMPANY_CODE.ToUpper() + "'");
SqlCommand cmd = new SqlCommand(sql.ToString(), DBbase.con);
cmd.ExecuteNonQuery();
DBbase.DisConnect();
}
catch (Exception ex)
{
throw ex;
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
if (txtCompantCode.Text == "")
{
MessageBox.Show("กรุณากรอก รหัสบริษัท");
return;
}
if (txtCompantFullName.Text == "")
{
MessageBox.Show("กรุณากรอก ชื่อเต็มบริษัท");
return;
}
if (MessageBox.Show("ยืนยันการบันทึกข้อมูล", "การบันทึกข้อมูล", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
bool complete = false;
InsureCompanyDAL dal = new InsureCompanyDAL();
if (DataCommon.Exists("COMPANY_EDIT"))
{
item = (InsureCompanyData)DataCommon.Get("COMPANY_EDIT");
item.COMPANY_CODE = txtCompantCode.Text;
item.COMPANY_FULLNAME = txtCompantFullName.Text;
item.COMPANY_PATH_PIC = "";
item.COMPANY_REMARK = txtRemark.Text;
item.COMPANY_SHORTNAME = "";
item.COMPANY_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I";
dal.Update(item);
DataCommon.Remove("COMPANY_EDIT");
complete = true;
}
else
{
if (dal.GetItem(txtCompantCode.Text) == null)
{
item = new InsureCompanyData();
item.COMPANY_CODE = txtCompantCode.Text;
item.COMPANY_FULLNAME = txtCompantFullName.Text;
item.COMPANY_PATH_PIC = "";
item.COMPANY_REMARK = txtRemark.Text;
item.COMPANY_SHORTNAME = "";
item.COMPANY_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I";
new InsureCompanyDAL().Insert(item);
complete = true;
}
else
{
MessageBox.Show("รหัสบริษัทนี้ซ้ำในระบบ กรุณาเปลี่ยนรหัสบริษัท");
}
}
if (complete)
{
MessageBox.Show("บันทึกข้อมูลสำเร็จ");
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
