public CheckInsureCarData GetItemAgent(string code)
{
try
{
DBbase.Connect();
string sql = @"SELECT T.SELECT_INSURANCE_CODE,T.SELECT_INSURANCE_STATUS,
T.WINDOW_IP,T.AGENT_CODE,T.TRANSACTION_TYPE,T.INSURE_CAR_CODE,T.REMARK,T.CREATE_DATE,S.sm_name,S.sm_lastname,S.sm_email,S.sm_tel,S.sm_phone
FROM TA_SELECT_INSURANCE T INNER JOIN system_member S ON T.AGENT_CODE = S.sm_code WHERE SELECT_INSURANCE_CODE = '" + code + "'";
SqlCommand cmd = new SqlCommand(sql, DBbase.con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
CheckInsureCarData item = new CheckInsureCarData();
item.SELECT_INSURANCE_CODE = reader["SELECT_INSURANCE_CODE"].ToString();
item.INSURE_CAR_CODE = reader["INSURE_CAR_CODE"].ToString();
//item.AGENT_NAME = reader.GetString("sm_name") + " " + reader.GetString("sm_lastname");
//item.AGENT_EMAIL = reader.GetString("sm_email");
//item.AGENT_PHONE = reader.GetString("sm_phone");
//item.AGENT_TEL = reader.GetString("sm_tel");
item.SELECT_INSURANCE_STATUS = reader["SELECT_INSURANCE_STATUS"].ToString();
item.WINDOW_IP = reader["WINDOW_IP"].ToString();
item.AGENT_CODE = reader["AGENT_CODE"].ToString();
item.TRANSACTION_TYPE = reader["TRANSACTION_TYPE"].ToString();
item.REMARK = reader["REMARK"].ToString();
item.CREATE_DATE = Convert.ToDateTime(reader["CREATE_DATE"].ToString());
reader.Close();
DBbase.DisConnect();
return(item);
}
else
{
DBbase.DisConnect();
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
CheckInsureCarDAL objDal = new CheckInsureCarDAL();
string code = ((DataRowView)grdInsure.SelectedItem).Row.ItemArray[0].ToString();
if (objDal.CheckStatus(code) != "01" && objDal.CheckOwner(code, member.MEMBER_USER) != "02" && member.ROLE_CODE.ToUpper() == "MEMBER")
{
MessageBox.Show("มีพนักงานท่ายอื่นดำเนินการแล้ว");
}
else
{
if (member.ROLE_CODE.ToUpper() == "MEMBER")
{
objDal.UpdateStatus(code);
}
CheckInsureCarData item = objDal.GetItem(code);
if (item.TRANSACTION_TYPE == "customer")
{
DataCommon.Set("CHECK_INSURE_CAR_EDIT", item);
PopupCheckCustomer popup = new PopupCheckCustomer();
popup.ShowDialog();
}
else
{
item = objDal.GetItemAgent(code);
DataCommon.Set("CHECK_INSURE_CAR_EDIT", item);
PopupCheckAgent popup = new PopupCheckAgent();
popup.ShowDialog();
}
}
ReloadData();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public CheckInsureCarData GetItem(string code)
{
try
{
DBbase.Connect();
string sql = @"SELECT SELECT_INSURANCE_CODE,CUSTOMER_NAME,CUSTOMER_EMAIL,CUSTOMER_TEL,SELECT_INSURANCE_STATUS,
WINDOW_IP,AGENT_CODE,TRANSACTION_TYPE,INSURE_CAR_CODE,REMARK,CREATE_DATE
FROM TA_SELECT_INSURANCE WHERE SELECT_INSURANCE_CODE = '" + code + "'";
SqlCommand cmd = new SqlCommand(sql, DBbase.con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
CheckInsureCarData item = new CheckInsureCarData();
item.SELECT_INSURANCE_CODE = reader["SELECT_INSURANCE_CODE"].ToString();
item.INSURE_CAR_CODE = reader["INSURE_CAR_CODE"].ToString();
item.CUSTOMER_NAME = reader["CUSTOMER_NAME"].ToString();
item.CUSTOMER_EMAIL = reader["CUSTOMER_EMAIL"].ToString();
item.CUSTOMER_TEL = reader["CUSTOMER_TEL"].ToString();
item.SELECT_INSURANCE_STATUS = reader["SELECT_INSURANCE_STATUS"].ToString();
item.WINDOW_IP = reader["WINDOW_IP"].ToString();
item.AGENT_CODE = reader["AGENT_CODE"].ToString();
item.TRANSACTION_TYPE = reader["TRANSACTION_TYPE"].ToString();
item.REMARK = reader["REMARK"].ToString();
item.CREATE_DATE = Convert.ToDateTime(reader["CREATE_DATE"].ToString());
reader.Close();
DBbase.DisConnect();
return(item);
}
else
{
DBbase.DisConnect();
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateComplete(CheckInsureCarData item)
{
try
{
MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER");
DBbase.Connect();
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE TA_SELECT_INSURANCE ");
sql.Append("SET SELECT_INSURANCE_STATUS = '" + item.SELECT_INSURANCE_STATUS + "',");
sql.Append(" REMARK = '" + item.REMARK + "',");
sql.Append(" WINDOW_IP = '" + UtilityCommon.GetLocalIPAddress() + "',");
sql.Append(" UPDATE_DATE = '" + ConvertCommon.ConvertDateTime(DateTime.Now) + "',");
sql.Append(" UPDATE_USER = '******'");
sql.Append(" WHERE SELECT_INSURANCE_CODE = '" + item.SELECT_INSURANCE_CODE + "'");
SqlCommand cmd = new SqlCommand(sql.ToString(), DBbase.con);
cmd.ExecuteNonQuery();
DBbase.DisConnect();
}
catch (Exception ex)
{
throw ex;
}
}
public PopupCheckAgent()
{
try
{
InitializeComponent();
item = (CheckInsureCarData)DataCommon.Get("CHECK_INSURE_CAR_EDIT");
txtDate.Text = item.CREATE_DATE.ToString();
txtEMail.Text = item.AGENT_EMAIL;
txtName.Text = item.AGENT_NAME;
txtTel.Text = item.AGENT_TEL + "," + item.AGENT_PHONE;
txtAgentCode.Text = item.AGENT_CODE;
member = (MemberData)DataCommon.Get("DATA.MEMBER");
if (member.ROLE_CODE.ToUpper().Equals("ADMIN"))
{
btnCancel.Visibility = System.Windows.Visibility.Hidden;
btnSave.Visibility = System.Windows.Visibility.Hidden;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public PopupCheckCustomer()
{
try
{
InitializeComponent();
item = (CheckInsureCarData)DataCommon.Get("CHECK_INSURE_CAR_EDIT");
txtDate.Text = item.CREATE_DATE.ToString();
txtEMail.Text = item.CUSTOMER_EMAIL;
txtName.Text = item.CUSTOMER_NAME;
txtTel.Text = item.CUSTOMER_TEL;
member = (MemberData)DataCommon.Get("DATA.MEMBER");
if (member.ROLE_CODE.ToUpper().Equals("Admin"))
{
btnCancel.Visibility = System.Windows.Visibility.Hidden;
btnSave.Visibility = System.Windows.Visibility.Hidden;
btnPing.Visibility = System.Windows.Visibility.Visible;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
