public outDelivery() { InitializeComponent(); Connection cn = new Connection(); Utilities ut = new Utilities(); try { cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "SELECT Delivered FROM MilkCreameryDelivery WHere Date='" + DateTime.Now.ToShortDateString() + "' AND TimeOfDay='" + ut.TimeOfDay() + "'"; object x=cn.cmd.ExecuteScalar(); if (x==null) { }else { lock_load= bool.Parse(cn.cmd.ExecuteScalar().ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } fillStaff(); fillTransporter(); }
private async void fillCombo() { Utilities f=new Utilities(); farmerNumber.Items.Clear(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "select FarmerNo from Farmer where FarmerNo NOT IN (Select farmerNo from MilkDelivery where DateOfDelivery = '"+DateTime.Now.ToShortDateString()+"' And TimeofDay='"+f.TimeOfDay()+"')"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { farmerNumber.Items.Add(cn.dr.GetString(0)); } } catch(Exception ex){ MessageBox.Show(ex.Message); } if (farmerNumber.Items.Count != 0) { farmerNumber.SelectedIndex = 0; fillName(); } else { MessageDialogResult x; MetroDialogSettings yl=new MetroDialogSettings(); yl.AffirmativeButtonText="Quit"; yl.NegativeButtonText = "View Deliveries"; x=await this.ShowMessageAsync("Entry Complete!", "All Farmers with Valid Farmer Numbers have been Processed. any other processing will have to be done Manualy",MessageDialogStyle.AffirmativeAndNegative,yl); if (x == MessageDialogResult.Affirmative) { this.Hide(); } } }
private List<FarmerReport> LoadCollectionData() { List<FarmerReport> farmerCollection = new List<FarmerReport>(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); MessageBox.Show(x); cn.cmd.CommandText = "Select TimeOfDelivery,TimeOfDay,FarmerMilkDelivery,BoughtAt,ReceivedBy From MilkDelivery where FarmerNo='" + x.ToUpper() + "'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { farmerCollection.Add(new FarmerReport() { TimeOfDelivery = cn.dr.GetTimeSpan(0), TimeOfDay = cn.dr.GetString(1), Delivery = cn.dr.GetFloat(2), BuyingPrice = cn.dr.GetDouble(3), ReceivedBy = cn.dr.GetString(4), }); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } return farmerCollection; }
private void initializeDB() { try { apps.Connection cn = new apps.Connection(); cn.connect(); cn.cnn.Open(); cn.cnn.Close(); } catch (Exception ex) { string x = ex.Message; } }
private void initializeDB() { try { apps.Connection cn = new apps.Connection(); cn.connect(); cn.cnn.Open(); cn.cnn.Close(); } catch (Exception ex) { string x=ex.Message; } }
private void totalMilk(DateTime TotalDate) { if (blovkLoop == false) { float totalmilk = 0; String obj; Utilities ut = new Utilities(); Connection cn = new Connection(); try { cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select sum(FarmerMilkDelivery) from MilkDelivery Where DateOfDelivery='" + TotalDate + "' AND TimeofDay='"+ut.TimeOfDay()+"' AND DateOfDelivery NOT IN(SELECT Date FROM MilkCreameryDelivery WHere Date='" + TotalDate + "' AND TimeOfDay='"+ut.TimeOfDay()+"' )"; obj = cn.cmd.ExecuteScalar().ToString(); if (obj == "") { obj = "0"; notifyDelivery(); loadEdatCoop.IsEnabled = false; fillTodayDelivery(); tabC.SelectedIndex = 1; } else { totalmilk = float.Parse(obj); } } catch (Exception ex) { displayMetroError(ex); System.Diagnostics.Debugger.Log(0, "db Error", ex.Message); totalmilk = 0; } loadedmilk.Text = totalmilk.ToString(); blovkLoop = true; } }
private String IdGen() { Connection cn = new Connection(); String pattID = "", Prodid = ""; int Temp1 = 0; String k = DateTime.Now.Year.ToString(); Start: Temp1 += 1; Prodid = "KDFC/SUPPLIER/"; try { cn.connect(); pattID = Prodid + Temp1 + k; String CheckString; cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select top 1 supplierNo from Supplier Where supplierNo='" + pattID + "' Order By supplierNo DESC"; CheckString = cn.cmd.ExecuteScalar().ToString(); if (CheckString == null) { return Temp1.ToString(); } else goto Start; } catch (Exception ex) { System.Diagnostics.Debugger.Log(0, "db Error", ex.Message); } return pattID; }
private async void RegisterTransporter_Click(object sender, RoutedEventArgs e) { Connection cn = new Connection(); String SupNo = txtSupno.Text; String SupName=txtsupName.Text.ToUpper(); String Phone = txtSupPhone.Text; int IDNumber=Int32.Parse(txtsupId.Text); String vehicle=travehicle.Text.ToUpper()+"("+travehicleType.Text.ToUpper()+")"; String Driver = tradriver.Text.ToUpper(); String TurnBoy=traTurnBoy.Text.ToUpper(); String DOR=DateTime.Now.ToShortDateString(); String Bankacc=bankacc.Text; String Bank = banklist.Text.ToUpper(); Boolean isActive= isActivestatus ; try { //MessageBox.Show(cn.connectionString); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "insert into Supplier(SupplierNo,SupplierName,SupplierID,DOR,SupplierTelNo,SupplierBank,SupplierBankacc,SupplierActive,Misc1,Misc2,Misc3) Values('"+SupNo+"','"+SupName+"','"+IDNumber+"','"+DOR+"','"+Phone+"','"+Bank+"','"+Bankacc+"','"+isActive+"','"+vehicle+"','"+Driver+"','"+TurnBoy+"')"; cn.cmd.ExecuteNonQuery(); await this.ShowMessageAsync("Registration is a Success", " The Transporter has been entered into the system Successfuly", MessageDialogStyle.Affirmative, null); //farmerDatagrid.ItemsSource = LoadCollectionData(); //ViewFarmersTab.BringIntoView(); // clearRegFields(); } catch (Exception ex) { ShowOverlay(); MessageBox.Show("Registration has Failed! The following Message was generated to explain why \n \n"+ex.Message+"\n \n"+ex.InnerException,"Registration Failure",MessageBoxButton.OK,MessageBoxImage.Error); HideOverlay(); } this.Close(); }
private void fillTransporter() { Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "select SupplierName from Supplier"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { suppliercombo.Items.Add(cn.dr.GetString(0)); } } catch(Exception ex){ displayMetroError(ex); } fillTransporterDetails(); }
private List<inDelivery> LoadCollection() { List<inDelivery> farmerCollection = new List<inDelivery>(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select FarmerNo,FarmerName,TimeOfDelivery,TimeOfDay,FarmerMilkDelivery,BoughtAt,ReceivedBy From MilkDelivery where DateOfDelivery='"+DateTime.Now.ToShortDateString()+"'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { farmerCollection.Add(new inDelivery() { FarmerNO = cn.dr.GetString(0), FarmerName = cn.dr.GetString(1), TimeOfDelivery=cn.dr.GetTimeSpan(2), TimeOfDay=cn.dr.GetString(3), Delivery = cn.dr.GetFloat(4), BuyingPrice = cn.dr.GetDouble(5), ReceivedBy = cn.dr.GetString(6), }); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } return farmerCollection; }
private void getTotal() { if (farmerNumber.Items.Count != 0) { String FirstMonthDate=DateTime.Now.Month.ToString()+"/1/"+DateTime.Now.Year.ToString(); //farmerNumber.Items.Clear(); Connection cn = new Connection(); double x,y; cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "select sum(FarmerMilKDelivery) from MilkDelivery where FarmerNo like '%" + farmerNumber.SelectedValue.ToString() + "%' and DateOfDelivery Between '" + FirstMonthDate + "' and '" + DateTime.Now.Date.ToShortDateString() + "'"; try { if (cn.cmd.ExecuteScalar().ToString() != "") { x =double.Parse(cn.cmd.ExecuteScalar().ToString()); y = Math.Round(x,1); } else { y = 0.0; } deliverythisMonth.Content = "Delivery This Month:" + y.ToString()+" Kilogrammes "; } catch (Exception ex) { MessageBox.Show(ex.Message); } }else { } }
private async void btnRegisterStaff_Click(object sender, RoutedEventArgs e) { Connection cn = new Connection(); String StaffNo = txtregNo.Text; String Staff=firstName.Text+" "+surName.Text;//FarmerFName.Text+" "+FarmerOtherName.Text; String Phone = phoneNumber.Text; int IDNumber=Int32.Parse(idNumber.Text); String kra =krapin.Text.ToUpper(); String nhif = nhifno.Text.ToUpper(); String DOE=DateTime.Now.ToShortDateString(); String Bankacc=accountnumber.Text; String Bank = banklist.Text.ToUpper(); MessageBox.Show(isActivestatus.ToString()); try { //MessageBox.Show(cn.connectionString); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "insert into Staff(staffNo,staffName,PhoneNumber,staffID,Date_of_Employment,Active,AccountNo,Bank,kraPIN,nhifNo) VALUES('" + StaffNo.ToUpper() + "','" + Staff.ToUpper() + "','" + Phone.ToUpper() + "','" +IDNumber + "','" + DOE +"','"+isActivestatus.ToString()+"','"+Bankacc+"','"+Bank+"','"+kra.ToUpper()+"','"+nhif.ToUpper()+"')"; cn.cmd.ExecuteNonQuery(); await this.ShowMessageAsync("Registration is a Success", "You have Registered " + Staff.ToUpper() + " Successfuly", MessageDialogStyle.Affirmative, null); staffDatagrid.ItemsSource = LoadCollectionData(); //farmerDatagrid.ItemsSource = LoadCollectionData(); //ViewFarmersTab.BringIntoView(); clearRegFields(); } catch (Exception ex) { ShowOverlay(); MessageBox.Show("Registration has Failed! The following Message was generated to explain why \n \n"+ex.Message+"\n \n"+ex.InnerException,"Registration Failure",MessageBoxButton.OK,MessageBoxImage.Error); HideOverlay(); } }
private List<Staff> LoadCollectionData() { List<Staff> farmer = new List<Staff>(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; try { cn.cmd.Connection.Open(); } finally { } cn.cmd.CommandText = "Select * From Staff"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { farmer.Add(new Staff() { StaffNo = cn.dr.GetString(0), staff = cn.dr.GetString(1), IDNumber = int.Parse(cn.dr.GetString(4)), Phone = cn.dr.GetString(2), DOE = cn.dr.GetDateTime(5), Bank = cn.dr.GetString(8), Bankacc = cn.dr.GetString(7), isActive = cn.dr.GetBoolean(6), nhif = cn.dr.GetString(9), kra=cn.dr.GetString(10) }); } } catch (Exception ex) { ShowOverlay(); MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); HideOverlay(); } return farmer; }
private async void UpdateDb_Click(object sender, RoutedEventArgs e) { //MessageBox.Show(Unloaded.Value.ToString()); if (Unloaded.Value != 0) { Double loaded=double.Parse(loadedmilk1.Text); Double unloaded = double.Parse(Unloaded.Value.ToString()); Double Deficit = loaded - unloaded; if (Deficit<3.0) { Deficit=0; } Connection cn = new Connection(); try{ cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "update MilkCreameryDelivery Set Litres_Unloaded='"+unloaded+"', Deficit='"+Deficit+"',Delivered='True' WHERE DATE='"+DateTime.Now.ToShortDateString()+"'"; cn.cmd.ExecuteScalar(); MessageDialogResult x = new MessageDialogResult(); MetroDialogSettings y = new MetroDialogSettings(); y.AffirmativeButtonText = "Quit"; await this.ShowMessageAsync("Delivery Confirmed", "You have updated the Delivery Successfuly.", MessageDialogStyle.Affirmative, y); if (x.ToString() == "Negative") { this.Close(); } //farmerDatagrid.ItemsSource = LoadCollectionData(); //ViewFarmersTab.BringIntoView(); // clearRegFields(); } catch (Exception ex) { displayMetroError(ex); //ShowOverlay(); //MessageBox.Show("Registration has Failed! The following Message was generated to explain why \n \n"+ex.Message+"\n \n"+ex.InnerException,"Registration Failure",MessageBoxButton.OK,MessageBoxImage.Error); //HideOverlay(); } } else { Unloaded.Focus(); } }
private void fillName(){ Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select Farmer_Name,Phone_Number From Farmer Where FarmerNo='"+farmerNumber.Text+"'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { PhoneNumber=(cn.dr.GetString(1)); farmerName = (cn.dr.GetString(0)); selectedfarmerName.Content = "Farmer: " + farmerName; selectedFarmerContact.Content = "Contact Number: " + PhoneNumber; } } catch (Exception ex) { MessageBox.Show(ex.Message); } getTotal(); }
private string checkNumber(String Check) { Connection cn = new Connection(); String CheckString=""; try { cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select FarmerNo from Farmer Where FarmerNo='" + Check + "' "; CheckString = cn.cmd.ExecuteScalar().ToString(); if (CheckString == null) { return ""; } } catch (Exception ex) { System.Diagnostics.Debugger.Log(0, "db Error", ex.Message); } return CheckString; }
private async void AddDelivery_Click(object sender, RoutedEventArgs e) { Connection cn = new Connection(); String DeliveryID = IdGen(); float Loaded=float.Parse(loadedmilk.Text); float UnLoaded = 0; float Deficit=Loaded-UnLoaded; String Supplier =suppliercombo.SelectedItem.ToString(); String DelVehicle = Vehicle.Text; String DOD=DateTime.Now.ToShortDateString(); String driver=Driver.Text; String conductor = Conductor.Text; String StaffName=staffcombo.SelectedItem.ToString(); Utilities f = new Utilities(); try { //MessageBox.Show(cn.connectionString); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "INSERT INTO MilkCreameryDelivery(DeliveryID,Date,timeofday,Litres_loaded,Litres_Unloaded,Deficit,Loader,Driver,Conductor,Vehicle,Supplier,Delivered) VALUES('" + DeliveryID + "','" + DOD + "','"+f.TimeOfDay()+"','" + Loaded + "','" + UnLoaded + "','" + Deficit + "','" + StaffName + "','" + driver + "','" + conductor + "','" + DelVehicle + "','" + Supplier + "','0')"; cn.cmd.ExecuteNonQuery(); MessageDialogResult x = new MessageDialogResult(); MetroDialogSettings y = new MetroDialogSettings(); y.AffirmativeButtonText = "Go to Delivery Tab"; y.NegativeButtonText = "Close"; x= await this.ShowMessageAsync("Delivery Added", "You have Added the Delivery Successfuly. Upon return, the Transporter("+Supplier+") Must enter milk unloaded at the creamery in the next Tab", MessageDialogStyle.AffirmativeAndNegative, y); if (x.ToString() == "Negative") { this.Close(); } else { loadEdatCoop.IsEnabled = false; fillTodayDelivery(); tabC.SelectedIndex = 1; } //farmerDatagrid.ItemsSource = LoadCollectionData(); //ViewFarmersTab.BringIntoView(); // clearRegFields(); } catch (Exception ex) { displayMetroError(ex); } }
private void fillTransporterDetails() { Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select Misc3,Misc2,Misc1 From Supplier Where SupplierActive='True' AND SupplierName='" + suppliercombo.Text + "'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { Driver.Text = (cn.dr.GetString(1)); Conductor.Text= (cn.dr.GetString(0)); Vehicle.Text = (cn.dr.GetString(2)); //MessageBox.Show(cn.dr.GetString(0) + cn.dr.GetString(1) + cn.dr.GetString(2)); } } catch (Exception ex) { displayMetroError(ex); } }
private void suppliercombo_SelectionChanged(object sender, SelectionChangedEventArgs e) { Driver.Clear(); Conductor.Clear(); Vehicle.Clear(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select Misc3,Misc2,Misc1 From Supplier Where SupplierActive='True' and SupplierName='" + suppliercombo.SelectedItem.ToString() + "'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { Driver.Text = (cn.dr.GetString(1)); Conductor.Text = (cn.dr.GetString(0)); Vehicle.Text = (cn.dr.GetString(2)); // MessageBox.Show(cn.dr.GetString(0) + cn.dr.GetString(1) + cn.dr.GetString(2)); } } catch (Exception ex) { displayMetroError(ex); } }
private async void registerFarmersDelivery_Click(object sender, RoutedEventArgs e) { if (farmerNumber.Items.Count != 0) { Connection cn = new Connection(); double delivery = (double)deliveryNum.Value; delivery = System.Math.Round(delivery, 2); string deliveryhash = farmerNumber.Text.ToUpper() + DateTime.Now.ToShortDateString()+DateTime.Now.ToShortTimeString(); try { //MessageBox.Show(cn.connectionString); Utilities f=new Utilities(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "insert into MilkDelivery(FarmerHash,FarmerNo,FarmerName,FarmerMilkDelivery,DateOfDelivery,timeofdelivery,timeofday,BoughtAt,ReceivedBy) VALUES('" + deliveryhash + "','" + farmerNumber.Text + "','" + farmerName + "','" + delivery + "','" + DateTime.Now.ToShortDateString() + "','"+DateTime.Now.ToLongTimeString()+"','"+f.TimeOfDay()+"','" + buyingPrice + "','SELF')"; //MessageBox.Show( "insert into MilkDelivery(FarmerHash,FarmerNo,FarmerName,FarmerMilkDelivery,DateOfDelivery,timeofdelivery,timeofday,BoughtAt,ReceivedBy) VALUES('" + deliveryhash + "','" + farmerNumber.Text + "','" + farmerName + "','" + delivery + "','" + DateTime.Now.ToShortDateString() + "','"+DateTime.Now.ToLongTimeString()+"','"+f.TimeOfDay()+"','" + buyingPrice + "','SELF')"); cn.cmd.ExecuteNonQuery(); await this.ShowMessageAsync("Delivery Registered!", "You have entered a milk delivery of " + delivery + " kg's for " + farmerNumber.Text + " Bought at Sh" + buyingPrice + "", MessageDialogStyle.Affirmative, null); deliveryNum.Value = 0; deliveryGrid.ItemsSource = LoadCollection(); fillCombo(); } catch (Exception ex) { ShowOverlay(); MessageBox.Show(ex.Message);//"Entry Failed! Most probable cause for this is that "+farmerName+ "'s has already delivered milk today", "Entry Failure", MessageBoxButton.OK, MessageBoxImage.Error); HideOverlay(); } } else { MessageDialogResult x; MetroDialogSettings yl=new MetroDialogSettings(); yl.AffirmativeButtonText="Quit"; x=await this.ShowMessageAsync("Entry Complete!", "All Farmers with Valid Farmer Numbers have been Processed. any other processing will have to be done Manualy",MessageDialogStyle.Affirmative,yl); if (x == MessageDialogResult.Affirmative) { MessageBox.Show("t"); this.Close(); } } }
private void fillStaff() { staffcombo.Items.Clear(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "select StaffName from Staff Where Active='True'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { staffcombo.Items.Add(cn.dr.GetString(0)); } } catch(Exception ex){ displayMetroError(ex); } }
private void fillTodayDelivery() { Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select litres_loaded,Loader,Supplier,Driver,Conductor,Vehicle From MilkCreameryDelivery Where Date='" + DateTime.Now.ToShortDateString() + "' and Delivered='False'"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { loadedmilk1.Text=cn.dr.GetDouble(0).ToString(); staffcombo1.Text = (cn.dr.GetString(1)); suppliercombo1.Text=(cn.dr.GetString(2)); Driver1.Text=(cn.dr.GetString(3)); Conductor1.Text = (cn.dr.GetString(4)); Vehicle1.Text = (cn.dr.GetString(5)); //MessageBox.Show(cn.dr.GetString(0) + cn.dr.GetString(1) + cn.dr.GetString(2)); } } catch (Exception ex) { displayMetroError(ex); } fillStaff(); fillTransporter(); }
private List<Farmer> LoadCollectionData() { List<Farmer> farmer = new List<Farmer>(); Connection cn = new Connection(); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "Select * From Farmer"; try { cn.dr = cn.cmd.ExecuteReader(); while (cn.dr.Read()) { farmer.Add(new Farmer() { farmerNO = cn.dr.GetString(0), farmerName = cn.dr.GetString(1), farmerID =int.Parse(cn.dr.GetString(5)), phoneNumber = cn.dr.GetString(2), dateOfRegistration = cn.dr.GetDateTime(6), Bank = cn.dr.GetString(9), BankNum = cn.dr.GetString(8), isActive = cn.dr.GetBoolean(7), nextOfKin = cn.dr.GetString(4), }); } } catch (Exception ex) { ShowOverlay(); MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); HideOverlay(); } return farmer; }
private async void btnRegister_Click(object sender, RoutedEventArgs e) { Connection cn = new Connection(); String FarmerNo = txtregNo.Text; String Farmer=FarmerFName.Text+" "+FarmerOtherName.Text; String Phone = FarmerPhone.Text; String NextOfKin = NextofKinFName.Text +" "+ NextOfKinOtherNames.Text; String Family = FarmerFamilyName.Text; String DOR=DateTime.Now.ToShortDateString(); String Bankacc = FarmerBankNo.Text; String Bank = BankList.Text; try { //MessageBox.Show(cn.connectionString); cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "insert into Farmer(FarmerNo,Farmer_Name,Phone_Number,NextOfKin_Name,FarmerID,Date_of_Registration,Active,AccountNo,Bank) VALUES('" + FarmerNo.ToUpper() + "','" + Farmer.ToUpper() + "','" + Phone.ToUpper() + "','" + NextOfKin.ToUpper() + "','" + Family.ToUpper() + "','" + DOR +"','1','"+Bankacc+"','"+Bank+"')"; cn.cmd.ExecuteNonQuery(); await this.ShowMessageAsync("Registration is a Success", "You have Registered " + Farmer.ToUpper() + " Successfuly", MessageDialogStyle.Affirmative, null); farmerDatagrid.ItemsSource = LoadCollectionData(); ViewFarmersTab.BringIntoView(); txtregNo.Text = IdGen(); clearRegFields(); } catch (Exception ex) { ShowOverlay(); MessageBox.Show("Registration has Failed! The following Message was generated to explain why \n \n"+ex.Message+"\n \n"+ex.InnerException,"Registration Failure",MessageBoxButton.OK,MessageBoxImage.Error); HideOverlay(); } }