private void CreateContract(string template) { //construct data OwnerInformation owner = new OwnerInformation(directorName.Text, directorSurname.Text, directorMail.Text, directorPhone.Text); BusinessInformation businessInformation = new BusinessInformation(companyNameTextbox.Text, companyAddress.Text, companyCityTextbox.Text, companyPIBTextbox.Text, companyRegistryTextbox.Text, dinarskiTextbox.Text, devizniTextbox.Text); ContractInformation contractInfo = new ContractInformation(contractLengthCombobox.SelectedIndex + 1, packageCombobox.SelectedIndex, owner, businessInformation); string contractNumber = DateTime.Now.ToString("MMddyyyymmssf"); contractInfo.ContractNumber = contractNumber; Document doc = new Document(); doc.LoadFromFile(template); doc.Replace("@companyName", contractInfo.GymInformation.Name, true, true); doc.Replace("@directorName", contractInfo.GymOwnerInformation.Name, true, true); doc.Replace("@directorSurname", contractInfo.GymOwnerInformation.Surname, true, true); doc.Replace("@companyCity", contractInfo.GymInformation.City, true, true); doc.Replace("@companyAddress", contractInfo.GymInformation.Address, true, true); doc.Replace("@PIB", contractInfo.GymInformation.PIB, true, true); doc.Replace("@companyRegistryNumber", contractInfo.GymInformation.RegistryNumber, true, true); doc.Replace("@dinarski", contractInfo.GymInformation.Dinarski, true, true); doc.Replace("@devizni", contractInfo.GymInformation.Devizni, true, true); doc.Replace("@directorNumber", contractInfo.GymOwnerInformation.Mobile, true, true); doc.Replace("@dateOfSigning", DateTime.Now.ToShortDateString(), true, true); doc.Replace("@package", (contractInfo.ContractPackage == 0) ? "Po iskoriscenosti" : "Flat fee", true, true); doc.Replace("@duration", contractInfo.ContractLength.ToString(), true, true); doc.Replace("@contractNumber", contractInfo.ContractNumber, true, true); doc.SaveToFile(contractNumber + ".docx"); ProcessStartInfo info = new ProcessStartInfo(contractNumber + ".docx"); Process.Start(info); }
public List <ContractInformation> GetAllContracts() { List <ContractInformation> toReturn = new List <ContractInformation>(); using (var conn = GetConnection()) { conn.Open(); using (var com = new MySqlCommand("SELECT * FROM contracts INNER JOIN business ON contracts.business_id = business.business_id INNER JOIN owners ON business.owner_id = owners.owner_id", conn)) { using (var reader = com.ExecuteReader()) { while (reader.Read()) { BusinessInformation businessInfo = new BusinessInformation(reader.GetString(8), reader.GetString(9), reader.GetString(10), reader.GetString(11), reader.GetString(12), reader.GetString(13), reader.GetString(14)); OwnerInformation ownerInfo = new OwnerInformation(reader.GetString(16), reader.GetString(17), reader.GetString(18), reader.GetString(19)); ContractInformation contractInfo = new ContractInformation(reader.GetInt32(1), reader.GetInt32(2), ownerInfo, businessInfo); contractInfo.ContractNumber = reader.GetString(4); if (!reader.IsDBNull(5)) { contractInfo.DateSigned = reader.GetDateTime(5); } toReturn.Add(contractInfo); } } } } return(toReturn); }
public void InsertContract(ContractInformation contract) { //first insert owner using (var conn = GetConnection()) { conn.Open(); long ownerID = -1; long businessID = -1; using (var com = new MySqlCommand("INSERT INTO owners (name,surname,email,phone,google_id) VALUES (@name,@surname,@email,@phone,'NOT SET')", conn)) { com.Parameters.Add("@name", MySqlDbType.VarChar).Value = contract.GymOwnerInformation.Name; com.Parameters.Add("@surname", MySqlDbType.VarChar).Value = contract.GymOwnerInformation.Surname; com.Parameters.Add("@email", MySqlDbType.VarChar).Value = contract.GymOwnerInformation.Email; com.Parameters.Add("@phone", MySqlDbType.VarChar).Value = contract.GymOwnerInformation.Mobile; com.ExecuteNonQuery(); ownerID = com.LastInsertedId; } if (ownerID >= 0) { using (var com = new MySqlCommand("INSERT INTO business (owner_id,name,address,city,pib,registry_number,dinarski,devizni) VALUES (@owner_id,@name,@address,@city,@pib,@registry_number,@dinarski,@devizni)", conn)) { com.Parameters.Add("@owner_id", MySqlDbType.Int64).Value = ownerID; com.Parameters.Add("@name", MySqlDbType.VarChar).Value = contract.GymInformation.Name; com.Parameters.Add("@address", MySqlDbType.VarChar).Value = contract.GymInformation.Address; com.Parameters.Add("@city", MySqlDbType.VarChar).Value = contract.GymInformation.City; com.Parameters.Add("@pib", MySqlDbType.VarChar).Value = contract.GymInformation.PIB; com.Parameters.Add("@registry_number", MySqlDbType.VarChar).Value = contract.GymInformation.RegistryNumber; com.Parameters.Add("@dinarski", MySqlDbType.VarChar).Value = contract.GymInformation.Dinarski; com.Parameters.Add("@devizni", MySqlDbType.VarChar).Value = contract.GymInformation.Devizni; com.ExecuteNonQuery(); businessID = com.LastInsertedId; } } if (businessID >= 0) { using (var com = new MySqlCommand("INSERT INTO contracts (contract_length,contract_package,business_id, contract_number, date_signed) VALUES (@length,@package,@id,@number,now())", conn)) { com.Parameters.Add("@length", MySqlDbType.Int32).Value = contract.ContractLength; com.Parameters.Add("@package", MySqlDbType.Int32).Value = contract.ContractPackage; com.Parameters.Add("@id", MySqlDbType.Int64).Value = businessID; com.Parameters.Add("@number", MySqlDbType.VarChar).Value = contract.ContractNumber; com.ExecuteNonQuery(); } } } }
private void button2_Click(object sender, EventArgs e) { //construct data OwnerInformation owner = new OwnerInformation(directorName.Text, directorSurname.Text, directorMail.Text, directorPhone.Text); BusinessInformation businessInformation = new BusinessInformation(companyNameTextbox.Text, companyAddress.Text, companyCityTextbox.Text, companyPIBTextbox.Text, companyRegistryTextbox.Text, dinarskiTextbox.Text, devizniTextbox.Text); ContractInformation contractInfo = new ContractInformation(contractLengthCombobox.SelectedIndex + 1, packageCombobox.SelectedIndex, owner, businessInformation); string contractNumber = DateTime.Now.ToString("MMddyyyymmssf"); contractInfo.ContractNumber = contractNumber; //upload to the database Form1.AllContracts.Add(contractInfo); //save locally FileStream fs = new FileStream("contracts.dat", FileMode.Create, FileAccess.Write); BinaryFormatter bf = new BinaryFormatter(); bf.Serialize(fs, Form1.AllContracts); fs.Close(); if (Database.Instance.CanConnect()) { Database.Instance.InsertContract(contractInfo); } else { if (Form1.SyncTree == null) { Form1.SyncTree = new List <SyncAction>(); } SyncAction syncAction = new SyncAction { Operation = "INSERT", ObjectValue = contractInfo }; Form1.SyncTree.Add(syncAction); FileStream fsSync = new FileStream("syncdata.syn", FileMode.Create, FileAccess.Write); BinaryFormatter bfSync = new BinaryFormatter(); bfSync.Serialize(fsSync, Form1.SyncTree); fsSync.Close(); } }
public void ModifyContract(ContractInformation contract) { }
public void DeleteContract(ContractInformation contract) { }