/// <summary> /// return the time activity from sql /// </summary> /// <param name="timeActivitydto"></param> /// <returns></returns> private List<TimeActivityFill> GetTimeActivityFromDb(TimeActivitydto timeActivitydto) { List<TimeActivityFill> fillList = new List<TimeActivityFill>(); using (SqlConnection sqlConnection = new SqlConnection(timeActivitydto.Syncdto.ConnectionString)) { string oString = "Select * from TimeActivity"; SqlCommand oCmd = new SqlCommand(oString, sqlConnection); sqlConnection.Open(); using (SqlDataReader oReader = oCmd.ExecuteReader()) { while (oReader.Read()) { TimeActivityFill timeActivityFill = new TimeActivityFill(); timeActivityFill.Employee = oReader["Employee"].ToString(); timeActivityFill.Customer = oReader["Customer"].ToString(); timeActivityFill.Item = oReader["Item"].ToString(); timeActivityFill.Date = oReader["Date"].ToString(); timeActivityFill.Hours = oReader["Hours"].ToString(); timeActivityFill.QboId = oReader["QboId"].ToString(); fillList.Add(timeActivityFill); } sqlConnection.Close(); } } return fillList; }
/// <summary> /// Populate the invoice left for pending. /// </summary> /// <param name="invoicedto"></param> /// <returns></returns> internal Invoicedto LoadPending(Invoicedto invoicedto) { List<TimeActivityFill> timeActivityFillList = new List<TimeActivityFill>(); using (SqlConnection sqlConnection = new SqlConnection(invoicedto.ConnectionString)) { string oString = string.Format("select * from TimeActivity where RealmId='{0}' and Invoice_QboId is null", invoicedto.CompanyId); SqlCommand oCmd = new SqlCommand(oString, sqlConnection); sqlConnection.Open(); using (SqlDataReader oReader = oCmd.ExecuteReader()) { while (oReader.Read()) { TimeActivityFill timeActivityFill = new TimeActivityFill(); timeActivityFill.Employee = oReader["Employee"].ToString(); timeActivityFill.Customer = oReader["Customer"].ToString(); timeActivityFill.Item = oReader["Item"].ToString(); timeActivityFill.Date = Convert.ToDateTime(oReader["Date"].ToString()).ToShortDateString(); timeActivityFill.Hours = oReader["Hours"].ToString(); timeActivityFill.QboId = oReader["QboId"].ToString(); timeActivityFillList.Add(timeActivityFill); } sqlConnection.Close(); } } if (invoicedto.InvoiceCreated==null) { invoicedto.InvoiceCreated = new List<InvoiceCreated>(); } invoicedto.InvoicePending = "Pending"; invoicedto.InvoicePendingLength = timeActivityFillList.Count; invoicedto.InvoicePendingList = timeActivityFillList; return invoicedto; }