private void buttonCancelSelect_Click(object sender, EventArgs e)
{
for (int i = 0; i < DeleteList.Items.Count; i++)
{
DeleteList.SetItemChecked(i, false);
}
}
private void buttonChooseAll_Click(object sender, EventArgs e)
{
for (int i = 0; i < DeleteList.Items.Count; i++)
{
DeleteList.SetItemChecked(i, true);
}
}
public int DeleteAccounts()
{
ClearDataGrid(Viewer.DataGridView_Delete);
int count = 0;
foreach (var resign in DeleteList)
{
if (Executioner.DeleteAccount(resign, out string erorr))
{
resign.Status = RecordStatus.Deleted;
Viewer.AddToDeleteGrid(resign, erorr, ActionOkColor);
if (!Adapter.UpdateRecord(resign, out var error))
{
throw new DbException(error);
}
count++;
}
else
{
resign.Status = RecordStatus.Erorr;
Viewer.AddToDeleteGrid(resign, erorr, ActionFailColor);
resign.AppendErrorMessage(erorr);
if (!Adapter.UpdateRecord(resign, out var error))
{
throw new DbException(error);
}
}
}
DeleteList.Clear();
return(count);
}
public virtual void Delete(IEnumerable <T> entities)
{
Infrastructure.Check.NotNull(entities, "entities");
foreach (var x1 in DeleteList)
{
DeleteList.Remove(x1);
}
}
protected override void BringOutYourDead()
{
if (DeleteList.Count > 0)
{
ActivatedList = (List <ScreenObject>)(ActivatedList.Except(DeleteList)).ToList();
DeleteList.Clear();
}
}
protected override void RemoveItem(int index)
{
if (this.RaiseListChangedEvents)
{
DeleteList.Add(this[index]);
this.AddedList.Remove(this[index]);
base.RemoveItem(index);
}
}
/// <summary>
/// 将封存的数据恢复到当前List，结束停止监控List的改变
/// <para>同时清空InsertList,UpdateList,DeleteList</para>
/// </summary>
public void RestoreList()
{
IsMonitChanges = false;
//保存当前数据至[初始数据列表]
CopyModelList <NotificationModel, NotificationModel>(_initialList, this);
InsertList.Clear();
UpdateList.Clear();
DeleteList.Clear();
}
/// <summary>
/// 结束监控List的改变，并将当前数据封存
/// <para>同时清空InsertList,UpdateList,DeleteList</para>
/// </summary>
public void EndMoinitChanges()
{
IsMonitChanges = false;
//保存当前数据至[初始数据列表]
CopyModelList <NotificationModel, NotificationModel>(this, _initialList);
InsertList.Clear();
UpdateList.Clear();
DeleteList.Clear();
}
public async Task <int> CommitAsync()
{
return(await Task.Factory.StartNew(() =>
{
ValidModel();
try
{
using (var trans = DbSession.Default.BeginTransaction())
//using(DbBatch batch = DbSession.Default.BeginBatchConnection(20))
{
if (InsertList != null && InsertList.Any())
{
// List<T> InsertNewList = InsertList.Distinct(new PropertyComparer<T>("Serialnum")).ToList();//按照特定规则排除重复项
trans.Insert(InsertList);
//batch.Insert(InsertNewList.ToArray());
}
if (DeleteList != null && DeleteList.Any())
{
trans.Delete(DeleteList);
}
//DeleteList.ForEach(delete =>
//{
// batch.Delete(delete);
//});
if (UpdateList != null && UpdateList.Any())
{
//List<T> UpdateNewList = UpdateList.Distinct(new PropertyComparer<T>("Serialnum")).ToList();//按照特定规则排除重复项
int i = trans.UpdateAll <T>(UpdateList);
//batch.UpdateAll(UpdateNewList.ToArray());
}
trans.Commit();
//trans.Commit();
if (InsertList != null && InsertList.Any())
{
InsertList.Clear();
}
if (DeleteList != null && DeleteList.Any())
{
DeleteList.Clear();
}
if (UpdateList != null && UpdateList.Any())
{
UpdateList.Clear();
}
return 1;
}
}
catch (Exception ex)
{
return 0;
//throw;
}
}));
}
public int DisplayTodayDeletes()
{
ClearDataGrid(Viewer.DataGridView_Delete);
DeleteList = Logic.GetTodayDeletes().ToList();
foreach (var delete in DeleteList)
{
Viewer.AddToDeleteGrid(delete);
}
return(DeleteList.Count());
}
/// <summary>
/// 删除用法
/// </summary>
/// <param name="sender">控件</param>
/// <param name="e">参数</param>
private void dgChannel_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgChannel.Columns.IndexOf(dgChannel.Columns["btnDelete"]) == e.ColumnIndex)
{
DataTable dt = dgChannel.DataSource as DataTable;
DeleteList.Add(ConvertExtend.ToObject <Basic_ExecuteBillChannel>(dt, e.RowIndex));
dt.Rows.RemoveAt(e.RowIndex);
dt.AcceptChanges();
}
}
/// <summary>
/// Default constructor
/// </summary>
public GoToAction()
{
var x = new NamedParameter("param1");
var y = new NamedParameter("param2");
var x2 = new NamedParameter("param3");
var y2 = new NamedParameter("param4");
Preconditions.Add(new Fact(Definitions.In, x, y));
AddList.Add(new Fact(Definitions.In, x2, y2));
DeleteList.Add(new Fact(Definitions.In, x, y));
}
/// <summary>
/// Default constructor
/// </summary>
public SellGoldAction()
{
var x = new NamedParameter("param1");
var y = new NamedParameter("param2");
Preconditions.Add(new Fact(Definitions.HasGold, new ValueParameter(true)));
Preconditions.Add(new Fact(Definitions.Town, x, y));
Preconditions.Add(new Fact(Definitions.In, x, y));
AddList.Add(new Fact(Definitions.HasGold, new ValueParameter(false)));
DeleteList.Add(new Fact(Definitions.HasGold, new ValueParameter(true)));
}
public async Task <int> CommitAsync()
{
ValidModel();
using (var scope = AhnqIotContainer.Container.BeginLifetimeScope())
{
var context = scope.Resolve <IDbContext>(new NamedParameter("connectionString", Connectstring));
var loggerFactory = ((DbContext)context).GetService <ILoggerFactory>();
loggerFactory.AddProvider(new DbLoggerProvider(Console.WriteLine));
var dbset = context.Set <T>();
if (InsertList != null && InsertList.Any())
{
List <T> InsertNewList = InsertList.Distinct(new PropertyComparer <T>("Serialnum")).ToList();//按照特定规则排除重复项
dbset.AddRange(InsertNewList);
}
if (DeleteList != null && DeleteList.Any())
{
dbset.RemoveRange(DeleteList);
}
//try
//{
if (UpdateList != null && UpdateList.Any())
{
List <T> UpdateNewList = UpdateList.Distinct(new PropertyComparer <T>("Serialnum")).ToList();//按照特定规则排除重复项
dbset.UpdateRange(UpdateNewList);
}
var result = await context.SaveChangesAsync();
//return result;
//}
//catch (Exception ex)
//{
// Console.Clear();
// Console.WriteLine(ex.ToString());
// throw;
//}
if (InsertList != null && InsertList.Any())
{
InsertList.Clear();
}
if (DeleteList != null && DeleteList.Any())
{
DeleteList.Clear();
}
if (UpdateList != null && UpdateList.Any())
{
UpdateList.Clear();
}
return(result);
}
}
/// <summary>
/// Default constructor that initializes preconditions, add/delete list and constraints
/// </summary>
/// <param name="table">The table of our problem</param>
public PutDownAction(Table table)
{
_table = table;
var block = new NamedParameter("param1");
var goal1 = new Fact(Definitions.ArmHolds, block);
Preconditions.Add(goal1);
AddList.Add(new Fact(Definitions.ArmHolds, new ValueParameter(null)));
AddList.Add(new Fact(Definitions.On, block, new ValueParameter(table)));
AddList.Add(new Fact(Definitions.Clear, block));
DeleteList.Add(goal1);
Constraints.Add(TypeCheck(typeof(Block), block));
}
private void RemoveIteminDb()
{
for (int i = 0; i < DeleteList.Count(); i++)
{
foreach (var item in Model.DataProvider.Ins.DB.TAIKHOANs)
{
while (item == DeleteList[i])
{
Model.DataProvider.Ins.DB.TAIKHOANs.Remove(item);
break;
}
}
}
Model.DataProvider.Ins.DB.SaveChanges();
}
private void Capnhat_dboTaiKhoan()
{
for (int i = 0; i < DeleteList.Count(); i++)
{
foreach (var item in Model.DataProvider.Ins.DB.TAIKHOANs.ToList())
{
while (item.NHANVIEN == DeleteList[i])
{
item.IsDeleted = true;
Model.DataProvider.Ins.DB.SaveChanges();
break;
}
}
}
}
private void RemoveIteminDb()
{
for (int i = 0; i < DeleteList.Count(); i++)
{
foreach (var item in Model.DataProvider.Ins.DB.KHACHHANGs.ToList())
{
while (item == DeleteList[i])
{
item.IsDeleted = true;
Model.DataProvider.Ins.DB.SaveChanges();
break;
}
}
}
}
public async Task Run_ReturnsNoContentOnSuccess()
{
var handler = new Mock <ICommandHander <DeleteListCommand> >();
var container = new Container();
var id = Guid.NewGuid().ToString();
var request = new DefaultHttpRequest(new DefaultHttpContext());
handler.Setup(h => h.Execute(It.IsAny <DeleteListCommand>())).Returns(Task.CompletedTask);
container.RegisterInstance(handler.Object);
container.RegisterInstance(_telemetryClient);
DeleteList.Container = container;
var result = await DeleteList.Run(request, id) as NoContentResult;
Assert.IsNotNull(result);
}
/// <summary>
/// List删除后的处理
/// </summary>
/// <param name="e"></param>
private void ItemDeleted(ListChangedEventArgs e)
{
if (InsertList.Contains(_deletedItem))
{
InsertList.Remove(_deletedItem);
return;
}
if (UpdateList.Contains(_deletedItem))
{
UpdateList.Remove(_deletedItem);
}
if (!DeleteList.Contains(_deletedItem))
{
DeleteList.Add(_deletedItem);
}
}
/// <summary>
/// List内对象属性值变化后的处理
/// </summary>
/// <param name="e"></param>
private void ItemChanged(ListChangedEventArgs e)
{
if ("IsChecked".Equals(e.PropertyDescriptor.Name))
{
return;
}
//***************************
//是否要过滤TBModel以外的属性
//***************************
if (!InsertList.Contains(this[e.NewIndex]) && !DeleteList.Contains(this[e.NewIndex]) &&
!UpdateList.Contains(this[e.NewIndex]))
{
UpdateList.Add(this[e.NewIndex]);
}
}
public async Task Run_ReturnsServerErrorOnServerError()
{
var handler = new Mock <ICommandHander <DeleteListCommand> >();
var container = new Container();
var id = Guid.NewGuid().ToString();
var request = new DefaultHttpRequest(new DefaultHttpContext());
handler.Setup(h => h.Execute(It.IsAny <DeleteListCommand>()))
.ThrowsAsync(new Exception());
container.RegisterInstance(handler.Object);
container.RegisterInstance(_telemetryClient);
DeleteList.Container = container;
var result = await DeleteList.Run(request, id) as InternalServerErrorResult;
Assert.IsNotNull(result);
}
public int Commit()
{
ValidModel();
try
{
using (var trans = DbSession.Default.BeginTransaction())
{
if (InsertList != null && InsertList.Any())
{
//List<T> InsertNewList = InsertList.Distinct(new PropertyComparer<T>("Serialnum")).ToList();//按照特定规则排除重复项
trans.Insert(InsertList);
}
if (DeleteList != null && DeleteList.Any())
{
trans.Delete(DeleteList);
}
if (UpdateList != null && UpdateList.Any())
{
// List<T> UpdateNewList = UpdateList.Distinct(new PropertyComparer<T>("Serialnum")).ToList();//按照特定规则排除重复项
trans.Update(UpdateList);
}
trans.Commit();
if (InsertList != null && InsertList.Any())
{
InsertList.Clear();
}
if (DeleteList != null && DeleteList.Any())
{
DeleteList.Clear();
}
if (UpdateList != null && UpdateList.Any())
{
UpdateList.Clear();
}
return(1);
}
}
catch (Exception ex)
{
return(0);
//throw;
}
}
public StackAction()
{
var param1 = new STRIPS.NamedParameter("param1");
var param2 = new STRIPS.NamedParameter("param2");
var goal1 = new STRIPS.Fact(Definitions.ArmHolds, param1);
var goal2 = new STRIPS.Fact(Definitions.Clear, param2);
Preconditions.Add(goal1);
Preconditions.Add(goal2);
AddList.Add(new STRIPS.Fact(Definitions.ArmHolds, new STRIPS.ValueParameter(null)));
AddList.Add(new STRIPS.Fact(Definitions.On, param1, param2));
AddList.Add(new STRIPS.Fact(Definitions.Clear, param1));
DeleteList.Add(goal1);
DeleteList.Add(goal2);
Constraints.Add(TypeCheck(typeof(Block), param1));
Constraints.Add(TypeCheck(typeof(Block), param2));
Constraints.Add(NotEqualsCheck(param1, param2));
}
private void RemoveIteminList()
{
for (int i = 0; i < List.Count(); i++)
{
while (DeleteList.Where(x => x == List[i]).Count() != 0)
{
if (List[i] == List[List.Count() - 1])
{
List.Remove(List[i]);
break;
}
else
{
List.Remove(List[i]);
}
}
;
}
}
public async Task <IActionResult> DeleteList(Guid listId)
{
var userEmail = User.FindFirst(c => c.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/emailaddress").Value;
var deleteTodoModel = new DeleteList();
deleteTodoModel.Email = User.FindFirst(c => c.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/emailaddress").Value;
deleteTodoModel.AccountId = User.ReadClaimAsGuidValue("urn:codefliptodo:accountid");
deleteTodoModel.ListId = listId;
var list = await _dapperQuery.GetListAsync(listId);
var todoListAuthorizationValidator = new TodoListAuthorizationValidator(list.Contributors, userEmail);
if (todoListAuthorizationValidator.IsUserAuthorized())
{
await _mediator.Send(deleteTodoModel);
return(Ok());
}
return(Forbid());
}
public async Task <IActionResult> AddToList([Bind("DListId,ArticleId,AuthorId,AuthorName,Reason,DateOfRequest")] DeleteList deleteList, int id, IFormCollection formFields)
{
//find the article by id
var article = await _context.Articles
.FirstOrDefaultAsync(m => m.ArticleId == id);
if (article == null)
{
return(NotFound());
}
//grab the delete list from db where Author.Id == Author.Id
var x = await _context.DeleteLists.FirstOrDefaultAsync(m => m.AuthorId == article.AuthorId);
//inserting values into the deletelist
if (x == null)
{
deleteList.AuthorId = article.AuthorId;
deleteList.ArticleId = article.ArticleId;
deleteList.AuthorName = article.AuthorName;
deleteList.DateOfRequest = $"{DateTime.Now.ToString("ssddmmyyyy")}";
deleteList.Reason = formFields["reason"];
//updating
_context.Update(deleteList);
await _context.SaveChangesAsync();
return(LocalRedirect("/"));
}
else
{
return(View("../Article/RequestDenied"));
}
}
//delete selected photos buttun
private void button1_Click(object sender, EventArgs e)
{
const string message = "you are going to delete all the selected photos,\n it means you will lose that picture completely. \n\nARE YOU SURE THAT YOU WANT TO DO THESE?";
const string caption = "Delete Files";
var result = MessageBox.Show(message, caption,
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
// If the no button was pressed ...
if (result == DialogResult.No)
{
return;
}
//dispose all memmory in use
PictureResult.Image = null;
pictureBox.Image = null;
PicLastRes.Image = null;
image.Dispose();
//send to delete function if checked
for (int i = 0; i < DeleteList.Items.Count; i++)
{
if (DeleteList.GetItemChecked(i))
{
TryToDelete(DeleteList.Items[i].ToString());
itemsToDelete[i] = null;
}
}
DeleteList.Items.Clear();
for (int i = 0; i < itemsToDelete.Count; i++)
{
if (itemsToDelete[i] != null)
{
DeleteList.Items.Add(itemsToDelete[i].ToString());
}
}
}
public Khachhang_ViewModel()
{
List = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false));
DeleteList = new ObservableCollection <Model.KHACHHANG>();
Active = false;
IsOpen = false;
Active_Command = new RelayCommand <object>(p =>
{
if (Active == false)
{
return(false);
}
return(true);
}, p =>
{
Active = false;
});
CloseDialog_Command = new RelayCommand <object>(p =>
{
return(true);
}, p =>
{
IsOpen = false;
});
Load_Command = new RelayCommand <object>(p =>
{
return(true);
}, p =>
{
List = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false));
DeleteList = new ObservableCollection <Model.KHACHHANG>();
Active = false;
IsOpen = false;
});
#region Phan them
Insert_Command = new RelayCommand <object>(p =>
{
if (string.IsNullOrEmpty(Tenkhachhang) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi))
{
return(false);
}
long i = 0;
if (!long.TryParse(Sodienthoai, out i))
{
return(false);
}
var check = Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.ten_khachhang == Tenkhachhang);
if (check == null || check.Count() != 0)
{
return(false);
}
return(true);
}, p =>
{
SelectedItem = null;
Model.KHACHHANG newItem = new Model.KHACHHANG()
{
ma_khachhang = Guid.NewGuid().ToString(),
ten_khachhang = Tenkhachhang,
diachi = Diachi,
sodienthoai = Sodienthoai,
IsDeleted = false
};
Model.Khachhang_Service.Insert(newItem);
List.Insert(0, newItem);
SelectedItem = newItem;
Active = true;
Message = "Thêm mới thành công !!!";
});
#endregion
#region Phan sua
Update_Command = new RelayCommand <object>(p =>
{
if (SelectedItem == null)
{
return(false);
}
long i = 0;
if (!long.TryParse(Sodienthoai, out i))
{
return(false);
}
if (string.IsNullOrEmpty(Tenkhachhang) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi))
{
return(false);
}
var check = Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.ten_khachhang == Tenkhachhang && x.diachi == Diachi && x.sodienthoai == Sodienthoai);
if (check == null || check.Count() != 0)
{
return(false);
}
return(true);
}, p =>
{
Model.KHACHHANG UpdateItem = new Model.KHACHHANG()
{
ten_khachhang = Tenkhachhang,
sodienthoai = Sodienthoai,
diachi = Diachi
};
Model.Khachhang_Service.Update(UpdateItem, Makhachhang);
for (int i = 0; i < List.Count(); i++)
{
if (List[i] == SelectedItem)
{
List[i] = new Model.KHACHHANG()
{
ma_khachhang = Makhachhang,
ten_khachhang = Tenkhachhang,
diachi = Diachi,
sodienthoai = Sodienthoai
};
break;
}
}
//MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO");
SelectedItem = null;
Tenkhachhang = "";
Sodienthoai = "";
Diachi = "";
Active = true;
Message = "Chỉnh sửa thành công !!!";
});
#endregion
#region Phan xoa
DeleteShow_Command = new RelayCommand <object>(p =>
{
if (DeleteList.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
IsOpen = true;
Content = " Xóa các bản ghi được chọn ???";
});
AddDeleteList_Command = new RelayCommand <CheckBox>(p =>
{
return(true);
}, p =>
{
DeleteList.Add(List.Where(x => x.ma_khachhang == p.Uid.ToString()).SingleOrDefault());
});
RemoveDeleteList_Command = new RelayCommand <CheckBox>(p =>
{
return(true);
}, p =>
{
DeleteList.Remove(List.Where(x => x.ma_khachhang == p.Uid.ToString()).SingleOrDefault());
});
Delete_Command = new RelayCommand <object>(p =>
{
if (DeleteList.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
RemoveIteminDb();
RemoveIteminList();
DeleteList = new ObservableCollection <Model.KHACHHANG>();
IsOpen = false;
SelectedItem = null;
});
#endregion
#region Tao moi
Reset_Command = new RelayCommand <object>(p =>
{
return(true);
}, p =>
{
SelectedItem = null;
Tenkhachhang = "";
Diachi = "";
Sodienthoai = "";
});
#endregion
#region Phan sap xep
Sort_Command = new RelayCommand <object>(p =>
{
if (List.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
ObservableCollection <Model.KHACHHANG> chkList = new ObservableCollection <Model.KHACHHANG>(List.OrderByDescending(x => x.ten_khachhang));
if (List[0] == chkList[0])
{
List = new ObservableCollection <Model.KHACHHANG>(List.OrderBy(x => x.ten_khachhang));
}
else
{
List = new ObservableCollection <Model.KHACHHANG>(chkList);
}
});
SortbyDiachi_Command = new RelayCommand <object>(p =>
{
if (List.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
ObservableCollection <Model.KHACHHANG> chkList = new ObservableCollection <Model.KHACHHANG>(List.OrderByDescending(x => x.diachi));
if (List[0] == chkList[0])
{
List = new ObservableCollection <Model.KHACHHANG>(List.OrderBy(x => x.diachi));
}
else
{
List = new ObservableCollection <Model.KHACHHANG>(chkList);
}
});
#endregion
}
public IActionResult DeleteView()
{
DeleteList deleteList = repository.CreateDeleteList();
return(View("DeleteView", deleteList));
}
