public static List <Voucher2Post> GetCurrentMonthTransactionsList(int officeID) { List <Voucher2Post> TheVoucher2PostList = new List <Voucher2Post>(); DataTable TheVoucher2PostDataTable = AccountsTransactionsDataAccess.GetInstance.GetCurrentMonthTransactionsList(officeID); foreach (DataRow dr in TheVoucher2PostDataTable.Rows) { Voucher2Post TheVoucher2Post = new Voucher2Post(); TheVoucher2Post.TranDate = DateTime.Parse(dr["TRAN. DATE"].ToString()).ToString(MicroConstants.DateFormat); TheVoucher2Post.TranNumber = int.Parse(dr["TRAN. NO."].ToString()); TheVoucher2Post.VoucherNumber = dr["VOUCHER NO."].ToString(); TheVoucher2Post.SerialNumber = int.Parse(dr["SL. NO."].ToString()); TheVoucher2Post.AccountsID = int.Parse(dr["ACC. ID"].ToString()); TheVoucher2Post.AccountCode = dr["ACC. CODE"].ToString(); TheVoucher2Post.AccountDescription = dr["ACC. DESC"].ToString().ToUpper(); TheVoucher2Post.TranType = dr["TRAN. TYPE"].ToString(); TheVoucher2Post.TranAmount = decimal.Parse(dr["TRAN. AMOUNT"].ToString()); TheVoucher2Post.BalanceType = dr["DR./CR."].ToString(); TheVoucher2Post.Narration = dr["ACC. NARRATION"].ToString(); TheVoucher2Post.IsPosted = dr["IsPosted"] != DBNull.Value ? dr["IsPosted"].ToString() : "N"; TheVoucher2Post.PostedBy = dr["PostedByUserID"] != DBNull.Value ? int.Parse(dr["PostedByUserID"].ToString()) : 0; TheVoucher2Post.PostedDate = dr["DateOfPosting"] != DBNull.Value ? dr["DateOfPosting"].ToString() : ""; TheVoucher2Post.PostMode = dr["ModeOfPosting"].ToString(); TheVoucher2Post.ACC_YEAR_ID = int.Parse(dr["ACC. YEAR ID"].ToString()); TheVoucher2Post.ACC_YEAR_CODE = dr["ACC. YEAR CODE"].ToString(); TheVoucher2Post.CURRENT_START_DATE = dr["YEAR START DT."].ToString(); TheVoucher2Post.CURRENT_END_DATE = dr["YEAR CLOSE DT."].ToString(); TheVoucher2Post.AccountGroupDescription = dr["GROUP-NAME"].ToString(); TheVoucher2Post.OfficeTypeID = int.Parse(dr["Office Type id"].ToString()); TheVoucher2Post.OfficeTypeName = dr["Type of Office"].ToString(); TheVoucher2Post.OfficeID = int.Parse(dr["Office ID"].ToString()); TheVoucher2Post.OfficeName = dr["Name Of The Office"].ToString(); TheVoucher2Post.OfficeCode = dr["Office Code"].ToString(); TheVoucher2Post.SocietyID = int.Parse(dr["SOCIETY ID"].ToString()); TheVoucher2Post.SocietyName = dr["SOCIETY NAME"].ToString(); TheVoucher2Post.SocietyAliasName = dr["SOCIETY ALIAS"].ToString(); TheVoucher2Post.SocietyCode = dr["SOCIETY CODE"].ToString(); TheVoucher2PostList.Add(TheVoucher2Post); } return(TheVoucher2PostList); }
public static List <Voucher2Post> GetValidTransactions() { List <Voucher2Post> TheVoucher2PostList = new List <Voucher2Post>(); DataTable TheVoucher2PostDataTable = AccountsTransactionsDataAccess.GetInstance.GetValidTransactionsList(); foreach (DataRow dr in TheVoucher2PostDataTable.Rows) { Voucher2Post TheVoucher2Post = new Voucher2Post(); TheVoucher2Post.TranDate = dr["TRAN. DATE"].ToString(); TheVoucher2Post.TranNumber = int.Parse(dr["TRAN. NO."].ToString()); TheVoucher2Post.SerialNumber = int.Parse(dr["SL. NO."].ToString()); TheVoucher2Post.AccountsID = int.Parse(dr["ACC. ID"].ToString()); TheVoucher2Post.AccountCode = dr["ACC. CODE"].ToString(); TheVoucher2Post.AccountDescription = dr["ACC. DESC"].ToString(); TheVoucher2Post.TranType = dr["TRAN. TYPE"].ToString(); TheVoucher2Post.TranAmount = decimal.Parse(dr["TRAN. AMOUNT"].ToString()); TheVoucher2Post.BalanceType = dr["DR./CR."].ToString(); TheVoucher2Post.Narration = dr["ACC. NARRATION"].ToString(); if (dr["IsPosted"] != DBNull.Value) { TheVoucher2Post.IsPosted = dr["IsPosted"].ToString(); } else { TheVoucher2Post.IsPosted = ""; } if (dr["PostedByUserID"] != DBNull.Value) { TheVoucher2Post.PostedBy = int.Parse(dr["PostedByUserID"].ToString()); } else { TheVoucher2Post.PostedBy = Micro.Commons.Connection.LoggedOnUser.UserID; } if (dr["DateOfPosting"] != DBNull.Value) { TheVoucher2Post.PostedDate = dr["DateOfPosting"].ToString(); } else { TheVoucher2Post.PostedDate = dr["TRAN. DATE"].ToString(); } TheVoucher2Post.PostMode = dr["ModeOfPosting"].ToString(); TheVoucher2Post.ACC_YEAR_ID = int.Parse(dr["ACC. YEAR ID"].ToString()); TheVoucher2Post.ACC_YEAR_CODE = dr["ACC. YEAR CODE"].ToString(); TheVoucher2Post.CURRENT_START_DATE = dr["YEAR START DT."].ToString(); TheVoucher2Post.CURRENT_END_DATE = dr["YEAR CLOSE DT."].ToString(); //TheAccounts_DailyTransactions.PREVIOUS_START_DATE = dr["PREVIOUS_START_DATE"].ToString(); //TheAccounts_DailyTransactions.PREVIOUS_END_DATE = dr["PREVIOUS_END_DATE"].ToString(); //TheAccounts_DailyTransactions.BOOK_CLOSING_FLAG = dr["BOOK_CLOSING_FLAG"].ToString(); //TheAccounts_DailyTransactions.YEAR_CLOSING_FLAG = dr["YEAR_CLOSING_FLAG"].ToString(); //TheAccounts_DailyTransactions.STATUS_FLAG = dr["STATUS_FLAG"].ToString(); //TheAccounts_DailyTransactions.MOD_DATE = dr["MOD_DATE"].ToString(); //TheAccounts_DailyTransactions.AUTH_CODE = dr["AUTH_CODE"].ToString(); //TheAccounts_DailyTransactions.AccountGroupID = int.Parse(dr["AccountGroupID"].ToString()); TheVoucher2Post.AccountGroupDescription = dr["GROUP-NAME"].ToString(); TheVoucher2Post.OfficeTypeID = int.Parse(dr["Office Type id"].ToString()); TheVoucher2Post.OfficeTypeName = dr["Type of Office"].ToString(); TheVoucher2Post.OfficeID = int.Parse(dr["Office ID"].ToString()); TheVoucher2Post.OfficeName = dr["Name Of The Office"].ToString(); TheVoucher2Post.OfficeCode = dr["Office Code"].ToString(); TheVoucher2Post.SocietyID = int.Parse(dr["SOCIETY ID"].ToString()); TheVoucher2Post.SocietyName = dr["SOCIETY NAME"].ToString(); TheVoucher2Post.SocietyAliasName = dr["SOCIETY ALIAS"].ToString(); TheVoucher2Post.SocietyCode = dr["SOCIETY CODE"].ToString(); TheVoucher2PostList.Add(TheVoucher2Post); } return(TheVoucher2PostList); }