public Common.OperationResult Add(Common.DataContract.ConditionDataContract dataContract)
{
var handler = DataAccess.Core.GetFactory().GetInstance <IConditionHandler>();
dataContract.CreatedBy = Common.SessionData.ResourceId;
dataContract.CreatedOn = DateTime.Now;
var val = dataContract.Validate();
if (!val.IsValid)
{
return(new Common.OperationResult(val));
}
if (dataContract.ConditionDetails != null && dataContract.ConditionDetails.Count() > 0)
{
dataContract.GeneratedCommand = GetCommandText(dataContract.ConditionDetails, dataContract.EntityId);
}
var result = handler.Add(dataContract);
if (result.Status == Common.OperationResultStatus.Succesfull)
{
UpdateConditionDetails(dataContract);
}
return(result);
}
public override Common.OperationResult Add(Common.DataContract.ConditionDataContract dataContract)
{
if (dataContract == null)
{
throw new ArgumentException("Cannot be Null", "dataContract");
}
try
{
Core.MainDataContextInstance().SGW_Conditions.InsertOnSubmit(GetLinqObj(dataContract));
Core.MainDataContextInstance().SubmitChanges();
return(new Common.OperationResult());
}
catch (Exception ex)
{
throw ex;
}
}
public override SGW_Condition GetLinqObj(Common.DataContract.ConditionDataContract dataContract, SGW_Condition linq)
{
if (dataContract == null)
{
return(null);
}
linq.Name = dataContract.Description;
linq.ConditionId = dataContract.Id;
linq.ConditionType = dataContract.ConditionType;
linq.EntityId = dataContract.EntityId;
linq.SQLCommand = dataContract.SQLCommand;
linq.StoredProcedure = dataContract.StoredProcedure;
linq.GeneratedCommand = dataContract.GeneratedCommand;
linq.CreatedOn = dataContract.CreatedOn;
linq.CreatedBy = dataContract.CreatedBy;
linq.UpdatedOn = dataContract.UpdatedOn;
linq.UpdatedBy = dataContract.UpdatedBy;
return(linq);
}
public override Common.DataContract.ConditionDataContract GetDataContract(SGW_Condition linqObj)
{
if (linqObj == null)
{
return(null);
}
Common.DataContract.ConditionDataContract dataContract = new Common.DataContract.ConditionDataContract();
dataContract.Id = linqObj.ConditionId;
dataContract.Description = linqObj.Name;
dataContract.ConditionType = linqObj.ConditionType;
dataContract.SQLCommand = linqObj.SQLCommand;
dataContract.StoredProcedure = linqObj.StoredProcedure;
dataContract.EntityId = linqObj.EntityId;
dataContract.GeneratedCommand = linqObj.GeneratedCommand;
dataContract.CreatedBy = linqObj.CreatedBy;
dataContract.CreatedOn = linqObj.CreatedOn;
dataContract.UpdatedBy = linqObj.UpdatedBy;
dataContract.UpdatedOn = linqObj.UpdatedOn;
return(dataContract);
}
public override Common.OperationResult Delete(Common.DataContract.ConditionDataContract dataContract)
{
if (dataContract == null)
{
throw new ArgumentException("Cannot be Null", "dataContract");
}
try
{
SGW_Condition obj = Core.MainDataContextInstance().SGW_Conditions.Where(o => o.ConditionId.Equals(dataContract.Id)).FirstOrDefault();
if (obj == null)
{
return(new Common.OperationResult(Common.OperationResultStatus.ValidationFailure, "Condição não encontrada."));
}
Core.MainDataContextInstance().SGW_Conditions.DeleteOnSubmit(obj);
Core.MainDataContextInstance().SubmitChanges();
return(new Common.OperationResult());
}
catch (Exception ex)
{
throw ex;
}
}
public Common.OperationResult Delete(Common.DataContract.ConditionDataContract dataContract)
{
var handler = DataAccess.Core.GetFactory().GetInstance <IConditionHandler>();
return(handler.Delete(dataContract));
}
public override SGW_Condition GetLinqObj(Common.DataContract.ConditionDataContract dataContract)
{
return(GetLinqObj(dataContract, new SGW_Condition()));
}
