public string Delete(string userId, string id) { Global.Response response = new Global.Response(); if (string.IsNullOrWhiteSpace(userId)) { response.isSuccess = false; response.msg = "select item"; return(JsonConvert.SerializeObject(response, Formatting.None)); } if (string.IsNullOrWhiteSpace(userId)) { response.isSuccess = false; response.msg = "error"; return(JsonConvert.SerializeObject(response, Formatting.None)); } try { using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + DB.GetDataBasePath(userId, userDataBase))) { connection.Open(); string sql = string.Format("DELETE FROM favoritefoods WHERE id = '{0}'", id); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.ExecuteNonQuery(); } response.isSuccess = true; } return(JsonConvert.SerializeObject(response, Formatting.None)); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; L.SendErrorLog(e, id, userId, "FavoriteFoods", "Delete"); return(JsonConvert.SerializeObject(response, Formatting.None)); } }
public string Delete(string userId, string[] ids, string tbl) { Global.Response response = new Global.Response(); if (ids.Length == 0) { response.isSuccess = false; response.msg = "select items"; return(JsonConvert.SerializeObject(response, Formatting.None)); } if (string.IsNullOrWhiteSpace(userId)) { response.isSuccess = false; response.msg = "error"; return(JsonConvert.SerializeObject(response, Formatting.None)); } try { using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + DB.GetDataBasePath(userId, dataBase))) { connection.Open(); foreach (var clientId in ids) { response = DeleteRecord(userId, clientId, connection, tbl); } } return(JsonConvert.SerializeObject(response, Formatting.None)); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; L.SendErrorLog(e, tbl, userId, "Archives", "Delete"); return(JsonConvert.SerializeObject(response, Formatting.None)); } }
public string DeleteErrorLog(string[] ids) { Global.Response response = new Global.Response(); if (ids.Length == 0) { response.isSuccess = false; response.msg = "select items"; return(JsonConvert.SerializeObject(response, Formatting.None)); } try { string sql = null; using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + usersDataBase))) { connection.Open(); foreach (var id in ids) { sql = string.Format(@"DELETE FROM errorlog WHERE errorLogId = '{0}'", id); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.ExecuteNonQuery(); } } } response.isSuccess = true; response.msg = "deleted"; return(JsonConvert.SerializeObject(response, Formatting.None)); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; SendErrorLog(e, ids.ToString(), null, "Log", "DeleteErrorLog"); return(JsonConvert.SerializeObject(response, Formatting.None)); } }
public Global.Response SendTicketMessage(string sendTo, string messageSubject, string messageBody, string lang, string filePath, bool send_cc) { Global.Response resp = new Global.Response(); resp.isSuccess = SendMail(sendTo, messageSubject, messageBody, lang, filePath, send_cc).isSuccess; resp.msg = true ? t.Tran("successfully sent", lang) : string.Format("{0}! {1}.", t.Tran("not sent", lang), t.Tran("please try again", lang)); return(resp); }
public JsonResult OnGetLoadAnalyzerInstance() { Global.Response response = new Global.Response(); try { string userIPAddress = Global.GetUserIPAddress(); List <CurrentAnalyzerInstancesTVF> currentAnalyzerInstancesTVFResults = _fortuneStreetAppContext.CurrentAnalyzerInstancesTVF.FromSqlInterpolated($"SELECT * FROM currentanalyzerinstances_tvf() WHERE status = 'in_progress'").OrderByDescending(timestampadded => timestampadded.TimestampAdded).ToList(); foreach (CurrentAnalyzerInstancesTVF currentAnalyzerInstancesTVFResult in currentAnalyzerInstancesTVFResults) { if (!Global.HashComparison(userIPAddress, currentAnalyzerInstancesTVFResult.IPAddress)) { currentAnalyzerInstancesTVFResults.Remove(currentAnalyzerInstancesTVFResult); } } response.HTMLResponse = "<div>" + ( currentAnalyzerInstancesTVFResults.Count > 0 ? "<div class=\"horizontal-items\">" + "<div>" + "<select class=\"form-select\">" + string.Join("", currentAnalyzerInstancesTVFResults.Select(results => "<option value=\"" + results.AnalyzerInstanceID + "\">" + results.TimestampAdded.ToLocalTime().ToString("MMMM d, yyyy h:mm:ss tt") + "</option>")) + "</select>" + "</div>" + "<div>" + "<button type=\"button\" class=\"btn btn-primary\" name=\"load\">Load</button>" + "</div>" + "</div>" : "<div>No previous analyzer instances found. Start a new one by clicking the \"Create\" button below.</div>" ) + "<div>" + Global.CreateConfirmationActions("center-items", new List <string> { "<button type=\"button\" class=\"btn btn-lg btn-primary\" name=\"create\">Create</button>" }) + "</div>" + "</div>"; return(new JsonResult(response)); } catch (Exception e) { return(Global.ServerErrorResponse(e)); } }
private Global.Response DeleteRecord(string userId, string id, SQLiteConnection connection, string tbl) { Global.Response response = new Global.Response(); try { string sql = null; switch (tbl) { case "clients": sql = string.Format(@"DELETE FROM clients WHERE clientId = '{0}'; DELETE FROM clientsdata WHERE clientId = '{0}'", id); F.DeleteClientFolder(userId, id); break; case "menus": sql = string.Format("DELETE FROM menues WHERE id = '{0}'", id); F.DeleteJsonFile(userId, id, "menues", null); break; case "weeklymenus": sql = string.Format("DELETE FROM weeklymenus WHERE id = '{0}'", id); break; case "recipes": sql = string.Format("DELETE FROM recipes WHERE id = '{0}'", id); F.DeleteJsonFile(userId, id, "recipes", null); /******* Delete from My Foods if exists (Recipes as My Food) *******/ MyFoods mf = new MyFoods(); mf.Delete(userId, id); F.DeleteRecipeFolder(userId, id); /******* Delete from My Sharing Recipes if exists *******/ SharingRecipes SR = new SharingRecipes(); SR.DeleteSharedRecipe(id); break; case "foods": sql = string.Format("DELETE FROM myfoods WHERE id = '{0}'", id); break; case "appointments": sql = string.Format("DELETE FROM scheduler WHERE rowid = '{0}'", id); break; default: break; } using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.ExecuteNonQuery(); } response.isSuccess = true; response.msg = "deleted"; return(response); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; L.SendErrorLog(e, id, userId, "Archives", "DeleteRecord"); return(response); } }
public string Delete(string userGroupId, string id, string userId, int adminType, string authorId) { var x = new Global.Response(); try { if (string.IsNullOrEmpty(userGroupId) || string.IsNullOrEmpty(id)) { x.isSuccess = false; x.msg = "tryAgainMsg"; return(JsonConvert.SerializeObject(x, Formatting.None)); } Global G = new Global(); if (!G.CheckUserPermission(userGroupId, userId, adminType, authorId)) { x.isSuccess = false; x.msg = "deleteRecipePermissionAlert"; return(JsonConvert.SerializeObject(x, Formatting.None)); } using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userGroupId, dataBase))) { connection.Open(); string sql = @"BEGIN; DELETE FROM recipes WHERE id = @Id; COMMIT;"; using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.Parameters.Add(new SQLiteParameter("Id", id)); command.ExecuteNonQuery(); } } Files F = new Files(); F.DeleteJsonFile(userGroupId, id, "recipes", null); /******* Delete from My Foods if exists (Recipes as My Food) *******/ MyFoods mf = new MyFoods(); mf.Delete(userGroupId, id); /*******************************************************************/ F.DeleteRecipeFolder(userGroupId, id); /******* Delete from My Sharing Recipes if exists *******/ SharingRecipes SR = new SharingRecipes(); SR.DeleteSharedRecipe(id); /*******************************************************************/ x.isSuccess = true; x.msg = "deleted"; return(JsonConvert.SerializeObject(x, Formatting.None)); } catch (Exception e) { x.isSuccess = false; x.msg = e.Message; L.SendErrorLog(e, id, null, "Recipes", "Delete"); return(JsonConvert.SerializeObject(x, Formatting.None)); } }
public string Save(NewTicket x, bool sendMail, bool attachFile, string lang) { try { //string path = Server.MapPath(string.Format("~/App_Data/{0}", dataBase)); //db.CreateGlobalDataBase(path, db.tickets); if (string.IsNullOrWhiteSpace(x.id)) { x.id = Convert.ToString(Guid.NewGuid()); } Global G = new Global(); x.title = G.RemoveSingleQuotes(x.title); x.desc = G.RemoveSingleQuotes(x.desc); x.note = G.RemoveSingleQuotes(x.note); string sql = string.Format(@"BEGIN; INSERT OR REPLACE INTO tickets ({0}) VALUES ('{1}', '{2}', '{3}', '{4}', '{5}', '{6}', {7}, {8}, '{9}'); COMMIT;", mainSql, x.id, x.user.userId, x.title, x.desc, x.reportDate, x.filePath, x.status, x.priority, x.note); using (SQLiteConnection connection = new SQLiteConnection(string.Format("Data Source={0}", Server.MapPath(dataSource)))) { connection.Open(); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.ExecuteNonQuery(); } } Users U = new Users(); x.user = U.GetUserInfo(x.user.userId); if (sendMail) { Mail M = new Mail(); string myEmail = ConfigurationManager.AppSettings["myEmail"]; Global.Response mailResp = M.SendTicketMessage(myEmail, messageSubject: string.Format("TICKET - {0}", x.user.email), messageBody: x.desc, lang: lang, filePath: attachFile ? x.filePath : null, send_cc: true); x.response = mailResp; } else { x.response.isSuccess = true; x.response.msg = "successfully sent"; } return(JsonConvert.SerializeObject(x, Formatting.None)); } catch (Exception e) { x.response.isSuccess = false; x.response.msg = e.Message; L.SendErrorLog(e, x.id, x.user.userId, "Tickets", "Save"); return(JsonConvert.SerializeObject(x, Formatting.None)); } }
public string Delete(string id) { var resp = new Global.Response(); try { DeleteSharedRecipe(id); resp.isSuccess = true; resp.msg = "saved"; return(JsonConvert.SerializeObject(resp, Formatting.None)); } catch (Exception e) { resp.isSuccess = false; resp.msg = e.Message; L.SendErrorLog(e, id, null, "SharingRecipes", "Delete"); return(JsonConvert.SerializeObject(resp, Formatting.None)); } }
public JsonResult OnPostSaveAnalyzerData([FromBody] SaveAnalyzerDataModel saveAnalyzerParameter) { Global.Response response = new Global.Response(); try { long?analyzerInstanceID = Global.VerifyAnalyzerInstanceID(saveAnalyzerParameter.analyzerData.AnalyzerInstanceID, _fortuneStreetAppContext); if (analyzerInstanceID == null) { throw new Exception(); } List <PropertyInfo> analyzerDataModelProperties = typeof(Global.AnalyzerDataModel).GetProperties(BindingFlags.Public | BindingFlags.Instance).ToList(); foreach (PropertyInfo currentAnalyzerDataModelProperty in analyzerDataModelProperties) { if (saveAnalyzerParameter.keys.Contains(currentAnalyzerDataModelProperty.Name)) { _fortuneStreetAppContext.AnalyzerInstanceLogs.Add(new AnalyzerInstanceLogs { AnalyzerInstanceID = (long)analyzerInstanceID, Key = currentAnalyzerDataModelProperty.Name, Value = JsonSerializer.Serialize(currentAnalyzerDataModelProperty.GetValue(saveAnalyzerParameter.analyzerData, null)) }); } } _fortuneStreetAppContext.SaveChanges(); response.AlertData = new Global.Response.Alert { Type = "alert-success", Title = "Saved data..." }; } catch { response.AlertData = new Global.Response.Alert { Type = "alert-warning", Title = "Cannot save data..." }; } return(new JsonResult(response)); }
public string CreateGlobalDataBase(string dataBase) { Global.Response response = new Global.Response(); try { DataBase DB = new DataBase(); string[] tables = { }; if (dataBase == ConfigurationManager.AppSettings["UsersDataBase"]) { tables = new [] { DB.users, DB.loginlog, DB.errorlog }; } else if (dataBase == ConfigurationManager.AppSettings["WebDataBase"]) { tables = new[] { DB.orders, DB.instals, DB.invoices, DB.tickets }; } else if (dataBase == ConfigurationManager.AppSettings["SharingDataBase"]) { tables = new[] { DB.sharingrecipes }; } else { response.isSuccess = false; response.msg = "select items"; return(JsonConvert.SerializeObject(response, Formatting.None)); } string path = HttpContext.Current.Server.MapPath(string.Format("~/App_Data/{0}", dataBase)); if (tables.Length == 0) { response.isSuccess = false; response.msg = "select items"; return(JsonConvert.SerializeObject(response, Formatting.None)); } foreach (var table in tables) { DB.CreateGlobalDataBase(path, table); } response.isSuccess = true; response.msg = "ok"; return(JsonConvert.SerializeObject(response, Formatting.None)); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; return(JsonConvert.SerializeObject(response, Formatting.None)); } }
public string Delete(Users.NewUser user, NewMenu menu) { var x = new Global.Response(); try { if (!string.IsNullOrEmpty(user.userGroupId) && !string.IsNullOrEmpty(menu.id)) { Global G = new Global(); if (!G.CheckUserPermission(user, menu.userId)) { x.isSuccess = false; x.msg = "you can only delete menus that you have created yourself"; return(JsonConvert.SerializeObject(x, Formatting.None)); } using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(user.userGroupId, userDataBase))) { connection.Open(); string sql = string.Format("DELETE FROM menues WHERE id = '{0}'", menu.id); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.ExecuteNonQuery(); } F.DeleteJsonFile(user.userGroupId, menu.id, "menues", null); } x.isSuccess = true; x.msg = "deleted"; return(JsonConvert.SerializeObject(x, Formatting.None)); } else { x.isSuccess = false; x.msg = "error"; return(JsonConvert.SerializeObject(x, Formatting.None)); } } catch (Exception e) { x.isSuccess = false; x.msg = e.Message; L.SendErrorLog(e, menu.id, user.userId, "Menues", "Delete"); return(JsonConvert.SerializeObject(x, Formatting.None)); } }
public string Save(string userId, string id) { Global.Response response = new Global.Response(); if (string.IsNullOrWhiteSpace(id)) { response.isSuccess = false; response.msg = "select item"; return(JsonConvert.SerializeObject(response, Formatting.None)); } if (string.IsNullOrWhiteSpace(userId)) { response.isSuccess = false; response.msg = "error"; return(JsonConvert.SerializeObject(response, Formatting.None)); } try { //DB.CreateDataBase(userId, DB.favoriteFoods); string sql = null; using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + DB.GetDataBasePath(userId, userDataBase))) { connection.Open(); sql = string.Format(@"INSERT OR REPLACE INTO favoritefoods VALUES ('{0}')", id); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { using (SQLiteTransaction transaction = connection.BeginTransaction()) { command.ExecuteNonQuery(); transaction.Commit(); } } } response.isSuccess = true; return(JsonConvert.SerializeObject(response, Formatting.None)); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; L.SendErrorLog(e, id, userId, "FavoriteFoods", "Save"); return(JsonConvert.SerializeObject(response, Formatting.None)); } }
public string Delete(string userId, string clientId) { Global.Response response = new Global.Response(); try { using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, dataBase))) { connection.Open(); string sql = @"DELETE FROM clients WHERE clientId = @ClientId; DELETE FROM clientsdata WHERE clientId = @ClientId"; using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.Parameters.Add(new SQLiteParameter("ClientId", clientId)); command.ExecuteNonQuery(); } F.DeleteClientFolder(userId, clientId); } response.isSuccess = true; response.msg = "deleted"; return(JsonConvert.SerializeObject(response, Formatting.None)); } catch (Exception e) { response.isSuccess = false; response.msg = e.Message; L.SendErrorLog(e, clientId, userId, "Clients", "Delete"); return(JsonConvert.SerializeObject(response, Formatting.None)); } }
public JsonResult OnGetLoadGameSelection() { Global.Response response = new Global.Response(); try { List <Rules> rules = _fortuneStreetAppContext.Rules.OrderBy(name => name.Name).ToList(); List <Boards> boards = _fortuneStreetAppContext.Boards.OrderBy(name => name.Name).ToList(); List <Colors> miiColors = _fortuneStreetAppContext.Colors.OrderBy(id => id.ID).ToList(); response.HTMLResponse = JsonSerializer.Serialize(new { Data = new Global.AnalyzerDataModel { GameSelection = new Global.AnalyzerDataModel.GameSelectionDataModel { RuleID = rules.FirstOrDefault().ID, BoardID = boards.FirstOrDefault().ID, ColorID = miiColors.FirstOrDefault().ID } }, Response = "<div id=\"settings-content\">" + "<div id=\"game-selection\">" + "<div>" + "<div>" + "<h5>Rules</h5>" + "</div>" + "<div>" + "<select class=\"form-select\">" + string.Join("", rules.Select(rule => "<option value=\"" + rule.ID + "\">" + rule.Name + "</option>")) + "</select>" + "</div>" + "</div>" + "<div>" + "<div>" + "<h5>Boards</h5>" + "</div>" + "<div>" + "<select class=\"form-select\">" + string.Join("", boards.Select(board => "<option value=\"" + board.ID + "\">" + board.Name + "</option>")) + "</select>" + "</div>" + "</div>" + "<div>" + "<div>" + "<h5>Mii Color</h5>" + "</div>" + "<div class=\"color-selection center-items\">" + string.Join("", miiColors.Select ( (color, index) => "<div>" + "<input type=\"hidden\" data-colorid=\"" + color.ID + "\" />" + "<div style=\"background-color: #" + color.MiiColor + "\"" + (index == 0 ? " class=\"selected\"" : "") + "></div>" + "</div>" )) + "</div>" + "</div>" + Global.CreateConfirmationActions("center-items", new List <string> { "<button type=\"button\" class=\"btn btn-lg btn-primary\" name=\"confirm\">Confirm</button>" }) + "</div>" + "</div>" }); return(new JsonResult(response)); } catch (Exception e) { return(Global.ServerErrorResponse(e)); } }
public Global.Response SendMail(string sendTo, string subject, string body, string lang, string file, bool send_cc) { Global.Response resp = new Global.Response(); if (!isSendMail || (!sendTo.Contains("@") && !sendTo.Contains("."))) { resp.isSuccess = true; return(resp); } try { string footer = ""; if (lang == "en") { myServerHost = myServerHost_en; myServerPort = myServerPort_en; myEmail = myEmail_en; myEmailName = myEmailName_en; myPassword = myPassword_en; footer = @" <br> <br> <br> <div><img alt=""nutriprog.com"" height=""40"" src=""https://www.nutriprog.com/assets/img/logo.svg"" style=""float:left"" width=""190"" /></div> <br> <br> <br> <div>IG PROG</div> <div><a href=""mailto:[email protected]?subject=Upit"">[email protected]</a></div> <div><a href = ""https://www.nutriprog.com"">www.nutriprog.com</a></div>"; } else { footer = @" <br> <br> <br> <div> <img alt=""ProgramPrehrane.com"" height=""40"" src=""https://www.programprehrane.com/assets/img/logo.svg"" style=""float:left"" width=""190"" /> </div> <br> <br> <br> <div style=""color:gray""> IG PROG - obrt za računalno programiranje<br> Ludvetov breg 5, 51000 Rijeka, HR<br> <a href=""tel:+385 98 330 966"">+385 98 330 966</a><br> <a href=""mailto:[email protected]?subject=Upit"">[email protected]</a><br> <a href=""https://www.programprehrane.com"">www.programprehrane.com</a> </div>"; } MailMessage mail = new MailMessage(); mail.From = new MailAddress(myEmail, myEmailName); mail.To.Add(sendTo); if (send_cc && sendTo != myEmail_cc) { mail.CC.Add(myEmail_cc); } mail.Subject = subject; mail.Body = string.Format(@" {0} {1}", body, footer); mail.IsBodyHtml = true; if (!string.IsNullOrEmpty(file)) { if (file.Contains("?")) { file = file.Remove(file.IndexOf("?")); } Attachment attachment = new Attachment(Server.MapPath(file.Replace("../", "~/"))); mail.Attachments.Add(attachment); } SmtpClient smtp = new SmtpClient(myServerHost, myServerPort); NetworkCredential Credentials = new NetworkCredential(myEmail, myPassword); smtp.Credentials = Credentials; smtp.EnableSsl = EnableSsl; smtp.Send(mail); resp.isSuccess = true; return(resp); } catch (Exception e) { resp.isSuccess = false; resp.msg = e.Message; L.SendErrorLog(e, subject, sendTo, "Mail", "SendMail"); return(resp); } }
public string SendOrder(NewOrder x, string lang) { Global.Response resp = new Global.Response(); try { Invoice.NewInvoice i = new Invoice.NewInvoice(); i.dateAndTime = DateTime.Now.ToString("dd.MM.yyyy, HH:mm"); i.year = DateTime.Now.Year; i.orderNumber = I.GetNextOrderNumber(); x.orderNumber = i.orderNumber; i.firstName = x.firstName; i.lastName = x.lastName; i.companyName = x.companyName; i.address = x.address; i.postalCode = x.postalCode; i.city = x.city; i.country = x.country; i.pin = x.pin; i.note = x.note; i.items = new List <Invoice.Item>(); Invoice.Item item = new Invoice.Item(); item.title = string.Format(@"{0} - {1} {2} {3}" , x.application , x.version , x.maxNumberOfUsers > 5 ? string.Format("({0} korisnika)", x.maxNumberOfUsers) : "" , string.Format("- {0} god. licenca", x.licence)); item.qty = Convert.ToInt32(x.licenceNumber); item.unitPrice = x.price; i.items.Add(item); if (x.discountCoeff > 0) { item = new Invoice.Item(); item.title = string.Format(@"Popust -{0}%", Math.Round(x.discountCoeff * 100, 0)); item.qty = 1; item.unitPrice = -Math.Round(x.price - x.priceWithDiscount, 2); i.items.Add(item); } i.total = x.discountCoeff > 0 ? x.priceWithDiscount * item.qty : x.price * item.qty; i.showSignature = true; i.isForeign = x.isForeign; i.docType = (int)Invoice.DocType.offer; if (x.maxNumberOfUsers > 5) { x.note = string.Format("{0}Pod-licence: {1}" , !string.IsNullOrWhiteSpace(x.note) ? string.Format("{0};", x.note) : "" , x.maxNumberOfUsers); } if (x.eInvoice) { x.note = string.Format("{0}e-Račun" , !string.IsNullOrWhiteSpace(x.note) ? string.Format("{0};", x.note) : ""); } if (string.IsNullOrEmpty(x.id)) { x.id = Guid.NewGuid().ToString(); } string path = HttpContext.Current.Server.MapPath("~/App_Data/" + dataBase); //db.CreateGlobalDataBase(path, db.orders); using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + dataBase))) { connection.Open(); string sql = @"INSERT INTO orders VALUES (@id, @orderNumber, @firstName, @lastName, @companyName, @address, @postalCode, @city, @country, @pin, @email, @ipAddress, @application, @version, @licence, @licenceNumber, @price, @priceEur, @orderDate, @additionalService, @note, @userGroupId, @discountCoeff)"; using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { command.Parameters.Add(new SQLiteParameter("id", x.id)); command.Parameters.Add(new SQLiteParameter("orderNumber", x.orderNumber)); command.Parameters.Add(new SQLiteParameter("firstName", x.firstName)); command.Parameters.Add(new SQLiteParameter("lastName", x.lastName)); command.Parameters.Add(new SQLiteParameter("companyName", x.companyName)); command.Parameters.Add(new SQLiteParameter("address", x.address)); command.Parameters.Add(new SQLiteParameter("postalCode", x.postalCode)); command.Parameters.Add(new SQLiteParameter("city", x.city)); command.Parameters.Add(new SQLiteParameter("country", x.country)); command.Parameters.Add(new SQLiteParameter("pin", x.pin)); command.Parameters.Add(new SQLiteParameter("email", x.email)); command.Parameters.Add(new SQLiteParameter("ipAddress", x.ipAddress)); command.Parameters.Add(new SQLiteParameter("application", x.application)); command.Parameters.Add(new SQLiteParameter("version", x.version)); command.Parameters.Add(new SQLiteParameter("licence", x.licence)); command.Parameters.Add(new SQLiteParameter("licenceNumber", x.licenceNumber)); command.Parameters.Add(new SQLiteParameter("price", x.price)); command.Parameters.Add(new SQLiteParameter("priceEur", x.priceEur)); command.Parameters.Add(new SQLiteParameter("orderDate", Convert.ToString(x.orderDate))); command.Parameters.Add(new SQLiteParameter("additionalService", x.additionalService)); command.Parameters.Add(new SQLiteParameter("note", x.note)); command.Parameters.Add(new SQLiteParameter("userGroupId", x.userGroupId)); command.Parameters.Add(new SQLiteParameter("discountCoeff", x.discountCoeff)); command.ExecuteNonQuery(); } } using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + usersDataBase))) { connection.Open(); string sql1 = string.Format(@"UPDATE Users SET CompanyName='{0}', Address='{1}', PostalCode='{2}', City='{3}', Country='{4}', Pin='{5}' WHERE email='{6}'", x.companyName, x.address, x.postalCode, x.city, x.country, x.pin, x.email); using (SQLiteCommand command = new SQLiteCommand(sql1, connection)) { command.ExecuteNonQuery(); } } PrintPdf PDF = new PrintPdf(); i.docType = (int)Invoice.DocType.offer; // i.totPrice_eur = x.priceEur; i.totPrice_eur = x.discountCoeff > 0 ? x.priceWithDiscountEur : x.priceEur; string offerPdf = PDF.CreateInvoicePdf(i); string offerPdfPath = !string.IsNullOrEmpty(offerPdf) ? string.Format("~/upload/invoice/temp/{0}.pdf", offerPdf) : null; Mail m = new Mail(); resp = m.SendOrder(x, lang, offerPdfPath); return(JsonConvert.SerializeObject(resp, Formatting.None)); } catch (Exception e) { resp.isSuccess = false; resp.msg = e.Message; L.SendErrorLog(e, x.id, x.email, "Orders", "SendOrder"); return(JsonConvert.SerializeObject(resp, Formatting.None)); } }
public Global.Response SendOrder(Orders.NewOrder order, string lang, string file) { Global.Response resp = new Global.Response(); try { //*****************Send mail to me**************** string messageSubject = "Nova narudžba"; string messageBody = string.Format( @" <h3>Nova Narudžba:</h3> <p>Ime i prezime: {0} {1},</p> <p>Tvrtka: {2}</p> <p>Ulica i broj: {3}</p> <p>Poštanski broj: {4}</p> <p>Grad: {5}</p> <p>Država: {6}</p> <p>OIB: {7}</p> <p>Email: {8}</p> <p>Verzija: {9} {10}</p> <p>Licenca: {11} ({12})</p> <p>Korisnici: {13}</p> <p>Cijena: {14} kn</p> <p>Broj ponude: {15}/{16}</p> <p>e-Račun: {17}</p> " , order.firstName , order.lastName , order.companyName , order.address , order.postalCode , order.city , order.country , order.pin , order.email , order.application , order.version , order.licenceNumber , GetLicenceDuration(order.licence) , order.version.ToLower() == "premium" ? order.maxNumberOfUsers.ToString() : null , order.price , order.orderNumber , DateTime.UtcNow.Year , order.eInvoice ? "DA" : "NE"); resp = SendMail(myEmail, messageSubject, messageBody, lang, null, true); //*****************Send mail to me**************** //************ Send mail to customer**************** messageSubject = string.Format("{0} - {1}", order.application, t.Tran("offer", lang)); // (order.application == "Program Prehrane 5.0" ? order.application : t.Tran("nutrition program web", lang)) + " - " + t.Tran("payment details", lang); messageBody = PaymentDetails(order, lang); resp = SendMail(order.email, messageSubject, messageBody, lang, file, false); //************ Send mail to customer**************** //if (sentToMe == false || sentToCustomer == false) { // resp.isSuccess = false; //} else { // resp.isSuccess = true; //} if (resp.isSuccess) { resp.msg = t.Tran("the order have been sent successfully", lang); } return(resp); } catch (Exception e) { resp.isSuccess = false; resp.msg = e.Message; L.SendErrorLog(e, order.id, order.id, "Mail", "SendOrder"); return(resp); } }