/// <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); }