/// <summary> /// Get card by key (number) /// </summary> /// <param name="number"></param> /// <returns>Return card if founed or null if error</returns> public DTO_Card GetCardByKey(string number) { DataTable dt = dal.GetCardByNumber(number); if (dt.Rows.Count < 0) { return(null); } try { DataRow row = dt.Rows[0]; DTO_Card card = new DTO_Card(); card.CardNumber = row["CardNumber"] == DBNull.Value ? null : row["CardNumber"].ToString(); card.CardSerial = row["CardSerial"] == DBNull.Value ? null : row["CardSerial"].ToString(); card.Holder = row["Holder"] == DBNull.Value ? null : row["Holder"].ToString(); card.Pin = row["PinCode"] == DBNull.Value ? 0 : int.Parse(row["PinCode"].ToString()); card.Type = row["Type"] == DBNull.Value ? EType.CardType.BLOCK : (CardType)Convert.ToInt16(row["Type"].ToString()); card.STime = row["STime"] == DBNull.Value ? new DateTime(1970, 01, 01) : Convert.ToDateTime(row["STime"].ToString()); card.ETime = row["ETime"] == DBNull.Value ? new DateTime(1970, 01, 01) : Convert.ToDateTime(row["ETime"].ToString()); return(card); } catch { return(null); } }
/// <summary> /// Search card /// </summary> /// <param name="searchValue">Card number or Card holder id</param> /// <returns>Return list card if founded or error if null</returns> public List <DTO_Card> SearchCard(string searchValue) { List <DTO_Card> lstCards = new List <DTO_Card>(); DataTable dt = dal.SearchCard(searchValue); if (dt.Rows.Count < 0) { return(null); } try { foreach (DataRow row in dt.Rows) { DTO_Card card = new DTO_Card(); card.CardNumber = row["CardNumber"] == DBNull.Value ? null : row["CardNumber"].ToString(); card.CardSerial = row["CardSerial"] == DBNull.Value ? null : row["CardSerial"].ToString(); card.Holder = row["Holder"] == DBNull.Value ? null : row["Holder"].ToString(); card.Pin = row["PinCode"] == DBNull.Value ? 0 : int.Parse(row["PinCode"].ToString()); card.Type = row["Type"] == DBNull.Value ? EType.CardType.BLOCK : (CardType)Convert.ToInt16(row["Type"].ToString()); card.STime = row["STime"] == DBNull.Value ? new DateTime(1970, 01, 01) : Convert.ToDateTime(row["STime"].ToString()); card.ETime = row["ETime"] == DBNull.Value ? new DateTime(1970, 01, 01) : Convert.ToDateTime(row["ETime"].ToString()); lstCards.Add(card); } return(lstCards); } catch { return(null); } }
private void MyCardWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { btSave.IsEnabled = true; if (result.Result) { if (this.mode == EType.WindowMode.ADD_MODE) { if (getCardWorker.IsBusy) { getCardWorker.CancelAsync(); } else { getCardWorker.RunWorkerAsync(); } } else { DTO_Card oldCard = Repository.lstAllCards.FirstOrDefault(c => c.CardNumber == myCard.CardNumber); if (oldCard != null) { oldCard = myCard; } this.DialogResult = true; this.Hide(); } } else { MessageBox.Show(result.Detail, "", MessageBoxButton.OK, MessageBoxImage.Error); } }
/// <summary> /// Update card information in database /// </summary> /// <param name="card"></param> /// <returns></returns> public SQLResult UpdateCard(DTO_Card card) { DataTable dt = new DataTable(); SQLResult result = new SQLResult(false, ""); try { _conn.Open(); SqlCommand command = new SqlCommand(); command.Connection = _conn; command.CommandType = CommandType.StoredProcedure; command.CommandText = "spLCardSave"; command.Parameters.AddWithValue("WorkType", "U"); command.Parameters.AddWithValue("CardNumber", card.CardNumber); command.Parameters.AddWithValue("CardSerial", card.CardSerial); command.Parameters.AddWithValue("Pin", card.Pin); if (string.IsNullOrEmpty(card.Holder)) { command.Parameters.AddWithValue("Holder", DBNull.Value); } else { command.Parameters.AddWithValue("Holder", card.Holder); } command.Parameters.AddWithValue("Type", (int)card.Type); command.Parameters.AddWithValue("STime", card.STime); command.Parameters.AddWithValue("ETime", card.ETime); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; adapter.Fill(dt); if (dt.Rows[0]["Result"].ToString() == "OK") { result.Result = true; } result.Detail = dt.Rows[0]["Detail"].ToString(); } catch (Exception ex) { result.Detail = ex.Message; } finally { _conn.Close(); } return(result); }
/// <summary> /// Update card information /// </summary> /// <param name="card">The card object want to update</param> /// <returns>Return true if update success, Error if update fail or validate fail</returns> public SQLResult UpdateCard(DTO_Card card) { if (card == null) { return(new SQLResult(false, "[112] - Thẻ rỗng.")); } if (!card.Validation().Result) { return(card.Validation()); } return(dal.UpdateCard(card)); }
private void DeleleCardWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { if (result.Result) { DTO_Card oldCard = Repository.lstAllCards.FirstOrDefault(c => c.CardNumber == myCard.CardNumber); if (oldCard != null) { Repository.lstAllCards.Remove(oldCard); } this.DialogResult = true; this.Hide(); } else { MessageBox.Show(result.Detail, "", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { InitData(); switch (mode) { case EType.WindowMode.ADD_MODE: ResetControl(); dpStartTime.SelectedDate = DateTime.Today; dpEndTime.SelectedDate = DateTime.Today.AddDays(1); btDelete.IsEnabled = false; myCard = new DTO_Card(); break; default: BindData(); break; } }
public int DeleteCard(DTO_Card card) { return(cardDAO.Delete(card.ID.ToString())); }
public int UpdateCard(DTO_Card card) { return(cardDAO.Update(card)); }
public int InsertCard(DTO_Card card) { return(cardDAO.Insert(card)); }
public int Update(DTO_Card card) { string sql = "UPDATE Card SET c_id='" + card.ID + "',r_id='" + card.ReaderID + "',expired_date='" + card.Expired_date + "'WHERE c_id = " + card.ID; return(this.ExecuteNonQuery(sql)); }
public int Insert(DTO_Card card) { string sql = "INSERT INTO Card(c_id,r_id,expired_date) VALUES('" + card.ID + "','" + card.ReaderID + "','" + card.Expired_date + "')"; return(this.ExecuteNonQuery(sql)); }
public wdCardDetail(EType.WindowMode mode, DTO_Card card) { InitializeComponent(); this.myCard = card; this.mode = mode; }