public void WordsAreAnagrams()
{
Question4 q = new Question4("Silent", "Listen");
q.Run();
Assert.AreEqual(q.Result, true);
}
public override void OnInspectorGUI()
{
Question4 question4 = (Question4)target;
question4.userName = EditorGUILayout.TextField("名前", question4.userName);
question4.hp = EditorGUILayout.IntSlider("HP", question4.hp, 0, 10);
question4.atk = EditorGUILayout.IntSlider("力", question4.atk, 0, 10);
question4.agi = EditorGUILayout.IntSlider("すばやさ", question4.agi, 0, 10);
}
public void CheckForInput_3()
{
int[] numArr = new int[] { 1, 2, 3, 4, 5, 1, 6, 7 };
var q4 = new Question4();
var result = q4.GetMostCommon(numArr);
Assert.AreEqual(1, result.Length);
Assert.That(result, Contains.Item(1));
}
public static void Run()
{
// warms up the methods
Question1.Answer(0.0, 0.0, 0.0);
Question2.Answer(new int[] { 0 }, new int[] { 0 }, new int[] { 0 });
Question3.Answer(new int[] { 0 }, new int[] { 0 });
Question4.Answer(new int[] { 0 }, new int[] { 0 }, 0);
Question5.Answer(new int[] { 0 });
Question6.Answer(new string[] { "AA", "AA" });
}
public void CheckForInput_1()
{
int[] numArr = new int[] { 5, 4, 3, 2, 4, 5, 1, 6, 1, 2, 5, 4 };
var q4 = new Question4();
var result = q4.GetMostCommon(numArr);
Assert.AreEqual(2, result.Length);
Assert.That(result, Contains.Item(5));
Assert.That(result, Contains.Item(4));
}
static void Main(string[] args)
{
Console.WriteLine("Hello PTG world!");
Question1 questionOne = new Question1();
int[] testOne = new int[] { 2, 7, 11, 15 };
int[] resultOne = questionOne.TwoSumIterative(testOne, 9);
int[] resultOnePT2 = questionOne.TwoSumEfficient(testOne, 9);
Console.WriteLine("[{0}]", string.Join(", ", resultOne));
Console.WriteLine("[{0}]", string.Join(", ", resultOnePT2));
Question2 questionTwo = new Question2();
int[] testTwo = new int[] { 3, 2, 2, 3, 3, 4, 5, 6, 9, 3 };
Console.WriteLine($"Initial Lenght: {questionTwo.InitialLength(testTwo, 3)}");
Console.WriteLine($"Final Lenght: {questionTwo.NewLength(testTwo, 3)}");
Question3 question3 = new Question3();
int[] test3Arr1 = new int[] { 1, 2, 3, 0, 0, 0 };
int[] test3Arr2 = new int[] { 2, 5, 6 };
int[] question3Result = question3.MergeSort(test3Arr1, test3Arr2);
Console.WriteLine("Question 3");
Console.WriteLine("[{0}]", string.Join(", ", question3Result));
Question4 question4 = new Question4();
Question5 question5 = new Question5();
Console.WriteLine("Question 5:");
string q5InTrue = "A man,! - a plAn, a canal: Panama";
string q5InFasle = "race a car";
Console.WriteLine($"Q5 Should be TRUE: {question5.ValidPalindrome(q5InTrue)}");
Console.WriteLine($"Q5 Should be FALSE: {question5.ValidPalindrome(q5InFasle)}");
Question6 question6 = new Question6();
Console.WriteLine("");
Console.WriteLine("QUESTION 6");
string simple = "(([[{{";
string test6True = "(){}[]";
string test6True2 = "}}))(({{[]";
string test6False = "{{{{((()(){{{{}}{{[[]{{{{{";
Console.WriteLine($"Q6 false should be: {question6.HashMapCharacterValidation(simple)}");
Console.WriteLine($"Q6 True should be: {question6.HashMapCharacterValidation(test6True)}");
Console.WriteLine($"True should be for starting with close: {question6.HashMapCharacterValidation(test6True2)}");
Console.WriteLine($"False should be: {question6.HashMapCharacterValidation(test6False)}");
Console.ReadLine();
}
protected override void OnDisappearing()
{
base.OnDisappearing();
Question1.RemoveBehaviors();
Question2.RemoveBehaviors();
Question3.RemoveBehaviors();
Question4.RemoveBehaviors();
Question5.RemoveBehaviors();
Question6.RemoveBehaviors();
Question7.RemoveBehaviors();
}
public void CheckForInput_2()
{
int[] numArr = new int[] { 1, 2, 3, 4, 5, 6, 7 };
var q4 = new Question4();
var result = q4.GetMostCommon(numArr);
Assert.AreEqual(numArr.Length, result.Length);
foreach (int num in numArr)
{
Assert.That(result, Contains.Item(num));
}
}
static void Main(string[] args)
{
Question4 question4 = new Question4();
question4.CalculatorInput();
double fahrenheit;
double celsius = 36;
Console.WriteLine("Celsius: " + celsius);
fahrenheit = (celsius * 9) / 5 + 32;
Console.WriteLine("Fahrenheit: " + fahrenheit);
Console.ReadLine();
}
TimedAnswer <int> getFourthAnwser(Test <FixMachines> test)
{
var timer = new Stopwatch();
var fixMachines = test.GetInput();
timer.Start();
var answer = Question4.Answer(fixMachines.rows, fixMachines.numberMachines);
timer.Stop();
var timeTaken = ((double)timer.ElapsedTicks / Stopwatch.Frequency) * 1000000000;
return(new TimedAnswer <int>(answer, timeTaken));
}
Answer getFourthAnswer(Q4Object input, TestCase test)
{
var timer = new Stopwatch();
timer.Start();
var answer = Question4.Answer(input.v, input.c, input.mc);
timer.Stop();
var timeTaken = ((double)timer.ElapsedTicks / Stopwatch.Frequency) * 1000000000;
return(new Answer()
{
questionNumber = 4,
testNumber = test.testNumber,
correct = answer == test.output ? "CORRECT" : "INCORRECT",
speed = timeTaken
});
}
Answer getFourthAnswer(FixMachines input, TestCase test)
{
var timer = new Stopwatch();
timer.Start();
var answer = Question4.Answer(input.rows, input.numberMachines);
timer.Stop();
var timeTaken = ((double)timer.ElapsedTicks / Stopwatch.Frequency) * 1000000000;
return new Answer()
{
questionNumber = 4,
testNumber = test.testNumber,
correct = answer == test.output ? "CORRECT" : "INCORRECT",
speed = timeTaken
};
}
public void Run()
{
Question4.Run();
}
public ActionResult AddQuestionnaire(QuestionnairesViewModel Model, string[] BlankOptions, string[] AnswerOptions)
{
try
{
VTSDBEntities objDB = new VTSDBEntities();
if (Model.QuestionType == DAL.Model.QuestionType.SingleLine)
{
Question1 question1 = new Question1();
question1.QuestionSentence = Model.QuestionText;
question1.OriginalSentence = "";
List <Option1> QuesOptions = new List <Option1>();
foreach (string OptionText in BlankOptions)
{
Option1 EachOption = new Option1();
EachOption.OptionText = OptionText;
EachOption.Question1 = question1;
QuesOptions.Add(EachOption);
}
List <Answer1> AllAnswers = new List <Answer1>();
foreach (string AnswerText in AnswerOptions)
{
Answer1 EachAnswer = new Answer1();
EachAnswer.AnswerText = AnswerText;
EachAnswer.Question1 = question1;
AllAnswers.Add(EachAnswer);
}
question1.Answer1 = AllAnswers;
question1.Option1 = QuesOptions;
objDB.Question1.Add(question1);
objDB.SaveChanges();
ViewBag.SuccessMsg = "Questionnaire added successfully.";
}
else if (Model.QuestionType == DAL.Model.QuestionType.MultiLine)
{
Question2 question2 = new Question2();
question2.QuestionText = Model.QuestionText;
List <Option2> QuesOptions = new List <Option2>();
foreach (string OptionText in BlankOptions)
{
Option2 EachOption = new Option2();
EachOption.OptionText = OptionText;
EachOption.Question2 = question2;
QuesOptions.Add(EachOption);
}
List <Answer2> AllAnswers = new List <Answer2>();
Answer2 EachAnswer = new Answer2();
EachAnswer.Answer = Model.AnswerText;
EachAnswer.Question2 = question2;
AllAnswers.Add(EachAnswer);
question2.Answer2 = AllAnswers;
question2.Option2 = QuesOptions;
objDB.Question2.Add(question2);
objDB.SaveChanges();
ViewBag.SuccessMsg = "Questionnaire added successfully.";
}
else if (Model.QuestionType == DAL.Model.QuestionType.SingleOption)
{
Question3 question3 = new Question3();
question3.QuestionText = Model.QuestionText;
List <Answer3> AllAnswers = new List <Answer3>();
foreach (string AnswerText in AnswerOptions)
{
Answer3 EachAnswer = new Answer3();
EachAnswer.Answer = AnswerText;
EachAnswer.Question3 = question3;
AllAnswers.Add(EachAnswer);
}
question3.Answer3 = AllAnswers;
objDB.Question3.Add(question3);
objDB.SaveChanges();
ViewBag.SuccessMsg = "Questionnaire added successfully.";
}
else if (Model.QuestionType == DAL.Model.QuestionType.MultiOption)
{
Question4 question4 = new Question4();
question4.QuestionText = Model.QuestionText;
List <Answer4> AllAnswers = new List <Answer4>();
foreach (string AnswerText in AnswerOptions)
{
Answer4 EachAnswer = new Answer4();
EachAnswer.Answer = AnswerText;
EachAnswer.Question4 = question4;
AllAnswers.Add(EachAnswer);
}
question4.Answer4 = AllAnswers;
objDB.Question4.Add(question4);
objDB.SaveChanges();
ViewBag.SuccessMsg = "Questionnaire added successfully.";
}
else if (Model.QuestionType == DAL.Model.QuestionType.Date)
{
Question5 question5 = new Question5();
question5.QuestionText = Model.QuestionText;
List <Answer5> AllAnswers = new List <Answer5>();
foreach (string AnswerText in AnswerOptions)
{
Answer5 EachAnswer = new Answer5();
EachAnswer.Answer = AnswerText;
EachAnswer.Question5 = question5;
AllAnswers.Add(EachAnswer);
}
question5.Answer5 = AllAnswers;
objDB.Question5.Add(question5);
objDB.SaveChanges();
ViewBag.SuccessMsg = "Questionnaire added successfully.";
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
//throw raise;
ViewBag.ErrorMsg = "An error occurred while saving the questionnaire.";
}
ModelState.Clear();
return(View());
}
public void Question4Test()
{
Assert.AreEqual(Question4.Fibonacci(), "0 1 1 2 3 5 8 13 21 34 55 89");
}
public void PDFGeneration()
{
MySqlConnection con1 = new MySqlConnection();
//SqlConnection con1 = new SqlConnection();
//con1.ConnectionString = ConfigurationManager.ConnectionStrings["DBconnection"].ConnectionString;
//con1.ConnectionString = "Data Source = 123.176.34.15;port=4043;Integrated Security=False; Initial Catalog = survey; User ID = TestLogin; Password = ASD123!@#;";
con1.ConnectionString = _base.Decrypt(ConfigurationManager.ConnectionStrings["MysqlPath"].ConnectionString);
//SqlDataAdapter da = new SqlDataAdapter("select * from question where submitted =1 AND MailStatus=0", con1);
MySqlDataAdapter da = new MySqlDataAdapter("select * from question where submitted =1 AND MailStatus=0", con1);
DataTable dt = new DataTable();
da.Fill(dt);
Base @base = new Base();
foreach (DataRow dr in dt.Rows)
{
ReportDocument ss = new ReportDocument();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.AllowCustomConnection = true;
myConnectionInfo.ServerName = _base.Decrypt(ConfigurationManager.AppSettings["SERVERNAME"].ToString());
myConnectionInfo.DatabaseName = _base.Decrypt(ConfigurationManager.AppSettings["DATABASE"].ToString());
myConnectionInfo.IntegratedSecurity = Convert.ToBoolean(ConfigurationManager.AppSettings["INTEGRATEDSECURITY"].ToString());
myConnectionInfo.UserID = _base.Decrypt(ConfigurationManager.AppSettings["USERID"].ToString());
myConnectionInfo.Password = _base.Decrypt(ConfigurationManager.AppSettings["PASSWORD"].ToString());
myConnectionInfo.Type = ConnectionInfoType.SQL;
string Rpt_Path = System.Web.Hosting.HostingEnvironment.MapPath(ConfigurationManager.AppSettings["rptLocation"].ToString());
string outputPath = System.Web.Hosting.HostingEnvironment.MapPath(ConfigurationManager.AppSettings["OutputPath_pdf"].ToString());
try
{
JavaScriptSerializer scr = new JavaScriptSerializer();
Question2 Que2 = (Question2)scr.Deserialize(dr["la_q2"].ToString().Replace("\\", ""), typeof(Question2));
Question4 Que4 = (Question4)scr.Deserialize(dr["la_q4"].ToString().Replace("\\", ""), typeof(Question4));
Question7 Que7 = (Question7)scr.Deserialize(dr["la_q7"].ToString().Replace("\\", ""), typeof(Question7));
question8 Que8 = (question8)scr.Deserialize(dr["la_q8"].ToString().Replace("\\", ""), typeof(question8));
//List<string> Que9 = (List<string>)scr.Deserialize(dr["la_q9"].ToString().Replace("\\", ""), typeof(List<string>));
Question11 Que11 = (Question11)scr.Deserialize(dr["la_q11"].ToString().Replace("\\", ""), typeof(Question11));
//Question15 Que15 = (Question15)scr.Deserialize(dr["la_q15"].ToString().Replace("\\", ""), typeof(Question15));
FQ1 fq1 = (FQ1)scr.Deserialize(dr["fq1"].ToString().Replace("\\", ""), typeof(FQ1));
FQ2 fq2 = (FQ2)scr.Deserialize(dr["fq2"].ToString().Replace("\\", ""), typeof(FQ2));
FQ3 fq3 = (FQ3)scr.Deserialize(dr["fq3"].ToString().Replace("\\", ""), typeof(FQ3));
string que1 = dr["la_q1"].ToString();
string que3 = dr["la_q3"].ToString();
string que5 = dr["la_q5"].ToString();
string que6 = dr["la_q6"].ToString();
string que9 = dr["la_q9"].ToString();
string que10 = dr["la_q10"].ToString();
string que12 = dr["la_q12"].ToString();
string que13 = dr["la_q13"].ToString();
string que14 = dr["la_q14"].ToString();
string que15 = dr["la_q15"].ToString();
String User_ID = dr["User_ID"].ToString();
con1.Open();
string q = "Select * from users WHERE User_ID = " + User_ID + " ";
MySqlCommand cmd3 = new MySqlCommand(q, con1);
//var a = cmd3.ExecuteScalar();
MySqlDataReader reader = cmd3.ExecuteReader();
MySqlUser u = new MySqlUser();
while (reader.Read())
{
u.FirstName = reader.GetString("First_Name");
u.SecoundName = reader.GetString("Second_Name");
u.Email = reader.GetString("Email");
u.Compnay = reader.GetString("Company_Name");
u.UserName = reader.GetString("User_Name");
}
con1.Close();
CrystalReport crypt = new CrystalReport();
crypt.SetParameterValue("Company_Name", u.Compnay);
crypt.SetParameterValue("User", u.FirstName + " " + u.SecoundName);
crypt.SetParameterValue("Promantus_POC", "Promantus");
crypt.SetParameterValue("Q4.1", Que4.la_q4_1);
crypt.SetParameterValue("Q4.2", Que4.la_q4_2);
crypt.SetParameterValue("Q4.3", Que4.la_q4_3);
//crypt.SetParameterValue("Q4.5", Que4.la_q4_5.ToString());
crypt.SetParameterValue("Q6", que6);
crypt.SetParameterValue("Q11", Que11.la_q11_1.ToString() + " , " + Que11.la_q11_2.ToString());
crypt.SetParameterValue("Q12", que12);
crypt.SetParameterValue("Q13", que13);
crypt.SetParameterValue("Q14", que14);
//crypt.SetParameterValue("Q15", Que15.la_q15_1 + " , " + Que15.la_q15_2.ToString());
crypt.SetParameterValue("Q15", que15);
crypt.SetParameterValue("f1", fq1.f1);
crypt.SetParameterValue("f2", fq1.f2);
crypt.SetParameterValue("f3", fq1.f3);
crypt.SetParameterValue("f4", fq2.f4);
crypt.SetParameterValue("f5", fq2.f5);
crypt.SetParameterValue("f6", fq2.f6);
crypt.SetParameterValue("f7", fq3.f7);
crypt.SetParameterValue("f8", fq3.f8);
if (que3 == "no")
{
if (Que4.la_q4_1 != "SAP ECC6.0" && Que4.la_q4_1 != "EHP")
{
crypt.SetParameterValue("Img_Op1", true);
crypt.SetParameterValue("Img_Op2", false);
}
else
{
crypt.SetParameterValue("Img_Op2", true);
crypt.SetParameterValue("Img_Op1", false);
}
}
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in crypt.Database.Tables)
{
TableLogOnInfo myTableLogonInfo = myTable.LogOnInfo;
myTableLogonInfo.ConnectionInfo = myConnectionInfo;
myTable.ApplyLogOnInfo(myTableLogonInfo);
myTable.Location = myConnectionInfo.DatabaseName + ".dbo." + myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1);
myTable.LogOnInfo.ConnectionInfo.ServerName = myConnectionInfo.ServerName;
}
CrystalReportViewer crb = new CrystalReportViewer();
crb.ReportSource = crypt;
ss.Load(Rpt_Path);
#region Q2
String Q2 = "";
if (Que2 != null)
{
if (Que2.la_q2_1 != "" && Que2.la_q2_1 != "undefined")
{
Q2 = Que2.la_q2_1 + ",";
}
if (Que2.la_q2_2 == "yes")
{
Q2 = Q2 + " Development,";
}
if (Que2.la_q2_3 == "yes")
{
Q2 = Q2 + " Sandbox,";
}
if (Que2.la_q2_4 == "yes")
{
Q2 = Q2 + " Quality / Test,";
}
if (Que2.la_q2_5 == "yes")
{
Q2 = Q2 + " Production,";
}
if (Que2.la_q2_6 != "")
{
Q2 = Q2 + Que2.la_q2_6;// " Any other System / Client in the SAP Landscape";
}
#endregion Q2
ss.SetParameterValue("Q2", Q2);
}
ss.SetParameterValue("Q4.1", Que4.la_q4_1);
ss.SetParameterValue("Q4.2", Que4.la_q4_2);
ss.SetParameterValue("Q4.3", Que4.la_q4_3);
//ss.SetParameterValue("Q4.5", Que4.la_q4_5.ToString());
ss.SetParameterValue("Q6", que6);
if (que3 == "no")
{
if (Que4.la_q4_1 != "SAP ECC6.0" && Que4.la_q4_1 != "EHP")
{
ss.SetParameterValue("Img_Op1", true);
ss.SetParameterValue("Img_Op2", false);
}
else
{
ss.SetParameterValue("Img_Op2", true);
ss.SetParameterValue("Img_Op1", false);
}
}
#region Q7
String Q7 = "";
if (Que7 != null)
{
if (Que7.la_q7_FI == "yes")
{
Q7 = Q7 + "Financials,";
}
if (Que7.la_q7_CO == "yes")
{
Q7 = Q7 + " Controlling,";
}
if (Que7.la_q7_MM == "yes")
{
Q7 = Q7 + " Materials Management,";
}
if (Que7.la_q7_SD == "yes")
{
Q7 = Q7 + " Sales & Distribution,";
}
if (Que7.la_q7_PP == "yes")
{
Q7 = Q7 + " Production Planning,";
}
if (Que7.la_q7_QM == "yes")
{
Q7 = Q7 + " Quality Management,";
}
if (Que7.la_q7_PS == "yes")
{
Q7 = " Project Systems,";
}
if (Que7.la_q7_PM == "yes")
{
Q7 = Q7 + " Plant Maintenance,";
}
if (Que7.la_q7_CS == "yes")
{
Q7 = Q7 + " Customer Service,";
}
if (Que7.la_q7_HR == "yes")
{
Q7 = Q7 + " Human Resources,";
}
if (Que7.la_q7_WM == "yes")
{
Q7 = Q7 + " Warehouse Management,";
}
if (Que7.la_q7_LO_VC == "yes")
{
Q7 = Q7 + " Variant Configuration,";
}
if (Que7.la_q7_LO_WTY == "yes")
{
Q7 = Q7 + " Warranty Management,";
}
if (Que7.la_q7_LO_SPM == "yes")
{
Q7 = Q7 + " Spare Parts Management,";
}
if (Que7.la_q7_other != "")
{
Q7 = Q7 + Que7.la_q7_other;
}
ss.SetParameterValue("Q7", Q7);
}
#endregion Q7
ss.SetParameterValue("Q11", Que11.la_q11_1.ToString() + " , " + Que11.la_q11_2.ToString());
ss.SetParameterValue("Q12", que12);
ss.SetParameterValue("Q13", que13);
ss.SetParameterValue("Q14", que14);
ss.SetParameterValue("Q15", que15);
//ss.SetParameterValue("Q15", Que15.la_q15_1 + " , " + Que15.la_q15_2.ToString());
ss.SetParameterValue("f1", fq1.f1);
ss.SetParameterValue("f2", fq1.f2);
ss.SetParameterValue("f3", fq1.f3);
ss.SetParameterValue("f4", fq2.f4);
ss.SetParameterValue("f5", fq2.f5);
ss.SetParameterValue("f6", fq2.f6);
ss.SetParameterValue("f7", fq3.f7);
ss.SetParameterValue("f8", fq3.f8);
ss.SetParameterValue("Company_Name", u.Compnay);
ss.SetParameterValue("User", u.FirstName + " " + u.SecoundName);
ss.SetParameterValue("Promantus_POC", "Promantus");
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = outputPath + User_ID + ".pdf";
CrExportOptions = ss.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
ss.Export();
// con1.Open();
// string q = "Select Email from users WHERE User_ID = " + User_ID + " ";
// MySqlCommand cmd3 = new MySqlCommand(q, con1);
//var a= cmd3.ExecuteScalar();
Boolean S = @base.AddQuestionnaire_Mail(Convert.ToInt32(User_ID), u.Email);
con1.Open();
string myQuery = "UPDATE question SET MailStatus = " + S + " WHERE User_ID = " + User_ID + " ";
MySqlCommand cmd2 = new MySqlCommand(myQuery, con1);
cmd2.ExecuteNonQuery();
con1.Close();
}
catch (Exception ex)
{
_log.createLog(ex, "-->CrystalReportPDF-->Loop" + ex.Message.ToString());
}
finally
{
if (ss != null)
{
ss.Close();
ss.Dispose();
}
}
}
}
