/// <summary> /// Search schedule by name /// </summary> /// <param name="scheduleName">Schedule name</param> /// <returns>Return list schedule if founded or error if null</returns> public List <DTO_Schedule> SearchCard(string scheduleName) { List <DTO_Schedule> lstSchedules = new List <DTO_Schedule>(); DataTable dt = dal.GetScheduledByName(scheduleName); if (dt.Rows.Count < 0) { return(null); } try { foreach (DataRow row in dt.Rows) { DTO_Schedule schedule = new DTO_Schedule(); schedule.Id = row["Id"] == DBNull.Value ? null : row["Id"].ToString(); schedule.Name = row["Name"] == DBNull.Value ? null : row["Name"].ToString(); schedule.Description = row["Description"] == DBNull.Value ? null : row["Description"].ToString(); schedule.Periods = bus_period.GetAllPeriodOfSchedule(schedule.Id); lstSchedules.Add(schedule); } return(lstSchedules); } catch { return(null); } }
private void Insert_to_waitingSMS() { DataTable tb = new DataTable(); tb = checkSchedule(); if (tb.Rows.Count > 0) { DTO_Schedule _sch = new DTO_Schedule(); _sch.Active = false; _sch.ID = tb.Rows[0][0].ToString(); _schedule.Update_state(_sch); for (int i = 0; i < tb.Rows.Count; i++) { string ID = tb.Rows[i][0].ToString(); string GroupID = tb.Rows[i][1].ToString(); if (GroupID == "") { sql_all_customer(ID); } else { sql_all_customer(ID, GroupID); } } } }
public bool Update(DTO_Schedule _Cus) { Connet(); string sql = "update Schedule set Date=@Date, Time=@Time,SMS_info =@SMS_info,AccountID= @AccountID, Active=@Active Where ID=@ID"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Cus.ID; _cmd.Parameters.Add("@Date", SqlDbType.Date).Value = _Cus.Date; _cmd.Parameters.Add("@Time", SqlDbType.DateTime).Value = _Cus.Time; _cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _Cus.AccountID; _cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = _Cus.Active; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
/// <summary> /// Get schedule by key (id) /// </summary> /// <param name="id"></param> /// <returns>Return schedule if founed or null if error</returns> public DTO_Schedule GetScheduleByKey(string id) { DataTable dt = dal.GetScheduledById(id); if (dt.Rows.Count < 0) { return(null); } try { DataRow row = dt.Rows[0]; DTO_Schedule schedule = new DTO_Schedule(); schedule.Id = row["Id"] == DBNull.Value ? null : row["Id"].ToString(); schedule.Name = row["Name"] == DBNull.Value ? null : row["Name"].ToString(); schedule.Description = row["Description"] == DBNull.Value ? null : row["Description"].ToString(); schedule.Periods = bus_period.GetAllPeriodOfSchedule(schedule.Id); return(schedule); } catch { return(null); } }
private void MyScheduleWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { btSave.IsEnabled = true; if (result.Result) { if (this.mode == EType.WindowMode.ADD_MODE) { if (getScheduleWorker.IsBusy) { getScheduleWorker.CancelAsync(); } else { getScheduleWorker.RunWorkerAsync(); } } else { DTO_Schedule oldSchedule = Repository.lstAllSchedules.FirstOrDefault(c => c.Id == schedule.Id); if (oldSchedule != null) { oldSchedule = schedule; } this.DialogResult = true; this.Hide(); } } else { MessageBox.Show(result.Detail, "", MessageBoxButton.OK, MessageBoxImage.Error); } }
/// <summary> /// Add new schedule /// </summary> /// <param name="card">The schedule object want to add</param> /// <returns>Return true if update success, Error if update fail or validate fail</returns> public SQLResult AddNewSchedule(DTO_Schedule schedule) { if (schedule == null) { return(new SQLResult(false, "Schedule null")); } return(dal.AddNewSchedule(schedule)); }
private void GetPeriodWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { if (newPeriod == null || newPeriod.Id == "") { } DTO_Schedule schedule = Repository.lstAllSchedules.FirstOrDefault(s => s.Id == newPeriod.Schedule); if (schedule != null) { schedule.Periods.Add(newPeriod); } this.DialogResult = true; this.Hide(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { InitData(); switch (mode) { case EType.WindowMode.ADD_MODE: schedule = new DTO_Schedule(); ResetControl(); break; default: BindData(); break; } }
private void DelScheduleWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { if (result.Result) { DTO_Schedule oldSchedule = Repository.lstAllSchedules.FirstOrDefault(s => s.Id == schedule.Id); if (oldSchedule != null) { Repository.lstAllSchedules.Remove(oldSchedule); } this.DialogResult = true; this.Hide(); } else { MessageBox.Show(result.Detail, "", MessageBoxButton.OK, MessageBoxImage.Error); } }
public List <DTO_Schedule> GetScheduleInRight(string rightId) { List <DTO_Schedule> lstSchedules = new List <DTO_Schedule>(); DataTable dt = dal.GetRightDetailByRight(rightId, 1); if (dt.Rows.Count <= 0) { return(lstSchedules); } foreach (DataRow dr in dt.Rows) { string id = dr["DetailId"].ToString(); DTO_Schedule schedule = bus_Schedule.GetScheduleByKey(id); lstSchedules.Add(schedule); } return(lstSchedules); }
/// <summary> /// Insert new schedule to database /// </summary> /// <param name="schedule"></param> /// <returns></returns> public SQLResult AddNewSchedule(DTO_Schedule schedule) { 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 = "spLScheduleSave"; command.Parameters.AddWithValue("WorkType", "A"); command.Parameters.AddWithValue("@Id", ""); command.Parameters.AddWithValue("@Name", schedule.Name); command.Parameters.AddWithValue("@Description", schedule.Description); 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(); result.ExtraData = dt.Rows[0]["ExtraData"].ToString(); } catch (Exception ex) { result.Detail = ex.Message; } finally { _conn.Close(); } return(result); }
public bool Delete(DTO_Schedule _Cus) { Connet(); string sql = "delete from Schedule where ID=@ID"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Cus.ID; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public bool Insert(DTO_Schedule _Cus) { Connet(); string sql = "insert into Schedule ( ID, Date, Time, SMS_info, AccountID, Active) values (@ID, @Date, @Time, @SMS_info, @AccountID, @Active)"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Cus.ID; _cmd.Parameters.Add("@Date", SqlDbType.Date).Value = _Cus.Date; _cmd.Parameters.Add("@Time", SqlDbType.DateTime).Value = _Cus.Time; _cmd.Parameters.Add("@SMS_info", SqlDbType.VarChar).Value = _Cus.SMS_info; _cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _Cus.AccountID; int i = 0; if (_Cus.Active == true) { _cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = 1; } else { _cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = 0; } _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
private void Window_Loaded(object sender, RoutedEventArgs e) { bUS_Right = new BUS_Right(); listRightDetails = new List <ListDetailItem>(); listRightDetails.Clear(); if (mode == DOOR_MODE) { foreach (DTO_Door door in Repository.lstAllDoor) { ListDetailItem item = new ListDetailItem(); item.TextBinding = door.Name; item.Key = door.Id; DTO_Door d = right.Doors.FirstOrDefault(o => o.Id == door.Id); if (d == null) { item.IsChecked = false; } else { item.IsChecked = true; } listRightDetails.Add(item); } lbRightDetail.ItemsSource = listRightDetails; return; } if (mode == SCHEDULE_MODE) { foreach (DTO_Schedule schedule in Repository.lstAllSchedules) { ListDetailItem item = new ListDetailItem(); item.TextBinding = schedule.Name; item.Key = schedule.Id; DTO_Schedule d = right.Schedules.FirstOrDefault(o => o.Id == schedule.Id); if (d == null) { item.IsChecked = false; } else { item.IsChecked = true; } listRightDetails.Add(item); } lbRightDetail.ItemsSource = listRightDetails; return; } if (mode == PERSON_MODE) { foreach (DTO_CardHolder hodler in Repository.lstAllCardHolders) { ListDetailItem item = new ListDetailItem(); item.TextBinding = hodler.Name; item.Key = hodler.Id; DTO_CardHolder d = right.CardHolders.FirstOrDefault(o => o.Id == hodler.Id); if (d == null) { item.IsChecked = false; } else { item.IsChecked = true; } listRightDetails.Add(item); } lbRightDetail.ItemsSource = listRightDetails; return; } }
public bool Insert(DTO_Schedule _sch) { return(_schedule.Insert(_sch)); }
public bool Delete(DTO_Schedule _sch) { return(_schedule.Delete(_sch)); }
public bool Update(DTO_Schedule _sch) { return(_schedule.Update(_sch)); }
public wdScheduleDetail(EType.WindowMode mode, DTO_Schedule schedule) { InitializeComponent(); this.mode = mode; this.schedule = schedule; }
private void btSave_Click(object sender, RoutedEventArgs e) { if (mode == DOOR_MODE) { List <DTO_Door> oldDoors = right.Doors; foreach (DTO_Door door in oldDoors) { bUS_Right.DeleteDoorInRight(rightId, door.Id); } right.Doors.Clear(); List <DTO_Door> newDoors = new List <DTO_Door>(); foreach (ListDetailItem item in listRightDetails) { if (item.IsChecked) { DTO_Door door = Repository.lstAllDoor.FirstOrDefault(d => d.Id == item.Key); newDoors.Add(door); right.Doors.Add(door); } } foreach (DTO_Door door in newDoors) { bUS_Right.AddDoorToRight(rightId, door.Id); } Repository.lstAllRIght.FirstOrDefault(r => r.Id == rightId).Doors = right.Doors; this.DialogResult = true; this.Hide(); return; } if (mode == SCHEDULE_MODE) { List <DTO_Schedule> oldSchedules = right.Schedules; foreach (DTO_Schedule schedule in oldSchedules) { bUS_Right.DeleteScheduleInRight(rightId, schedule.Id); } right.Schedules.Clear(); List <DTO_Schedule> newSchedules = new List <DTO_Schedule>(); foreach (ListDetailItem item in listRightDetails) { if (item.IsChecked) { DTO_Schedule schedule = Repository.lstAllSchedules.FirstOrDefault(d => d.Id == item.Key); newSchedules.Add(schedule); } } right.Schedules = newSchedules; foreach (DTO_Schedule schedule in newSchedules) { bUS_Right.AddScheduleToRight(rightId, schedule.Id); } Repository.lstAllRIght.FirstOrDefault(r => r.Id == rightId).Schedules = right.Schedules; this.DialogResult = true; this.Hide(); return; } if (mode == PERSON_MODE) { List <DTO_CardHolder> oldPersons = right.CardHolders; foreach (DTO_CardHolder person in oldPersons) { bUS_Right.DeletePersonInRight(rightId, person.Id); } right.CardHolders.Clear(); List <DTO_CardHolder> newPersons = new List <DTO_CardHolder>(); foreach (ListDetailItem item in listRightDetails) { if (item.IsChecked) { DTO_CardHolder person = Repository.lstAllCardHolders.FirstOrDefault(d => d.Id == item.Key); newPersons.Add(person); right.CardHolders.Add(person); } } foreach (DTO_CardHolder person in newPersons) { bUS_Right.AddPersonToRight(rightId, person.Id); } Repository.lstAllRIght.FirstOrDefault(r => r.Id == rightId).CardHolders = right.CardHolders; this.DialogResult = true; this.Hide(); return; } }