public string Priority(int id, string desc, out byte status)
{
lstError = new errorCompositeType();
var tm = new PriorityManager();
try
{
if (tm.ExistPriority(desc))
{
status = 2;
return(string.Empty);
}
if (id == 0)
{
tm.AddPriority(desc);
}
else
{
tm.UpdatePriority(id, desc);
}
status = 6;
return(string.Empty);
}
catch (Exception ex)
{
status = 1;
return(string.Empty);
}
}
public string AffectationType(int id, string desc, out byte status)
{
lstError = new errorCompositeType();
var tm = new AffectationTypeManager();
try
{
if (tm.ExistAffectation(desc))
{
status = 2;
return(string.Empty);
}
else
{
if (id == 0)
{
tm.AddAffectationType(desc);
}
else
{
tm.UpdateAffectationType(id, desc);
}
status = 6;
return(string.Empty);
}
}
catch (Exception ex)
{
status = 1;
return(string.Empty);
}
status = (byte)0;
return(null);
}
public string TaskData(int id, string desc1, string desc2, string desc3, out byte status)
{
lstError = new errorCompositeType();
var tm = new TaskDataManager();
try
{
if (tm.ExistTaskData(desc1, int.Parse(desc2), int.Parse(desc3)))
{
status = 2;
return(string.Empty);
}
else
{
if (id == 0)
{
tm.AddTaskData(int.Parse(desc2), int.Parse(desc3), desc1);
}
else
{
tm.UpdateTaskData(id, int.Parse(desc2), int.Parse(desc3), desc1);
}
status = 6;
return(string.Empty);
}
}
catch (Exception ex)
{
status = 1;
return(string.Empty);
}
status = (byte)0;
return(null);
}
public string PartList(int id, string desc1, string desc2, string desc3, out byte status)
{
lstError = new errorCompositeType();
var tm = new PartListManager();
try
{
if (tm.ExistPartList(desc2))
{
status = 2;
return(string.Empty);
}
else
{
if (id == 0)
{
tm.AddPartList(desc2, desc1, desc3);
}
else
{
tm.UpdatePartList(id, desc2, desc1, desc3);
}
status = 6;
return(string.Empty);
}
}
catch (Exception ex)
{
status = 1;
return(string.Empty);
}
status = (byte)0;
return(null);
}
public string Reason(int id, string desc1, string desc2, out byte status)
{
lstError = new errorCompositeType();
var tm = new ReasonManager();
try
{
if (tm.ExistNumberReason(int.Parse(desc2)))
{
status = 2;
return(string.Empty);
}
else
{
if (id == 0)
{
tm.AddReason(int.Parse(desc2), desc1);
}
else
{
tm.UpdateReason(id, int.Parse(desc2), desc1);
}
status = 6;
return(string.Empty);
}
}
catch (Exception ex)
{
status = 1;
return(string.Empty);
}
status = (byte)0;
return(null);
}
public string ExchangeType(int id, string desc1, string desc2, out byte status)
{
lstError = new errorCompositeType();
var tm = new ExchangeTypeManager();
try
{
if (tm.ExistExchangeType(desc1))
{
status = 2;
return(string.Empty);
}
else
{
if (id == 0)
{
tm.AddExchangeType(desc1, desc2);
}
else
{
tm.UpdateExchangeType(id, desc1, desc2);
}
status = 6;
return(string.Empty);
}
}
catch (Exception ex)
{
status = 1;
return(string.Empty);
}
status = (byte)0;
return(null);
}
public errorCompositeType AddTaskExchange(TaskExchangeCompositeType tect)
{
var lstError = new errorCompositeType();
try
{
te.InsertTaskExchange(tect);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateEmployed(int iIdEmployed, int iNumber, String sName, String sMotherLastName, String sFatherLastName, String sEmail, int iIdArea, int iIdPlant, int iBoss, int iSubstitute)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Employed et = new Employed();
et.UpdateEmployed(iIdEmployed, iNumber, sName, sMotherLastName, sFatherLastName, sEmail, iIdArea, iIdPlant, iBoss, iSubstitute);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
//Add
public errorCompositeType UpdateExchangeDate(ExchangeCompositeType ectExchange)
{
var lstError = new errorCompositeType();
try
{
var et = new Exchange();
et.UpdateExchangeDateById(ectExchange);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeleteTaskData(int iIdTaskData)
{
errorCompositeType lstError = new errorCompositeType();
try
{
TaskData et = new TaskData();
et.DeleteTaskData(iIdTaskData);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddGroup(String description)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Group et = new Group();
et.InsertGroup(description);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeletePartList(int iIdPartList)
{
var lstError = new errorCompositeType();
try
{
var r = new PartList();
r.DeletePartList(iIdPartList);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeletePriority(int iIdPriority)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Priority et = new Priority();
et.DeletePriority(iIdPriority);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddAffectationType(String description)
{
errorCompositeType lstError = new errorCompositeType();
try
{
AffectationType et = new AffectationType();
et.InsertAffectationType(description);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateExchangeType(int iIdExchangeType, String sDescription, String sInitial)
{
errorCompositeType lstError = new errorCompositeType();
try
{
ExchangeType et = new ExchangeType();
et.UpdateExchangeType(iIdExchangeType, sDescription, sInitial);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateQuote(QuoteCompositeType qct)
{
var lstError = new errorCompositeType();
try
{
var r = new Quote();
r.UpdateQuote(qct);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddPriority(String description)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Priority et = new Priority();
et.InsertPriority(description);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeleteAffectationType(int iIdAffectationType)
{
errorCompositeType lstError = new errorCompositeType();
try
{
AffectationType et = new AffectationType();
et.DeleteAffectationType(iIdAffectationType);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdatePriority(int iIdPriority, String sDescription)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Priority et = new Priority();
et.UpdatePriority(iIdPriority, sDescription);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddArea(String description, int iNumber, int iResponsable)
{
var lstError = new errorCompositeType();
try
{
var et = new Area();
et.InsertArea(description, iNumber, iResponsable);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdatePartList(int iIdPartList, String iNumber, String sDescription, String iNumberClient)
{
var lstError = new errorCompositeType();
try
{
var r = new PartList();
r.UpdatePartList(iIdPartList, iNumber, sDescription, iNumberClient);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateArea(int iIdArea, String sDescription, int iNumber, int iResponsable)
{
var lstError = new errorCompositeType();
try
{
var et = new Area();
et.UpdateArea(iIdArea, sDescription, iNumber, iResponsable);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeleteGroup(int iIdGroup)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Group et = new Group();
et.DeleteGroup(iIdGroup);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateExchangeAutorization(ExchangeAutorizationCompositeType eact)
{
var lstError = new errorCompositeType();
try
{
var et = new ExchangeAutorization();
et.UpdateExchangeAutorization(eact);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateTaskData(int iIdTaskData, int iIdTask, int iIdGroup, String sDescription)
{
errorCompositeType lstError = new errorCompositeType();
try
{
TaskData et = new TaskData();
et.UpdateTaskData(iIdTaskData, iIdTask, iIdGroup, sDescription);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddReviewType(String description)
{
var lstError = new errorCompositeType();
try
{
var et = new ReviewType();
et.InsertReviewType(description);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeleteEmployed(int iIdEmployed)
{
errorCompositeType lstError = new errorCompositeType();
try
{
Employed et = new Employed();
et.DeleteEmployed(iIdEmployed);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType DeleteReviewType(int iIdReviewType)
{
var lstError = new errorCompositeType();
try
{
var et = new ReviewType();
et.DeleteReviewType(iIdReviewType);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType AddExchangeFlA(ExchangeFlACompositeType ectExchangeFlA)
{
errorCompositeType lstError = new errorCompositeType();
try
{
ExchangeFlA et = new ExchangeFlA();
et.InsertExchangeFlA(ectExchangeFlA);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public errorCompositeType UpdateReviewType(int iIdReviewType, String sDescription)
{
errorCompositeType lstError = new errorCompositeType();
try
{
ReviewType et = new ReviewType();
et.UpdateReviewType(iIdReviewType, sDescription);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}