public void GetCustomer(string filtro)
{
try
{
if (!string.IsNullOrEmpty(filtro) && filtro.Length > 4)
{
SwiftExpressWSCustomer _objCustomer = new SwiftExpressWSCustomer();
var pResult = "";
var ds = _objCustomer.GetCustomerByIncome(filtro, Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
GrLookProvider.DataSource = ds;
GrLookProvider.DataBind();
Session["PROVIDER"] = ds;
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
Session["PROVIDER"] = null;
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void GetProvider(string filtro)
{
try
{
if (!string.IsNullOrEmpty(filtro) && filtro.Length > 4)
{
var pResult = "";
var ds = _wscalled.GetProvidersByIncome(filtro, _cs, ref pResult);
if (pResult == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
GrLookProvider.DataSource = ds;
GrLookProvider.DataBind();
Session["PROVIDER"] = ds;
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
Session["PROVIDER"] = null;
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void CbType_ValueChanged(object sender, EventArgs e)
{
try
{
if (CbType.SelectedItem.Value.ToString() == Enums.GetStringValue(RecepcionTipo.RecepcionPorDevolucion) || CbType.SelectedItem.Value.ToString() == Enums.GetStringValue(RecepcionTipo.DevolucionPorReparacion))
{
ClearFields(false);
}
//Por tipo
Session["PROVIDER"] = null;
GrLookProvider.DataSource = Session["PROVIDER"];
GrLookProvider.DataBind();
LlenarListaPorTipo("");
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
if (Session["SAP_RECEPTION_DATA"] != null)
{
GridSap.DataSource = Session["SAP_RECEPTION_DATA"];
GridSap.DataBind();
}
//Validacion de insercion de datos HEADER en tabla temporal
if (Request["__EVENTARGUMENT"] == "KeyPress")
{
_cs = Session["connectionString"].ToString();
_wscalled.InsertIncomeTemp(Convert.ToString(CbType.Value), Convert.ToString(GrLookProvider.Value), Convert.ToString(GrLookUser.Text), TxtReference.Text, SpinSap.Text, Session["USER"].ToString(), Session["connectionString"].ToString(), DateAssignedDate.Date, Convert.ToInt32(CbPriority.Value));
Session["INGRESO_HEADER"] = "TRUE";
}
//Validacion de insercion de datos en Detail en tabla Temporal
if (Request["__EVENTARGUMENT"] == "KeyPressSpE")
{
if ((string)Session["UPDATE_TEMP"] == "true")
{
_wscalled.UpdateDetail((int)Session["RECEPTION_DETAIL_TEMP"], Convert.ToString(GrLookSku.Value), Convert.ToString(GrLookSku.Text), Convert.ToInt32(SpinSku.Number), Session["connectionString"].ToString());
Session["UPDATE_TEMP"] = "false";
Session["EXPECTED"] = Convert.ToInt32(SpinSku.Number);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else if ((string)Session["INGRESO_HEADER"] == "TRUE")
{
var dsNumber = _wscalled.GetNumberHeader(Session["connectionString"].ToString());
Session["Header"] = Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]);
_wscalled.InsertIncomeDetail(Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]), Convert.ToString(GrLookSku.Value), Convert.ToDecimal(SpinSku.Number), Session["connectionString"].ToString(), GrLookSku.Text);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
SpinSku.Number = 0;
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
//?Actualizar o insertar en base a la variable de sesion que lo indica
if ((string)Session["UPDATE_TEMP"] == "true")
{
_wscalled.UpdateDetail((int)Session["RECEPTION_DETAIL_TEMP"], Convert.ToString(GrLookSku.Value), Convert.ToString(GrLookSku.Text), Convert.ToInt32(SpinSku.Number), Session["connectionString"].ToString());
Session["UPDATE_TEMP"] = "false";
Session["EXPECTED"] = Convert.ToInt32(SpinSku.Number);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
_wscalled.InsertIncomeTemp(Convert.ToString(CbType.Value), Convert.ToString(GrLookProvider.Value), Convert.ToString(GrLookUser.Text), TxtReference.Text, SpinSap.Text, Session["USER"].ToString(), Session["connectionString"].ToString(), DateAssignedDate.Date, Convert.ToInt32(CbPriority.Value));
Session["INGRESO_HEADER"] = "TRUE";
var dsNumber = _wscalled.GetNumberHeader(Session["connectionString"].ToString());
Session["Header"] = Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]);
_wscalled.InsertIncomeDetail(Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]), Convert.ToString(GrLookSku.Value), Convert.ToDecimal(SpinSku.Number), Session["connectionString"].ToString(), GrLookSku.Text);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
SpinSku.Number = 0;
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
}
}
_cs = (string)Session["connectionString"];
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
if (!Page.IsPostBack)
{
try
{
Session["SAP_RECEPTION_TYPE"] = null;
Session["LIST_DOC_ERP_PICKING"] = null;
Session["SAP_RECEPTION_DATA"] = null;
GridSap.DataSource = null;
GridSap.DataBind();
DateAssignedDate.Date = DateTime.Today;
Session["INGRESO_HEADER"] = "false";
Session["SaveReception"] = "false";
Session["dsReception"] = null;
//
LlenarListaDocErp();
//Carga de Tipos de clasificacion Recepcion
GetClassificationReception();
//Carga de Proveedores
GetProvider("");
//Carga de Operadores
GetOperator();
//Carga de SKU
if (Session["SKU"] != null)
{
var ds = (DataSet)Session["SKU"];
if (ds.Tables[0].Rows.Count > 0)
{
GrLookSku.DataSource = ds;
GrLookSku.DataBind();
Session["SKU"] = ds;
}
}
else
{
GetSku();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
try
{
if (Session["LIST_DOC_ERP_PICKING"] != null)
{
UiListaPedidosErp.DataSource = Session["LIST_DOC_ERP_PICKING"];
UiListaPedidosErp.DataBind();
}
GetSkuIngrid();
GrLookUser.DataSource = Session["OPERATOR"];
GrLookUser.DataBind();
GrLookProvider.DataSource = Session["PROVIDER"];
GrLookProvider.DataBind();
GrLookSku.DataSource = Session["SKU"];
GrLookSku.DataBind();
GridReception.DataSource = Session["dsReception"];
GridReception.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
ReportView();
}
