public static List <AccountBookClose> GetMonthByOfficeId(int OfficeId) { List <AccountBookClose> AccountBookCloseList = new List <AccountBookClose>(); DataTable AccountingYeartable = AccountingYearDataAccess.GetInstance.GetMonthByOfficeId(OfficeId); foreach (DataRow dr in AccountingYeartable.Rows) { AccountBookClose TheAccountBookClose = DataRow(dr); AccountBookCloseList.Add(TheAccountBookClose); } return(AccountBookCloseList); }
public static AccountBookClose DataRow(DataRow dr) { AccountBookClose TheAccountBookClose = new AccountBookClose(); TheAccountBookClose.RecordNumber = int.Parse(dr["RecordNumber"].ToString()); TheAccountBookClose.AccountYearID = int.Parse(dr["AccountYearID"].ToString()); TheAccountBookClose.AccountYearMonth = dr["AccountYearMonth"].ToString(); TheAccountBookClose.IsBookClosed = char.Parse(dr["IsBookClosed"].ToString()); if (dr["BookCloseDateTime"] != DBNull.Value) { TheAccountBookClose.BookCloseDateTime = DateTime.Parse(dr["BookCloseDateTime"].ToString()).ToString(MicroConstants.DateFormat); } TheAccountBookClose.BookClosedByUserID = dr["BookClosedByUserID"] != DBNull.Value ? int.Parse(dr["BookClosedByUserID"].ToString()) : 0; TheAccountBookClose.AuthorisationID = dr["AuthorisationID"] != DBNull.Value ? int.Parse(dr["AuthorisationID"].ToString()) : 0; TheAccountBookClose.SocietyID = int.Parse(dr["SocietyID"].ToString()); TheAccountBookClose.OfficeID = int.Parse(dr["OfficeID"].ToString()); return(TheAccountBookClose); }
public static List <AccountBookClose> GetAccountsBookCloseList() { List <AccountBookClose> theAccountBookCloseList = new List <AccountBookClose>(); DataTable theAccountBookCloseTable = AccountsTransactionsDataAccess.GetInstance.GetAccountsBookCloseList(); foreach (DataRow dr in theAccountBookCloseTable.Rows) { AccountBookClose theAccountBookClose = new AccountBookClose(); theAccountBookClose.RecordNumber = int.Parse(dr["RecordNumber"].ToString()); theAccountBookClose.AccountYearID = int.Parse(dr["AccountYearID"].ToString()); theAccountBookClose.AccountYearMonth = dr["AccountYearMonth"].ToString(); theAccountBookClose.IsBookClosed = char.Parse(dr["IsBookClosed"].ToString()); theAccountBookClose.BookClosedByUserID = dr["BookClosedByUserID"] != DBNull.Value ? int.Parse(dr["BookClosedByUserID"].ToString()) : 0; theAccountBookClose.BookCloseDateTime = dr["BookCloseDateTime"] != DBNull.Value ? dr["BookCloseDateTime"].ToString() : string.Empty; theAccountBookClose.AuthorisationID = dr["AuthorisationID"] != DBNull.Value ? int.Parse(dr["AuthorisationID"].ToString()) : 0; theAccountBookClose.SocietyID = int.Parse(dr["SocietyID"].ToString()); theAccountBookClose.OfficeID = int.Parse(dr["OfficeID"].ToString()); theAccountBookCloseList.Add(theAccountBookClose); } return(theAccountBookCloseList); }