} //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