} //end SendEmails
private static Project GetProjectInfo(Receivable r)
{
Console.WriteLine("Attempting to get Project info for Project " + r.ProjectID);
Project p = Project.GetProjectByID(r.ProjectID);
if (p != null)
{
Console.WriteLine("Project info = SUCCESS");
}//end if
else
{
Console.WriteLine("Project info = FAILED");
}//end else
return(p);
}
private static List <Receivable> GetReceivableList()
{
List <Receivable> RList;
Console.WriteLine("Attempting to get Receivable List...");
RList = Receivable.GetAllReceivables();
if (RList.Count > 0)
{
Console.WriteLine("Receivable List = SUCCESS");
}//end if
else
{
Console.WriteLine("Receivable List = FAILED");
}//end else
return(RList);
}
} //Empty Constructor
//Utils
public static List <Receivable> GetAllReceivables()
{
//local var
List <Receivable> RList = new List <Receivable>();
DataSet ds = new DataSet();
//get dataset of invoice by id
ds = ReceivableDB.GetAllReceivables();
//check for null DataSet
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
//local var
Receivable Rec = new Receivable();
//pass values
Rec.BillNo = int.Parse(dr["BillNo"].ToString());
Rec.ProjectID = int.Parse(dr["ProjectID"].ToString());
Rec.ItemCount = int.Parse(dr["InvoiceCount"].ToString());
Rec.DateCreated = DateTime.Parse(dr["DateCreated"].ToString());
Rec.DateSent = DateTime.Parse(dr["DateSent"].ToString());
Rec.SentByTuid = dr["SentByTUID"].ToString();
Rec.AmountDue = double.Parse(dr["AmountDue"].ToString());
//add to list
RList.Add(Rec);
}//end foreach
//Return List
return(RList);
} //end if inner
} //end if outter
return(null);
} //end GetReceivableByProjectID
