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); }