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()); } }