private static object[] TakeInsert(RefTypeEntity refTypeEntity) { return(new object[] { "@RefTypeID", refTypeEntity.RefTypeId, "@RefTypeName", refTypeEntity.RefTypeName, "@FunctionID", refTypeEntity.FunctionId, "@RefTypeCategoryID ", refTypeEntity.RefTypeCategoryId, "@MasterTableName ", refTypeEntity.MasterTableName, "@DetailTableName ", refTypeEntity.DetailTableName, "@LayoutMaster ", refTypeEntity.LayoutMaster, "@LayoutDetail ", refTypeEntity.LayoutDetail, "@DefaultDebitAccountCategoryID ", refTypeEntity.DefaultDebitAccountCategoryId, "@DefaultDebitAccountID ", refTypeEntity.DefaultDebitAccountId, "@DefaultCreditAccountCategoryID ", refTypeEntity.DefaultCreditAccountCategoryId, "@DefaultCreditAccountID ", refTypeEntity.DefaultCreditAccountId, "@DefaultTaxAccountCategoryID ", refTypeEntity.DefaultTaxAccountCategoryId, "@DefaultTaxAccountID ", refTypeEntity.DefaultTaxAccountId, "@AllowDefaultSetting ", refTypeEntity.AllowDefaultSetting, "@Postable ", refTypeEntity.Postable, "@Searchable ", refTypeEntity.Searchable, "@SortOrder ", refTypeEntity.SortOrder, "@SubSystem ", refTypeEntity.SubSystem, }); }
/// <summary> /// Takes the specified department. /// </summary> /// <param name="refTypeEntity">The department.</param> /// <returns></returns> private static object[] Take(RefTypeEntity refTypeEntity) { return(new object[] { "@RefTypeID", refTypeEntity.RefTypeId, "@DefaultCreditAccountCategoryID", refTypeEntity.DefaultCreditAccountCategoryId, "@DefaultCreditAccountID", refTypeEntity.DefaultCreditAccountId, "@DefaultDebitAccountCategoryID", refTypeEntity.DefaultDebitAccountCategoryId, "@DefaultDebitAccountID", refTypeEntity.DefaultDebitAccountId, "@DefaultTaxAccountCategoryID", refTypeEntity.DefaultTaxAccountCategoryId, "@DefaultTaxAccountID", refTypeEntity.DefaultTaxAccountId }); }
private static object[] TakeInsert(RefTypeEntity refTypeEntity) { return(new object[] { "@RefTypeID ", refTypeEntity.RefTypeID, "@RefTypeNo ", refTypeEntity.RefTypeNo, "@RefTypeCode ", refTypeEntity.RefTypeCode, "@RefTypeName ", refTypeEntity.RefTypeName, "@RefTypeCaption ", refTypeEntity.RefTypeCaption, "@FrmDetail ", refTypeEntity.FrmDetail, "@NameSpace ", refTypeEntity.NameSpace, "@SystemType ", refTypeEntity.SystemType, "@IsEnable ", refTypeEntity.IsEnable, "@ViewModel ", refTypeEntity.ViewModel, }); }
public RefTypeResponse InsertAccountDefaultConvert(RefTypeEntity refTypeEntity) { var response = new RefTypeResponse() { Acknowledge = AcknowledgeType.Success }; try { if (!refTypeEntity.Validate()) { foreach (string error in refTypeEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } var accountDefault = RefTypeDao.GetRefType(refTypeEntity.RefTypeId); if (accountDefault != null) { if (accountDefault.RefTypeId == refTypeEntity.RefTypeId) { response.Acknowledge = AcknowledgeType.Failure; response.Message = @"Tài khoản " + refTypeEntity.RefTypeName.Trim() + @" đã tồn tại !"; return(response); } } response.Message = RefTypeDao.InsertReftype(refTypeEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.RefTypeId = refTypeEntity.RefTypeId; return(response); } catch (Exception ex) { response.Message = ex.Message; return(response); } }
public List <RefTypeEntity> GetAccountsDefault(string connectionString) { List <RefTypeEntity> listAccount = new List <RefTypeEntity>(); using (var context = new MISAEntity(connectionString)) { var lstaccountDefault = context.RefTypes.ToList(); foreach (var result in lstaccountDefault) { var accountDefault = new RefTypeEntity(); accountDefault.RefTypeId = result.RefType1; accountDefault.RefTypeName = result.RefTypeName; accountDefault.FunctionId = result.FunctionID; accountDefault.RefTypeCategoryId = result.RefTypeCategory; accountDefault.MasterTableName = result.MasterTableName; accountDefault.DetailTableName = result.DetailTableName; accountDefault.LayoutMaster = result.LayoutMaster; accountDefault.LayoutDetail = result.LayoutDetail; accountDefault.DefaultDebitAccountCategoryId = result.DefaultDebitAccountCategoryID; accountDefault.DefaultDebitAccountId = result.DefaultDebitAccountID; accountDefault.DefaultCreditAccountCategoryId = result.DefaultCreditAccountCategoryID; accountDefault.DefaultCreditAccountId = result.DefaultCreditAccountID; accountDefault.DefaultTaxAccountCategoryId = result.DefaultTaxAccountCategoryID; accountDefault.DefaultTaxAccountId = result.DefaultTaxAccountID; accountDefault.AllowDefaultSetting = result.AllowDefaultSetting; accountDefault.Postable = result.Postable; accountDefault.Searchable = result.Searchable; accountDefault.SortOrder = result.SortOrder; accountDefault.SubSystem = result.SubSystem; listAccount.Add(accountDefault); } } return(listAccount); }
/// <summary> /// Updates the type of the reference. /// </summary> /// <param name="refTypeEntity">The reference type entity.</param> /// <returns></returns> public RefTypeResponse UpdateRefType(RefTypeEntity refTypeEntity) { var response = new RefTypeResponse { Acknowledge = AcknowledgeType.Success }; try { if (!refTypeEntity.Validate()) { foreach (var error in refTypeEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } using (var scope = new TransactionScope()) { response.Message = RefTypeDao.UpdateRefType(refTypeEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } scope.Complete(); } response.RefTypeId = refTypeEntity.RefTypeId; return(response); } catch (Exception ex) { response.Message = ex.Message; return(response); } }
public string InsertReftype(RefTypeEntity refTypeEntity) { const string sql = @"uspInsert_RefType"; return(Db.Update(sql, true, TakeInsert(refTypeEntity))); }
/// <summary> /// Updates the type of the reference. /// </summary> /// <param name="refTypeEntity">The reference type entity.</param> /// <returns></returns> public string UpdateRefType(RefTypeEntity refTypeEntity) { const string sql = @"uspUpdate_RefType"; return(Db.Update(sql, true, Take(refTypeEntity))); }
internal static RefTypeModel FromDataTransferObject(RefTypeEntity entity) { return(entity == null ? null : AutoMapper.Mapper.Map <RefTypeEntity, RefTypeModel>(entity)); }