public async Task <ResultPageDto <List <Department> > > DepLists(DepDto dto)
{
var resultPage = new ResultPageDto <List <Department> >();
resultPage.total = await db.Department.Where(o => o.Isdel != true).CountAsync();
if (resultPage.total == 0)
{
return(resultPage);
}
var dep = db.Department.Where(o => o.Isdel != true);
if (!string.IsNullOrEmpty(dto.DepName) && dto.DepName != "ascend" && dto.DepName != "descend")
{
dep = dep.Where(Company => Company.DepName.Contains(dto.DepName));
}
else if (dto.DepName == "ascend")
{
dep = dep.OrderBy(m => m.DepName);
}
else if (dto.DepName == "ascend")
{
dep = dep.OrderByDescending(m => m.DepName);
}
else
{
}
resultPage.list = await dep.Skip(dto.ps *(dto.pi - 1)).Take(dto.ps).ToListAsync();
return(resultPage);
}
public void sqlUpdateMethod(String strDepID, String strDepName, String method)
{
String sqlStr = "exec sp_KiemTraKhoa '" + txtDepID.Text + "', '" + method + "'";
Program.myReader = Program.ExecSqlDataReader(sqlStr);
if (Program.myReader == null)
{
return;
}
Program.myReader.Read();
currentBranchName = ((DataRowView)bdsDep[index])["TENKH"].ToString();
if (txtDepName.Text == currentBranchName)
{
MessageBox.Show("You must type different name!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
Program.myReader.Close();
return;
}
else
{
if (txtDepName.Text.Length == 0)
{
MessageBox.Show("Department Name can not empty!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
try
{
this.Validate();
bdsDep.EndEdit();
bdsDep.ResetCurrentItem();
this.kHOATableAdapter.Update(this.dataSetTracNghiem.KHOA);
if (isUndo == false)
{
DepDto dataUndo = new DepDto(dtoUndo.strDepID, dtoUndo.strDepName, method);
stUndo.Push(dataUndo);
updateUIUndo();
}
}
catch (Exception ex)
{
MessageBox.Show("Update subjects failed! \n" + ex.Message, "Error", MessageBoxButtons.OK);
Program.myReader.Close();
return;
}
}
}
Program.myReader.Close();
}
public void sqlNewMethod(String strDepID, String strDepName, String method)
{
String sqlStr = "exec sp_KiemTraKhoa '" + strDepID + "', '" + method + "'";
Program.myReader = Program.ExecSqlDataReader(sqlStr);
if (Program.myReader == null)
{
return;
}
Program.myReader.Read();
if (Program.myReader.FieldCount > 0)
{
MessageBox.Show("The " + strDepID + " has already exists!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
Program.myReader.Close();
return;
}
else
{
if (strDepID.Length == 0 || strDepName.Length == 0)
{
MessageBox.Show("Department ID or Department Name can not empty!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Program.myReader.Close();
return;
}
else
{
try
{
this.Validate();
bdsDep.EndEdit();
bdsDep.ResetCurrentItem();
this.kHOATableAdapter.Update(this.dataSetTracNghiem.KHOA);
if (isUndo == false)
{
DepDto dataUndo = new DepDto(strDepID, strDepName, method);
stUndo.Push(dataUndo);
updateUIUndo();
}
}
catch (Exception ex)
{
MessageBox.Show("Create department failed! \n" + ex.Message, "Error", MessageBoxButtons.OK);
Program.myReader.Close();
return;
}
}
}
Program.myReader.Close();
}
public void sqlDeleteMethod(String strDepID, String strDepName, String method)
{
String sqlStr = "exec sp_KiemTraKhoa '" + strDepID + "', '" + method + "'";
Program.myReader = Program.ExecSqlDataReader(sqlStr);
if (Program.myReader == null)
{
return;
}
Program.myReader.Read();
if (Program.myReader.FieldCount > 0)
{
MessageBox.Show("Can not delete " + strDepName + " branch. \nThe branch has data available! ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
Program.myReader.Close();
}
else
{
if (MessageBox.Show("Do you want to delete " + strDepName + " branch?", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
bdsDep.RemoveCurrent();
this.kHOATableAdapter.Update(this.dataSetTracNghiem.KHOA);
if (isUndo == false)
{
DepDto dataUndo = new DepDto(strDepID, strDepName, method);
stUndo.Push(dataUndo);
updateUIUndo();
}
}
catch (Exception ex)
{
MessageBox.Show("Failure. Please delete again!\n" + ex.Message, "",
MessageBoxButtons.OK);
Program.myReader.Close();
this.kHOATableAdapter.Fill(this.dataSetTracNghiem.KHOA);
bdsDep.Position = bdsDep.Find("MAKH", strDepID);
return;
}
}
}
Program.myReader.Close();
}
private void btnRedo_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
isRedo = isUndo = true;
DepDto dataRedo = (DepDto)stRedo.Pop();
if (dataRedo.method == Program.NEW_METHOD)
{
stUndo.Push(dataRedo);
bdsDep.AddNew();
txtBranchID.Text = depID;
txtDepName.Text = dataRedo.strDepName;
txtDepID.Text = dataRedo.strDepID;
sqlNewMethod(dataRedo.strDepID, dataRedo.strDepName, Program.NEW_METHOD);
}
else if (dataRedo.method == Program.UPDATE_METHOD)
{
int index = getIndexDBS(dataRedo.strDepID);
if (index >= 0)
{
DepDto dataUndo = new DepDto(txtDepID.Text, txtDepName.Text, method);
stUndo.Push(dataUndo);
bdsDep.Position = index;
txtDepName.Text = dataRedo.strDepName;
txtDepID.Text = dataRedo.strDepID;
sqlUpdateMethod(dataRedo.strDepID, dataRedo.strDepName, method);
}
}
else if (dataRedo.method == Program.DETELE_METHOD)
{
stUndo.Push(dataRedo);
int index = getIndexDBS(dataRedo.strDepID);
if (index >= 0)
{
bdsDep.Position = index;
sqlDeleteMethod(dataRedo.strDepID, dataRedo.strDepName, Program.DETELE_METHOD);
}
}
isRedo = isUndo = false;
updateUIUndo();
}
public async Task <ResponseDto> Deps(DepDto dto)
{
result.data = _mapper.Map <ResultPageDto <List <Department> >, ResultPageDto <List <DepDto> > >(await bll.DepLists(dto));
return(result);
}
