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());
}
