public void Update() { using (CallDB db = new CallDB()) { new UsersQuery(db).UpdateProfile(this); } }
public void Update2(int id) { using (CallDB db = new CallDB()) { new UsersQuery(db).UpdateProduto2(this, id); } }
public string save(string param) { string mode = JObject.Parse(param)["mode"].ToString(); string planno = JObject.Parse(param)["planno"].ToString(); string plandt = JObject.Parse(param)["plandt"].ToString(); string userid = JObject.Parse(param)["userid"].ToString(); string amt = JObject.Parse(param)["amt"].ToString(); string rmk = JObject.Parse(param)["rmk"].ToString(); string inuser = "******"; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "numeric", "planno", planno, "20"); fm.icnitMakeNode(dom, node, "varchar", "plandt", plandt, "10"); fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20"); fm.icnitMakeNode(dom, node, "numeric", "amt", amt, "20"); fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE41_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public string notice_save(string param) { string seq = JObject.Parse(param)["seq"].ToString(); string mode = JObject.Parse(param)["mode"].ToString(); string subject = JObject.Parse(param)["subject"].ToString(); string contents = JObject.Parse(param)["contents"].ToString(); string inuser = JObject.Parse(param)["inuser"].ToString(); FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "int", "seq", seq, "20"); fm.icnitMakeNode(dom, node, "varchar", "subject", subject, "20"); fm.icnitMakeNode(dom, node, "varchar", "contents", contents, "200"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"NOTICE_TEST_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public void Update(int id) { using (CallDB db = new CallDB()) { new UsersQuery(db).UpdatePedido(id); } }
public string save(string param) { string mode = JObject.Parse(param)["mode"].ToString(); string gbncd = JObject.Parse(param)["gbncd"].ToString(); string code = JObject.Parse(param)["code"].ToString(); string codenm = JObject.Parse(param)["codenm"].ToString(); string codeseq = JObject.Parse(param)["codeseq"].ToString(); string useyn = JObject.Parse(param)["useyn"].ToString(); string inuser = "******"; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "varchar", "gbncd", gbncd, "20"); fm.icnitMakeNode(dom, node, "varchar", "code", code, "20"); fm.icnitMakeNode(dom, node, "varchar", "codenm", codenm, "100"); fm.icnitMakeNode(dom, node, "int", "codeseq", codeseq, "20"); fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE17_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public string del(string param) { if (HttpContext.Current.Request.GetUserCookie("userid") == "") { return(""); } string stno = JObject.Parse(param)["stno"].ToString(); string inuser = "******"; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "stno", stno, "20"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE61_DEL"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public void Update(int id, string caminhoImagem) { using (CallDB db = new CallDB()) { new UsersQuery(db).UpdateProduto(this, caminhoImagem, id); } }
public string detail_search(string param) { if (HttpContext.Current.Request.GetUserCookie("userid") == "") { return(""); } string stno = JObject.Parse(param)["stno"].ToString(); FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "stno", stno, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE61_DETAIL_SEARCH"; dom.SelectSingleNode("//proc").InnerText = query; DataTable dt = CallDB.getExecuteDataTable(dom); return(dt.ToJson()); }
public string save(string param) { string mode = JObject.Parse(param)["mode"].ToString(); string itemcd = JObject.Parse(param)["itemcd"].ToString(); string itemnm = JObject.Parse(param)["itemnm"].ToString(); string sitemnm = JObject.Parse(param)["sitemnm"].ToString(); string eitemnm = JObject.Parse(param)["eitemnm"].ToString(); string ditemcd = JObject.Parse(param)["ditemcd"].ToString(); string spec = JObject.Parse(param)["spec"].ToString(); string width = JObject.Parse(param)["width"].ToString(); string height = JObject.Parse(param)["height"].ToString(); string qty = JObject.Parse(param)["qty"].ToString(); string sqm = JObject.Parse(param)["sqm"].ToString(); string unitprice = JObject.Parse(param)["unitprice"].ToString(); string safeqty = JObject.Parse(param)["safeqty"].ToString(); string comnm = JObject.Parse(param)["comnm"].ToString(); string statuscd = JObject.Parse(param)["statuscd"].ToString(); string rmk = JObject.Parse(param)["rmk"].ToString(); string useyn = JObject.Parse(param)["useyn"].ToString(); string inuser = "******"; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "varchar", "itemcd", itemcd, "20"); fm.icnitMakeNode(dom, node, "varchar", "itemnm", itemnm, "100"); fm.icnitMakeNode(dom, node, "varchar", "sitemnm", sitemnm, "50"); fm.icnitMakeNode(dom, node, "varchar", "eitemnm", eitemnm, "50"); fm.icnitMakeNode(dom, node, "varchar", "ditemcd", ditemcd, "20"); fm.icnitMakeNode(dom, node, "varchar", "spec", spec, "100"); fm.icnitMakeNode(dom, node, "int", "width", width, "20"); fm.icnitMakeNode(dom, node, "int", "height", height, "20"); fm.icnitMakeNode(dom, node, "numeric", "qty", qty, "20"); fm.icnitMakeNode(dom, node, "numeric", "sqm", sqm, "20"); fm.icnitMakeNode(dom, node, "numeric", "unitprice", unitprice, "20"); fm.icnitMakeNode(dom, node, "numeric", "safeqty", safeqty, "20"); fm.icnitMakeNode(dom, node, "varchar", "comnm", comnm, "200"); fm.icnitMakeNode(dom, node, "varchar", "statuscd", statuscd, "10"); fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000"); fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE12_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public bool Exist() { using (var db = new CallDB()) { db.conexao.Open(); var exist = new LoginQuery(db).Exist(this.Email); return(exist.Result); } }
public static bool EmailExist(string Email) { using (CallDB db = new CallDB())//Open { return(new DMLQuery(db).ExistData("usuario", new List <string> { "email" }, new List <string> { Email })); } }
public ActionResult Index(CheckoutModel model) { using (CallDB db = new CallDB()) { Order order = new Order().GetCardUser(AlgeCookieController.UserID); new Carrinho().Update(order.id_pedido); } return(RedirectToAction("Orders", "Home")); }
public static void ChangePassword(string newPassword, int UserID) { MD5 md5hash = MD5.Create(); string passwordHashed = PasswordProcedures.ToMD5Hash(newPassword); using (CallDB db = new CallDB()) { new UsersQuery(db).ChangePassword(passwordHashed, UserID); db.conexao.Close(); } }
public static UserProfileModel GetProfileModel(int userID) { using (CallDB db = new CallDB()) { var profile = new UsersQuery(db).GetProfile(userID); if (profile == null) { return(new UserProfileModel()); } return(profile); } }
public static void ChangeEmail(string emailFrom, string emailTo, string idUser) { using (CallDB db = new CallDB()) { new DMLQuery(db).UpdateData("usuario", new List <string> { "email" }, new List <string> { emailTo }, "id_usuario =" + idUser); db.conexao.Close(); } }
public static RegisterModel RegisterFaturamento(RegisterModel model, int userID) { using (CallDB db = new CallDB()) { new UsersQuery(db).UpdateDadosFaturamento(model, userID); } var Dados = GetDadosFaturamento(AlgeCookieController.UserID); return(Dados); }
public void RegisterProduto(string caminhoImg) { using (CallDB db = new CallDB()) { this.id_produto = new UsersQuery(db).RegisteProduto(this, caminhoImg); if (this.id_produto == 0) { throw new Exception(); } } }
public bool Login() { string loginPasswordHashed = ToMD5Hash(this.Senha); using (var db = new CallDB()) { db.conexao.OpenAsync(); var passwordHash = new LoginQuery(db).GetPasswordHash(this.Email).Result; return(loginPasswordHashed == passwordHash); } }
public static void RegisterUser(RegisterModel model) { using (CallDB db = new CallDB()) { model.Register_PasswordHash = PasswordProcedures.ToMD5Hash(model.Password); model.ID = new UsersQuery(db).RegisterUser(model); if (model.ID == 0) { throw new Exception(); } } }
public string save(string param) { if (HttpContext.Current.Request.GetUserCookie("userid") == "") { return(""); } string ss_userid = HttpContext.Current.Request.GetUserCookie("userid"); string mode = JObject.Parse(param)["mode"].ToString(); string locno = JObject.Parse(param)["locno"].ToString(); string whcd = JObject.Parse(param)["whcd"].ToString(); string typecd = JObject.Parse(param)["typecd"].ToString(); string typeno = JObject.Parse(param)["typeno"].ToString(); string colno = JObject.Parse(param)["colno"].ToString(); string ordseq = JObject.Parse(param)["ordseq"].ToString(); string rmk = JObject.Parse(param)["rmk"].ToString(); string useyn = JObject.Parse(param)["useyn"].ToString(); string inuser = ss_userid; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "varchar", "locno", locno, "20"); fm.icnitMakeNode(dom, node, "varchar", "whcd", whcd, "20"); fm.icnitMakeNode(dom, node, "varchar", "typecd", typecd, "10"); fm.icnitMakeNode(dom, node, "varchar", "typeno", typeno, "20"); fm.icnitMakeNode(dom, node, "varchar", "colno", colno, "20"); fm.icnitMakeNode(dom, node, "numeric", "ordseq", ordseq, "20"); fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "500"); fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE19_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public static RegisterModel GetDadosFaturamento(int userID) { using (CallDB db = new CallDB()) { if (FaturamentoExist(userID)) { var dadosFaturamento = new UsersQuery(db).GetFaturamento(userID); return(dadosFaturamento); } else { var dadosFaturamento = new RegisterModel(); return(dadosFaturamento); } } }
public string save(string param) { string mode = JObject.Parse(param)["mode"].ToString(); string userid = JObject.Parse(param)["userid"].ToString(); string usernm = JObject.Parse(param)["usernm"].ToString(); string email = JObject.Parse(param)["email"].ToString(); string hp = JObject.Parse(param)["hp"].ToString(); string jkcd = JObject.Parse(param)["jkcd"].ToString(); string deptcd = JObject.Parse(param)["deptcd"].ToString(); string addr = JObject.Parse(param)["addr"].ToString(); string filepath = JObject.Parse(param)["filepath"].ToString(); string pwd = JObject.Parse(param)["pwd"].ToString(); string useyn = JObject.Parse(param)["useyn"].ToString(); string inuser = "******"; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20"); fm.icnitMakeNode(dom, node, "varchar", "usernm", usernm, "50"); fm.icnitMakeNode(dom, node, "varchar", "email", email, "100"); fm.icnitMakeNode(dom, node, "varchar", "hp", hp, "50"); fm.icnitMakeNode(dom, node, "varchar", "jkcd", jkcd, "10"); fm.icnitMakeNode(dom, node, "varchar", "deptcd", deptcd, "20"); fm.icnitMakeNode(dom, node, "varchar", "addr", addr, "200"); fm.icnitMakeNode(dom, node, "varchar", "filepath", filepath, "200"); fm.icnitMakeNode(dom, node, "varchar", "pwd", pwd, "50"); fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE14_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
private void inserirItems(Carrinho model , int quantidade, string pedidoID ,double preco,int idproduto) { List<string> columns = new List<string>(); List<string> values = new List<string>(); ListHelper.AddKey(ref columns, ref values, "FK_PRODUTO", idproduto.ToString()); ListHelper.AddKey(ref columns, ref values, "FK_PEDIDO", pedidoID.ToString()); ListHelper.AddKey(ref columns, ref values, "texto_personalizado", model.texto_personalizado); ListHelper.AddKey(ref columns, ref values, "quantidade", quantidade.ToString()); ListHelper.AddKey(ref columns, ref values, "preco_produto_unidade", preco.ToString().Replace(',','.')); using (CallDB db = new CallDB()) { bool insert = db.InsertData("itens_pedido", columns, values); } }
public IActionResult Login(LoginModel model) { if (ModelState.IsValid) { if (model.Exist()) { using (var db = new CallDB()) { db.conexao.Open(); var loginModel = new LoginQuery(db).GetLoginModel(model.Email, model.ToMD5Hash(model.Senha)).Result; if (loginModel != null) { AlgeCookieController.LoggedByAdmin = false; AlgeCookieController.UserEmail = model.Email; AlgeCookieController.UserStatus = "logado"; AlgeCookieController.UserID = loginModel.ID; return RedirectToAction("Index", "Home"); } else { ViewBag.ErrorMessage = "Senha incorreta"; } } } else { ViewBag.ErrorMessage = "Usuário não encontrado"; } return View(model); } else { return RedirectToAction("Index"); } }
public IActionResult Detalhe(Carrinho model, int Id, int quantidade) { Produto produto = new Produto(); produto.texto_personalizado = model.texto_personalizado; produto.id_produto = Id; var itens = new UsersQuery().ReturnProdutos(Id); List<string> columns = new List<string>(); List<string> values = new List<string>(); ListHelper.AddKey(ref columns, ref values, "fk_usuario", AlgeCookieController.UserID.ToString()); ListHelper.AddKey(ref columns, ref values, "fk_status", "5");//5 carrinho bool retorno = new DMLQuery(new CallDB()).ExistData("pedido", columns, values); if (retorno == false) { int user = AlgeCookieController.UserID; using (CallDB db = new CallDB()) { int pedidoID = new UsersQuery(db).RegisterCart(user); inserirItems(model,quantidade, pedidoID.ToString(), itens.preco, itens.id_produto); } return RedirectToAction("Produto", "Home", new { idCarrinho = "" }); } else { Order order = new Order().GetCardUser(AlgeCookieController.UserID); inserirItems(model,quantidade, order.id_pedido.ToString(), itens.preco, itens.id_produto); return RedirectToAction("Produto", "Home", new { idCarrinho = "" }); } }
private void inserirItems(string pedidoID) { Cart cart = CartCookieController.ReturnCart(); for (int i = 0; i < cart.Product.Count; i++) { List <string> columns = new List <string>(); List <string> values = new List <string>(); ListHelper.AddKey(ref columns, ref values, "FK_PRODUTO", cart.Product[i].ProductID.ToString()); ListHelper.AddKey(ref columns, ref values, "FK_PEDIDO", pedidoID); ListHelper.AddKey(ref columns, ref values, "texto_personalizado", cart.Product[i].produtoCartFormat.Texto); ListHelper.AddKey(ref columns, ref values, "quantidade", cart.Product[i].produtoCartFormat.Quantidade.ToString()); ListHelper.AddKey(ref columns, ref values, "valor_total_itens", cart.Product[i].produtoCartFormat.Price.ToString().Replace(",", ".")); ListHelper.AddKey(ref columns, ref values, "preco_produto_unidade", cart.Product[i].produtoCartFormat.PrecoUnitario.ToString().Replace(",", ".")); CallDB db = new CallDB(DBSource.Alge_db); bool insert = db.InsertData("itens_pedido", columns, values); } }
public string selone(string param) { string menucd = JObject.Parse(param)["menucd"].ToString(); FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "menucd", menucd, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE16_SELONE"; dom.SelectSingleNode("//proc").InnerText = query; DataTable dt = CallDB.getExecuteDataTable(dom); return(dt.ToJson()); }
public string save(string param) { string mode = JObject.Parse(param)["mode"].ToString(); string whcd = JObject.Parse(param)["whcd"].ToString(); string whnm = JObject.Parse(param)["whnm"].ToString(); //string whnm2 = JObject.Parse(param)["whnm2"].ToString(); string brief = JObject.Parse(param)["brief"].ToString(); string tel = JObject.Parse(param)["tel"].ToString(); string addr = JObject.Parse(param)["addr"].ToString(); string useyn = JObject.Parse(param)["useyn"].ToString(); string inuser = "******"; FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10"); fm.icnitMakeNode(dom, node, "varchar", "whcd", whcd, "20"); fm.icnitMakeNode(dom, node, "varchar", "whnm", whnm, "50"); //fm.icnitMakeNode(dom, node, "varchar", "whnm2", whnm2, "200"); fm.icnitMakeNode(dom, node, "varchar", "brief", brief, "200"); fm.icnitMakeNode(dom, node, "varchar", "tel", tel, "50"); fm.icnitMakeNode(dom, node, "varchar", "addr", addr, "200"); fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1"); fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"PAGE13_SAVE"; dom.SelectSingleNode("//proc").InnerText = query; result result = CallDB.getXmlTrans(dom); return(JsonConvert.SerializeObject(result)); }
public string notice_search(string param) { string subject = JObject.Parse(param)["subject"].ToString(); FormManager fm = new FormManager(); XmlDocument dom = new XmlDocument(); dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>"); dom.SelectSingleNode("//act").InnerText = "proc"; XmlNode node; node = dom.CreateNode(XmlNodeType.Element, "zrow", ""); fm.icnitMakeNode(dom, node, "varchar", "subject", subject, "100"); dom.SelectSingleNode("//xmldata").AppendChild(node); string query = @"NOTICE_TEST_SEARCH"; dom.SelectSingleNode("//proc").InnerText = query; DataTable dt = CallDB.getExecuteDataTable(dom); return(dt.ToJson()); }