private void readData() { conDB.customer_id = 0; if (productName.SelectedText == "") { conDB.product_name_th = productName.Text.Trim(); conDB.product_name_en = ""; conDB.product_price = 0; conDB.product_value = ""; conDB.product_date_create = convertDT.convert(DateTime.Now); conDB.product_date_stamp = convertDT.convert(DateTime.Now); conDB.product_id = conDB.addProduct(); } if (companyName.SelectedIndex < 0) { conDB.company_name_th = companyName.Text.Trim(); conDB.company_name_en = ""; conDB.company_adddress = ""; conDB.company_phone = ""; conDB.company_email = ""; conDB.company_date_create = convertDT.convert(DateTime.Now); conDB.company_date_stamp = convertDT.convert(DateTime.Now); conDB.company_id = conDB.addCompany(); } if (productType.SelectedIndex < 0) { conDB.product_type_name_th = productType.Text.Trim(); conDB.product_type_name_en = ""; conDB.product_type_date_create = convertDT.convert(DateTime.Now); conDB.product_type_date_stamp = convertDT.convert(DateTime.Now); conDB.product_type_id = conDB.addProductType(); } conDB.product_name = productName.Text.Trim(); conDB.serial = serial.Text.Trim(); conDB.address = ""; conDB.phone = ""; conDB.status = status.Text; conDB.date_create = convertDT.convert(DateTime.Now); conDB.date_product = convertDT.convert(dtProductEndDate.DateTime); conDB.date_stamp = convertDT.convert(DateTime.Now); conDB.chargebacks = 0; conDB.warranty = ""; conDB.symptom = symptom.Text.Trim(); conDB.equipment = equipment.Text.Trim(); conDB.detail = detail.Text.Trim(); if (fRMMain.typeOfEmployeeClem == "add") { conDB.in_document_number_id = conDB.getNewIDClemOfMonth(clemType); } else { conDB.in_document_number_id = conDB.getNewIDClemOfMonth(clemType); } conDB.in_document_number = convertDT.convert(DateTime.Now); conDB.in_document_number_string = inDocumentNumber.Text; conDB.out_document_number = outDocumentNumber.Text.Trim(); conDB.in_serial_clem = ""; conDB.out_serial_clem = ""; conDB.clem_type = clemType; conDB.customer_clem = ""; conDB.employee_receive_clem = ""; conDB.employee_clem = employeeClem.Text.Trim(); conDB.company_receive_clem = companyReceiveClem.Text.Trim(); conDB.company_return = companyReturn.Text.Trim(); conDB.employee_receive_product = employeeReceiveProduct.Text.Trim(); conDB.employee_return = ""; conDB.customer_receive_product = ""; }