public string RecordLine() { StringBuilder sb = new StringBuilder(); sb.Append(recordType); // (2) - static length sb.Append(SduBatchId.PadLeft(20, '0')); sb.Append(SduTranId); //(20) - static length sb.Append(ReceiptNumber.PadLeft(7, '0')); sb.Append(StrRetransmittalIndicator.PadRight(1)); sb.Append(PayorID.PadRight(13)); sb.Append(PayorSSN.PadRight(9)); sb.Append(PaidBy.PadRight(15)); sb.Append(PayorLastName.PadRight(25)); sb.Append(PayorFirstName.PadRight(20)); sb.Append(PayorMiddleName.PadRight(20)); sb.Append(PayorSuffix.PadRight(3)); sb.Append(StrAmount.PadLeft(15, '0')); sb.Append(StrOfcAmount.PadLeft(15, '0')); sb.Append(PaymentMode.PadRight(2)); sb.Append(PaymentSource.PadRight(4)); sb.Append(ReceiptReceivedDate.PadRight(8)); sb.Append(ReceiptEffectiveDate.PadRight(8)); sb.Append(CheckNumber.PadRight(18)); sb.Append(ComplianceExemptionReason.PadRight(1)); sb.Append(TargetedPaymentIndicator.PadRight(1, '0')); sb.Append(Fips.PadRight(7)); sb.Append(CourtCaseNumber.PadRight(25)); sb.Append(CourtJudgementNumber.PadLeft(3, '0')); sb.Append(CourtGuidelineNumber.PadLeft(3, '0')); sb.Append(ReasonCode.PadRight(3)); sb.Append(filler.PadRight(32)); return(sb.ToString()); }
public List <FinalTransaction> SelectIndivisualTotalExpenses(Attribute objCategory) { List <Person> result = new List <Person>(); List <PaidBy> payee = new List <PaidBy>(); List <PaidTo> payto = new List <PaidTo>(); List <FinalTransaction> finaltransaction = new List <FinalTransaction>(); using (SqlConnection con = new SqlConnection(connection)) { using (SqlCommand cmd = new SqlCommand("Kit_SelectIndivisualTotalExpenses", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@FromDate", SqlDbType.VarChar)).Value = objCategory.FromDate; cmd.Parameters.Add(new SqlParameter("@ToDate", SqlDbType.VarChar)).Value = objCategory.ToDate; cmd.Parameters.Add(new SqlParameter("@KitchenID", SqlDbType.Int)).Value = Convert.ToInt32(Session["KitchenID"]); con.Open(); using (SqlDataReader dreader = cmd.ExecuteReader()) { while (dreader.Read()) { try { Person att = new Person() { TotalExpenses = Convert.ToDecimal(dreader["TotalExpenses"]), FirstName = dreader["FirstName"].ToString(), MiddleName = dreader["MiddleName"].ToString(), LastName = dreader["LastName"].ToString(), UserID = Convert.ToInt32(dreader["UserID"].ToString()), TotalPeople = Convert.ToInt32(dreader["TotalPeople"]) }; result.Add(att); } catch (Exception ex) { } } dreader.Close(); } con.Close(); } } decimal totalexpenses = 0; decimal perpersonexpenses = 0; int totalpeople = 0; foreach (Person lst in result) { totalexpenses += lst.TotalExpenses; totalpeople = lst.TotalPeople; //lst.TotalExpenses= } perpersonexpenses = totalexpenses / totalpeople; foreach (Person lst in result) { //categorize people whether payee or paidto groups if (lst.TotalExpenses > perpersonexpenses) { PaidTo pay2 = new PaidTo() { FirstName = lst.FirstName, MiddleName = lst.MiddleName, LastName = lst.LastName, Amount = lst.TotalExpenses, HaveToGet = lst.TotalExpenses - perpersonexpenses }; payto.Add(pay2); } else if (lst.TotalExpenses < perpersonexpenses) { PaidBy payby = new PaidBy() { FirstName = lst.FirstName, MiddleName = lst.MiddleName, LastName = lst.LastName, Amount = lst.TotalExpenses, HaveToPay = perpersonexpenses - lst.TotalExpenses }; payee.Add(payby); } } foreach (PaidBy person in payee) { foreach (PaidTo person2 in payto) { if (person2.HaveToGet != 0) { if (person2.HaveToGet >= person.HaveToPay) { FinalTransaction transaction = new FinalTransaction() { PaidBy = person.FirstName + " " + person.MiddleName + " " + person.LastName, Amount = person.HaveToPay, PaidTo = person2.FirstName + " " + person2.MiddleName + " " + person2.LastName }; person2.HaveToGet = person2.HaveToGet - person.HaveToPay; person.HaveToPay = person.HaveToPay - person.HaveToPay; finaltransaction.Add(transaction); } else if (person2.HaveToGet < person.HaveToPay) { if (person.HaveToPay != 0) { FinalTransaction transaction = new FinalTransaction() { PaidBy = person.FirstName + " " + person.MiddleName + " " + person.LastName, Amount = person2.HaveToGet, PaidTo = person2.FirstName + " " + person2.MiddleName + " " + person2.LastName }; person.HaveToPay = person.HaveToPay - person2.HaveToGet; person2.HaveToGet = person2.HaveToGet - person2.HaveToGet; finaltransaction.Add(transaction); } } } } } return(finaltransaction); }