/// <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;
}
