public void NullingMsj(string Id_Msj)
{
Conn = new Coneccion();
#region InsertString
string Insert = "UPDATE GLA_System_Msj SET IsAvailable=0 WHERE Id=@ID ";
#endregion
try
{
Conn.ConnPlabal.Open();
Conn.CmdPlabal = new SqlCommand(Insert, Conn.ConnPlabal);
#region Parameters
Conn.CmdPlabal.Parameters.AddWithValue("@ID", Id_Msj);
#endregion
Conn.CmdPlabal.ExecuteNonQuery();
Conn.ConnPlabal.Close();
}
catch (Exception EX)
{
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
Conn.ConnPlabal.Close();
}
}
private void GetRiesgoPropioNCredito()
{
Conn = new Coneccion();
Query = @"SELECT TOP 1 NOKOEN,DIEN,FOEN,CRTO,CRSD,CRCH,CRPA,CRLT,MOCTAEN FROM MAEEN WITH ( NOLOCK ) WHERE KOEN= @RUT";
try
{
Conn.ConnGlasser.Open();
Conn.CmdPlabal = new SqlCommand(Query, Conn.ConnGlasser);
Conn.CmdPlabal.Parameters.AddWithValue("@RUT", Rut);
dr = Conn.CmdPlabal.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Validadores validadores = new Validadores();
string Rpr = dr["CRPA"].ToString();
string Crtr = dr["CRTO"].ToString();
RiesgoPropio = Math.Round(validadores.ParseoDouble(Rpr), 0);
Credito = Math.Round(validadores.ParseoDouble(Crtr), 0);
}
dr.Close();
Conn.ConnGlasser.Close();
}
catch (Exception EX)
{
string ERRORSTR = "Mensaje:" + EX.Message + " trace: " + EX.StackTrace + " Rut:" + Rut + " empresa:" + Empresa;
ErrorCatching gETerror = new ErrorCatching();
gETerror.ErrorCatch(ERRORSTR, HttpContext.Current.Request.Url.ToString());
dr.Close();
Conn.ConnGlasser.Close();
}
}
public void CreateMsj(string para, string from, string cuerpo)
{
Conn = new Coneccion();
#region InsertString
string Insert = "INSERT INTO GLA_System_Msj (UserName,From,Date,Message,IsAvailable) VALUES (@UserName,@From,GETDATE(),@Mensaje,1)";
#endregion
try
{
Conn.ConnPlabal.Open();
Conn.CmdPlabal = new SqlCommand(Insert, Conn.ConnPlabal);
#region Parameters
Conn.CmdPlabal.Parameters.AddWithValue("@UserName", para);
Conn.CmdPlabal.Parameters.AddWithValue("@From", from);
Conn.CmdPlabal.Parameters.AddWithValue("@Mensaje", cuerpo);
#endregion
Conn.CmdPlabal.ExecuteNonQuery();
Conn.ConnPlabal.Close();
}
catch (Exception EX)
{
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
Conn.ConnPlabal.Close();
}
}
public void AnularRutaAsign(string ID, string token)
{
_token = new TokenClass();
string To = _token.TokenId;
if (To == token)
{
#region InsertString
string Insert = "UPDATE LO_Asignruta SET Status=1 WHERE Id=@ID ";
#endregion
try
{
ConnPlabal.Open();
cmdPlabal = new SqlCommand(Insert, ConnPlabal);
#region Parameters
cmdPlabal.Parameters.AddWithValue("@ID", ID);
#endregion
cmdPlabal.ExecuteNonQuery();
ConnPlabal.Close();
}
catch (Exception EX)
{
throw EX;
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
ConnGlasser.Close();
}
}
else
{
}
}
private void GetRandomData()
{
Conn = new Coneccion();
Query = @"SELECT TOP 1 * FROM MAEEN WITH ( NOLOCK ) WHERE KOEN= @RUT";
try
{
Conn.ConnGlasser.Open();
Conn.CmdPlabal = new SqlCommand(Query, Conn.ConnGlasser);
Conn.CmdPlabal.Parameters.AddWithValue("@RUT", Rut);
dr = Conn.CmdPlabal.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Validadores Val = new Validadores();
Bloqueado = Val.ParseoBoolean(dr["BLOQUEADO"].ToString());
Nombre = dr["NOKOEN"].ToString().Trim();
CondPago = dr["CPEN"].ToString().Trim();
Region = dr["CIEN"].ToString().Trim().Substring(1);
}
dr.Close();
Conn.ConnGlasser.Close();
}
catch (Exception EX)
{
string ERRORSTR = "Mensaje:" + EX.Message + " trace: " + EX.StackTrace + " Rut:" + Rut;
ErrorCatching gETerror = new ErrorCatching();
gETerror.ErrorCatch(ERRORSTR, HttpContext.Current.Request.Url.ToString());
dr.Close();
Conn.ConnGlasser.Close();
}
}
public void NullorCloseInventario(string ID, string token, string Action)
{
_token = new TokenClass();
string To = _token.TokenId;
if (To == token)
{
#region InsertString
string Insert = "";
if (Action == "Cerrar")
{
Insert = "UPDATE LO_inventory SET Status=1 WHERE Id=@ID ";
}
else if (Action == "Anular")
{
Insert = "UPDATE LO_inventory SET Status=3 WHERE Id=@ID ";
}
else if (Action == "Activar")
{
Insert = "UPDATE LO_inventory SET Status=0 WHERE Id=@ID ";
}
#endregion
try
{
ConnPlabal.Open();
cmdPlabal = new SqlCommand(Insert, ConnPlabal);
#region Parameters
cmdPlabal.Parameters.AddWithValue("@ID", ID);
#endregion
cmdPlabal.ExecuteNonQuery();
ConnPlabal.Close();
}
catch (Exception EX)
{
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
ConnGlasser.Close();
}
}
}
private double GetAmountNVV()
{
Conn = new Coneccion();
Query = @"SELECT SUM(MAEDDO.VABRLI ) " +
"FROM MAEDDO MAEDDO WITH ( NOLOCK ) " +
"INNER JOIN MAEEDO MAEEDO WITH ( NOLOCK ) ON MAEEDO.IDMAEEDO = MAEDDO.IDMAEEDO " +
"WHERE MAEDDO.ENDO = @RUT AND " +
"MAEDDO.TIDO IN ('NVV','RES','PRO','OCC','GDD','GDP','GDV','GRC','GRD','GRP') " +
"AND MAEDDO.EMPRESA=@Empresa AND MAEDDO.ESLIDO=' ' AND MAEDDO.LILG IN ('SI','GR') AND MAEEDO.ESDO<>'N' ";
try
{
Conn.ConnGlasser.Open();
Conn.CmdPlabal = new SqlCommand(Query, Conn.ConnGlasser);
Conn.CmdPlabal.Parameters.AddWithValue("@RUT", Rut);
Conn.CmdPlabal.Parameters.AddWithValue("@Empresa", Empresa);
dr = Conn.CmdPlabal.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Validadores validadores = new Validadores();
return(validadores.ParseoDouble(dr[0].ToString()));
}
else
{
return(0);
}
}
catch (Exception EX)
{
string ERRORSTR = "Mensaje:" + EX.Message + " trace: " + EX.StackTrace + " Rut:" + Rut + " empresa:" + Empresa;
ErrorCatching gETerror = new ErrorCatching();
gETerror.ErrorCatch(ERRORSTR, HttpContext.Current.Request.Url.ToString());
dr.Close();
Conn.ConnGlasser.Close();
return(0);
}
}
private double GetAmountCHEQUES()
{
Conn = new Coneccion();
Query = @"SELECT sum(VABRDO) " +
"FROM MAEEDO EDO WITH ( NOLOCK ) " +
"WHERE EDO.ENDO = @RUT AND EDO.TIDO IN ('CHV') AND " +
"EDO.EMPRESA=@Empresa AND EDO.ESPGDO = 'P' AND EDO.ESDO<>'N' AND EDO.NUDONODEFI = 0 ";
try
{
Conn.ConnGlasser.Open();
Conn.CmdPlabal = new SqlCommand(Query, Conn.ConnGlasser);
Conn.CmdPlabal.Parameters.AddWithValue("@RUT", Rut);
Conn.CmdPlabal.Parameters.AddWithValue("@Empresa", Empresa);
dr = Conn.CmdPlabal.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Validadores validadores = new Validadores();
return(Math.Round(validadores.ParseoDouble(dr[0].ToString()), 0));
}
else
{
return(0);
}
}
catch (Exception EX)
{
string ERRORSTR = "Mensaje:" + EX.Message + " trace: " + EX.StackTrace + " Rut:" + Rut + " empresa:" + Empresa;
ErrorCatching gETerror = new ErrorCatching();
gETerror.ErrorCatch(ERRORSTR, HttpContext.Current.Request.Url.ToString());
dr.Close();
Conn.ConnGlasser.Close();
return(0);
}
}
public bool AnularAsignUser(string ID, string token)
{
_token = new TokenClass();
string To = _token.TokenId;
bool valid = false;
if (To == token)
{
#region InsertString
string Insert = "UPDATE LO_invasignoperario SET Estado=1 WHERE Id=@ID ";
#endregion
try
{
ConnPlabal.Open();
cmdPlabal = new SqlCommand(Insert, ConnPlabal);
#region Parameters
cmdPlabal.Parameters.AddWithValue("@ID", ID);
#endregion
cmdPlabal.ExecuteNonQuery();
ConnPlabal.Close();
valid = true;
}
catch (Exception EX)
{
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
ConnGlasser.Close();
valid = false;
}
}
else
{
valid = false;
}
return(valid);
}
/* Hay que arreglar esta funcion, no está devolviendo ningun valor*/
private double GetAmountPedidos()
{
Conn = new Coneccion();
Query = @"SELECT SUM (totalPedido) FROM e_Pedidos WHERE Estado='INGo' ";
try
{
Conn.ConnPlabal.Open();
Conn.CmdPlabal = new SqlCommand(Query, Conn.ConnPlabal);
Conn.CmdPlabal.Parameters.AddWithValue("@RUT", Rut);
Conn.CmdPlabal.Parameters.AddWithValue("@Empresa", Empresa);
dr = Conn.CmdPlabal.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Validadores validadores = new Validadores();
return(validadores.ParseoDouble(dr[0].ToString()));
}
else
{
return(0);
}
}
catch (Exception EX)
{
string ERRORSTR = "Mensaje:" + EX.Message + " trace: " + EX.StackTrace + " Rut:" + Rut + " empresa:" + Empresa;
ErrorCatching gETerror = new ErrorCatching();
gETerror.ErrorCatch(ERRORSTR, HttpContext.Current.Request.Url.ToString());
dr.Close();
Conn.ConnPlabal.Close();
return(0);
}
}
