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);
}
