public static bool AddCustomer(ImportCustomerCard rec, string connString) { try { var cols = ""; var vals = ""; if (!string.IsNullOrEmpty(rec.CoLastName)) { cols += ",CoLastName"; vals += ",'" + rec.CoLastName + "'"; } if (!string.IsNullOrEmpty(rec.FirstName)) { cols += ",FirstName"; vals += ",'" + rec.FirstName + "'"; } if (!string.IsNullOrEmpty(rec.CardID)) { cols += ",CardID"; vals += ",'" + rec.CardID + "'"; } if (!string.IsNullOrEmpty(rec.CardStatus)) { cols += ",CardStatus"; vals += ",'" + rec.CardStatus + "'"; } if (!string.IsNullOrEmpty(rec.CurrencyCode)) { cols += ",CurrencyCode"; vals += ",'" + rec.CurrencyCode + "'"; } if (!string.IsNullOrEmpty(rec.Address1AddressLine1)) { cols += ",Address1AddressLine1"; vals += ",'" + rec.Address1AddressLine1 + "'"; } if (!string.IsNullOrEmpty(rec.Address1AddressLine2)) { cols += ",Address1AddressLine2"; vals += ",'" + rec.Address1AddressLine2 + "'"; } if (!string.IsNullOrEmpty(rec.Address1AddressLine3)) { cols += ",Address1AddressLine3"; vals += ",'" + rec.Address1AddressLine3 + "'"; } if (!string.IsNullOrEmpty(rec.Address1AddressLine4)) { cols += ",Address1AddressLine4"; vals += ",'" + rec.Address1AddressLine4 + "'"; } if (!string.IsNullOrEmpty(rec.Address1City)) { cols += ",Address1City"; vals += ",'" + rec.Address1City + "'"; } if (!string.IsNullOrEmpty(rec.Address1State)) { cols += ",Address1State"; vals += ",'" + rec.Address1State + "'"; } if (!string.IsNullOrEmpty(rec.Address1PostCode)) { cols += ",Address1PostCode"; vals += ",'" + rec.Address1PostCode + "'"; } if (!string.IsNullOrEmpty(rec.Address1Country)) { cols += ",Address1Country"; vals += ",'" + rec.Address1Country + "'"; } if (!string.IsNullOrEmpty(rec.Address1Phone1)) { cols += ",Address1Phone1"; vals += ",'" + rec.Address1Phone1 + "'"; } if (!string.IsNullOrEmpty(rec.Address1Phone2)) { cols += ",Address1Phone2"; vals += ",'" + rec.Address1Phone2 + "'"; } if (!string.IsNullOrEmpty(rec.Address1Phone3)) { cols += ",Address1Phone3"; vals += ",'" + rec.Address1Phone3 + "'"; } if (!string.IsNullOrEmpty(rec.Address1Fax)) { cols += ",Address1Fax"; vals += ",'" + rec.Address1Fax + "'"; } if (!string.IsNullOrEmpty(rec.Address1Email)) { cols += ",Address1Email"; vals += ",'" + rec.Address1Email + "'"; } if (!string.IsNullOrEmpty(rec.Address1Website)) { cols += ",Address1Website"; vals += ",'" + rec.Address1Website + "'"; } if (!string.IsNullOrEmpty(rec.Address1ContactName)) { cols += ",Address1ContactName"; vals += ",'" + rec.Address1ContactName + "'"; } if (!string.IsNullOrEmpty(rec.Address1Salutation)) { cols += ",Address1Salutation"; vals += ",'" + rec.Address1Salutation + "'"; } //remove first comma cols = cols.Substring(1, cols.Length - 1); vals = vals.Substring(1, vals.Length - 1); var sqlquery = "Insert into Import_Customer_Cards (" + cols + ") values (" + vals + ")"; //Delete the LOG File - Probably not required, but ensures its clean File.Delete(LogFileName); using (var connection = new OdbcConnection(connString)) { var db = new dbLinqDataContext(connection); var res = db.ExecuteCommand(sqlquery); if (res < 1) { return(false); } } //Read the log file var sr = File.ReadAllText(LogFileName); if (sr.StartsWith("-")) { var errMsg = "An Unknown Validation Error has occured while importing, check the log file (" + LogFileName + ") for details."; //means there was an issue var newLinesRegex = new Regex(@"\r\n|\n|\r", RegexOptions.Singleline); var lines = newLinesRegex.Split(sr); foreach (string l in lines) { if (l.StartsWith("Error -")) { errMsg = l; } } MessageBox.Show("MYOB has rejected the import with the following reason: " + errMsg); return(false); } } catch (Exception Ex) { //If you're getting an error about the file already being opened exclusivley - you HAVE to run as Administrator. if (Ex.Message != null && Ex.Message.Contains("[HZ080]")) { MessageBox.Show("Error: " + Ex.Message + Environment.NewLine + Environment.NewLine + "Please ensure you have MYOB running, that you are running this program and MYOB as an administrator (Windows 7+) That you have not exceeded your licenced User count."); } else { MessageBox.Show("Error: " + Ex.Message); } return(false); } return(true); }
public static bool AddMiscSale(ImportMiscellaneousSale rec, string connString) { try { var cols = ""; var vals = ""; if (!string.IsNullOrEmpty(rec.CoLastName)) { cols += ",CoLastName"; vals += ",'" + rec.CoLastName + "'"; } if (!string.IsNullOrEmpty(rec.FirstName)) { cols += ",FirstName"; vals += ",'" + rec.FirstName + "'"; } if (!string.IsNullOrEmpty(rec.CustomersNumber)) { cols += ",CustomersNumber"; vals += ",'" + rec.CustomersNumber + "'"; } if (!string.IsNullOrEmpty(rec.SaleDate)) { cols += ",SaleDate"; vals += ",'" + rec.SaleDate + "'"; } if (!string.IsNullOrEmpty(rec.InvoiceNumber)) { cols += ",InvoiceNumber"; vals += ",'" + rec.InvoiceNumber + "'"; } if (!string.IsNullOrEmpty(rec.Inclusive)) { cols += ",Inclusive"; vals += ",'" + rec.Inclusive + "'"; } if (!string.IsNullOrEmpty(rec.Memo)) { cols += ",Memo"; vals += ",'" + rec.Memo + "'"; } if (!string.IsNullOrEmpty(rec.Description)) { cols += ",Description"; vals += ",'" + rec.Description + "'"; } if (!string.IsNullOrEmpty(rec.Job)) { cols += ",Job"; vals += ",'" + rec.Job + "'"; } if (!string.IsNullOrEmpty(rec.TaxCode)) { cols += ",TaxCode"; vals += ",'" + rec.TaxCode + "'"; } if (!string.IsNullOrEmpty(rec.CurrencyCode)) { cols += ",CurrencyCode"; vals += ",'" + rec.CurrencyCode + "'"; } if (!string.IsNullOrEmpty(rec.Category)) { cols += ",Category"; vals += ",'" + rec.Category + "'"; } if (!string.IsNullOrEmpty(rec.CardID)) { cols += ",CardID"; vals += ",'" + rec.CardID + "'"; } if (!string.IsNullOrEmpty(rec.SalespersonLastName)) { cols += ",SalespersonLastName"; vals += ",'" + rec.SalespersonLastName + "'"; } if (!string.IsNullOrEmpty(rec.SalespersonFirstName)) { cols += ",SalespersonFirstName"; vals += ",'" + rec.SalespersonFirstName + "'"; } if (!string.IsNullOrEmpty(rec.ReferralSource)) { cols += ",ReferralSource"; vals += ",'" + rec.ReferralSource + "'"; } if (!string.IsNullOrEmpty(rec.SaleStatus)) { cols += ",SaleStatus"; vals += ",'" + rec.SaleStatus + "'"; } if (!string.IsNullOrEmpty(rec.PaymentMethod)) { cols += ",PaymentMethod"; vals += ",'" + rec.PaymentMethod + "'"; } if (!string.IsNullOrEmpty(rec.PaymentNotes)) { cols += ",PaymentNotes"; vals += ",'" + rec.PaymentNotes + "'"; } if (!string.IsNullOrEmpty(rec.NameOnCard)) { cols += ",NameOnCard"; vals += ",'" + rec.NameOnCard + "'"; } if (!string.IsNullOrEmpty(rec.CardNumber)) { cols += ",CardNumber"; vals += ",'" + rec.CardNumber + "'"; } if (!string.IsNullOrEmpty(rec.ExpiryDate)) { cols += ",ExpiryDate"; vals += ",'" + rec.ExpiryDate + "'"; } if (!string.IsNullOrEmpty(rec.AuthorisationCode)) { cols += ",AuthorisationCode"; vals += ",'" + rec.AuthorisationCode + "'"; } if (!string.IsNullOrEmpty(rec.DrawerBSB)) { cols += ",DrawerBSB"; vals += ",'" + rec.DrawerBSB + "'"; } if (!string.IsNullOrEmpty(rec.DrawerAccountName)) { cols += ",DrawerAccountName"; vals += ",'" + rec.DrawerAccountName + "'"; } if (!string.IsNullOrEmpty(rec.DrawerChequeNumber)) { cols += ",DrawerChequeNumber"; vals += ",'" + rec.DrawerChequeNumber + "'"; } if (!string.IsNullOrEmpty(rec.Category)) { cols += ",Category"; vals += ",'" + rec.Category + "'"; } //DOubles and integers if (rec.NonGSTLCTAmount != null) { cols += ",NonGSTLCTAmount"; vals += "," + rec.NonGSTLCTAmount.ToString(); } if (rec.GSTAmount != null) { cols += ",GSTAmount"; vals += "," + rec.GSTAmount.ToString(); } if (rec.LCTAmount != null) { cols += ",LCTAmount"; vals += "," + rec.LCTAmount.ToString(); } if (rec.ExTaxAmount != null) { cols += ",ExTaxAmount"; vals += "," + rec.ExTaxAmount.ToString(); } if (rec.IncTaxAmount != null) { cols += ",IncTaxAmount"; vals += "," + rec.IncTaxAmount.ToString(); } if (rec.ExchangeRate != null) { cols += ",ExchangeRate"; vals += "," + rec.ExchangeRate.ToString(); } if (rec.PercentDiscount != null) { cols += ",PercentDiscount"; vals += "," + rec.PercentDiscount.ToString(); } if (rec.PercentMonthlyCharge != null) { cols += ",PercentMonthlyCharge"; vals += "," + rec.PercentMonthlyCharge.ToString(); } if (rec.AmountPaid != null) { cols += ",AmountPaid"; vals += "," + rec.AmountPaid.ToString(); } if (rec.RecordID != null) { cols += ",RecordID"; vals += "," + rec.RecordID.ToString(); } if (rec.AccountNumber != null) { cols += ",AccountNumber"; vals += "," + rec.AccountNumber.ToString(); } if (rec.PaymentIsDue != null) { cols += ",PaymentIsDue"; vals += "," + rec.PaymentIsDue.ToString(); } if (rec.DiscountDays != null) { cols += ",DiscountDays"; vals += "," + rec.DiscountDays.ToString(); } if (rec.BalanceDueDays != null) { cols += ",BalanceDueDays"; vals += "," + rec.BalanceDueDays.ToString(); } if (rec.DrawerAccountNumber != null) { cols += ",DrawerAccountNumber"; vals += "," + rec.DrawerAccountNumber.ToString(); } //remove first comma cols = cols.Substring(1, cols.Length - 1); vals = vals.Substring(1, vals.Length - 1); var sqlquery = "Insert into Import_Miscellaneous_Sales (" + cols + ") values (" + vals + ")"; //Delete the LOG File - Probably not required, but ensures its clean File.Delete(LogFileName); using (var connection = new OdbcConnection(connString)) { var db = new dbLinqDataContext(connection); var res = db.ExecuteCommand(sqlquery); if (res < 1) { return(false); } } //Read the log file var sr = File.ReadAllText(LogFileName); if (sr.StartsWith("-")) { var errMsg = "An Unknown Validation Error has occured while importing, check the log file (" + LogFileName + ") for details."; //means there was an issue var newLinesRegex = new Regex(@"\r\n|\n|\r", RegexOptions.Singleline); var lines = newLinesRegex.Split(sr); foreach (string l in lines) { if (l.StartsWith("Error -")) { errMsg = l; } } MessageBox.Show("MYOB has rejected the import with the following reason: " + errMsg); return(false); } } catch (Exception Ex) { //If you're getting an error about the file already being opened exclusivley - you HAVE to run as Administrator. if (Ex.Message != null && Ex.Message.Contains("[HZ080]")) { MessageBox.Show("Error: " + Ex.Message + Environment.NewLine + Environment.NewLine + "Please ensure you have MYOB running, that you are running this program and MYOB as an administrator (Windows 7+) That you have not exceeded your licenced User count."); } else { MessageBox.Show("Error: " + Ex.Message); } return(false); } return(true); }