コード例 #1
0
        public string PopulateBody()
        {
            string body = string.Empty;


            Directory_Path = @"\Monthly_Invoice_Email.htm";


            using (StreamReader reader = new StreamReader(Environment.CurrentDirectory + Directory_Path))
            {
                body = reader.ReadToEnd();
            }
            body = body.Replace("{From_Date}", From_Date.ToString());
            body = body.Replace("{To_Date}", To_date.ToString());

            return(body);
        }
コード例 #2
0
 public override string ToString()
 {
     return(From_Date.ToString("MM/dd/yyy").PadRight(15) + To_Date.ToString("MM/dd/yyy").PadRight(15) + Site_Id.ToString().PadRight(10) + Reservation_Id.ToString().PadRight(15) + Name.PadRight(30));
 }
コード例 #3
0
        // FOR ACTIVE RECEIPTS
        public List <Remit_ReceiptRepo> GetERList(Remit_ReceiptRepo ReceiptRepo)
        {
            try
            {
                AppSettings app = new AppSettings();
                con = app.GetConnection();
                List <Remit_ReceiptRepo> bn = new List <Remit_ReceiptRepo>();

                string query = "Select * from VW_RECEIPT_EMPLOYER WHERE EMPLOYER_ID = '" + Employer_Id + "' and  (ACTUAL_RECEIPT_DATE between '" + From_Date.ToString("dd-MMM-yyyy") + "' and '" + To_Date.ToString("dd-MMM-yyyy") + "')   AND RECEIPT_STATUS = 'ACTIVE'";
                return(bn = con.Query <Remit_ReceiptRepo>(query).ToList());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Dispose();
            }
        }
コード例 #4
0
 public override string ToString()
 {
     return(Reservation_ID.ToString() + Site_ID.ToString() + Name + From_Date.ToString() + To_Date.ToString() + Create_Date.ToString());
 }