public static bool Insert(OffDayModel model)
{
var @Date = new SqlParameter("@Date", model.Date);
var @Remarks = new SqlParameter("@Remarks", model.Remarks);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertOffDay @Date, @Remarks", @Date, @Remarks) > 0)
{
return(true);
}
return(false);
}
private void bwInsert_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
btnInsert.IsEnabled = true;
this.Cursor = null;
OffDayModel offDay = offDayViewList.FirstOrDefault(f => f.Date.Date == offDayToInsert.Date.Date);
if (offDay == null)
{
offDayViewList.Add(offDayToInsert);
}
else
{
offDay.Remarks = offDayToInsert.Remarks;
}
dgOffDay.ScrollIntoView(offDayToInsert);
}
private void btnInsert_Click(object sender, RoutedEventArgs e)
{
DateTime date = dpDate.SelectedDate.Value.Date;
string remarks = txtRemarks.Text;
offDayToInsert = new OffDayModel
{
Date = date,
Remarks = remarks,
};
if (bwInsert.IsBusy == false)
{
this.Cursor = Cursors.Wait;
btnInsert.IsEnabled = false;
bwInsert.RunWorkerAsync();
}
}
public InsertOffDayWindow(AccountModel account)
{
this.account = account;
bwLoadData = new BackgroundWorker();
bwLoadData.WorkerSupportsCancellation = true;
bwLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork);
bwLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted);
bwInsert = new BackgroundWorker();
bwInsert.DoWork += new DoWorkEventHandler(bwInsert_DoWork);
bwInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwInsert_RunWorkerCompleted);
offDayList = new List <OffDayModel>();
offDayViewList = new ObservableCollection <OffDayModel>();
offDayToInsert = new OffDayModel();
offDayToDeleteList = new List <OffDayModel>();
bwDelete = new BackgroundWorker();
bwDelete.DoWork += new DoWorkEventHandler(bwDelete_DoWork);
bwDelete.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwDelete_RunWorkerCompleted);
InitializeComponent();
}
