public override void Delete(object sender, EventArgs e)
{
if (dgvCompany.SelectedRows.Count < 1)
{
frm.NoticeMessage = Resources.DelEmpty;
}
else
{
if (MessageBox.Show("삭제하시겠습니까?", "확인", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
StandardService service = new StandardService();
service.DeleteCompany(item.Company_ID);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
frm.NoticeMessage = Resources.DeleteDone;
dgvCompany.DataSource = null;
LoadGridView();
}
}
}
private void InsertFactory()
{
if (cboFactoryDivision.SelectedIndex != 0)
{
FactoryVO item = new FactoryVO
{
Factory_Name = txtFactoryName.Text,
Factory_Division = Convert.ToInt32(cboFactoryDivision.SelectedValue),
Factory_Number = maskedFactoryNumber.Text,
Factory_Fax = maskedFactoryFaxNumber.Text,
Factory_Address = addrFactory.Address1 + " " + addrFactory.Address2,
Factory_AddrNumber = addrFactory.Zipcode
};
if (item.Factory_Fax.Replace("-", "").Trim().Length < 10)
{
item.Factory_Fax = null;
}
try
{
StandardService service = new StandardService();
service.InsertFactory(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
}
public override void Delete(object sender, EventArgs e)
{
if (dgvEmployee.SelectedRows.Count < 1)
{
frm.NoticeMessage = Resources.DelEmpty;
}
if (rdoResign.Checked && dgvEmployee.SelectedRows.Count > 0)
{
frm.NoticeMessage = Properties.Resources.DelResigndateError;
}
if (rdoWork.Checked && dgvEmployee.SelectedRows.Count > 0)
{
if (MessageBox.Show("삭제하시겠습니까?", "확인", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
StandardService service = new StandardService();
service.DeleteEmployee(item.Employees_ID);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
frm.NoticeMessage = Resources.DeleteDone;
dgvEmployee.DataSource = null;
LoadGridView();
}
}
}
private void InsertCompany()
{
CompanyVO item = new CompanyVO
{
Company_Name = txtCompanyName.Text,
Company_Number = maskedCompanyNumber.Text,
Company_Fax = maskedCompanyFaxNumber.Text,
CodeTable_CodeID = cboCompanyDivision.SelectedValue.ToString(),
Company_Owner = txtCompanyOwner.Text,
Company_Address = addrCompany.Address1 + " " + addrCompany.Address2,
Company_AddrNumber = addrCompany.Zipcode
};
if (item.Company_Fax.Replace("-", "").Trim().Length < 10)
{
item.Company_Fax = null;
}
try
{
StandardService service = new StandardService();
service.InsertCompany(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
public async Task GetStandard_Returns_Valid_Standard()
{
var standardCode = "547";
var standardName = "Broadcast and Media Systems Technician";
var standardSectorCode = "11";
var apiStandard = new Models.StandardModel
{
StandardCode = standardCode,
StandardName = standardName,
StandardSectorCode = standardSectorCode
};
_azureServiceMock
.Setup(m => m.GetStandard(standardCode))
.ReturnsAsync(apiStandard);
var service = new StandardService(_azureServiceMock.Object, _searchCleaningServiceMock.Object);
var result = await service.GetStandard(standardCode);
_azureServiceMock.Verify(m => m.GetStandard(standardCode), Times.Once);
result.StandardCode.Should().Be(standardCode);
result.StandardName.Should().Be(standardName);
result.StandardSectorCode.Should().Be(standardSectorCode);
}
public void Setup()
{
_mockLogger = new Mock <ILogger <StandardService> >();
_mockStandardRepository = new Mock <IStandardRepository>();
_standardService = new StandardService(new CacheService(Mock.Of <IDistributedCache>()),
_mockLogger.Object,
_mockStandardRepository.Object);
}
private void LoadData()
{
try
{
StandardService service = new StandardService();
list = service.GetAllResource();
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
//부서목록을 콤보바인딩
private void InitCombo()
{
try
{
StandardService service = new StandardService();
List <ComboItemVO> employeeList = service.GetComboEmployee();
UtilClass.ComboBinding(cboEmployeesCategory, employeeList, "선택");
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
// DataGridView 가져오기
private void LoadGridView()
{
try
{
StandardService service = new StandardService();
list = service.GetAllWarehouse();
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
dgvWarehouse.DataSource = list;
dgvWarehouse.CurrentCell = null;
}
public static void Revoke()
{
CS505Project1.Services.StandardService dbServices = new StandardService();
//Mom tries to give <dad, purchases, select, without>
GrantAction grant = new GrantAction();
grant.grantor_name = "mom";
grant.grantee_name = "PhilCollins";
grant.table_name = "clients";
grant.operation = Operation_Type.SELECT;
grant.grant = false;
dbServices.Revoke(grant);
}
// DataGridView 가져오기
private void LoadGridView()
{
try
{
StandardService service = new StandardService();
FList = service.GetAllFactory();
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
dgvFactory.DataSource = FList;
dgvFactory.CurrentCell = null;
dgvLine.DataSource = null;
}
//공정이 속할 공장목록과 공정이 없는 반제품 카테고리 목록을 가져와서 콤보바인딩한다.
private void InitCombo()
{
try
{
StandardService service = new StandardService();
List <ComboItemVO> factoryList = service.GetComboFactory();
UtilClass.ComboBinding(cboFactoryName, factoryList, "선택");
List <ComboItemVO> categoryList = service.GetComboCategory();
UtilClass.ComboBinding(cboCategory, categoryList, "선택");
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
public async Task GetStandards_EncodesSearchTerm()
{
// Arrange
var searchTerm = "test/test";
var searchModel = new StandardSearchModel()
{
SearchTerm = searchTerm
};
var service = new StandardService(_azureServiceMock.Object, _searchCleaningServiceMock.Object);
// Act
var result = await service.GetStandards(searchModel);
// Assert
_searchCleaningServiceMock.Verify(m => m.EscapeSearchSpecialCharacters(searchTerm), Times.Once);
}
//업종목록을 콤보바인딩 한다.
private void InitCombo()
{
try
{
StandardService service = new StandardService();
List <ComboItemVO> companyList = service.GetComboSector();
UtilClass.ComboBinding(cboCompanyDivision, companyList, "선택");
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
if (mode.Equals("Update"))
{
cboCompanyDivision.SelectedValue = division;
}
}
private void InsertLine()
{
LineVO item = new LineVO
{
Line_Name = txtLineName.Text,
Factory_ID = Convert.ToInt32(cboFactoryName.SelectedValue),
Line_CodeID = cboCategory.SelectedValue.ToString()
};
try
{
StandardService service = new StandardService();
service.InsertLine(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
public void And_epao_not_approved_to_assess_any_standard_version_then_result_is_not_returned()
{
StandardService.Setup(s => s.GetEPAORegisteredStandardVersions(It.IsAny <string>(), null))
.ReturnsAsync(new List <OrganisationStandardVersion> {
new OrganisationStandardVersion {
Title = "Standard 13", Version = "1.0", LarsCode = 13
}
});
var result =
SearchHandler.Handle(
new SearchQuery()
{
Surname = "Lamora", EpaOrgId = "12345", Uln = 1111111111, Username = "******"
},
new CancellationToken()).Result;
result.Count.Should().Be(0);
}
private void InsertEmployee()
{
EmployeeVO item = new EmployeeVO
{
Employees_Name = txtEmployeesName.Text,
CodeTable_CodeID = cboEmployeesCategory.SelectedValue.ToString(),
Employees_Hiredate = dtpEmployeesHireDate.Value.ToShortDateString(),
Employees_PWD = txtEmployeesPassword.Text,
Employees_Phone = maskedEmployeesPhoneNumber.Text,
Employees_Birth = dtpEmployeesBirthDay.Value.ToShortDateString()
};
try
{
StandardService service = new StandardService();
service.InsertEmployee(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
private void dgvFactory_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvFactory.Rows.Count > 0)
{
searchLineName.Visible = true;
}
if (e.RowIndex < dgvFactory.Rows.Count && e.RowIndex > -1)
{
try
{
StandardService service = new StandardService();
LList = service.GetAllLine(Convert.ToInt32(dgvFactory.Rows[e.RowIndex].Cells[0].Value));
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
dgvLine.DataSource = LList;
dgvLine.CurrentCell = null;
}
}
// DataGridView 가져오기
private void LoadGridView()
{
try
{
StandardService service = new StandardService();
list = service.GetAllEmployee();
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
if (!rdoWork.Checked)
{
rdoList = (from item in list where item.Employees_DeletedYN == true select item).ToList();
}
else
{
rdoList = (from item in list where item.Employees_DeletedYN == false select item).ToList();
}
dgvEmployee.DataSource = rdoList;
dgvEmployee.CurrentCell = null;
}
private void InsertResource()
{
ResourceVO item = new ResourceVO
{
Product_Name = txtResourceName.Text,
Warehouse_ID = Convert.ToInt32(cboResourceWarehouse.SelectedValue),
Product_Price = Convert.ToInt32(txtResourceMoney.Text),
Product_Qty = Convert.ToInt32(numResourceNum.Value),
Product_Safety = Convert.ToInt32(numSafety.Value),
Product_Category = cboResourceCategory.SelectedValue.ToString(),
Company_ID = Convert.ToInt32(cboCompany.SelectedValue)
};
try
{
StandardService service = new StandardService();
service.InsertResource(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
private void UpdateWarehouse()
{
if (cboWarehouseDivision.SelectedIndex != 0)
{
WarehouseVO item = new WarehouseVO
{
Warehouse_ID = code,
Warehouse_Division = Convert.ToInt32(cboWarehouseDivision.SelectedValue),
Warehouse_Name = txtWarehouseName.Text,
Warehouse_Number = maskedWarehouseNumber.Text,
Warehouse_Fax = maskedWarehouseNumber.Text,
Warehouse_Address = addrWarehouse.Address1 + " " + addrWarehouse.Address2,
Warehouse_AddrNumber = addrWarehouse.Zipcode
};
//MaskTextBox는 값이 없을 때 공백과 -만 남으므로 item 값을 null로 준다.
if (item.Warehouse_Number.Replace("-", "").Trim().Length < 10)
{
item.Warehouse_Number = null;
}
if (item.Warehouse_Fax.Replace("-", "").Trim().Length < 10)
{
item.Warehouse_Fax = null;
}
try
{
StandardService service = new StandardService();
service.UpdateWarehouse(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
}
//원자재가 보관될 창고목록과 원자재가 속하는 카테고리 목록과 어느 거래처와 거래하는지 설정하기 위해 거래처 목록을 콤보바인딩
private void InitCombo()
{
try
{
StandardService service = new StandardService();
List <ComboItemVO> warehouseList = service.GetComboWarehouse(0);
UtilClass.ComboBinding(cboResourceWarehouse, warehouseList, "선택");
List <ComboItemVO> meterialList = (from item in service.GetComboMeterial() where item.ID.Contains("M") select item).ToList();
UtilClass.ComboBinding(cboResourceCategory, meterialList, "선택");
List <ComboItemVO> companyList = service.GetComboCompany();
UtilClass.ComboBinding(cboCompany, companyList, "선택");
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
if (mode.Equals("Update"))
{
cboResourceCategory.SelectedValue = category;
cboCompany.SelectedValue = cID.ToString("0000");
cboResourceWarehouse.SelectedValue = wID.ToString("0000");
}
}
public void Arrange()
{
Setup();
var certificateId = Guid.NewGuid();
var searchingEpaoOrgId = Guid.NewGuid();
CertificateRepository.Setup(r => r.GetDraftAndCompletedCertificatesFor(It.IsAny <long>()))
.ReturnsAsync(new List <Certificate>());
StandardService.Setup(s => s.GetAllStandardOptions()).ReturnsAsync(
new List <StandardOptions> {
new StandardOptions
{
StandardUId = "ST013_1.0",
StandardCode = 13,
Version = "1.0",
StandardReference = "ST013",
CourseOption = new List <string>
{
"MyOption",
"MyOption1",
"MyOption2"
}
},
new StandardOptions {
StandardUId = "ST012_1.0",
StandardCode = 12,
Version = "1.0",
StandardReference = "ST012",
CourseOption = new List <string>
{
"MyOption",
"MyOption1",
"MyOption2"
}
}
});
LearnerRepository.Setup(r => r.SearchForLearnerByUln(1111111111))
.ReturnsAsync(new List <Domain.Entities.Learner> {
new Domain.Entities.Learner()
{
StdCode = 13,
FamilyName = "Lamora",
Version = "1.0",
CourseOption = "MyOption",
VersionConfirmed = true,
StandardUId = "ST013_1.0"
}
});
LearnerRepository.Setup(r => r.SearchForLearnerByUln(2222222222))
.ReturnsAsync(new List <Domain.Entities.Learner> {
new Domain.Entities.Learner()
{
StdCode = 12,
FamilyName = "Gamora",
Version = "1.0",
CourseOption = "",
VersionConfirmed = true,
StandardUId = "ST012_1.0"
}
});
}
public StandardController(StandardService standardService)
{
this.standardService = standardService;
_indexService = GetService <IIndexerService>();
}
