internal String saveUserEdition(HttpRequest f) { int ID = Int32.Parse(f.Form["id"]); DataClassesDataContext d = new DataClassesDataContext(); var query = from u in d.Users where u.UserID == ID select u; Users us = query.First(); us.Login = f.Form["login"]; us.Imie = f.Form["imie"]; us.Nazwisko = f.Form["nazwisko"]; us.PhoneCountryCode = f.Form["numerPanstwa"]; us.PhoneAreaCode = f.Form["numerWojewodztwa"]; us.PhoneNumber = f.Form["numerTelefonu"]; us.Street = f.Form["ulica"]; if (f.Form["rights"] != "") { us.CzyAdmin = int.Parse(f.Form["rights"]); } if (f.Form["numerDomu"] != "") { us.StreetNumber = int.Parse(f.Form["numerDomu"]); } if (f.Form["numerMieszkania"] != "") { us.FlatNumber = int.Parse(f.Form["numerMieszkania"]); } us.PostCode = f.Form["kodPocztowy"]; us.City = f.Form["miasto"]; d.SubmitChanges(); d.Dispose(); String result = "Zapisano zmiany." + editUser(ID); return(result); }
public static List<FormaPagtoResumido> ListarFormasPagto(UsuarioResumido Usuario) { DataClassesDataContext dcdc = new DataClassesDataContext(); /* SELECT * FROM ITCONPAGTO, FORMAPAGTO, TIPOPRAZO * WHERE * ITCONPAGTO.CodFrmPgt = FORMAPAGTO.CodFrmPgt AND * ITCONPAGTO.CodTipPrz = TIPOPRAZO.CodTipPrz and * codemp = 1 AND * FILTROVENDA = 1 * ORDER BY FORMAPAGTO.DesFrmPgt, FORMAPAGTO.CodFrmPgt * */ var dados = (from it in dcdc.ITCONPAGTOs join fp in dcdc.FORMAPAGTOs on it.CodFrmPgt equals fp.CodFrmPgt join tp in dcdc.TIPOPRAZOs on it.CodTipPrz equals tp.CodTipPrz where it.CodEmp.Equals(Usuario.CodEmp) where fp.FiltroVenda.Equals(1) orderby fp.DesFrmPgt orderby fp.CodFrmPgt select new FormaPagtoResumido ( it.CodEmp, fp.CodFrmPgt, tp.CodTipPrz, fp.DesFrmPgt, tp.DesTipPrz, String.Empty, String.Empty, fp.GeraParcelas.ToString() )).ToList(); //dcdc.Dispose(); String vrGeraParcelas = ""; String vrFormaPagto =""; foreach (FormaPagtoResumido item in dados) { if (vrGeraParcelas == "S" && item.CodFrmPgt.ToString() == vrFormaPagto) { vrGeraParcelas = item.GeraParcelas.ToString(); } else { item.ValorCombo = (item.CodFrmPgt.ToString() + "|" + item.CodTipPrz.ToString().Trim()); item.LinhaCombo = (item.CodFrmPgt.ToString("000") + " - " + item.DesFrmPgt.Trim()); vrFormaPagto = item.CodFrmPgt.ToString(); vrGeraParcelas = item.GeraParcelas.ToString(); } } dcdc.Dispose(); return dados; }
/// <summary> /// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. /// </summary> public void Dispose() { context.Dispose(); connection.Close(); connection.Dispose(); log.Flush(); log.Close(); log.Dispose(); }
internal String EditLanguage(int ID) { String result = "<form id=\"editLanguage\" name=\"editLanguage\" action=\"#\" method=\"post\"><ul>"; DataClassesDataContext d = new DataClassesDataContext(); var query = from j in d.Jezyki where j.JezykID == ID select j; result += "<li class=\"PAMenuItems\">Nazwa języka: <input name=\"nameOfLanguage\" type=\"text\" value=\"" + query.First().Nazwa + "\" /></li>"; result += "<input name=\"id\" type=\"hidden\" value=\"" + query.First().JezykID + "\" />"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editLanguage\").submit();\" />"; result += "</ul></form>"; d.Dispose(); return result; }
internal String EditLanguage(int ID) { String result = "<form id=\"editLanguage\" name=\"editLanguage\" action=\"#\" method=\"post\"><ul>"; DataClassesDataContext d = new DataClassesDataContext(); var query = from j in d.Jezyki where j.JezykID == ID select j; result += "<li class=\"PAMenuItems\">Nazwa języka: <input name=\"nameOfLanguage\" type=\"text\" value=\"" + query.First().Nazwa + "\" /></li>"; result += "<input name=\"id\" type=\"hidden\" value=\"" + query.First().JezykID + "\" />"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editLanguage\").submit();\" />"; result += "</ul></form>"; d.Dispose(); return(result); }
protected virtual void Dispose(bool isDisposing) { if (!_disposed) { if (isDisposing) { if (_db != null) { _db.Dispose(); } } } _disposed = true; }
private UserItemToRecover LoginAndMailValidation(String seekingLogin, String seekingMail) { DataClassesDataContext d = new DataClassesDataContext(); var query = from u in d.Users where ((u.Login == seekingLogin) && (u.E_mail == seekingMail)) select u; bool notEmpty = query.Any(); UserItemToRecover result; if( notEmpty ) { result = new UserItemToRecover(query.First().UserID); } else { result = null; } d.Dispose(); return result; }
internal String saveLanguageEdition(HttpRequest f) { int ID = Int32.Parse(f.Form["id"]); DataClassesDataContext d = new DataClassesDataContext(); var query = from j in d.Jezyki where j.JezykID == ID select j; var jz = query.First(); jz.Nazwa = f.Form["nameOfLanguage"]; d.SubmitChanges(); d.Dispose(); String result = "Zapisano zmiany."; result += "<p><a href=\"?content=ManageLanguages\">Powrót</a></p>"; return result; }
internal String insertCourse() { String result = "<form id=\"insertCourse\" name=\"insertCourse\" action=\"#\" method=\"post\">"; DataClassesDataContext d = new DataClassesDataContext(); result += "<ul>"; // JĘZYK result += "<li class=\"PAMenuItems\">Język kursu: <select name=\"language\">"; var languageQuery = from j in d.Jezyki select j; foreach (var r in languageQuery) { result += "<option value=\"" + r.JezykID + "\">" + r.Nazwa + "</option>"; } result += "</select></li>"; // POZIOM result += "<li class=\"PAMenuItems\">Poziom kursu: <select name=\"level\">"; var levelQuery = from p in d.Poziomy select p; foreach (var r in levelQuery) { result += "<option value=\"" + r.PoziomID + "\">" + r.Nazwa + "</option>"; } result += "</select></li>"; // PROWADZĄCY result += "<li class=\"PAMenuItems\">Prowadzący: <select name=\"teacher\">"; var teacherQuery = from u in d.Users select u; foreach (var r in teacherQuery) { result += "<option value=\"" + r.UserID + "\">" + r.Imie + " " + r.Nazwisko + "</option>"; } result += "</select></li>"; result += "<input name=\"type\" type=\"hidden\" value=\"1\" />"; result += "<input name=\"inserting\" type=\"hidden\" value=\"true\" />"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"insertCourse\").submit();\" />"; result += "</ul></form>"; d.Dispose(); return(result); }
public static Material Read(int id) { DataClassesDataContext d = new DataClassesDataContext(); var MaterialCollection = from m in d.Materialy where m.ID == id select m; if ( MaterialCollection.Count() == 1 ) { var Material = MaterialCollection.First(); Material ReturnObject = new Material(Material.ID, Material.CourseID, Material.Title, Material.Type, Material.FilePath); d.Dispose(); return ReturnObject; } else { throw new HttpResponseException(HttpStatusCode.NotFound); } }
internal String saveLanguageEdition(HttpRequest f) { int ID = Int32.Parse(f.Form["id"]); DataClassesDataContext d = new DataClassesDataContext(); var query = from j in d.Jezyki where j.JezykID == ID select j; var jz = query.First(); jz.Nazwa = f.Form["nameOfLanguage"]; d.SubmitChanges(); d.Dispose(); String result = "Zapisano zmiany."; result += "<p><a href=\"?content=ManageLanguages\">Powrót</a></p>"; return(result); }
public void cadastrarLaboratorio (String lb_Numero, int lb_Capacidade, String projetor, String arcondicionado) { using (DataClassesDataContext db = new DataClassesDataContext()) { tb_Laboratorio novoLaboratorio = new tb_Laboratorio(); novoLaboratorio.lb_Numero = lb_Numero; novoLaboratorio.lb_Capacidade = lb_Capacidade; novoLaboratorio.lb_Projeto = projetor; novoLaboratorio.lb_Arcondicionado = arcondicionado; db.tb_Laboratorios.InsertOnSubmit(novoLaboratorio); db.SubmitChanges(); db.Dispose(); }; }
public void cadastrarOcorrencia(String ocorrencia, String LabsNome) { using (DataClassesDataContext db = new DataClassesDataContext()) { var idLaboratorio = Convert.ToInt32((from p in db.tb_Laboratorios where p.lb_Numero.Equals(LabsNome) select p.id_Laboratorio).FirstOrDefault()); tb_Ocorrencia novaOcorrencia = new tb_Ocorrencia(); novaOcorrencia.oc_descricao = ocorrencia; novaOcorrencia.id_Laboratorio = idLaboratorio; novaOcorrencia.id_Usuario = Sessao.UsuarioLogado; db.tb_Ocorrencias.InsertOnSubmit(novaOcorrencia); db.SubmitChanges(); db.Dispose(); }; }
public static Material Read(int id) { DataClassesDataContext d = new DataClassesDataContext(); var MaterialCollection = from m in d.Materialy where m.ID == id select m; if (MaterialCollection.Count() == 1) { var Material = MaterialCollection.First(); Material ReturnObject = new Material(Material.ID, Material.CourseID, Material.Title, Material.Type, Material.FilePath); d.Dispose(); return(ReturnObject); } else { throw new HttpResponseException(HttpStatusCode.NotFound); } }
private UserItemToRecover LoginAndMailValidation(String seekingLogin, String seekingMail) { DataClassesDataContext d = new DataClassesDataContext(); var query = from u in d.Users where ((u.Login == seekingLogin) && (u.E_mail == seekingMail)) select u; bool notEmpty = query.Any(); UserItemToRecover result; if (notEmpty) { result = new UserItemToRecover(query.First().UserID); } else { result = null; } d.Dispose(); return(result); }
public void editarLaboratorio (int idLaboratorio, String lb_Numero, int lb_Capacidade, String projetor, String arcondicionado) { using (DataClassesDataContext db = new DataClassesDataContext()) { tb_Laboratorio resultado = (from p in db.tb_Laboratorios where p.id_Laboratorio.Equals(idLaboratorio) select p).SingleOrDefault(); resultado.lb_Numero = lb_Numero; resultado.lb_Capacidade = lb_Capacidade; resultado.lb_Projeto = projetor; resultado.lb_Arcondicionado = arcondicionado; db.SubmitChanges(); db.Dispose(); }; }
public static List<ParametroResumido> GetParametro(int CodEmp) { DataClassesDataContext dcdc = new DataClassesDataContext(); List<ParametroResumido> parametros = new List<ParametroResumido>(); dcdc.PARAMETROs.Where(e => e.CodEmp == CodEmp).ToList().ForEach(e => parametros.Add(new ParametroResumido( e.CodEmp, e.TipMovPedPALM == null ? 0 : e.TipMovPedPALM, e.TipMovPedPALMFE == null ? 0 : e.TipMovPedPALMFE, e.CodTipPrc == null ? 0 : e.CodTipPrc, e.CodTipPrz == null ? 0 : e.CodTipPrz, e.NumPedIni == null ? 0 : e.NumPedIni, e.PARA_CasasDecimais == null ? '2' : e.PARA_CasasDecimais, e.Prioridade_Cliente == null ? 0 : e.Prioridade_Cliente, e.Prioridade_Merc == null ? 0 : e.Prioridade_Merc, e.Prioridade_Repr == null ? 0 : e.Prioridade_Repr, e.Prioridade_Tab == null ? 0 : e.Prioridade_Tab, e.PARA_PriorGrupo == null ? 0 : e.PARA_PriorGrupo, e.PERCBLOQUEIO, e.SaldoPed, (e.PARA_UnidadeVenda == null ? 0 : e.PARA_UnidadeVenda), e.CondicaoTabLivreWeb, e.ExibirRazaoSocial, e.HostFtp, e.FtpUsuario, e.FtpSenha, e.PastaServidor, e.LayoutCombo))); dcdc.Dispose(); return parametros; }
public void cadastrarComputador(String nomePC, String mRam, String processador, String plMae, String stPC, int lab) { using (DataClassesDataContext db = new DataClassesDataContext()) { tb_Computador novoComputador = new tb_Computador(); novoComputador.nm_Computador = nomePC; novoComputador.plMae_Computador = plMae; novoComputador.st_Computador = stPC; novoComputador.mRam_Computador = mRam; novoComputador.processador_Computador = processador; novoComputador.id_Laboratorio = lab; db.tb_Computadors.InsertOnSubmit(novoComputador); db.SubmitChanges(); db.Dispose(); }; }
internal String editUser(int ID) { AdminRightsChecker userRights = new AdminRightsChecker(ID); String result = "<form id=\"editUser\" name=\"editUser\" action=\"#\" method=\"post\"><ul>"; DataClassesDataContext d = new DataClassesDataContext(); var query = from u in d.Users where u.UserID == ID select u; result += "<li class=\"PAMenuItems\">Login: <input name=\"login\" type=\"text\" value=\"" + query.First().Login + "\" /></li>"; result += "<li class=\"PAMenuItems\">Imię: <input name=\"imie\" type=\"text\" value=\"" + query.First().Imie + "\" /></li>"; result += "<li class=\"PAMenuItems\">Nazwisko: <input name=\"nazwisko\" type=\"text\" value=\"" + query.First().Nazwisko + "\" /></li>"; result += "<li class=\"PAMenuItems\">Numer telefonu: +<input name=\"numerPanstwa\" type=\"text\" value=\"" + query.First().PhoneCountryCode + "\" />(<input name=\"numerWojewodztwa\" type=\"text\" value=\"" + query.First().PhoneAreaCode + "\" />)<input name=\"numerTelefonu\" type=\"text\" value=\"" + query.First().PhoneNumber + "\" /></li>"; result += "<li class=\"PAMenuItems\">Adres:</li><li class=\"PAMenuItems\">Ulica: <input name=\"ulica\" type=\"text\" value=\"" + query.First().Street + "\" /><input name=\"numerDomu\" type=\"text\" value=\"" + query.First().StreetNumber + "\" />, mieszkania <input name=\"numerMieszkania\" type=\"text\" value=\"" + query.First().FlatNumber + "\" /></li>"; result += "<li class=\"PAMenuItems\">Kod pocztowy: <input name=\"kodPocztowy\" type=\"text\" value=\"" + query.First().PostCode + "\" /> Miasto: <input name=\"miasto\" type=\"text\" value=\"" + query.First().City + "\" /></li>"; result += "<li class=\"PAMenuItems\">Uprawnienia użytkownika: <select name=\"rights\"><option value=\"1\""; if (userRights.CzyAdmin()) { result += " selected=\"selected\""; } result += ">Administrator</option><option value=\"2\""; if (!(userRights.CzyAdmin()) && (userRights.CzySek())) { result += " selected=\"selected\""; } result += ">Sekretariat</option><option value=\"3\""; if (!(userRights.CzyAdmin()) && !(userRights.CzySek())) { result += " selected=\"selected\""; } result += ">Użytkownik</option></select></li>"; result += "<input name=\"id\" type=\"hidden\" value=\"" + query.First().UserID + "\" />"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editUser\").submit();\" />"; result += "</ul></form>"; result += "<p><a href=\"?content=ShowUsers\">Powrót do listy użytkowników</a><br /><a href=\"?content=\">Powrót do panelu administracyjnego</a></p>"; d.Dispose(); return(result); }
internal String ShowUsers() { AdminRightsChecker rights = new AdminRightsChecker(Request.Cookies["user"], Session); String result = "<table><tr><td>Login</td><td>E-mail</td><td>Imie</td><td>Nazwisko</td><td>Numer kierunkowy (państwa)</td><td>Numer kierunkowy (województwo)</td><td>Numer telefonu</td><td>Ulica</td><td>Numer ulicy</td><td>Numer domu</td><td>Kod pocztowy</td><td>Miasto</td><td></td><td></td></tr>"; DataClassesDataContext d = new DataClassesDataContext(); List <Users> l = d.Users.ToList(); foreach (var k in l) { result += "<tr><td>" + k.Login + "</td><td>" + k.E_mail + "</td><td>" + k.Imie + "</td><td>" + k.Nazwisko + "</td><td>" + k.PhoneCountryCode + "</td><td>" + k.PhoneAreaCode + "</td><td>" + k.PhoneNumber + "</td><td>" + k.Street + "</td><td>" + k.StreetNumber + "</td><td>" + k.FlatNumber + "</td><td>" + k.PostCode + "</td><td>" + k.City + "</td>"; if (rights.CzyAdmin()) { result += "<td><a href=\"?content=EditUsers&ID=" + k.UserID + "\">edycja</a></td><td><a href=\"?content=DeleteUsers&ID=" + k.UserID + "\">usuń</a></td></tr>"; } else { result += "<td></td><td></td></tr>"; } } result += "</table>"; result += "<p><a href=\"?content=\">Powrót</a></p>"; d.Dispose(); return(result); }
public static Boolean RemoverReservaItemPedidoWeb(UsuarioResumido Usuario, Int32 NumPedWeb, Int32 CodServMerc) { DataClassesDataContext dcdc = new DataClassesDataContext(); var Item = dcdc.ITPEDIDOWEBs.FirstOrDefault(p => p.NUMPEDWEB == NumPedWeb && p.CODSERVMERC == CodServMerc && p.CODEMP == Usuario.CodEmp && p.CODUSU == Usuario.CodUsu); dcdc.ITPEDIDOWEBs.DeleteOnSubmit(Item); //EXECUTA PROCEDURE PARA CORRIGIR QTD RESERVADA SE O PEDIDO NAO FOI GRAVADO. dcdc.sp_corrige_reserva_webpedido(); dcdc.SubmitChanges(); dcdc.Dispose(); return true; }
public static int InserePedido( UsuarioResumido u, ParametroResumido pr, int codVendedor, int codCliente, string observacao, int codFormaPagto, int codCondPagto, List<ProdutoResumido> produtos, int codEmp, Int32 NumPedWeb, Int32 NumPed, decimal DescontoPedido, int CodPrc_Tab, int CodPrz_Tab, int UnidadeVenda, int iCodTipMov) { Decimal TotalComissao = 0; Decimal TotalComissaoTelev = 0; ClasseBanco csBanco = new ClasseBanco(); //verifica se tem itens na grid if (produtos.Count.ToString() == "0") { //throw new Exception("Não há produtos digitados."); return 0; } try { DataClassesDataContext dcdc = new DataClassesDataContext(); decimal cPesoTotal = 0; decimal comissao_televend = 0; decimal comissao_vendedor = 0; int iIncideTelev = 0; int iIncideVend = 0; int CodTipMov = ValidaMovimentacao(codCliente, codEmp, iCodTipMov); if (CodTipMov == 0) { throw new Exception("Não há Tipo de Movimentação Padrão cadastrada nos Parâmetros de Venda."); } /*51287*/ string varCLIE_IPISuspenso = dcdc.CLIENTEs.FirstOrDefault(cli => cli.CodCli == codCliente).CLIE_IPISuspenso.ToString(); PEDIDO p = new PEDIDO(); p.CodEmp = (short)codEmp; //FABIANO - 12/10/2011 - N.42120 //Buscar o segundo vendedor da VENDCLI e sua comissao. (TELEVENDEDOR) //49637 - Adicionado CODEMP na clausula where //var sSql = "SELECT CodVen, COMISSAOTELEV, INCIDE FROM VENDCLI INNER JOIN VENDEDOR ON VENDCLI.CodVen = VENDEDOR.CodVend" + //" WHERE CodCli = " + codCliente + " AND CodVen <> " + codVendedor + ""; var sSql = "SELECT CodVen, COMISSAOTELEV, INCIDE FROM VENDCLI INNER JOIN VENDEDOR ON VENDCLI.CodVen = VENDEDOR.CodVend" + " WHERE CodCli = " + codCliente + " AND CodVen <> " + codVendedor + " AND CODEMP = " + p.CodEmp; var televendedor = csBanco.Query(sSql); p.TelVend_Pedido = null; if (televendedor.Read()) { if (televendedor[0].ToString() != "") //CODVEN { p.TelVend_Pedido = Convert.ToInt16(televendedor[0].ToString()); } if (televendedor[1].ToString()!="") //COMISSAO { comissao_televend = Convert.ToDecimal(televendedor[1].ToString()); } if (televendedor[2].ToString() != "") //INCIDE { iIncideTelev = Convert.ToInt16(televendedor[2].ToString()); } } televendedor.Close(); //Busca comissao do vendedor principal e o setor na vendcli sSql = "SELECT SETOR, Comissao, Incide" + " FROM " + " VENDCLI INNER JOIN VENDEDOR ON VENDCLI.CodVen = VENDEDOR.CodVend " + " WHERE 1=1 " + " AND CodCli = " + codCliente + "" + " AND CodVen = " + codVendedor + ""; var r = csBanco.Query(sSql); if (r.Read()) { p.SETOR = r[0].ToString(); //43573 if (r[1].ToString()!="") //COMISSAO { comissao_vendedor = Convert.ToDecimal(r[1].ToString()); } if (r[2].ToString() != "") //INCIDE { iIncideVend = Convert.ToInt16(r[2].ToString()); } } r.Close(); //Busca parametro sistema r = csBanco.Query("SELECT conteudo FROM parametrosist WHERE descparametro = 'BloqPedConf' AND codemp = " + codEmp); if (r.Read()) { //Se Bloqueia por conferencia ou nao //Se = 'S' bloqueia com DIV (Divergencia), senao grava null p.RESCONFER = r[0].ToString() == "S" ? "DIV" : null; } r.Close(); //Validacao PEDIDO X PEDIDOWEB r = csBanco.Query("SELECT NUMPED FROM PEDIDO WHERE codemp = " + codEmp + " AND NUMPED = " + NumPedWeb + " AND NUMPEDWEB = " + NumPed + ""); if (r.Read()) { throw new Exception("Pedido " + NumPed + " já cadastrado."); } r.Close(); //Campos fixos p.Origem = 'W'; //43573 //p.StatusComercial = "BCF"; // bloqueado para conferência (default) p.PesoBruto = 0; p.Volume = 0; p.Carga = 1; p.SubCarga = 1; p.Comissao = 0; p.VlrFrete_Pedido = 0; p.Origem_Pedido = "VENDEDOR"; p.Tipo_Pedido = "PEDIDO"; p.USUCAD = u.NomUsu; //43573 p.SitPed = "ABE"; p.HoraCad = DateTime.Now; //43573 p.Hora = DateTime.Now; p.DtaEmi = DateTime.Today; //DateTime.Now; p.DtaEnt = DateTime.Today; p.DtaFat = DateTime.Today; //Campos dinamicos p.PercDes = DescontoPedido; p.CodVen = (short)codVendedor; p.CodCli = (int)codCliente; p.CodTipMov = Convert.ToInt16(CodTipMov); p.NumPedWeb = NumPedWeb; p.NumPed = NumPed; //Agora buscando de forma diferente p.CodPgt = (short)codCondPagto; p.CodFrmPgt = (short)codFormaPagto; /*Alterado forma de pegar tabela de preco. Agora pega da combo, pois pode ser diferente do padrao configurado no sigma - Regras alteradas por solicitacao do cliente Bagetti - 13/03/2013 - Fabiano p.CodigoTab = Convert.ToInt16(pr.CodTipPrc); p.CodPrzTab = Convert.ToInt16(pr.CodTipPrz); */ p.CodigoTab = (short)CodPrc_Tab; p.CodPrzTab = (short)CodPrz_Tab; p.Obs = observacao; p.Vlrtot = (decimal)produtos.Sum(p2 => p2.TotalParcial) - ((decimal)produtos.Sum(p2 => p2.TotalParcial) * DescontoPedido/100); p.NomUsu = u.NomUsu; p.Usuario = u.NomUsu; p.VlrSubTot = (decimal)produtos.Sum(p2 => p2.TotalParcial); p.VlrDes1 = ((decimal)produtos.Sum(p2 => p2.TotalParcial) * DescontoPedido / 100); p.PesoLiq = 0; //produtos.ForEach(prood => p.PesoLiq += dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc == prood.Codigo).PesoLiq * prood.Quantidade); //produtos.ForEach(prood => p.PesoLiq += Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc == prood.Codigo).PesoLiq)) * prood.Quantidade); //produtos.ForEach(prood => p.PesoBruto += dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc == prood.Codigo).PesoBruto * prood.Quantidade); //produtos.ForEach(prood => p.PesoBruto += Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc == prood.Codigo).PesoBruto)) * prood.Quantidade); string sValidaIPI = "", sIncidenciaDescBaseIpi=""; /*51667 - BIERHOFF*/ r = csBanco.Query("SELECT CALCULAIPI, CALCIPIDESC FROM NATOPER WHERE CODIGO = " + iCodTipMov); if (r.Read()) { sValidaIPI = r["CALCULAIPI"].ToString(); sIncidenciaDescBaseIpi = r["CALCIPIDESC"].ToString(); } r.Close(); //<<51667 decimal cQtdTributavel = 0; decimal cVlrTributavel = 0; decimal cVlrIpi = 0; decimal cVlrPis = 0; decimal cVlrCofins = 0; decimal cQtdEmb = 0; decimal cPercIpi = 0; //<<51667 dcdc.PEDIDOs.InsertOnSubmit(p); foreach (ProdutoResumido produto in produtos) { ITENSPED itped = new ITENSPED(); /* Verifica qual unidade de venda * 0 = Menor Unidade (Padrão) * 2 = Maior Unidade (Selecionada pelo usuário) */ int iUniVend = produto.UnidadeVenda == "0" ? 0 : 2; itped.Consignacao = 'N'; itped.Itp_CodTabPrz = produto.Itp_CodTabPrz; itped.Reserva = Convert.ToChar(pr.SaldoPed); itped.CodEmp = (short)codEmp; itped.Qtd = (decimal)produto.Quantidade; itped.Item = (short)(produtos.IndexOf(produto) + 1); itped.CodServMerc = produto.Codigo; //Comissao Tabela de Preco r = csBanco.Query("SELECT COMISSAO, FATOR FROM FATORES WHERE CODSERVMERC = " + produto.Codigo + " AND CodTipPrc = " + CodPrc_Tab + " AND CodTipPrz = " + produto.Itp_CodTabPrz + ""); decimal dComissaoTabela=0; if (r.Read()) { dComissaoTabela = Convert.ToDecimal(r["COMISSAO"].ToString()); } r.Close(); itped.NumPed = NumPed; //SERVMERC servMercadoria = dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc == produto.Codigo); r = csBanco.Query("SELECT QTDEMB, VALORPIS, VALORCOFINS, IPI, SERV_VALORIPI, PercDesc, Aliquota, Saldo, PesoLiq, PesoBruto FROM SERVMERC WHERE CODSERVMERC = " + produto.Codigo + ""); if (r.Read()) { itped.DescMax = Convert.ToDecimal(r["PercDesc"].ToString()); itped.Aliquota = Convert.ToDecimal(r["Aliquota"].ToString()); itped.Saldo = (decimal)(Convert.ToDecimal(r["Saldo"].ToString()) - (decimal)produto.Quantidade); //Bug com LinqToSql , tivemos que fazer calculo manualmente... var cLiq = Convert.ToDecimal(r["PesoLiq"].ToString()); p.PesoLiq += cLiq * produto.Quantidade; var cBruto = Convert.ToDecimal(r["PesoBruto"].ToString()); p.PesoBruto += cBruto * produto.Quantidade; //<<51667 cPercIpi = Convert.ToDecimal(r["IPI"] == null ? "0" : r["IPI"].ToString()); cVlrIpi = Convert.ToDecimal(r["SERV_VALORIPI"] == null ? "0" : r["SERV_VALORIPI"].ToString()); cVlrPis = Convert.ToDecimal(r["VALORPIS"].ToString() == "" ? "0" : r["VALORPIS"].ToString()); cVlrCofins = Convert.ToDecimal(r["VALORCOFINS"].ToString() == "" ? "0" : r["VALORCOFINS"].ToString()); cQtdEmb = Convert.ToDecimal(r["QTDEMB"].ToString() == "" ? "0" : r["QTDEMB"].ToString()); //<<51667 } r.Close(); cPesoTotal = cPesoTotal + produto.Peso; itped.VlrProm = 0; itped.UniVenda = (short)iUniVend; if (produto.QtdCaixa == 0) { produto.QtdCaixa = 1; } //Maior e menor unidade decimal cQtdSolicitada = (Convert.ToDecimal(produto.Quantidade) / Convert.ToDecimal(produto.QtdCaixa)); //String.Format("{0:" + Funcoes.Decimais(pr) + "}", products.Sum(p => p.TotalParcial)); //itped.VlrUni = iUniVend == 2 ? (double)(Convert.ToDecimal(produto.Preco) / Convert.ToDecimal(produto.Quantidade)) : (double)produto.Preco; //itped.VlrReal = iUniVend == 2 ? (decimal)produto.Preco / cQtdSolicitada : (decimal)produto.Preco; //itped.VLRUNIVENDA = iUniVend == 2 ? (double)produto.Preco / (double)cQtdSolicitada : (double)produto.Preco; //itped.QTDUNIVENDA = iUniVend == 2 ? cQtdSolicitada : produto.Quantidade; //if (iUniVend == 2) //{ // itped.VLRUNIVENDALIQ = ((double)produto.Preco / (double)cQtdSolicitada) - Convert.ToDouble(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (((double)produto.Preco / (double)cQtdSolicitada) * ((double)produto.Desconto / 100)))); //} //else //{ // itped.VLRUNIVENDALIQ = (double)produto.Preco - Convert.ToDouble(String.Format("{0:" + Funcoes.Decimais(pr) + "}", ((double)produto.Preco * (double)produto.Desconto / 100))); //} //49199 string sPrecoUnitario, sPrecoUnitarioReal, sPrecoUnitarioOriginal; decimal dValorUnitarioLiq; if (iUniVend == 2) { sPrecoUnitario = String.Format("{0:" + Funcoes.Decimais(pr) + "}", (double)(Convert.ToDecimal(produto.Preco) / Convert.ToDecimal(produto.Quantidade))); sPrecoUnitarioReal = String.Format("{0:" + Funcoes.Decimais(pr) + "}", (decimal)produto.Preco / cQtdSolicitada); sPrecoUnitarioOriginal = String.Format("{0:" + Funcoes.Decimais(pr) + "}", (decimal)produto.PrecoReal / cQtdSolicitada); } else { sPrecoUnitario = String.Format("{0:" + Funcoes.Decimais(pr) + "}", (double)produto.Preco); sPrecoUnitarioReal = sPrecoUnitario; sPrecoUnitarioOriginal = String.Format("{0:" + Funcoes.Decimais(pr) + "}", (double)produto.PrecoReal); } itped.ValorIpi = 0; itped.BASEIPI = 0; itped.ALIQIPI = 0; itped.IPIUNIVENDA = 0; /*51954*///Calcular o Valor unitario liquido antes do calculo da Qtd e Vlr tributavel IPI if (iUniVend == 2) { //itped.VLRUNIVENDALIQ = ((double)produto.Preco / (double)cQtdSolicitada) - Convert.ToDouble(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (((double)produto.Preco / (double)cQtdSolicitada) * ((double)produto.Desconto / 100)))); dValorUnitarioLiq = (Convert.ToDecimal(sPrecoUnitarioReal) - (Convert.ToDecimal(sPrecoUnitarioReal) * produto.Desconto / 100)); } else { //itped.VLRUNIVENDALIQ = (double)produto.Preco - Convert.ToDouble(String.Format("{0:" + Funcoes.Decimais(pr) + "}", ((double)produto.Preco * (double)produto.Desconto / 100))); dValorUnitarioLiq = (Convert.ToDecimal(sPrecoUnitario) - (Convert.ToDecimal(sPrecoUnitario) * produto.Desconto / 100)); } dValorUnitarioLiq = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", dValorUnitarioLiq)); //>>51667 //51954 - Considerar o valor unitario liquido. if (sValidaIPI == "S") { /* Se valida IPI */ if (cPercIpi <= 0) /* Se percentual do IPI for zero, considerar valor*/ { cVlrTributavel = Convert.ToDecimal(dValorUnitarioLiq) / (cQtdEmb == 0 ? 1 : cQtdEmb); cQtdTributavel = (decimal)itped.Qtd * (cQtdEmb == 0 ? 1 : cQtdEmb); /*51827*/ if (cVlrIpi > 0) /* Se houver valor de IPI no cadastro da mercadoria*/ { //itped.ValorIpi = cQtdTributavel * cVlrIpi; /*Tratar casas decimais*/ itped.ValorIpi = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (cQtdTributavel * cVlrIpi))); itped.BASEIPI = (decimal)itped.Qtd * Convert.ToDecimal(dValorUnitarioLiq); itped.ALIQIPI = 0; itped.IPIUNIVENDA = itped.ValorIpi; } } else if (cPercIpi > 0) /* Existe Percentual IPI */ { cVlrTributavel = Convert.ToDecimal(dValorUnitarioLiq); cQtdTributavel = (decimal)itped.Qtd; /*51827*/ itped.BASEIPI = cQtdTributavel * Convert.ToDecimal(dValorUnitarioLiq); //itped.ValorIpi = ((itped.BASEIPI * cPercIpi) / 100); /*Tratar casas decimais*/ itped.ValorIpi = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", ((itped.BASEIPI * cPercIpi) / 100))); itped.IPIUNIVENDA = itped.ValorIpi; /* Verificar incidencias sobre base IPI ?*/ itped.ALIQIPI = cPercIpi; } if (sIncidenciaDescBaseIpi.Equals("S")) { itped.BASEIPI = itped.BASEIPI - Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (itped.BASEIPI * DescontoPedido / 100))); } /*51827*/ if (varCLIE_IPISuspenso.Equals("S")) /* Se cliente for suspenso IPI, zera valores calculados*/ { itped.ValorIpi = 0; itped.BASEIPI = 0; itped.ALIQIPI = 0; itped.IPIUNIVENDA = 0; } } /*Não validad IPI*/ else { if (cVlrPis > 0 || cVlrCofins > 0) { cVlrTributavel = Convert.ToDecimal(dValorUnitarioLiq) / (cQtdEmb == 0 ? 1 : cQtdEmb); cQtdTributavel = (decimal)itped.Qtd * (cQtdEmb == 0 ? 1 : cQtdEmb); } else { cVlrTributavel = Convert.ToDecimal(dValorUnitarioLiq); cQtdTributavel = (decimal)itped.Qtd; } } itped.QTDTRIBUTAVEL = cQtdTributavel; itped.VLRTRIBUTAVEL = cVlrTributavel; //<<51667 itped.VlrUni = Convert.ToDouble(sPrecoUnitario); //itped.VlrReal = Convert.ToDecimal(sPrecoUnitarioReal); itped.VlrReal = Convert.ToDecimal(sPrecoUnitarioOriginal); itped.VLRUNIVENDA = Convert.ToDouble(sPrecoUnitarioReal); itped.QTDUNIVENDA = iUniVend == 2 ? cQtdSolicitada : produto.Quantidade; /*51954*/ //if (iUniVend == 2) //{ // //itped.VLRUNIVENDALIQ = ((double)produto.Preco / (double)cQtdSolicitada) - Convert.ToDouble(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (((double)produto.Preco / (double)cQtdSolicitada) * ((double)produto.Desconto / 100)))); // dValorUnitarioLiq = (Convert.ToDecimal(sPrecoUnitarioReal) - (Convert.ToDecimal(sPrecoUnitarioReal) * produto.Desconto / 100)); //} //else //{ // //itped.VLRUNIVENDALIQ = (double)produto.Preco - Convert.ToDouble(String.Format("{0:" + Funcoes.Decimais(pr) + "}", ((double)produto.Preco * (double)produto.Desconto / 100))); // dValorUnitarioLiq = (Convert.ToDecimal(sPrecoUnitario) - (Convert.ToDecimal(sPrecoUnitario) * produto.Desconto / 100)); //} //dValorUnitarioLiq = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", dValorUnitarioLiq)); itped.VLRUNIVENDALIQ = Convert.ToDouble(dValorUnitarioLiq); itped.QtdCan = 0; itped.QTDCANUNIVENDA = 0; itped.QtdTroca = 0; itped.VlrDes = produto.Desconto; //FABIANO - 07/10/2011 itped.ValorDesconto = 0; itped.VlrDescRateio = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (((decimal)itped.VLRUNIVENDALIQ * DescontoPedido / 100) * (decimal)itped.Qtd))); itped.PerDescRateio = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", DescontoPedido)); itped.PercDescGordura = 0; itped.VLRADICIONAL = 0; itped.VLREMBALAGEM = 0; itped.VlrComiss = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (decimal)ClasseComissao.CalculaComissao(pr, Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", iUniVend == 2 ? (double)(Convert.ToDecimal(itped.VLRUNIVENDALIQ) / Convert.ToDecimal(produto.QtdCaixa)) : (double)itped.VLRUNIVENDALIQ)), (decimal)itped.Qtd, 0, 0, comissao_vendedor, dComissaoTabela, produto.Comissao, produto.Comissao, "N", 0, 0, produto.Comissao, (decimal)comissao_televend, (Int16)iIncideVend, (Int16)iIncideTelev, (Int32)produto.Codigo, produto.Desconto))); itped.ComissaoUsada = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (decimal)ClasseComissao.ComissaoUsada)); //VALOR DA COMISSAO TELEVENDEDOR itped.COMISSAOTELEV = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", (decimal)ClasseComissao.CalculaComissao(pr, Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", iUniVend == 2 ? (double)(Convert.ToDecimal(itped.VLRUNIVENDALIQ) / Convert.ToDecimal(produto.QtdCaixa)) : (double)itped.VLRUNIVENDALIQ)), (decimal)itped.Qtd, 0, 0, comissao_vendedor, dComissaoTabela, produto.ComissaoTel, produto.Comissao, "T", 0, 0, produto.Comissao, (decimal)comissao_televend, (Int16)iIncideVend, (Int16)iIncideTelev, (Int32)produto.Codigo, produto.Desconto))); itped.COMISSAOUSADATELEV = (decimal)ClasseComissao.ComissaoUsadaTele; itped.FatorComiss = (decimal)ClasseComissao.FatorDesconto; TotalComissao += (decimal)itped.VlrComiss; TotalComissaoTelev += (decimal)itped.COMISSAOTELEV; dcdc.ITENSPEDs.InsertOnSubmit(itped); } p.Comissao = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", TotalComissao)); //Valor da comissao VENDEDOR p.COMISSAOTELEV = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", TotalComissaoTelev)); //Valor da comissao do TELEVENDEDOR (OU SEGUNDO VENDEDOR) //p.PesoBruto = cPesoTotal; //p.PesoLiq = cPesoTotal; dcdc.SubmitChanges(); dcdc.Dispose(); return NumPed; } catch (Exception ex) { if (!String.IsNullOrEmpty(ex.Message)) { throw new Exception(ex.Message); } else { return -1; } } }
public static Boolean ReservarItemPedidoWeb(UsuarioResumido Usuario, Int32 NumPedWeb, Int32 CodServMerc, Decimal Quantidade, ParametroResumido pr) { DataClassesDataContext dcdc = new DataClassesDataContext(); //Decimal? Saldo = Convert.ToDecimal(dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc.Equals((Int32)CodServMerc)).Saldo); //Decimal? QtdRes = Convert.ToDecimal(dcdc.SERVMERCs.SingleOrDefault(sm => sm.CodServMerc.Equals(CodServMerc)).QtdRes); Decimal? Saldo = 0; Decimal? QtdRes = 0; ClasseBanco csBanco = new ClasseBanco(); var r = csBanco.Query("SELECT Saldo, QtdRes FROM SERVMERC WHERE CODSERVMERC = " + CodServMerc + ""); if (r.Read()) { Saldo = Convert.ToDecimal(r["SALDO"].ToString()); QtdRes = Convert.ToDecimal(r["QtdRes"].ToString()); } r.Close(); r.Dispose(); // verifica se a quantidade da mercadoria solicitada está disponível em estoque // if (pr.SaldoPed == 'S') { if ((Saldo - (QtdRes <= 0 ? 0 : QtdRes)) < Quantidade) { throw new Exception("Quantidade indisponível da(s) mercadoria(s) solicitada(s). Se foi feita importação de Planilha/Arquivo OffLine, favor verificar a listagem de itens não atendidos."); } } // retorna os itens da mercadoria selecionada em outros pedidos // var Itens = (from o in dcdc.ITPEDIDOWEBs where (o.CODSERVMERC == CodServMerc) where (o.CODEMP != Usuario.CodEmp || o.CODUSU != Usuario.CodUsu) select new { o.CODSERVMERC, o.QTDE }).ToList(); // soma a quantidade dos itens retornados var Soma = (Decimal)Itens.Select(c => c.QTDE).Sum(); /* FABIANO ------------------------------------------------------------------------------- Verifica saldo - reserva do produto - reserva de produto via web (ITPEDIDOWEB) ------------------------------------------------------------------------------------------*/ if (pr.SaldoPed == 'S') { // se a soma dos itens em reserva for maior que a quantidade // if (((Saldo - QtdRes) - Soma) < Quantidade) { throw new Exception("Quantidade solicitada é superior ao saldo disponível da mercadoria selecionada."); } } // ajusta as propriedades do Item ITPEDIDOWEB Item = new ITPEDIDOWEB(); Item.NUMPEDWEB = NumPedWeb; Item.CODSERVMERC = CodServMerc; Item.CODEMP = Usuario.CodEmp; Item.CODUSU = Usuario.CodUsu; Item.QTDE = (Decimal)Quantidade; // grava o item na tabela // dcdc.ITPEDIDOWEBs.InsertOnSubmit(Item); dcdc.SubmitChanges(); //dcdc.Dispose(); //FABIANO //GRAVAR NA SERVMERC A QTD. RESERVADA NO MOMENTO DA INCLUSAO DO ITEM //SERVMERC prod = dcdc.SERVMERCs.Single(p => p.CodServMerc == CodServMerc); //prod.QtdRes = (prod.QtdRes == null ? (Convert.ToDouble(Quantidade)) : (prod.QtdRes + Convert.ToDouble(Quantidade))); //dcdc.SubmitChanges(); String sQuantidade = Quantidade.ToString();//51747 csBanco.ExecutarComando(" UPDATE SERVMERC SET QTDRES = ISNULL(QTDRES,0) + " + sQuantidade.Replace(',','.') + " WHERE CODSERVMERC = " + CodServMerc + ""); dcdc.Dispose(); return true; }
internal String insertCourse() { String result = "<form id=\"insertCourse\" name=\"insertCourse\" action=\"#\" method=\"post\">"; DataClassesDataContext d = new DataClassesDataContext(); result += "<ul>"; // JĘZYK result += "<li class=\"PAMenuItems\">Język kursu: <select name=\"language\">"; var languageQuery = from j in d.Jezyki select j; foreach (var r in languageQuery) { result += "<option value=\"" + r.JezykID + "\">" + r.Nazwa + "</option>"; } result += "</select></li>"; // POZIOM result += "<li class=\"PAMenuItems\">Poziom kursu: <select name=\"level\">"; var levelQuery = from p in d.Poziomy select p; foreach (var r in levelQuery) { result += "<option value=\"" + r.PoziomID + "\">" + r.Nazwa + "</option>"; } result += "</select></li>"; // PROWADZĄCY result += "<li class=\"PAMenuItems\">Prowadzący: <select name=\"teacher\">"; var teacherQuery = from u in d.Users select u; foreach (var r in teacherQuery) { result += "<option value=\"" + r.UserID + "\">" + r.Imie + " " + r.Nazwisko + "</option>"; } result += "</select></li>"; result += "<input name=\"type\" type=\"hidden\" value=\"1\" />"; result += "<input name=\"inserting\" type=\"hidden\" value=\"true\" />"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"insertCourse\").submit();\" />"; result += "</ul></form>"; d.Dispose(); return result; }
internal String editCourse(int ID) { String result = "<form id=\"editCourse\" name=\"editCourse\" action=\"#\" method=\"post\">"; DataClassesDataContext d = new DataClassesDataContext(); var query = from k in d.Kursy join u in d.Users on k.IDprowadzacego equals u.UserID join j in d.Jezyki on k.Jezyk equals j.JezykID join p in d.Poziomy on k.Poziom equals p.PoziomID where k.KursID == ID select new { IDkursu = k.KursID, TypKursu = k.Typ, Jezyk = j.Nazwa, Poziom = p.Nazwa, ImieProwadzacego = u.Imie, NazwiskoProwadzacego = u.Nazwisko, EMailProwadzacego = u.E_mail, IDprowadzacego = k.IDprowadzacego, IDjezyka = k.Jezyk, IDpoziomu = k.Poziom }; result += "<ul>"; // JĘZYK result += "<li class=\"PAMenuItems\">Język kursu: <select name=\"language\">"; var languageQuery = from j in d.Jezyki select j; foreach (var r in languageQuery) { if (r.JezykID == query.First().IDjezyka) { result += "<option value=\"" + r.JezykID + "\" selected=\"selected\">" + r.Nazwa + "</option>"; } else { result += "<option value=\"" + r.JezykID + "\">" + r.Nazwa + "</option>"; } } result += "</select></li>"; // POZIOM result += "<li class=\"PAMenuItems\">Poziom kursu: <select name=\"level\">"; var levelQuery = from p in d.Poziomy select p; foreach (var r in levelQuery) { if (r.PoziomID == query.First().IDpoziomu) { result += "<option value=\"" + r.PoziomID + "\" selected=\"selected\">" + r.Nazwa + "</option>"; } else { result += "<option value=\"" + r.PoziomID + "\">" + r.Nazwa + "</option>"; } } result += "</select></li>"; // PROWADZĄCY result += "<li class=\"PAMenuItems\">Prowadzący: <select name=\"teacher\">"; var teacherQuery = from u in d.Users select u; foreach (var r in teacherQuery) { if (r.UserID == query.First().IDprowadzacego) { result += "<option value=\"" + r.UserID + "\" selected=\"selected\">" + r.Imie + " " + r.Nazwisko + "</option>"; } else { result += "<option value=\"" + r.UserID + "\">" + r.Imie + " " + r.Nazwisko + "</option>"; } } result += "</select></li>"; // POZOZSTAŁE WARTOŚCI result += "<input name=\"idKursu\" type=\"hidden\" value=\"" + query.First().IDkursu + "\" />"; result += "<li class=\"PAMenuItems\">Typ kursu: <input name=\"type\" type=\"text\" value=\"" + query.First().TypKursu + "\" /></li>"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editCourse\").submit();\" />"; result += "</ul></form>"; d.Dispose(); return result; }
internal String saveUserEdition(HttpRequest f) { int ID = Int32.Parse(f.Form["id"]); DataClassesDataContext d = new DataClassesDataContext(); var query = from u in d.Users where u.UserID == ID select u; Users us = query.First(); us.Login = f.Form["login"]; us.Imie = f.Form["imie"]; us.Nazwisko = f.Form["nazwisko"]; us.PhoneCountryCode = f.Form["numerPanstwa"]; us.PhoneAreaCode = f.Form["numerWojewodztwa"]; us.PhoneNumber = f.Form["numerTelefonu"]; us.Street = f.Form["ulica"]; if( f.Form["rights"] != "" ) us.CzyAdmin = int.Parse(f.Form["rights"]); if( f.Form["numerDomu"] != "" ) us.StreetNumber = int.Parse(f.Form["numerDomu"]); if( f.Form["numerMieszkania"] != "" ) us.FlatNumber = int.Parse(f.Form["numerMieszkania"]); us.PostCode = f.Form["kodPocztowy"]; us.City = f.Form["miasto"]; d.SubmitChanges(); d.Dispose(); String result = "Zapisano zmiany." + editUser(ID); return result; }
internal String editUser(int ID) { AdminRightsChecker userRights = new AdminRightsChecker(ID); String result = "<form id=\"editUser\" name=\"editUser\" action=\"#\" method=\"post\"><ul>"; DataClassesDataContext d = new DataClassesDataContext(); var query = from u in d.Users where u.UserID == ID select u; result += "<li class=\"PAMenuItems\">Login: <input name=\"login\" type=\"text\" value=\"" + query.First().Login + "\" /></li>"; result += "<li class=\"PAMenuItems\">Imię: <input name=\"imie\" type=\"text\" value=\"" + query.First().Imie + "\" /></li>"; result += "<li class=\"PAMenuItems\">Nazwisko: <input name=\"nazwisko\" type=\"text\" value=\"" + query.First().Nazwisko + "\" /></li>"; result += "<li class=\"PAMenuItems\">Numer telefonu: +<input name=\"numerPanstwa\" type=\"text\" value=\"" + query.First().PhoneCountryCode + "\" />(<input name=\"numerWojewodztwa\" type=\"text\" value=\"" + query.First().PhoneAreaCode + "\" />)<input name=\"numerTelefonu\" type=\"text\" value=\"" + query.First().PhoneNumber + "\" /></li>"; result += "<li class=\"PAMenuItems\">Adres:</li><li class=\"PAMenuItems\">Ulica: <input name=\"ulica\" type=\"text\" value=\"" + query.First().Street + "\" /><input name=\"numerDomu\" type=\"text\" value=\"" + query.First().StreetNumber + "\" />, mieszkania <input name=\"numerMieszkania\" type=\"text\" value=\"" + query.First().FlatNumber + "\" /></li>"; result += "<li class=\"PAMenuItems\">Kod pocztowy: <input name=\"kodPocztowy\" type=\"text\" value=\"" + query.First().PostCode + "\" /> Miasto: <input name=\"miasto\" type=\"text\" value=\"" + query.First().City + "\" /></li>"; result += "<li class=\"PAMenuItems\">Uprawnienia użytkownika: <select name=\"rights\"><option value=\"1\""; if (userRights.CzyAdmin()) result += " selected=\"selected\""; result += ">Administrator</option><option value=\"2\""; if (!(userRights.CzyAdmin()) && (userRights.CzySek())) result += " selected=\"selected\""; result += ">Sekretariat</option><option value=\"3\""; if (!(userRights.CzyAdmin()) && !(userRights.CzySek())) result += " selected=\"selected\""; result += ">Użytkownik</option></select></li>"; result += "<input name=\"id\" type=\"hidden\" value=\"" + query.First().UserID + "\" />"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editUser\").submit();\" />"; result += "</ul></form>"; result += "<p><a href=\"?content=ShowUsers\">Powrót do listy użytkowników</a><br /><a href=\"?content=\">Powrót do panelu administracyjnego</a></p>"; d.Dispose(); return result; }
public static void DisposeDB() { _db.Dispose(); }
public static Boolean RemoverReservaItensPedidoWeb(UsuarioResumido Usuario) { DataClassesDataContext dcdc = new DataClassesDataContext(); var Itens = dcdc.ITPEDIDOWEBs.Where(p => p.CODEMP == Usuario.CodEmp && p.CODUSU == Usuario.CodUsu); dcdc.ITPEDIDOWEBs.DeleteAllOnSubmit(Itens); //EXECUTA PROCEDURE PARA CORRIGIR QTD RESERVADA SE O PEDIDO NAO FOI GRAVADO. dcdc.sp_corrige_reserva_webpedido(); dcdc.SubmitChanges(); dcdc.Dispose(); return true; }
public void Dispose() { _dataContext.Dispose(); }
public static List<ClienteResumido> ListarClientes(UsuarioResumido u, ParametroResumido pr) { //CODIGO FEITO COM LINQ DataClassesDataContext dcdc = new DataClassesDataContext(); var retorno = (from c in dcdc.CLIENTEs join vc in dcdc.VENDCLIs on c.CodCli equals vc.CodCli join ve in dcdc.VENDEDORs on vc.CodVen equals ve.CodVend where c.Ativo != 'N' // clientes ativos where c.Prospect != 'S' // nao trazer prospects where ve.Status.Equals('A') // vendedores ativos where ve.CodUsu.Equals(u.CodUsu) where vc.CodEmp.Equals(u.CodEmp) orderby (pr.ExibirRazaoSocial==1 ? c.RazSoc : c.NomFan) select new ClienteResumido(c.CodCli, (c.CodCli + " - " + (pr.ExibirRazaoSocial == 1 ? c.RazSoc : c.NomFan)))).ToList(); dcdc.Dispose(); return retorno; }
internal String ShowUsers() { AdminRightsChecker rights = new AdminRightsChecker(Request.Cookies["user"], Session); String result = "<table><tr><td>Login</td><td>E-mail</td><td>Imie</td><td>Nazwisko</td><td>Numer kierunkowy (państwa)</td><td>Numer kierunkowy (województwo)</td><td>Numer telefonu</td><td>Ulica</td><td>Numer ulicy</td><td>Numer domu</td><td>Kod pocztowy</td><td>Miasto</td><td></td><td></td></tr>"; DataClassesDataContext d = new DataClassesDataContext(); List<Users> l = d.Users.ToList(); foreach (var k in l) { result += "<tr><td>" + k.Login + "</td><td>" + k.E_mail + "</td><td>" + k.Imie + "</td><td>" + k.Nazwisko + "</td><td>" + k.PhoneCountryCode + "</td><td>" + k.PhoneAreaCode + "</td><td>" + k.PhoneNumber + "</td><td>" + k.Street + "</td><td>" + k.StreetNumber + "</td><td>" + k.FlatNumber + "</td><td>" + k.PostCode + "</td><td>" + k.City + "</td>"; if (rights.CzyAdmin()) { result += "<td><a href=\"?content=EditUsers&ID=" + k.UserID + "\">edycja</a></td><td><a href=\"?content=DeleteUsers&ID=" + k.UserID + "\">usuń</a></td></tr>"; } else { result += "<td></td><td></td></tr>"; } } result += "</table>"; result += "<p><a href=\"?content=\">Powrót</a></p>"; d.Dispose(); return result; }
public static List<ProdutoResumido> Produto(UsuarioResumido u, Int32 iCodProduto, ParametroResumido pr, Int16 CodPrcTab, Int16 CodPrzTab) { DataClassesDataContext dcdc = new DataClassesDataContext(); ClasseBanco conn = new ClasseBanco(); decimal var_preco = 0; var strSql = ""; conn.AbrirBanco(); //BUSCAR PRECO DO PRODUTO NA TABELA PADRAO strSql = "SELECT ISNULL(T.PRECO,0) AS Preco FROM "; strSql = strSql + " TABPRECO T LEFT JOIN REGRAS_PRODUTO R ON T.CODSERVMERC = R.CODPRO "; strSql = strSql + " WHERE ISNULL(R.REGRA1,0)=0 AND CODSERVMERC = " + iCodProduto + " AND CODEMP = " + u.CodEmp + ""; if (!CodPrcTab.Equals(0) && !CodPrzTab.Equals(0)) { strSql = strSql + " AND CodTipPrc = " + CodPrcTab + " AND CodTipPrz = " + CodPrzTab + ""; } var r = conn.Query(strSql); if (r.Read()) { var_preco = Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", r[0].ToString())); } r.Close(); //Verifica se produto está em promoção ou pra mocinha... VerificaSeTemPromocao(iCodProduto, CodPrcTab); if (cPrecoPromocao!=0) { var_preco = cPrecoPromocao; } else if (cPercPromocao!=0) { var_preco = var_preco - (var_preco * cPercPromocao / 100); } List<ProdutoResumido> produtos = new List<ProdutoResumido>(); try { dcdc.SERVMERCs.Where(s => s.CodServMerc == iCodProduto).Where(s => s.Ativo.Equals("S")).OrderBy(s => s.DesServMerc).ToList().ForEach(s => produtos.Add( new ProdutoResumido( s.CodServMerc, (s.DesServMerc == null ? "" : s.DesServMerc), (var_preco == 0 ? (decimal)s.PrecoBase : var_preco), //PRECO DA TABELA 0, 0, s.Saldo == null ? 0 : Convert.ToDecimal(s.Saldo) - (s.QtdRes == null ? 0 : (Convert.ToDecimal(s.QtdRes) <= 0 ? 0 : Convert.ToDecimal(s.QtdRes))), s.Comissao == null ? 0 : Convert.ToDecimal(s.Comissao), 0, s.DescCliente > 0 ? Convert.ToDecimal(s.DescCliente) : (s.PercDesc == null ? 0 : Convert.ToDecimal(s.PercDesc)), s.ComissaoTel == null ? 0 : Convert.ToDecimal(s.ComissaoTel), Convert.ToDecimal(s.QtdCaixa), s.M_Unidade, s.Unidade, "0", Convert.ToDecimal(String.Format("{0:" + Funcoes.Decimais(pr) + "}", Convert.ToDecimal(s.PesoBruto))), sValidadePromocao, CodPrzTab,0,0,0,"") )); if (produtos.Count > 0) { // retorna os itens da mercadoria selecionada em outros pedidos // var Itens = (from o in dcdc.ITPEDIDOWEBs where (o.CODSERVMERC == produtos[0].Codigo) where (o.CODEMP != u.CodEmp || o.CODUSU != u.CodUsu) select new { o.CODSERVMERC, o.QTDE }).ToList(); // soma a quantidade dos itens retornados // var Soma = (decimal)Itens.Select(c => c.QTDE).Sum(); // atualiza a quantidade do saldo do produto na coleção // produtos[0].Saldo -= Soma; dcdc.Dispose(); } else { produtos = null; } } catch (Exception exps) { throw new Exception(exps.ToString()); } return produtos; }
internal String editCourse(int ID) { String result = "<form id=\"editCourse\" name=\"editCourse\" action=\"#\" method=\"post\">"; DataClassesDataContext d = new DataClassesDataContext(); var query = from k in d.Kursy join u in d.Users on k.IDprowadzacego equals u.UserID join j in d.Jezyki on k.Jezyk equals j.JezykID join p in d.Poziomy on k.Poziom equals p.PoziomID where k.KursID == ID select new { IDkursu = k.KursID, TypKursu = k.Typ, Jezyk = j.Nazwa, Poziom = p.Nazwa, ImieProwadzacego = u.Imie, NazwiskoProwadzacego = u.Nazwisko, EMailProwadzacego = u.E_mail, IDprowadzacego = k.IDprowadzacego, IDjezyka = k.Jezyk, IDpoziomu = k.Poziom }; result += "<ul>"; // JĘZYK result += "<li class=\"PAMenuItems\">Język kursu: <select name=\"language\">"; var languageQuery = from j in d.Jezyki select j; foreach (var r in languageQuery) { if (r.JezykID == query.First().IDjezyka) { result += "<option value=\"" + r.JezykID + "\" selected=\"selected\">" + r.Nazwa + "</option>"; } else { result += "<option value=\"" + r.JezykID + "\">" + r.Nazwa + "</option>"; } } result += "</select></li>"; // POZIOM result += "<li class=\"PAMenuItems\">Poziom kursu: <select name=\"level\">"; var levelQuery = from p in d.Poziomy select p; foreach (var r in levelQuery) { if (r.PoziomID == query.First().IDpoziomu) { result += "<option value=\"" + r.PoziomID + "\" selected=\"selected\">" + r.Nazwa + "</option>"; } else { result += "<option value=\"" + r.PoziomID + "\">" + r.Nazwa + "</option>"; } } result += "</select></li>"; // PROWADZĄCY result += "<li class=\"PAMenuItems\">Prowadzący: <select name=\"teacher\">"; var teacherQuery = from u in d.Users select u; foreach (var r in teacherQuery) { if (r.UserID == query.First().IDprowadzacego) { result += "<option value=\"" + r.UserID + "\" selected=\"selected\">" + r.Imie + " " + r.Nazwisko + "</option>"; } else { result += "<option value=\"" + r.UserID + "\">" + r.Imie + " " + r.Nazwisko + "</option>"; } } result += "</select></li>"; // POZOZSTAŁE WARTOŚCI result += "<input name=\"idKursu\" type=\"hidden\" value=\"" + query.First().IDkursu + "\" />"; result += "<li class=\"PAMenuItems\">Typ kursu: <input name=\"type\" type=\"text\" value=\"" + query.First().TypKursu + "\" /></li>"; result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editCourse\").submit();\" />"; result += "</ul></form>"; d.Dispose(); return(result); }