コード例 #1
0
        private bool updateBuildingContractor()
        {
            DTO.ST_building_contractor newBuildingContractor = new DTO.ST_building_contractor();
            newBuildingContractor.building_contractor_id                  = buildingContractorId;
            newBuildingContractor.building_contractor_name                = txt_BuildingContractorName.Text;
            newBuildingContractor.building_contractor_address             = txt_Address.Text;
            newBuildingContractor.building_contractor_phone               = txt_PhoneNumber.Text;
            newBuildingContractor.building_contractor_email               = txt_Email.Text;
            newBuildingContractor.building_contractor_bank_account_number = txt_BankAccountNumber.Text;
            newBuildingContractor.building_contractor_tax_code            = txt_Fax.Text;
            newBuildingContractor.building_contractor_description         = txt_Description.Text;
            if (txt_Liabilities.Text != "")
            {
                newBuildingContractor.building_contractor_liabilities = Convert.ToDecimal(txt_Liabilities.Text);
            }
            if (date_BirthDay.Text != "")
            {
                DateTime date = Convert.ToDateTime(date_BirthDay.Text);
                date.ToString("yyyy/MM/dd");
                newBuildingContractor.building_contractor_date_of_birth = date;
            }

            if (pic_Logo.Image != null)
            {
                byte[] fileByte = converImageToBirany(pic_Logo.Image);
                System.Data.Linq.Binary fileBinary = new System.Data.Linq.Binary(fileByte);
                newBuildingContractor.building_contractor_image = fileBinary;
            }

            return(buildingContractorBus.updateBuildingContractor(newBuildingContractor));
        }
コード例 #2
0
        public bool updateBuildingContractor(DTO.ST_building_contractor buildingContractor)
        {
            try
            {
                var updateBuildingContractor = db.ST_building_contractors.Where(p => p.building_contractor_id.Equals(buildingContractor.building_contractor_id)).SingleOrDefault();
                updateBuildingContractor.building_contractor_name                = buildingContractor.building_contractor_name;
                updateBuildingContractor.building_contractor_address             = buildingContractor.building_contractor_address;
                updateBuildingContractor.building_contractor_phone               = buildingContractor.building_contractor_phone;
                updateBuildingContractor.building_contractor_email               = buildingContractor.building_contractor_email;
                updateBuildingContractor.building_contractor_bank_account_number = buildingContractor.building_contractor_bank_account_number;
                updateBuildingContractor.building_contractor_tax_code            = buildingContractor.building_contractor_tax_code;
                updateBuildingContractor.building_contractor_description         = buildingContractor.building_contractor_description;

                updateBuildingContractor.building_contractor_liabilities = buildingContractor.building_contractor_liabilities;


                updateBuildingContractor.building_contractor_date_of_birth = buildingContractor.building_contractor_date_of_birth;

                updateBuildingContractor.building_contractor_image = buildingContractor.building_contractor_image;


                db.SubmitChanges();
                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
コード例 #3
0
 public bool insertBuildingContractor(DTO.ST_building_contractor buildingContractor)
 {
     try
     {
         db.ST_building_contractors.InsertOnSubmit(buildingContractor);
         db.SubmitChanges();
         return(true);
     }
     catch (Exception)
     {
         return(false);
     }
 }
コード例 #4
0
 public bool updateBuildingContractor(DTO.ST_building_contractor buildingContractor)
 {
     return(buildingContractorDao.updateBuildingContractor(buildingContractor));
 }
コード例 #5
0
 public bool insertBuildingContractor(DTO.ST_building_contractor buildingContractor)
 {
     return(buildingContractorDao.insertBuildingContractor(buildingContractor));
 }