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);
}
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));
}
// 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();
}
}
public override string ToString()
{
return(Reservation_ID.ToString() + Site_ID.ToString() + Name + From_Date.ToString() + To_Date.ToString() + Create_Date.ToString());
}