/// <summary>
/// Insert TransactionType Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, int> TransactionTypeConditionDetail(tblTransactionTypeConditionDetail data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblTransactionTypeConditionDetail.Count();
if (propertyFind > 0)
{
data.id = db.tblTransactionTypeConditionDetail.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblTransactionTypeConditionDetail.Add(data);
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
if (result > 0)
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id));
}
else
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), result));
}
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, 0));
}
}
/// <summary>
/// Return All Transaction Condition Detail By Specific TransactionType ID and TransactionAnchorID
/// </summary>
/// <param name="TransactionTypeID">TransactionType ID</param>
/// <param name="TransactionAnchorID">TransactionAnchor ID</param>
/// <param name="ConditionID">Condition ID</param>
/// <returns>All Transaction Condition Detail</returns>
public static Tuple <ErrorObject, tblTransactionTypeConditionDetail> GetTransactionTypeConditionDetail(int TransactionTypeID, int TransactionAnchorID, int ConditionID)
{
tblTransactionTypeConditionDetail data = new tblTransactionTypeConditionDetail();
erros = new ErrorObject();
try
{
// using (HSCMEntities db = new HSCMEntities())
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblTransactionTypeConditionDetail.Where(t => t.idTransactionType == TransactionTypeID && t.idTransactionAnchor == TransactionAnchorID && t.idCondition == ConditionID).First();
}
erros.Error = false;
return(new Tuple <ErrorObject, tblTransactionTypeConditionDetail>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblTransactionTypeConditionDetail>(erros, data));
}
}
/// <summary>
/// Update Transaction Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> TransactionTypeConditionDetail(tblTransactionTypeConditionDetail data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblTransactionTypeConditionDetail.Single(p => p.id == data.id);
row.amount = data.amount;
row.upDateDate = data.upDateDate;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, String.Empty));
}
}
/// <summary>
/// Return Affected Row Or Error If Exist
/// </summary>
/// <param name="request">Employee Information</param>
/// <returns>Affected Row Or Error If Exist</returns>
public static GetTransactionTypeConditionDetailResponse TransactionTypeConditionDetail(GetTransactionTypeConditionDetailResponse request)
{
GetTransactionTypeConditionDetailResponse response = new GetTransactionTypeConditionDetailResponse();
response.Error = new Handler.ErrorObject();
try
{
tblTransactionTypeConditionDetail bussines = new tblTransactionTypeConditionDetail()
{
id = request.TransactionTypeConditionDetail.id,
amount = request.TransactionTypeConditionDetail.amount,
idCondition = request.TransactionTypeConditionDetail.idCondition,
idTransactionType = request.TransactionTypeConditionDetail.idTransactionType,
idTransactionAnchor = request.TransactionTypeConditionDetail.idTransactionAnchor,
createDate = DateTime.Now,
upDateDate = null,
deleteDate = null,
state = "Active"
};
var result = TransactionTypeConditionDetailData.Insert.TransactionTypeConditionDetail(bussines);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2.ToString();
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
