public void Update(CompanyT entity)
{
Connection.Execute(
@"UPDATE CompanyT SET
CompanyName = @CompanyName,
CompanyCode = @CompanyCode,
TaxID = @TaxID,
Phone = @Phone,
Address = @Address,
WebsiteURL = @WebsiteURL,
Owner = @Owner,
EditedDate = GETUTCDATE()
WHERE CompanyID = @CompanyID",
param: new
{
CompanyID = entity.CompanyID,
CompanyName = entity.CompanyName,
CompanyCode = entity.CompanyCode,
TaxID = entity.TaxID,
Phone = entity.Phone,
Address = entity.Address,
WebsiteURL = entity.WebsiteURL,
Owner = entity.Owner,
}, transaction: Transaction);
}
public void Add(CompanyT entity)
{
Connection.Execute(@"INSERT INTO CompanyT(
CompanyName,
CompanyCode,
TaxID,
Phone,
Address,
WebsiteURL,
Owner)
VALUES(
@CompanyName,
@CompanyCode,
@TaxID,
@Phone,
@Address,
@WebsiteURL,
@Owner
)",
param: new
{
CompanyName = entity.CompanyName,
CompanyCode = entity.CompanyCode,
TaxID = entity.TaxID,
Phone = entity.Phone,
Address = entity.Address,
WebsiteURL = entity.WebsiteURL,
Owner = entity.Owner
}, transaction: Transaction);
}
public Jsend <CompanyT> FindCompanyByID(int id)
{
CompanyT result = null;
try
{
result = _uow.CompanyTRepository.FindByID(id);
_uow.Commit();
}
catch (SqlException ex)
{
_logger.Error(ex);
return(JsendResult <CompanyT> .Error("Queay data occured error"));
}
return(JsendResult <CompanyT> .Success(result));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (lv == 0)
{
MessageBox.Show("사용자 정보를 입력하세요");
}
else
{
Company company = new Company();
company = (Company)lvControl.Items[lvControl.SelectedIndex];
CompanyT companyT = new CompanyT();
companyT.Insert_company_information(company.Id, 0);
Calculate_Rate calculate_Rate = new Calculate_Rate(lv, company.Id);
MessageBox.Show(calculate_Rate.Result());
//Show_Company show_Company = new Show_Company(lv, company.Id);
//show_Company.Show();
}
}
public Jsend <CompanyT> FindComapnyByTaxID(string id)
{
if (string.IsNullOrWhiteSpace(id))
{
return(JsendResult <CompanyT> .Error("name can't be null"));
}
CompanyT result = null;
try
{
result = _uow.CompanyTRepository.FindByTaxID(id);
_uow.Commit();
}
catch (SqlException ex)
{
_logger.Error(ex);
return(JsendResult <CompanyT> .Error("Queay data occured error"));
}
return(JsendResult <CompanyT> .Success(result));
}
public void Delete(CompanyT entity)
{
Delete(entity.CompanyID);
}
