public void getFranquiasRegiao()
{
try
{
dao.AcessoLogin iAcessoLogin = (dao.AcessoLogin)Session["acessoLogin"];
dao.resumoOS iFuncoes = new dao.resumoOS();
System.Data.DataTable iTabela = iFuncoes.getFranquiasRegiao();
List <object> iLista = new List <object>();
foreach (System.Data.DataRow iLinha in iTabela.Rows)
{
if (iAcessoLogin.cdCetec == iLinha["cd_cetec"].ToString() || iAcessoLogin.isSupervisor)
{
iLista.Add(
new
{
franquia = iLinha["franquia"].ToString(),
regiao = iLinha["regiao"].ToString(),
codigoCetec = iLinha["cd_cetec"].ToString(),
id = iAcessoLogin.isSupervisor ? "franquia-ativa" : (iAcessoLogin.cdCetec == iLinha["cd_cetec"].ToString() ? "franquia-ativa" : "franquia-inativa")
}
);
}
}
System.Web.Script.Serialization.JavaScriptSerializer jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
Response.Write(jsonSerialiser.Serialize(iLista));
}
catch (Exception ex)
{
Response.Write("ERRO##class:" + this.GetType().Name + "\r\n Method:" + System.Reflection.MethodBase.GetCurrentMethod().Name + "\r\n" + ex.Message);
}
}//getFranquiasRegiao
}//getFranquiasRegiao
public void getFile()
{
string sFileName = System.IO.Path.GetRandomFileName();
string sGenName = "agenda.csv";
Response.AddHeader("Content-disposition", "attachment; filename=" + sGenName);
Response.ContentType = "application/vnd.ms-excel";
try
{
dao.AcessoLogin iAcessoLogin = (dao.AcessoLogin)Session["acessoLogin"];
dao.resumoOS iFuncoes = new dao.resumoOS();
string iCodigoCetec = iAcessoLogin.isSupervisor ? Request.Form["pCodigoCetec"].ToString() : iAcessoLogin.cdCetec;
object pLocalOS = Request.Form["pLocalOS"];
object iStatusOS = Request.Form["pStatusOS"];
DateTime iData = Convert.ToDateTime(Request.Form["pData"]);
object iServicoOS = Request.Form["pServico"];
System.Data.DataTable iTabela = iFuncoes.getDetalhesOS(iCodigoCetec, Convert.ToInt32(pLocalOS), iStatusOS, iData, iServicoOS);
List <object> iLista = new List <object>();
string iNomeCampos = "";
foreach (System.Data.DataColumn iColuna in iTabela.Columns)
{
iNomeCampos += iNomeCampos == "" ? iColuna.ColumnName : "," + iColuna.ColumnName;
}
foreach (System.Data.DataRow iLinha in iTabela.Rows)
{
Response.Write(iLinha["contrato"].ToString() + "," +
iLinha["nome"].ToString() + "," +
iLinha["telefone"].ToString() + "," +
iLinha["celular"].ToString() + "," +
iLinha["veiculo"].ToString() + "," +
iLinha["servico"].ToString() + "," +
iLinha["status"].ToString() + "," +
iLinha["produto"].ToString() + "," +
iLinha["horario"].ToString() + "," +
iLinha["tecnico"].ToString() + "," +
iLinha["codigoOS"].ToString() + "," +
iLinha["placa"].ToString() + "," +
iLinha["local"].ToString() + "\r\n");
}
}
catch (Exception ex)
{
Response.Write("ERRO##class:" + this.GetType().Name + "\r\n Method:" + System.Reflection.MethodBase.GetCurrentMethod().Name + "\r\n" + ex.Message);
}
Response.End();
}
public void getFile(HttpContext context)
{
try
{
dao.AcessoLogin iAcessoLogin = (dao.AcessoLogin)context.Session["acessoLogin"];
string iCodigoCetec = iAcessoLogin.isSupervisor ? context.Request["pCodigoCetec"].ToString() : iAcessoLogin.cdCetec;
object pLocalOS = context.Request["pLocalOS"];
object iStatusOS = context.Request["pStatusOS"];
DateTime iData = Convert.ToDateTime(context.Request["pData"]);
object iServicoOS = context.Request["pServico"];
dao.resumoOS iFuncoes = new dao.resumoOS();
System.Data.DataTable iTabela = iFuncoes.getDetalhesOS(iCodigoCetec, Convert.ToInt32(pLocalOS), iStatusOS, iData, iServicoOS);
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.AddHeader("Content-disposition", "attachment; filename=agenda.csv");
string iLinhasArquivo = "";
foreach (System.Data.DataColumn iColuna in iTabela.Columns)
{
iLinhasArquivo += iLinhasArquivo == "" ? iColuna.ColumnName : ";" + iColuna.ColumnName;
}
context.Response.Write(iLinhasArquivo += "\r\n");
foreach (System.Data.DataRow iLinha in iTabela.Rows)
{
context.Response.Write(iLinha["contrato"].ToString()
+ ";" + iLinha["nome"].ToString()
+ ";" + iLinha["telefone"].ToString()
+ ";" + iLinha["celular"].ToString()
+ ";" + iLinha["veiculo"].ToString()
+ ";" + iLinha["servico"].ToString()
+ ";" + iLinha["status"].ToString()
+ ";" + iLinha["codigoOS"].ToString()
+ ";" + iLinha["horario"].ToString()
+ ";" + iLinha["produto"].ToString()
+ ";" + iLinha["tecnico"].ToString()
+ ";" + iLinha["placa"].ToString()
+ ";" + iLinha["local"].ToString() + "\r\n");
}
}
catch (Exception ex)
{
int linhaErro = (new System.Diagnostics.StackTrace(ex, true)).GetFrame(0).GetFileLineNumber();
context.Response.Write("ERRO##class:" + this.GetType().Name + "\r\n Method:" + System.Reflection.MethodBase.GetCurrentMethod().Name + "\r\n" + ex.Message + "\r\nLinha:" + linhaErro.ToString());
}
}
public void getDetalhesOS()
{
try
{
dao.AcessoLogin iAcessoLogin = (dao.AcessoLogin)Session["acessoLogin"];
dao.resumoOS iFuncoes = new dao.resumoOS();
string iCodigoCetec = iAcessoLogin.isSupervisor ? Request.Form["pCodigoCetec"].ToString() : iAcessoLogin.cdCetec;
object pLocalOS = Request.Form["pLocalOS"];
object iStatusOS = Request.Form["pStatusOS"];
DateTime iData = Convert.ToDateTime(Request.Form["pData"]);
object iServicoOS = Request.Form["pServico"];
System.Data.DataTable iTabela = iFuncoes.getDetalhesOS(iCodigoCetec, Convert.ToInt32(pLocalOS), iStatusOS, iData, iServicoOS);
List <object> iLista = new List <object>();
foreach (System.Data.DataRow iLinha in iTabela.Rows)
{
iLista.Add(
new
{
contrato = iLinha["contrato"].ToString(),
nome = iLinha["nome"].ToString(),
telefone = iLinha["telefone"].ToString(),
celular = iLinha["celular"].ToString(),
veiculo = iLinha["veiculo"].ToString(),
servico = iLinha["servico"].ToString(),
status = iLinha["status"].ToString(),
produto = iLinha["produto"].ToString(),
horario = iLinha["horario"].ToString(),
tecnico = iLinha["tecnico"].ToString(),
codigoOS = iLinha["codigoOS"].ToString(),
placa = iLinha["placa"].ToString(),
local = iLinha["local"].ToString()
}
);
}
System.Web.Script.Serialization.JavaScriptSerializer jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
Response.Write(jsonSerialiser.Serialize(iLista));
}
catch (Exception ex)
{
Response.Write("ERRO##class:" + this.GetType().Name + "\r\n Method:" + System.Reflection.MethodBase.GetCurrentMethod().Name + "\r\n" + ex.Message);
}
}
public void getDetalhesOSFiltros()
{
try
{
dao.AcessoLogin iAcessoLogin = (dao.AcessoLogin)Session["acessoLogin"];
dao.resumoOS iFuncoes = new dao.resumoOS();
string iCodigoCetec = iAcessoLogin.isSupervisor ? Request.Form["pCodigoCetec"].ToString() : iAcessoLogin.cdCetec;
DateTime iData = Convert.ToDateTime(Request.Form["pData"]);
int pLocalOS = Convert.ToInt32(Request.Form["pLocalOS"]);
System.Data.DataTable iTabela = iFuncoes.getDetalhesOSFiltros(iCodigoCetec, iData, pLocalOS);
List <object> iLista = new List <object>();
foreach (System.Data.DataRow iLinha in iTabela.Rows)
{
iLista.Add(
new
{
servico = iLinha["servico"].ToString(),
quantidade = iLinha["quantidade"].ToString(),
status = iLinha["status"].ToString(),
visita = iLinha["visita"].ToString(),
loja = iLinha["loja"].ToString(),
agenda = iLinha["agendaWeb"].ToString()
}
);
}
System.Web.Script.Serialization.JavaScriptSerializer jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
Response.Write(jsonSerialiser.Serialize(iLista));
}
catch (Exception ex)
{
Response.Write("ERRO##class:" + this.GetType().Name + "\r\n Method:" + System.Reflection.MethodBase.GetCurrentMethod().Name + "\r\n" + ex.Message);
}
}
//Franquia.pro_getResumoOS ( @dataInicial datetime, @dataFinal datetime, @codigoCetec char(6) )
private void getResumoOS()
{
try
{
DateTime iDataInicial; DateTime iDataFinal; string iCodigoCetec;
if (Request.Form["start"] != null)
{
iDataInicial = Convert.ToDateTime(Request["start"]);
}
else
{
iDataInicial = Convert.ToDateTime("27/10/2013");
//Response.Write("Data incial não informada!!");
//return;
}
if (Request.Form["end"] != null)
{
iDataFinal = Convert.ToDateTime(Request["end"]);
}
else
{
iDataFinal = Convert.ToDateTime("7/12/2013");
//Response.Write("Data final não informada!!");
//return;
}
dao.AcessoLogin iAcessoLogin = (dao.AcessoLogin)Session["acessoLogin"];
iCodigoCetec = iAcessoLogin.isSupervisor ? Request.Form["pCodigoCetec"].ToString() : iAcessoLogin.cdCetec;
if (iAcessoLogin.isSupervisor && Request.Form["pCodigoCetec"] != null)
{
iCodigoCetec = Request.Form["pCodigoCetec"];
}
dao.resumoOS iFuncoes = new dao.resumoOS();
System.Collections.ArrayList iListaEventos = new System.Collections.ArrayList();
List <object> eventList = new List <object>();
foreach (System.Data.DataRow iLinha in iFuncoes.getResumoOS(iDataInicial, iDataFinal, iCodigoCetec).Rows)
{
iListaEventos.Add(
new
{
title = iLinha["descricaoStatus"].ToString() + ":" + iLinha["quantidade"].ToString(),
start = iLinha["data"].ToString(),
allDay = "true"
}
);
}
System.Web.Script.Serialization.JavaScriptSerializer jsonSerialiser = new System.Web.Script.Serialization.JavaScriptSerializer();
string json = jsonSerialiser.Serialize(iListaEventos);
Response.Write(json);
}
catch (Exception ex)
{
Response.Write("ERRO##class:" + this.GetType().Name + "\r\n Method:" + System.Reflection.MethodBase.GetCurrentMethod().Name + "\r\n" + ex.Message);
}
}
