/// <summary> /// Deletes the autoBusiness. /// </summary> /// <param name="autoBusiness">The autoBusiness.</param> /// <returns></returns> public string DeleteAutoBusiness(AutoBusinessEntity autoBusiness) { const string sql = @"uspDelete_AutoBusiness"; object[] parms = { "@AutoBusinessId", autoBusiness.AutoBusinessId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified autoBusiness. /// </summary> /// <param name="autoBusiness">The autoBusiness.</param> /// <returns></returns> private static object[] Take(AutoBusinessEntity autoBusiness) { return(new object[] { "@AutoBusinessID", autoBusiness.AutoBusinessId, "@AutoBusinessCode", autoBusiness.AutoBusinessCode, "@AutoBusinessName", autoBusiness.AutoBusinessName, "@RefTypeID", autoBusiness.RefTypeId, "@VoucherTypeID", autoBusiness.VoucherTypeId, "@DebitAccountNumber", autoBusiness.DebitAccountNumber, "@CreditAccountNumber", autoBusiness.CreditAccountNumber, "@BudgetSourceCode", autoBusiness.BudgetSourceCode, "@BudgetItemCode", autoBusiness.BudgetItemCode, "@Description", autoBusiness.Description, "@CurrencyCode", autoBusiness.CurrencyCode, "@IsActive", autoBusiness.IsActive }); }
/// <summary> /// Updates the account category. /// </summary> /// <param name="autoBusinessEntity">The automatic business entity.</param> /// <returns> /// AccountCategoryResponse. /// </returns> public AutoBusinessResponse UpdateAutoBusiness(AutoBusinessEntity autoBusinessEntity) { var response = new AutoBusinessResponse { Acknowledge = AcknowledgeType.Success }; try { if (!autoBusinessEntity.Validate()) { foreach (string error in autoBusinessEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } var autoBusiness = AutoBusinessDao.GetAutoBusinessesByAutoBusinessCode(autoBusinessEntity.AutoBusinessCode.Trim()); if (autoBusiness != null) { if (autoBusiness.AutoBusinessId != autoBusinessEntity.AutoBusinessId) { response.Acknowledge = AcknowledgeType.Failure; response.Message = @"Mã định khoản tự động " + autoBusinessEntity.AutoBusinessCode.Trim() + @" đã tồn tại !"; return(response); } } response.Message = AutoBusinessDao.UpdateAutoBusiness(autoBusinessEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.AutoBusinessId = autoBusinessEntity.AutoBusinessId; return(response); } catch (Exception ex) { response.Message = ex.Message; return(response); } }
/// <summary> /// Takes the specified autoBusiness. /// </summary> /// <param name="autoBusiness">The autoBusiness.</param> /// <returns></returns> private static object[] Take(AutoBusinessEntity autoBusiness) { return(new object[] { "@AutoBusinessID", autoBusiness.AutoBusinessId, "@AutoBusinessCode", autoBusiness.AutoBusinessCode, "@AutoBusinessName", autoBusiness.AutoBusinessName, "@RefTypeID", autoBusiness.RefTypeId, "@DebitAccount", autoBusiness.DebitAccount, "@CreditAccount", autoBusiness.CreditAccount, "@BudgetSourceID", autoBusiness.BudgetSourceId, "@BudgetChapterCode", autoBusiness.BudgetChapterCode, "@BudgetKindItemCode", autoBusiness.BudgetKindItemCode, "@BudgetSubKindItemCode", autoBusiness.BudgetSubKindItemCode, "@BudgetItemCode", autoBusiness.BudgetItemCode, "@BudgetSubItemCode", autoBusiness.BudgetSubItemCode, "@MethodDistributeID", autoBusiness.MethodDistributeId, "@CashWithDrawTypeID", autoBusiness.CashWithDrawTypeId, "@Description", autoBusiness.Description, "@IsActive", autoBusiness.IsActive }); }
public List <AutoBusinessEntity> GetAutoBusiness(string connectionString) { List <AutoBusinessEntity> listAutoBusiness = new List <AutoBusinessEntity>(); using (var context = new MISAEntity(connectionString)) { var lstAutoBusinessDetail = context.AutoBusinessDetails.ToList(); var lstAutoBusiness = context.AutoBusinesses.ToList().OrderBy(o => o.AutoBusinessID); int i = 0; foreach (var autoBusiness in lstAutoBusiness) { foreach (var result in autoBusiness.AutoBusinessDetails) { i = i + 1; var autoBusinessDetail = new AutoBusinessEntity(); autoBusinessDetail.AutoBusinessId = result.AutoBusinessDetailID.ToString(); autoBusinessDetail.AutoBusinessCode = i.ToString(); autoBusinessDetail.AutoBusinessName = autoBusiness.AutoBusinessName; autoBusinessDetail.RefTypeId = autoBusiness.RefTypeID; autoBusinessDetail.DebitAccount = result.DebitAccount; autoBusinessDetail.CreditAccount = result.CreditAccount; autoBusinessDetail.BudgetSourceId = result.BudgetSourceID.ToString(); autoBusinessDetail.BudgetChapterCode = result.BudgetChapterCode; autoBusinessDetail.BudgetKindItemCode = result.BudgetKindItemCode; autoBusinessDetail.BudgetSubKindItemCode = result.BudgetSubKindItemCode; autoBusinessDetail.BudgetItemCode = result.BudgetItemCode; autoBusinessDetail.BudgetSubItemCode = result.BudgetSubItemCode; autoBusinessDetail.MethodDistributeId = result.MethodDistributeID; autoBusinessDetail.CashWithDrawTypeId = result.CashWithDrawTypeID; autoBusinessDetail.Description = result.Description; autoBusinessDetail.IsActive = autoBusiness.Inactive == true ? false : true; listAutoBusiness.Add(autoBusinessDetail); } } } return(listAutoBusiness); }
internal static AutoBusinessModel FromDataTransferObject(AutoBusinessEntity entity) { return(entity == null ? null : AutoMapper.Mapper.Map <AutoBusinessEntity, AutoBusinessModel>(entity)); }
/// <summary> /// Updates the autoBusiness. /// </summary> /// <param name="autoBusiness">The autoBusiness.</param> /// <returns></returns> public string UpdateAutoBusiness(AutoBusinessEntity autoBusiness) { const string sql = @"uspUpdate_AutoBusiness"; return(Db.Update(sql, true, Take(autoBusiness))); }
/// <summary> /// Inserts the autoBusiness. /// </summary> /// <param name="autoBusiness">The autoBusiness.</param> /// <returns></returns> public int InsertAutoBusiness(AutoBusinessEntity autoBusiness) { const string sql = @"uspInsert_AutoBusiness"; return(Db.Insert(sql, true, Take(autoBusiness))); }