public void Insert_SalesAutorization_Type(String sDescription)
{
param = new SqlParameter[2];
param[0] = new SqlParameter("@iSales", SqlDbType.Int)
{
Value = 0
};
param[1] = new SqlParameter("@vSalesDesc", SqlDbType.VarChar)
{
Value = sDescription
};
objDB.ExecStoredIUD("sp_insertSalesAutorization_Type", param);
}
public errorCompositeType InsertTaskExchange(ExchangeFileCompositeType etct)
{
var lstError = new errorCompositeType();
try
{
var param = new SqlParameter[4];
param[0] = new SqlParameter("@fvlabel_file", SqlDbType.VarChar)
{
Value = etct.sLabel
};
param[1] = new SqlParameter("@fvaddress_file", SqlDbType.VarChar)
{
Value = etct.sURL
};
param[2] = new SqlParameter("@fiid_file_type", SqlDbType.Int)
{
Value = etct.iTiype
};
param[3] = new SqlParameter("@fiid_Exchange", SqlDbType.Int)
{
Value = etct.iExchange
};
objDB.ExecStoredIUD("sp_insertFileExchange", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType InsertEmployed(int iNumber, String sName, String sMotherLastName, String sFatherLasteName, String sEMail, int iIdArea, int iIdPlant, int iBoss, int iSubstitute)
{
errorCompositeType lstError = new errorCompositeType();
try
{
param = new SqlParameter[11];
param[0] = new SqlParameter("@finumber_employed", SqlDbType.Int);
param[0].Value = iNumber;
param[1] = new SqlParameter("@fvname_employed", SqlDbType.VarChar);
param[1].Value = sName;
param[2] = new SqlParameter("@fvmother_last_name", SqlDbType.VarChar);
param[2].Value = sMotherLastName;
param[3] = new SqlParameter("@fvfather_last_name", SqlDbType.VarChar);
param[3].Value = sFatherLasteName;
param[4] = new SqlParameter("@fvemail_employed", SqlDbType.VarChar);
param[4].Value = sEMail;
param[5] = new SqlParameter("@fistatus_employed", SqlDbType.Int);
param[5].Value = 1;
param[6] = new SqlParameter("@fiid_area", SqlDbType.Int);
param[6].Value = iIdArea;
param[7] = new SqlParameter("@fiid_plant", SqlDbType.Int);
param[7].Value = iIdPlant;
param[8] = new SqlParameter("@fdregistry_date", SqlDbType.DateTime);
param[8].Value = DateTime.Now;
param[9] = new SqlParameter("@fiid_boss", SqlDbType.Int);
param[9].Value = iBoss;
param[10] = new SqlParameter("@fiid_substitute", SqlDbType.Int);
param[10].Value = iSubstitute;
objDB.ExecStoredIUD("sp_insertEmployed", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeleteTaskExchange(int iIdTaskExchange)
{
var lstError = new errorCompositeType();
try
{
param = new SqlParameter[1];
param[0] = new SqlParameter("@iTaskExchange", SqlDbType.Int)
{
Value = iIdTaskExchange
};
objDB.ExecStoredIUD("sp_deleteTaskExchange", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType InsertExchangeAutorization(ExchangeAutorizationCompositeType eact)
{
var lstError = new errorCompositeType();
try
{
param = new SqlParameter[5];
param[0] = new SqlParameter("@fiid_Exchange", SqlDbType.Int)
{
Value = eact.iIdExchange
};
param[1] = new SqlParameter("@fiid_review_type_eng", SqlDbType.Int)
{
Value = eact.iIdReviewTypeEng
};
param[2] = new SqlParameter("@fvEngObservation", SqlDbType.VarChar)
{
Value = eact.sEngObsevations
};
param[3] = new SqlParameter("@fiid_review_type_adm", SqlDbType.Int)
{
Value = eact.iIdReviewTypeAdm
};
param[4] = new SqlParameter("@fvobservation", SqlDbType.VarChar)
{
Value = eact.sObsevations
};
objDB.ExecStoredIUD("sp_insertExchangeAutorization", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
/// <summary>
/// Inserta un Tipo de Cambio(Client) en la base de datos
/// </summary>
/// <param name="sDescription">La descripción</param>
public errorCompositeType InsertClient(String sDescription)
{
errorCompositeType lstError = new errorCompositeType();
try
{
bool bStatus = true;
param = new SqlParameter[2];
param[0] = new SqlParameter("@fvdescription_client", SqlDbType.VarChar);
param[0].Value = sDescription;
param[1] = new SqlParameter("@fbstatus_client", SqlDbType.Bit);
param[1].Value = bStatus;
objDB.ExecStoredIUD("sp_insertClient", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
//#region Insert
public errorCompositeType InsertExchangeFlA(ExchangeFlACompositeType ect)
{
errorCompositeType lstError = new errorCompositeType();
try
{
bool bStatus = true;
param = new SqlParameter[12];
param[0] = new SqlParameter("@fdDateIn", SqlDbType.DateTime);
param[0].Value = ect.dDateIn;
param[1] = new SqlParameter("@fdDatePromese", SqlDbType.DateTime);
param[1].Value = ect.dDatePromise;
param[2] = new SqlParameter("@fdDateOut", SqlDbType.DateTime);
param[2].Value = ect.dDateOut;
param[3] = new SqlParameter("@fvSOP", SqlDbType.VarChar);
param[3].Value = ect.SOECliente;
param[4] = new SqlParameter("@fiMold", SqlDbType.Int);
param[4].Value = ect.iMold;
param[5] = new SqlParameter("@fiMoldProt", SqlDbType.Int);
param[5].Value = ect.iMoldProt;
param[6] = new SqlParameter("@fiCostMa", SqlDbType.Int);
param[6].Value = ect.iCost;
param[7] = new SqlParameter("@fiDateStart", SqlDbType.Int);
param[7].Value = ect.iDateStart;
param[8] = new SqlParameter("@fiTotal", SqlDbType.Int);
param[8].Value = ect.iTotalInv;
param[9] = new SqlParameter("@fiTotalP", SqlDbType.Int);
param[9].Value = ect.iTotalP;
param[10] = new SqlParameter("@fbStatus", SqlDbType.Bit);
param[10].Value = ect.bStatus;
param[11] = new SqlParameter("@fiidEPL", SqlDbType.Int);
param[11].Value = ect.iIdPlEA;
objDB.ExecStoredIUD("sp_insertTAAfectationExchangePartList", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public void Del_RegFile(int iFile)
{
try
{
param = new SqlParameter[1];
param[0] = new SqlParameter("@idFile", SqlDbType.Int)
{
Value = iFile
};
objDB.ExecStoredIUD("sp_deleteFileRelease", param);
}
catch
{
throw new Exception();
}
}
public void DeleteDescription(string stp, string sParametro, int iId)
{
try
{
param = new SqlParameter[1];
param[0] = new SqlParameter(sParametro, SqlDbType.Int)
{
Value = iId
};
objDB.ExecStoredIUD(stp, param);
}
catch
{
throw new Exception();
}
}
public void ReviewMessages(int iUsuario, int iMessage)
{
try
{
param = new SqlParameter[2];
param[0] = new SqlParameter("@iMensaje", SqlDbType.Int)
{
Value = iMessage
};
param[1] = new SqlParameter("@iUsuario", SqlDbType.Int)
{
Value = iUsuario
};
objDB.ExecStoredIUD("sp_deleteMessage", param);
}
catch
{
throw new Exception();
}
}
public errorCompositeType InsertActionRol(int iIdAction, int iIdRol, Boolean bStatus)
{
var lstError = new errorCompositeType();
try
{
param = new SqlParameter[3];
param[0] = new SqlParameter("@fiIdAction", SqlDbType.TinyInt) { Value = iIdAction };
param[1] = new SqlParameter("@fiRol", SqlDbType.SmallInt) { Value = iIdRol };
param[2] = new SqlParameter("@fiStatus", SqlDbType.Bit) { Value = bStatus };
objDB.ExecStoredIUD("sp_insertActionsxRol", param);
lstError.bError = true;
return lstError;
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return lstError;
}
}
public errorCompositeType InsertExchange(ExchangeCompositeType ect, bool bInicial)
{
var lstError = new errorCompositeType();
try
{
bool bStatus = true;
param = new SqlParameter[18];
param[0] = new SqlParameter("@fvdescription_Exchange", SqlDbType.VarChar)
{
Value = ect.sDescription
};
param[1] = new SqlParameter("@fvissue_Exchange", SqlDbType.VarChar)
{
Value = ect.sIssue
};
param[2] = new SqlParameter("@fvmeasure_Exchange", SqlDbType.VarChar)
{
Value = ect.sMeasure
};
param[3] = new SqlParameter("@fvcontact_Exchange", SqlDbType.VarChar)
{
Value = ect.sContact
};
param[4] = new SqlParameter("@fvfolio_Exchange", SqlDbType.VarChar)
{
Value = ect.sFolio
};
param[5] = new SqlParameter("@fvprefolio_Exchange", SqlDbType.VarChar)
{
Value = ect.sFolioPre
};
param[6] = new SqlParameter("@fvproyect_Exchange", SqlDbType.VarChar)
{
Value = ect.sProyect
};
param[7] = new SqlParameter("@fdlimit_date_Exchange", SqlDbType.DateTime)
{
Value = ect.dLimitDate
};
param[8] = new SqlParameter("@fvlast_folio_Exchange", SqlDbType.VarChar)
{
Value = ect.sLastFolio
};
param[9] = new SqlParameter("@fistatus_Exchange", SqlDbType.Int)
{
Value = ect.iStatus
};
param[10] = new SqlParameter("@fiid_plant", SqlDbType.Int)
{
Value = ect.iIdPlant
};
param[11] = new SqlParameter("@fiid_Exchange_type", SqlDbType.Int)
{
Value = ect.iIdExchangeType
};
param[12] = new SqlParameter("@fiid_client", SqlDbType.Int)
{
Value = ect.iIdClient
};
param[13] = new SqlParameter("@fvreason_Exchange", SqlDbType.VarChar)
{
Value = ect.sReason
};
param[14] = new SqlParameter("@fiid_priority", SqlDbType.Int)
{
Value = ect.iIdPriority
};
param[15] = new SqlParameter("@fiid_serie_proyect", SqlDbType.Int)
{
Value = ect.iSerie
};
param[16] = new SqlParameter("@fiid_product_engeener", SqlDbType.Int)
{
Value = ect.iProductEngener
};
param[17] = new SqlParameter("@source", SqlDbType.Bit)
{
Value = bInicial
};
objDB.ExecStoredIUD("sp_insertExchange", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddQuote(QuoteCompositeType ect)
{
var lstError = new errorCompositeType();
try
{
bool bStatus = true;
param = new SqlParameter[45];
param[0] = new SqlParameter("@fiid_exchange", SqlDbType.Int)
{
Value = ect.iExchange
};
param[1] = new SqlParameter("@fiid_part_list", SqlDbType.Int)
{
Value = ect.iPartList
};
param[2] = new SqlParameter("@fvSOP", SqlDbType.VarChar)
{
Value = ect.SOPCliente
};
param[3] = new SqlParameter("@fdIn", SqlDbType.DateTime)
{
Value = ect.dIn
};
param[4] = new SqlParameter("@fdprom", SqlDbType.DateTime)
{
Value = ect.dProm
};
param[5] = new SqlParameter("@fdout", SqlDbType.DateTime)
{
Value = ect.dOut
};
param[6] = new SqlParameter("@fbmold_prot", SqlDbType.Bit)
{
Value = ect.bMoldProt
};
param[7] = new SqlParameter("@fimold_prot", SqlDbType.Decimal)
{
Value = ect.iMoldProt
};
param[8] = new SqlParameter("@fbmold_serie", SqlDbType.Bit)
{
Value = ect.bMoldSerie
};
param[9] = new SqlParameter("@fimold_serie", SqlDbType.Decimal)
{
Value = ect.iMoldSerie
};
param[10] = new SqlParameter("@fbCF", SqlDbType.Bit)
{
Value = ect.bCF
};
param[11] = new SqlParameter("@fiCF", SqlDbType.Decimal)
{
Value = ect.iCF
};
param[12] = new SqlParameter("@fbdevice", SqlDbType.Bit)
{
Value = ect.bDevice
};
param[13] = new SqlParameter("@fidevice", SqlDbType.Decimal)
{
Value = ect.iDevice
};
param[14] = new SqlParameter("@fbobsolet", SqlDbType.Bit)
{
Value = ect.bObsolet
};
param[15] = new SqlParameter("@fiobsolet", SqlDbType.Decimal)
{
Value = ect.iObsolet
};
param[16] = new SqlParameter("@fbeng_man", SqlDbType.Bit)
{
Value = ect.bEngMan
};
param[17] = new SqlParameter("@fieng_man", SqlDbType.Decimal)
{
Value = ect.iEngMan
};
param[18] = new SqlParameter("@fbdesign", SqlDbType.Bit)
{
Value = ect.bDesign
};
param[19] = new SqlParameter("@fidesign", SqlDbType.Decimal)
{
Value = ect.iDesign
};
param[20] = new SqlParameter("@fbcomponents", SqlDbType.Bit)
{
Value = ect.bComponents
};
param[21] = new SqlParameter("@ficomponets", SqlDbType.Decimal)
{
Value = ect.iComponents
};
param[22] = new SqlParameter("@fbothers", SqlDbType.Decimal)
{
Value = ect.bOthers
};
param[23] = new SqlParameter("@fvothers", SqlDbType.VarChar)
{
Value = ect.sOthers
};
param[24] = new SqlParameter("@fiothers", SqlDbType.Decimal)
{
Value = ect.iOthers
};
param[25] = new SqlParameter("@fbpaint", SqlDbType.Bit)
{
Value = ect.bPaint
};
param[26] = new SqlParameter("@fipaint", SqlDbType.Decimal)
{
Value = ect.iPaint
};
param[27] = new SqlParameter("@fbemp", SqlDbType.Bit)
{
Value = ect.bEmp
};
param[28] = new SqlParameter("@fiemp", SqlDbType.Decimal)
{
Value = ect.iEmp
};
param[29] = new SqlParameter("@fbbank", SqlDbType.Bit)
{
Value = ect.bBank
};
param[30] = new SqlParameter("@fibank", SqlDbType.Decimal)
{
Value = ect.iBank
};
param[31] = new SqlParameter("@fbothersC", SqlDbType.Bit)
{
Value = ect.bOthersC
};
param[32] = new SqlParameter("@fiothersC", SqlDbType.Decimal)
{
Value = ect.iOthersC
};
param[33] = new SqlParameter("@fipound", SqlDbType.Decimal)
{
Value = ect.iPound
};
param[34] = new SqlParameter("@fidelta1", SqlDbType.Int)
{
Value = ect.iDelta1
};
param[35] = new SqlParameter("@fidelta2", SqlDbType.Int)
{
Value = ect.iDelta2
};
param[36] = new SqlParameter("@ficost", SqlDbType.Decimal)
{
Value = ect.iCost
};
param[37] = new SqlParameter("@fimold_p", SqlDbType.Int)
{
Value = ect.iMoldP
};
param[38] = new SqlParameter("@fimold_prot_p", SqlDbType.Int)
{
Value = ect.iMoldProtP
};
param[39] = new SqlParameter("@fvobs", SqlDbType.VarChar)
{
Value = ect.sObservations
};
param[40] = new SqlParameter("@fistart", SqlDbType.Int)
{
Value = ect.iStart
};
param[41] = new SqlParameter("@fir1", SqlDbType.Decimal)
{
Value = ect.iFR1
};
param[42] = new SqlParameter("@fir2", SqlDbType.Decimal)
{
Value = ect.iFR2
};
param[43] = new SqlParameter("@fitotal_inv", SqlDbType.Decimal)
{
Value = ect.iTotalInv
};
param[44] = new SqlParameter("@fitotal_piece", SqlDbType.Decimal)
{
Value = ect.iTotalP
};
objDB.ExecStoredIUD("sp_insertQuote", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType InsertExchangeAffectationDocuments(affectationDocumentsCompositeType adct)
{
var lstError = new errorCompositeType();
try
{
bool bStatus = true;
param = new SqlParameter[13];
param[0] = new SqlParameter("@fiid_Exchange_affectation", SqlDbType.Int)
{
Value = adct.iIdExchange
};
param[1] = new SqlParameter("@dibujo", SqlDbType.Bit)
{
Value = adct.bDrawing
};
param[2] = new SqlParameter("@especificaciones", SqlDbType.Bit)
{
Value = adct.bEspecifications
};
param[3] = new SqlParameter("@HOE", SqlDbType.Bit)
{
Value = adct.bHOE
};
param[4] = new SqlParameter("@AMEF", SqlDbType.Bit)
{
Value = adct.bAMEF
};
param[5] = new SqlParameter("@Costos", SqlDbType.Bit)
{
Value = adct.bCost
};
param[6] = new SqlParameter("@SAP", SqlDbType.Bit)
{
Value = adct.bSAP
};
param[7] = new SqlParameter("@singoff", SqlDbType.Bit)
{
Value = adct.bSingOff
};
param[8] = new SqlParameter("@mediosproduccion", SqlDbType.Bit)
{
Value = adct.bMedia
};
param[9] = new SqlParameter("@dispositivoverificacion", SqlDbType.Bit)
{
Value = adct.bDevices
};
param[10] = new SqlParameter("@plancontrol", SqlDbType.Bit)
{
Value = adct.bPlan
};
param[11] = new SqlParameter("@molde", SqlDbType.Bit)
{
Value = adct.bMold
};
param[12] = new SqlParameter("@Otros", SqlDbType.Bit)
{
Value = adct.bOthers
};
objDB.ExecStoredIUD("sp_insertAfectationDocuments", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}