static void Main(string[] args) { var server = new Server(new DishManager()); while (true) { var order = Console.ReadLine(); var output = server.TakeOrder(order); Console.WriteLine(output); } }
public void Update() { SqlConnection conn = new SqlConnection(connstring); conn.Open(); try { string UpdateStatement = "BEGIN UPDATE Form SET Date=@Date,DSS_ID=@DSS_ID,Child_Name=@Child_Name,Mother_Name=@Mother_Name,Father_Name=@Father_Name,DOB=@DOB, Age_months=@Age_months, Age_days=@Age_days, Mother_Age=@Mother_Age, Gender=@Gender," + "BCG=@BCG,OPV0=@OPV0, OPV1=@OPV1,Penta1=@Penta1,PCV1=@PCV1,Rota1=@Rota1,OPV2=@OPV2,Penta2=@Penta2,PCV2=@PCV2,Rota2=@Rota2,OPV3=@OPV3,Penta3=@Penta3,PCV3=@PCV3,IPV3=@IPV3,Measles1=@Measles1,TCV=@TCV,Measles2=@Measles2,TT1=@TT1,TT2=@TT2,TT3=@TT3,TT4=@TT4,TT5=@TT5,remarks=@remarks,update_date=CURRENT_TIMESTAMP,update_name=@DIO_Name,date_1=@DateV1,date_2=@DateV2,date_3=@DateV3,date_4=@DateV4,date_5=@DateV5,date_6=@DateV6,date_7=@DateV7,date_m1=@DateMV1,date_m2=@DateMV2,date_m3=@DateMV3,date_m4=@DateMV4,date_m5=@DateMV5,QR_Code=@QRcode where Card_No= '" + TextCardno.Text + "' END"; //string UpdateStatement = "UPDATE FORM SET Name='"+TextName.Text+"' where DSS_ID= '" + Convert.ToString(Session["DssID"]) + "'"; SqlCommand cmd = new SqlCommand(UpdateStatement, conn); cmd.Parameters.AddWithValue("@Date", TxtDOV.Text); //cmd.Parameters.AddWithValue("@Card_No", TextCardno.Text); cmd.Parameters.AddWithValue("@DSS_ID", TextDSSID.Text.ToUpper()); cmd.Parameters.AddWithValue("@Child_Name", TextName.Text.ToUpper()); cmd.Parameters.AddWithValue("@Mother_Name", TextMname.Text.ToUpper()); cmd.Parameters.AddWithValue("@Father_Name", TextFname.Text.ToUpper()); cmd.Parameters.AddWithValue("@DOB", TextDOB.Text); cmd.Parameters.AddWithValue("@Age_months", AgeMonths.Text); cmd.Parameters.AddWithValue("@Age_days", AgeDays.Text); cmd.Parameters.AddWithValue("@Mother_Age", TextMAge.Text); cmd.Parameters.AddWithValue("@Gender", radioList.SelectedValue); cmd.Parameters.AddWithValue("@BCG", CheckBCG.Checked); cmd.Parameters.AddWithValue("@OPV0", CheckOPV0.Checked); cmd.Parameters.AddWithValue("@OPV1", CheckOPV1.Checked); cmd.Parameters.AddWithValue("@Penta1", CheckPenta1.Checked); cmd.Parameters.AddWithValue("@PCV1", CheckPCV1.Checked); cmd.Parameters.AddWithValue("@Rota1", CheckRota1.Checked); cmd.Parameters.AddWithValue("@OPV2", CheckOPV2.Checked); cmd.Parameters.AddWithValue("@Penta2", CheckPenta2.Checked); cmd.Parameters.AddWithValue("@PCV2", CheckPCV2.Checked); cmd.Parameters.AddWithValue("@Rota2", CheckRota2.Checked); cmd.Parameters.AddWithValue("@OPV3", CheckOPV3.Checked); cmd.Parameters.AddWithValue("@Penta3", CheckPenta3.Checked); cmd.Parameters.AddWithValue("@PCV3", CheckPCV3.Checked); cmd.Parameters.AddWithValue("@IPV3", CheckIPV3.Checked); cmd.Parameters.AddWithValue("@TCV", CheckTCV.Checked); cmd.Parameters.AddWithValue("@Measles1", CheckMeasles1.Checked); cmd.Parameters.AddWithValue("@Measles2", CheckMeasles2.Checked); cmd.Parameters.AddWithValue("@TT1", CheckTT1.Checked); cmd.Parameters.AddWithValue("@TT2", CheckTT2.Checked); cmd.Parameters.AddWithValue("@TT3", CheckTT3.Checked); cmd.Parameters.AddWithValue("@TT4", CheckTT4.Checked); cmd.Parameters.AddWithValue("@TT5", CheckTT5.Checked); cmd.Parameters.AddWithValue("@remarks", txtremarks.InnerText.ToUpper()); cmd.Parameters.AddWithValue("@DIO_Name", Label1.Text.ToUpper()); cmd.Parameters.AddWithValue("@DateV1", txtDateV1.Text); cmd.Parameters.AddWithValue("@DateV2", txtDateV2.Text); cmd.Parameters.AddWithValue("@DateV3", txtDateV3.Text); cmd.Parameters.AddWithValue("@DateV4", txtDateV4.Text); cmd.Parameters.AddWithValue("@DateV5", txtDateV5.Text); cmd.Parameters.AddWithValue("@DateV6", txtDateV6.Text); cmd.Parameters.AddWithValue("@DateV7", txtDateV7.Text); cmd.Parameters.AddWithValue("@DateMV1", txtDateMV1.Text); cmd.Parameters.AddWithValue("@DateMV2", txtDateMV2.Text); cmd.Parameters.AddWithValue("@DateMV3", txtDateMV3.Text); cmd.Parameters.AddWithValue("@DateMV4", txtDateMV4.Text); cmd.Parameters.AddWithValue("@DateMV5", txtDateMV5.Text); cmd.Parameters.AddWithValue("@QRcode", txtQRcode.Text); cmd.ExecuteNonQuery(); } finally { Response.Write("<script type=\"text/javascript\">alert('Form Updated successfully!')</script>"); Server.Transfer("page.aspx"); //PopulateFields(); conn.Close(); } }
public void Setup() { _sut = new Server(new DishManager()); }