public void Day4BValidPasswordMyTest1()
{
Assert.IsFalse(Day4.IsValidPassword("555666", false));
Assert.IsFalse(Day4.IsValidPassword(555666, false));
}
public void Day4Test4()
{
Day4 t = new Day4();
Assert.IsFalse(t.Rule2(223450));
}
public void Day4Test6()
{
Day4 t = new Day4();
Assert.IsTrue(t.Rule2(123789));
}
public void DoItB() // 58559
{
var day = new Day4();
Console.WriteLine(day.SolveB(InputData.Day4));
}
public void Day4Test2()
{
Day4 t = new Day4();
Assert.IsTrue(t.Rule2(111111));
}
public void Answer2()
{
int answer = 103;
Assert.AreEqual(answer, Day4.Problem2());
}
public void BeforeEach()
{
_sut = new Day4();
}
public void TestProblem1()
{
var test = Day4.Problem1("aa bb cc dd ee\naa bb cc dd aa\naa bb cc dd aaa");
Assert.Equal(2, test);
}
public void TestProblem1Real()
{
var test = Day4.Problem1(Real);
Assert.Equal(386, test);
}
public void TestIsValidPassphrase1Invalid()
{
var test = Day4.IsValidPassphrase1("aa bb cc dd aa");
Assert.False(test);
}
public void TestIsValidPassphrase1WordContainsAnotherWord()
{
var test = Day4.IsValidPassphrase1("aa bb cc dd aaa");
Assert.True(test);
}
public void TestProblem2Real()
{
var test = Day4.Problem2(Real);
Assert.Equal(208, test);
}
public static void ProcessInputDay(int dayValue)
{
switch (dayValue)
{
case 0:
Day0.CallGreet();
break;
case 1:
Day1.ReturnSumByType();
break;
case 2:
Day2.InputValues();
break;
case 3:
Day3.ConditionalStaments();
break;
case 4:
Day4.PersonAge();
break;
case 5:
Day5.MultiplicationTable();
break;
case 6:
Day6.Review();
break;
case 7:
Day7.ArrayNumber();
break;
case 8:
Day8.PhoneDirectory();
break;
case 9:
Day9.FactorialNumber();
break;
case 10:
Day10.ConvertNumber();
break;
case 11:
Day11.HourGlass2DArray();
break;
case 12:
Day12.InharenceExercise();
break;
case 13:
Day13.AbstractClassExercise();
break;
case 14:
Day14.AbsoluteNumber();
break;
case 15:
Day15.LinkedList();
break;
case 16:
Day16.ExceptionStringToInt();
break;
case 17:
Day17.NonNegativesNumbers();
break;
case 18:
Day18.Palindrome();
break;
case 19:
Day19.InterfaceExcersise();
break;
case 20:
Day20.SortingValue();
break;
case 21:
Day21.GenericPrint();
break;
case 22:
Day22.NodeRoot();
break;
case 23:
Day23.Search();
break;
case 24:
Day24.LinkedList();
break;
case 25:
Day25.PrimeOrNot();
break;
case 26:
Day26.Nested();
break;
case 28:
Day_28.RegexTester();
break;
case 29:
Day29.BitwiseAND();
break;
default:
Console.WriteLine("Coming soon...");
break;
}
}
private void Generate()
{
int Issue = 0;
DateTime extraDay = DateTime.Now;
//delete from table.
SqlQuery = "delete from REPORT";
conString = ConfigurationManager.AppSettings["conString"];
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlCommand cmd = new SqlCommand(SqlQuery, con);
cmd.ExecuteNonQuery();
}
DateTime From = Convert.ToDateTime(datepickerfrom.Text);
DateTime To = Convert.ToDateTime(datepickerTo.Text);
//schedular
//DateTime From = Convert.ToDateTime(DateTime.Today.AddDays(-7));
//DateTime To = Convert.ToDateTime(DateTime.Now);
//DataTable pending = GetData("select ReceivedDate, Pending from (select cast(FI_CreatedOn as date )as ReceivedDate,sum([IP_Asg]) as Pending from (select * from (select FI_CreatedOn ,IND_Status from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID) src pivot (count(IND_Status) for IND_Status in ([IP_Asg]) ) piv) aaa where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' group by cast(FI_CreatedOn as date))a order by ReceivedDate");
DataTable pending = GetData("select ReceivedDate, Issue+Invoicesassigned+InvoiceInProgress+invoiceUnassigned as PendingTotal, Invoicesassigned+InvoiceInProgress+invoiceUnassigned as pending,Issue as Issue from(select ReceivedDate,TotalInvoicesReceived,Invoicesassigned,InvoiceInProgress,(TotalInvoicesReceived - (Invoicesassigned+InvoiceInProgress+QCUnassinged+QCAssigned+QCInprogress+QCCompleted+Duplicate+Issue+EDI+DNP+Expedite+Statement)) as invoiceUnassigned,(QCUnassinged+QCAssigned+QCInprogress+QCCompleted) as InvoiceCompleted,Duplicate,Issue,EDI,DNP,Expedite from (select cast(FI_CreatedOn as date )as ReceivedDate,count (FI_OriginalName) as TotalInvoicesReceived,sum([IP_Asg]) as Invoicesassigned,sum([IP_Inp]) as InvoiceInProgress,sum ([QC_Idle]) as QCUnassinged,sum([QC_Asg])as QCAssigned,sum([QC_Inp])as QCInprogress,sum([QC_Comp])as QCCompleted,sum([Duplicate])as Duplicate,sum([IP_Issue])as Issue, SUM([EDI]) as EDI, SUM([DNP]) as DNP, SUM([Expedite]) as Expedite,SUM([Statement]) as Statement from (select * from (select FI_OriginalName,FI_Source,FI_CreatedOn ,IND_Status,IND_FI from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID ) src pivot (count(IND_Status) for IND_Status in ([IP_Asg],[QC_Inp],[QC_Idle],[IP_Inp],[QC_Comp],[QC_Asg],[Duplicate],[IP_Issue],[EDI],[DNP],[Expedite],[Statement]) ) piv) aaa where FI_Source not in ('EDI') and cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' group by cast(FI_CreatedOn as date ))a)b ");
DataTable dt = new DataTable();
//dt = GetData(";with CTE_Input1 as ( select RecieveDate,cast(IND_IP_ModifiedOn as date) as ProcessDate, count(FI_OriginalName) as InvoiceCount from (select cast(FI_CreatedOn as date ) as RecieveDate, IND_IP_ModifiedOn,FI_OriginalName from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' and IND_IP_Processed_By !='null' and IND_Status not in ('IP_Asg','IP_Issue')) A group by cast(IND_IP_ModifiedOn as date),RecieveDate),CTE_Input2 as (select cast(FI_CreatedOn as date )as RecieveDate, count(FI_OriginalName) as TotalInvoices from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' group by cast(FI_CreatedOn as date )),CTE_Input3 as(SELECT RecieveDate,ProcessDate,TotalInvoices,InvoiceCount,Cast(round(Accuracy,2) as decimal(10,2)) as Day1 FROM (select CTE_Input1.RecieveDate as RecieveDate,CTE_Input1.ProcessDate as ProcessDate,CTE_Input1.InvoiceCount as InvoiceCount,CTE_Input2.TotalInvoices as TotalInvoices, case when CTE_Input1.InvoiceCount<>0 then (CAST(CTE_Input1.InvoiceCount as float)/CAST(CTE_Input2.TotalInvoices as float)*100.0) else 100 END as Accuracy from CTE_Input1 join CTE_Input2 on CTE_Input1.RecieveDate=CTE_Input2.RecieveDate where ProcessDate<= DATEADD(day,DATEDIFF(day,0,CTE_Input1.RecieveDate),7) )B ) " +
// "select * from CTE_Input3");
dt = GetData(";with CTE_Input1 as ( select RecieveDate,cast(IND_IP_ModifiedOn as date) as ProcessDate, count(FI_OriginalName) as InvoiceCount from (select cast(FI_CreatedOn as date ) as RecieveDate, IND_IP_ModifiedOn,FI_OriginalName from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' and IND_IP_Processed_By !='null' and FI_Source !='EDI' and IND_Status not in ('IP_Asg','IP_Inp','IP_Issue')) A group by cast(IND_IP_ModifiedOn as date),RecieveDate),CTE_Input2 as (select cast(FI_CreatedOn as date )as RecieveDate, count(FI_OriginalName) as TotalInvoices from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' and FI_Source !='EDI' group by cast(FI_CreatedOn as date )),CTE_Input3 as(SELECT RecieveDate,ProcessDate,TotalInvoices,InvoiceCount,Cast(round(Accuracy,2) as decimal(10,2)) as Day1 FROM (select CTE_Input1.RecieveDate as RecieveDate,CTE_Input1.ProcessDate as ProcessDate,CTE_Input1.InvoiceCount as InvoiceCount,CTE_Input2.TotalInvoices as TotalInvoices, case when CTE_Input1.InvoiceCount<>0 then (CAST(CTE_Input1.InvoiceCount as float)/CAST(CTE_Input2.TotalInvoices as float)*100.0) else 100 END as Accuracy from CTE_Input1 join CTE_Input2 on CTE_Input1.RecieveDate=CTE_Input2.RecieveDate )B ) " +
"select * from CTE_Input3");
if (dt.Rows.Count < 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "YourUniqueScriptKey", "alert('No records found');", true);
grdPending.DataSource = null;
grdPending.DataBind();
grdReport.DataSource = null;
grdReport.DataBind();
grdSLA.DataSource = null;
grdSLA.DataBind();
subgrid.Visible = false;
return;
}
//select distinct date.
var distinctValues = dt.AsEnumerable()
.Select(row => new
{
attribute1_name = row.Field <DateTime>("RecieveDate"),
})
.Distinct();
//loop through recieve date
foreach (var RecieveDate in distinctValues)
{
DataTable GroupData = null;
var query = from t in dt.AsEnumerable()
where t.Field <DateTime>("RecieveDate") == RecieveDate.attribute1_name
select t;
if (query != null && query.Count() > 0)
{
int Day6Invoice = 0;
decimal Day6Percenatage = 0;
int Day5Invoice = 0;
decimal Day5Percenatage = 0;
int Day4Invoice = 0;
decimal Day4Percenatage = 0;
int Day3Invoice = 0;
decimal Day3Percenatage = 0;
int Day2Invoice = 0;
decimal Day2Percenatage = 0;
int Pending = 0;
decimal Day1Percenatage = 0;
int Day1Invoice = 0;
DateTime Processdate = DateTime.Now;
GroupData = query.CopyToDataTable();
DateTime Recievedate = Convert.ToDateTime(GroupData.Rows[0]["RecieveDate"]);
int TotalInvoices = Convert.ToInt32(GroupData.Rows[0]["TotalInvoices"]);
for (int i = 0; i < pending.Rows.Count; i++)
{
DateTime PendingReceiveDate = Convert.ToDateTime(pending.Rows[i]["ReceivedDate"]);
if (PendingReceiveDate == Recievedate)
{
Pending = Convert.ToInt32(pending.Rows[i]["pending"]);
Issue = Convert.ToInt32(pending.Rows[i]["Issue"]);
}
}
//Day counting
int flag = 0;
DateTime Day2;
DateTime Day3;
DateTime Day4;
DateTime Day5;
DateTime Day6;
//if (Recievedate.DayOfWeek == DayOfWeek.Friday)
//{
// flag = 1;
// Day2 = Recievedate.AddDays(3);
//}
//else
//{
// Day2 = Recievedate.AddDays(1);
// flag = 0;
//}
//if (Recievedate.DayOfWeek == DayOfWeek.Friday)
//{
// if (flag == 1)
// {
// Day3 = Recievedate.AddDays(4);
// flag = 1;
// }
// else
// {
// Day3 = Recievedate.AddDays(3);
// flag = 0;
// }
//}
//else
//{
// Day3 = Recievedate.AddDays(2);
//}
//if (Recievedate.DayOfWeek == DayOfWeek.Friday)
//{
// if (flag == 1)
// {
// Day4 = Recievedate.AddDays(5);
// flag = 1;
// }
// else
// {
// Day4 = Recievedate.AddDays(3);
// flag = 0;
// }
//}
//else
//{
// Day4 = Recievedate.AddDays(3);
//}
//if (Recievedate.DayOfWeek == DayOfWeek.Friday)
//{
// if (flag == 1)
// {
// Day5 = Recievedate.AddDays(6);
// flag = 1;
// }
// else
// {
// Day5 = Recievedate.AddDays(3);
// flag = 0;
// }
//}
//else
//{
// Day5 = Recievedate.AddDays(4);
//}
//if (Recievedate.DayOfWeek == DayOfWeek.Friday)
//{
// if (flag == 1)
// {
// Day6 = Recievedate.AddDays(7);
// flag = 1;
// }
// else
// {
// Day6 = Recievedate.AddDays(3);
// flag = 0;
// }
//}
//else
//{
// Day6 = Recievedate.AddDays(5);
//}
//extraDay = Day6;
if (Recievedate.DayOfWeek == DayOfWeek.Friday)
{
flag = 1;
Day2 = Recievedate.AddDays(3);
}
else
{
Day2 = Recievedate.AddDays(1);
flag = 0;
if (Day2.DayOfWeek == DayOfWeek.Saturday)
{
Day2 = Day2.AddDays(2);
}
if (Day2.DayOfWeek == DayOfWeek.Sunday)
{
Day2 = Day2.AddDays(1);
}
}
if (Recievedate.DayOfWeek == DayOfWeek.Friday)
{
if (flag == 1)
{
Day3 = Recievedate.AddDays(4);
flag = 1;
}
else
{
Day3 = Recievedate.AddDays(3);
flag = 0;
}
}
else
{
if (Day2 == Recievedate.AddDays(3))
{
Day3 = Recievedate.AddDays(4);
}
else
{
Day3 = Recievedate.AddDays(2);
}
if (Day3.DayOfWeek == DayOfWeek.Saturday)
{
Day3 = Day3.AddDays(2);
}
if (Day3.DayOfWeek == DayOfWeek.Sunday)
{
if (Day2 != Day3.AddDays(1))
{
Day3 = Day3.AddDays(1);
}
}
}
if (Recievedate.DayOfWeek == DayOfWeek.Friday)
{
if (flag == 1)
{
Day4 = Recievedate.AddDays(5);
flag = 1;
}
else
{
Day4 = Recievedate.AddDays(3);
flag = 0;
}
}
else
{
if (Day2 == Recievedate.AddDays(3) || Day3 == Recievedate.AddDays(3))
{
Day4 = Recievedate.AddDays(5);
}
else
{
Day4 = Recievedate.AddDays(3);
}
if (Day4.DayOfWeek == DayOfWeek.Saturday)
{
Day4 = Day4.AddDays(2);
}
if (Day4.DayOfWeek == DayOfWeek.Sunday)
{
if (Day3 != Day4.AddDays(1))
{
Day4 = Day4.AddDays(1);
}
}
}
if (Recievedate.DayOfWeek == DayOfWeek.Friday)
{
if (flag == 1)
{
Day5 = Recievedate.AddDays(6);
flag = 1;
}
else
{
Day5 = Recievedate.AddDays(3);
flag = 0;
}
}
else
{
if (Day2 == Recievedate.AddDays(4) || Day3 == Recievedate.AddDays(4) || Day4 == Recievedate.AddDays(4))
{
Day5 = Recievedate.AddDays(6);
}
else
{
Day5 = Recievedate.AddDays(4);
}
if (Day5.DayOfWeek == DayOfWeek.Saturday)
{
Day5 = Day5.AddDays(2);
}
if (Day5.DayOfWeek == DayOfWeek.Sunday)
{
if (Day4 != Day5.AddDays(1))
{
Day5 = Day5.AddDays(1);
}
}
}
if (Recievedate.DayOfWeek == DayOfWeek.Friday)
{
if (flag == 1)
{
Day6 = Recievedate.AddDays(7);
flag = 1;
}
else
{
Day6 = Recievedate.AddDays(3);
flag = 0;
}
}
else
{
Day6 = Recievedate.AddDays(5);
}
extraDay = Day6;
//loop 5 times for day1,day2,day3,day4,day5
for (int k = 0; k < GroupData.Rows.Count; k++)
{
Processdate = Convert.ToDateTime(GroupData.Rows[k]["ProcessDate"]);
//if (k == 0)
//{
if (Processdate == Recievedate)
{
Day1Invoice = Convert.ToInt32(GroupData.Rows[k]["InvoiceCount"]);
Day1Percenatage = Convert.ToDecimal(GroupData.Rows[k]["Day1"]);
}
//}
//if (k == 1)
//{
//if (GroupData.Rows.Count > 1)
if (Processdate == Day2)
{
Day2Invoice = Convert.ToInt32(GroupData.Rows[k]["InvoiceCount"]);
Day2Percenatage = Convert.ToDecimal(GroupData.Rows[k]["Day1"]);
}
//}
//if (k == 2)
//{
if (Processdate == Day3)
{
Day3Invoice = Convert.ToInt32(GroupData.Rows[k]["InvoiceCount"]);
Day3Percenatage = Convert.ToDecimal(GroupData.Rows[k]["Day1"]);
}
//}
//if (k == 3)
//{
if (Processdate == Day4)
{
Day4Invoice = Convert.ToInt32(GroupData.Rows[k]["InvoiceCount"]);
Day4Percenatage = Convert.ToDecimal(GroupData.Rows[k]["Day1"]);
}
//}
//if (k == 4)
//{
if (Processdate == Day5)
{
Day5Invoice = Convert.ToInt32(GroupData.Rows[k]["InvoiceCount"]);
Day5Percenatage = Convert.ToDecimal(GroupData.Rows[k]["Day1"]);
}
//}
}
SqlQuery = "INSERT INTO REPORT VALUES('" + Recievedate + "'," + TotalInvoices + "," + Pending + "," + Issue + "," + Day1Invoice + "," + Day1Percenatage + "," + Day2Invoice + "," + Day2Percenatage + "," + Day3Invoice + "," + Day3Percenatage + "," + Day4Invoice + "," + Day4Percenatage + "," + Day5Invoice + "," + Day5Percenatage + "," + Day6Invoice + "," + Day6Percenatage + ")";
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlCommand cmd = new SqlCommand(SqlQuery, con);
cmd.ExecuteNonQuery();
}
}
}
//get 6plus day report
//DataTable PlusDay_dt = GetData(";with CTE_Input1 as ( select RecieveDate,cast(IND_IP_ModifiedOn as date) as ProcessDate, count(FI_OriginalName) as InvoiceCount from (select cast(FI_CreatedOn as date ) as RecieveDate, IND_IP_ModifiedOn,FI_OriginalName from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' and IND_IP_Processed_By !='null' and IND_Status not in ('IP_Asg','IP_Issue')) A group by cast(IND_IP_ModifiedOn as date),RecieveDate),CTE_Input2 as (select cast(FI_CreatedOn as date )as RecieveDate,count(FI_OriginalName) as TotalInvoices from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' group by cast(FI_CreatedOn as date )),CTE_Input3 as (SELECT RecieveDate,ProcessDate,TotalInvoices,InvoiceCount,Cast(round(Accuracy,2) as decimal(10,2)) as Day1 FROM (select CTE_Input1.RecieveDate as RecieveDate,CTE_Input1.ProcessDate as ProcessDate,CTE_Input1.InvoiceCount as InvoiceCount,CTE_Input2.TotalInvoices as TotalInvoices, case when CTE_Input1.InvoiceCount<>0 then (CAST(CTE_Input1.InvoiceCount as float)/CAST(CTE_Input2.TotalInvoices as float)*100.0) else 100 END as Accuracy from CTE_Input1 join CTE_Input2 on CTE_Input1.RecieveDate=CTE_Input2.RecieveDate )B ) select RecieveDate,TotalInvoices,PlusDay as '6PlusDay',Cast(round(Accuracy,2) as decimal(10,2)) as '6PlusDay%' from (select RecieveDate,TotalInvoices,PlusDay,case when PlusDay<>0 then (CAST(PlusDay as float)/CAST(TotalInvoices as float)*100.0) else 100 END as Accuracy from (select RecieveDate,TotalInvoices,sum(InvoiceCount) as PlusDay from CTE_Input3 WHERE ProcessDate >= DATEADD(day,5, RecieveDate)group by RecieveDate,TotalInvoices " +
// " )C)D order by RecieveDate");
DataTable PlusDay_dt = GetData(";with CTE_Input1 as ( select RecieveDate,cast(IND_IP_ModifiedOn as date) as ProcessDate, count(FI_OriginalName) as InvoiceCount from (select cast(FI_CreatedOn as date ) as RecieveDate, IND_IP_ModifiedOn,FI_OriginalName from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' and IND_IP_Processed_By !='null' and FI_Source !='EDI' and IND_Status not in ('IP_Asg','IP_Issue')) A group by cast(IND_IP_ModifiedOn as date),RecieveDate),CTE_Input2 as (select cast(FI_CreatedOn as date )as RecieveDate,count(FI_OriginalName) as TotalInvoices from dbo.EMSDB_FileInfo left join dbo.EMSDB_InvDetails on IND_FI=FI_ID where cast(FI_CreatedOn as date ) >='" + From.ToString("yyyy-MM-dd") + "' and cast(FI_CreatedOn as date ) <='" + To.ToString("yyyy-MM-dd") + "' and FI_Source !='EDI' group by cast(FI_CreatedOn as date )),CTE_Input3 as (SELECT RecieveDate,ProcessDate,TotalInvoices,InvoiceCount,Cast(round(Accuracy,2) as decimal(10,2)) as Day1 FROM (select CTE_Input1.RecieveDate as RecieveDate,CTE_Input1.ProcessDate as ProcessDate,CTE_Input1.InvoiceCount as InvoiceCount,CTE_Input2.TotalInvoices as TotalInvoices, case when CTE_Input1.InvoiceCount<>0 then (CAST(CTE_Input1.InvoiceCount as float)/CAST(CTE_Input2.TotalInvoices as float)*100.0) else 100 END as Accuracy from CTE_Input1 join CTE_Input2 on CTE_Input1.RecieveDate=CTE_Input2.RecieveDate )B ) select RecieveDate,TotalInvoices,PlusDay as '6PlusDay',Cast(round(Accuracy,2) as decimal(10,2)) as '6PlusDay%' from (select RecieveDate,TotalInvoices,PlusDay,case when PlusDay<>0 then (CAST(PlusDay as float)/CAST(TotalInvoices as float)*100.0) else 100 END as Accuracy from (select RecieveDate,TotalInvoices,sum(InvoiceCount) as PlusDay from CTE_Input3 WHERE ProcessDate >= (select(DATEADD(day, (5 % 5) + CASE ((@@DATEFIRST + DATEPART(weekday, RecieveDate) + (5 % 5)) % 7) WHEN 0 THEN 2 WHEN 1 THEN 1 ELSE 0 END, DATEADD(week, (5 / 5), RecieveDate))) as RecieveDate) group by RecieveDate,TotalInvoices " +
" )C)D order by RecieveDate");
for (int z = 0; z < PlusDay_dt.Rows.Count; z++)
{
int plusdayCount = Convert.ToInt32(PlusDay_dt.Rows[z]["6PlusDay"]);
decimal plusdayPercentage = Convert.ToInt32(PlusDay_dt.Rows[z]["6PlusDay%"]);
DateTime Recievedate = Convert.ToDateTime(PlusDay_dt.Rows[z]["RecieveDate"]);
//update 6plus day data.
SqlQuery = " update Report set Day6Count=" + plusdayCount + ", Day6Percentage='" + plusdayPercentage + "' where RECEIVEDATE='" + Recievedate + "'";
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlCommand cmd = new SqlCommand(SqlQuery, con);
cmd.ExecuteNonQuery();
}
}
//generate table
DataTable data = GetData("SELECT RECEIVEDATE,TotalInvoice,Pending,Day1Count,Convert(varchar(10),day1Percentage)+'%' AS day1Percentage,Day2Count,Convert(varchar(10),day2Percentage)+'%' AS Day2Percentage,Day3Count,Convert(varchar(10),day3Percentage)+'%' AS Day3Percentage,Day4Count,Convert(varchar(10),day4Percentage)+'%' AS Day4Percentage,Day5Count,Convert(varchar(10),day5Percentage)+'%' AS Day5Percentage,Day6Count,Convert(varchar(10),day6Percentage)+'%' AS Day6Percentage FROM REPORT");
grdReport.DataSource = data;
grdReport.DataBind();
//generate SLA table
DataTable SLA = GetData("select RECEIVEDATE,TotalInvoice,ProcessedInvoices,Convert(varchar(10),(CAST(round(Percentage,2) as decimal(10,2))))+'%' as Percentage from (select RECEIVEDATE,TotalInvoice,sum(Day1Count+Day2Count+Day3Count+Day4Count+Day5Count) as ProcessedInvoices,case when sum(Day1Count+Day2Count+Day3Count+Day4Count+Day5Count)<>0 then (CAST(sum(Day1Count+Day2Count+Day3Count+Day4Count+Day5Count) as float)/CAST(TotalInvoice as float)*100.0) else 100 END as Percentage from dbo.REPORT group by RECEIVEDATE,TotalInvoice ) as a order by RECEIVEDATE");
grdSLA.DataSource = SLA;
grdSLA.DataBind();
DataTable pendingReport = GetData("select RECEIVEDATE,Pending+Issue as TotalPending,Pending,Issue from REPORT where Pending<>0 or Issue <>0");
grdPending.DataSource = pendingReport;
grdPending.DataBind();
ds.Tables.Add(data);
ds.Tables.Add(SLA);
ds.Tables.Add(pendingReport);
}
public void TestDay4()
{
var day4 = new Day4("0-" + int.MaxValue.ToString());
Assert.IsTrue(day4.MeetsCriteria("111111"));
Assert.IsFalse(day4.MeetsCriteria("223450")); //223450 does not meet these criteria(decreasing pair of digits 50).
Assert.IsFalse(day4.MeetsCriteria("123789")); //123789 does not meet these criteria(no double).
//It is a six-digit number.
Assert.IsFalse(day4.MeetsCriteria("000000"));
Assert.IsFalse(day4.MeetsCriteria("123456"));
Assert.IsFalse(day4.MeetsCriteria("000001"));
Assert.IsTrue(day4.MeetsCriteria("999999"));
Assert.IsFalse(day4.MeetsCriteria("088888"));
Assert.IsFalse(day4.MeetsCriteria("001299"));
Assert.IsFalse(day4.MeetsCriteria("12378"));
Assert.IsFalse(day4.MeetsCriteria("1237"));
Assert.IsFalse(day4.MeetsCriteria("001237"));
Assert.IsFalse(day4.MeetsCriteria("011237"));
Assert.IsFalse(day4.MeetsCriteria("9999"));
Assert.IsFalse(day4.MeetsCriteria("1000000"));
Assert.IsFalse(day4.MeetsCriteria("344322"));
Assert.IsFalse(day4.MeetsCriteria("90999"));
Assert.IsTrue(day4.MeetsCriteria("113333"));
Assert.IsTrue(day4.MeetsCriteria("113788"));
Assert.IsTrue(day4.MeetsCriteria("134588"));
Assert.IsTrue(day4.MeetsCriteria("135578"));
Assert.IsTrue(day4.MeetsCriteria("136688"));
Assert.IsTrue(day4.MeetsCriteria("136778"));
Assert.IsTrue(day4.MeetsCriteria("136788"));
Assert.IsTrue(day4.MeetsCriteria("136799"));
//112233 meets these criteria because the digits never decrease and all repeated digits are exactly two digits long.
Assert.IsTrue(day4.MeetsCriteriaUpdated("112233"));
//123444 no longer meets the criteria (the repeated 44 is part of a larger group of 444).
Assert.IsFalse(day4.MeetsCriteriaUpdated("123444"));
//111122 meets the criteria (even though 1 is repeated more than twice, it still contains a double 22).
Assert.IsTrue(day4.MeetsCriteriaUpdated("111122"));
Assert.IsTrue(day4.MeetsCriteria("111111"));
Assert.IsFalse(day4.MeetsCriteria("223450")); //223450 does not meet these criteria(decreasing pair of digits 50).
Assert.IsFalse(day4.MeetsCriteria("123789")); //123789 does not meet these criteria(no double).
//It is a six-digit number.
Assert.IsFalse(day4.MeetsCriteriaUpdated("000000"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("123456"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("000001"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("999999"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("088888"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("001299"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("12378"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("1237"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("001237"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("011237"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("9999"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("1000000"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("344322"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("90999"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("113333"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("113788"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("134588"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("135578"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("136688"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("136778"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("136788"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("136799"));
//Two adjacent digits are the same (like 22 in 122345).
//Going from left to right, the digits never decrease; they only ever increase or stay the same(like 111123 or 135679).
day4 = new Day4("158126-624574");
Assert.IsFalse(day4.MeetsCriteria("158125"));
Assert.IsFalse(day4.MeetsCriteria("624574"));
Assert.IsFalse(day4.MeetsCriteria("624575"));
Assert.IsTrue(day4.MeetsCriteria("223679"));
Assert.IsFalse(day4.MeetsCriteria("158126"));
Assert.IsFalse(day4.MeetsCriteria("624574"));
//The value is within the range given in your puzzle input.
Assert.IsFalse(day4.MeetsCriteriaUpdated("1000000"));
day4 = new Day4("158126-624574");
Assert.IsFalse(day4.MeetsCriteriaUpdated("158125"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("624574"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("624575"));
Assert.IsTrue(day4.MeetsCriteriaUpdated("223679"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("158126"));
Assert.IsFalse(day4.MeetsCriteriaUpdated("624574"));
//The value is within the range given in your puzzle input.
Assert.IsFalse(day4.MeetsCriteriaUpdated("1000000"));
}
public void TestIsValidPassphrase2BasicValid()
{
var test = Day4.IsValidPassphrase2("abcde fghij");
Assert.True(test);
}
public Day4Tests()
{
day4 = new Day4();
}
public void TestIsValidPassphrase2BasicInvalid()
{
var test = Day4.IsValidPassphrase2("abcde xyz ecdab");
Assert.False(test);
}
public void Answer1()
{
int answer = 170;
Assert.AreEqual(answer, Day4.Problem1());
}
public void TestIsValidPassphrase2AllLettersNeedToBeUsedValid()
{
var test = Day4.IsValidPassphrase2("a ab abc abd abf abj");
Assert.True(test);
}
public void DoItA() // 85296
{
var day = new Day4();
Console.WriteLine(day.SolveA(InputData.Day4));
}
public void TestIsValidPassphrase2LongerValid()
{
var test = Day4.IsValidPassphrase2("iiii oiii ooii oooi oooo");
Assert.True(test);
}
public void Setup()
{
_day4 = new Day4();
}
public void TestIsValidPassphrase1Valid()
{
var test = Day4.IsValidPassphrase1("aa bb cc dd ee");
Assert.True(test);
}
public void Day4Test3()
{
Day4 t = new Day4();
Assert.IsTrue(t.Rule1(223450));
}
public void TestIsValidPassphrase2AllTheSameLettersInvalid()
{
var test = Day4.IsValidPassphrase2("oiii ioii iioi iiio");
Assert.False(test);
}
public void Day4Test5()
{
Day4 t = new Day4();
Assert.IsFalse(t.Rule1(123789));
}
public void TestPart2Invalid(string[] data, int result)
{
Assert.AreEqual(result, Day4.Calculate2(data));
}
public void Day4Test8()
{
Day4 t = new Day4();
Assert.IsTrue(t.Rule3(112233));
}
public void Day4BValidPasswordExample3()
{
Assert.IsTrue(Day4.IsValidPassword("111122", false));
Assert.IsTrue(Day4.IsValidPassword(111122, false));
}
