public void setPasswordOldUser()
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary<String, Object> parameters = new Dictionary<string, object>();
parameters.Add("username", this.userName);
parameters.Add("password", this.password);
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_cambiar_password", parameters);
spManager.Close();
}
public void setPasswordOldUser()
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary <String, Object> parameters = new Dictionary <string, object>();
parameters.Add("username", this.userName);
parameters.Add("password", this.password);
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_cambiar_password", parameters);
spManager.Close();
}
public string publicarCupon(String codigo)
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary <String, Object> parameters = new Dictionary <string, object>();
parameters.Add("codigo", codigo);
try
{
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_publicar_cupon", parameters);
return("Publicación exitosa");
}
catch (Exception e)
{
return("Error en compra");
}
}
/*
* create procedure MR_ANDERSON.sp_pedir_devolucion (@ numeric(18), @codigo nvarchar(50), @ DATETIME,
* @ NVARCHAR(255), @ numeric )
* */
public string devolverCupon(String dni, String codigo, DateTime fecha, String motivo, String idCompra)
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary <String, Object> parameters = new Dictionary <string, object>();
parameters.Add("dni", Int32.Parse(dni));
parameters.Add("fecha_devolucion", fecha);
parameters.Add("motivo", motivo);
parameters.Add("id_compra", Int32.Parse(idCompra));
try
{
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_pedir_devolucion", parameters);
return("Devolución exitosa");
}
catch (SqlException e)
{
return("Error en la devolución: " + e.Message);
}
}
public static String Registrar(String codigo, String dni, String cuit)
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary <String, Object> param = new Dictionary <string, object>();
param.Add("fecha_actual", AdministradorConfiguracion.obtenerFecha());
param.Add("id_compra", Decimal.Parse(codigo));
param.Add("provee_cuit", cuit);
try
{
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_registra_consumo_cupon", param);
}
catch (Exception e)
{
return("Se produjo el siguiente error: " + e.Message);
}
spManager.Close();
return("Se registró correctamente.");
}
public static String Registrar(String codigo, String dni, String cuit)
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary<String, Object> param = new Dictionary<string, object>();
param.Add("fecha_actual", AdministradorConfiguracion.obtenerFecha());
param.Add("id_compra", Decimal.Parse(codigo));
param.Add("provee_cuit", cuit);
try
{
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_registra_consumo_cupon", param);
}
catch(Exception e)
{
return "Se produjo el siguiente error: " + e.Message;
}
spManager.Close();
return "Se registró correctamente.";
}
public string publicarCupon(String codigo)
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary<String, Object> parameters = new Dictionary<string, object>();
parameters.Add("codigo", codigo);
try
{
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_publicar_cupon", parameters);
return "Publicación exitosa";
}
catch (Exception e)
{
return "Error en compra";
}
}
/*
* create procedure MR_ANDERSON.sp_pedir_devolucion (@ numeric(18), @codigo nvarchar(50), @ DATETIME,
@ NVARCHAR(255), @ numeric )
* */
public string devolverCupon(String dni, String codigo, DateTime fecha, String motivo, String idCompra)
{
DataAccess.SPManager spManager = new GrouponDesktop.DataAccess.SPManager();
Dictionary<String, Object> parameters = new Dictionary<string, object>();
parameters.Add("dni", Int32.Parse(dni));
parameters.Add("fecha_devolucion", fecha);
parameters.Add("motivo", motivo);
parameters.Add("id_compra", Int32.Parse(idCompra));
try
{
spManager.executeSPWithParametersWithOutReturn("MR_ANDERSON.sp_pedir_devolucion", parameters);
return "Devolución exitosa";
}
catch (SqlException e)
{
return "Error en la devolución: " + e.Message;
}
}