public int update(be b)
{
int flag = 0;
be brr = new be();
dap = new SqlDataAdapter("select * from addbook ", getconnection());
ds = new DataSet();
dap.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
if (ds.Tables[0].Rows[i][0].ToString() == b.id.ToString())
{
ds.Tables[0].Rows[i][1] = b.fname.ToString();
ds.Tables[0].Rows[i][2] = b.lname.ToString();
ds.Tables[0].Rows[i][3] = b.email.ToString();
ds.Tables[0].Rows[i][4] = b.phone.ToString();
flag = 1;
}
else
{
return(flag);
}
}
dap.Update(ds);
cb = new SqlCommandBuilder(dap);
return(flag);
}
protected void Button2_Click(object sender, EventArgs e)
{
be bee = new be {
id = Convert.ToInt16(TextBox1.Text)
};
b.deletedata(bee);
}
protected void Button1_Click(object sender, EventArgs e)
{
be bee = new be {
fname = TextBox2.Text, lname = TextBox3.Text, email = TextBox4.Text, phone = TextBox5.Text
};
b.insertdata(bee);
}
protected void Button3_Click(object sender, EventArgs e)
{
be bee = new be {
id = Convert.ToInt16(TextBox1.Text)
};
be dd = b.searchdata(bee);
TextBox2.Text = dd.fname.ToString();
TextBox3.Text = dd.lname.ToString();
TextBox4.Text = dd.ToString();
TextBox5.Text = dd.ToString();
}
public void deletedata(be b)
{
dap = new SqlDataAdapter("select * from addbook ", getconnection());
ds = new DataSet();
dap.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
if (ds.Tables[0].Rows[i][0].ToString() == b.id.ToString())
{
ds.Tables[0].Rows[i].Delete();
}
}
dap.Update(ds);
cb = new SqlCommandBuilder(dap);
}
public void insertdata(be b)
{
dap = new SqlDataAdapter("select * from addbook ", getconnection());
cb = new SqlCommandBuilder(dap);
ds = new DataSet();
dap.Fill(ds);
dr = ds.Tables[0].NewRow();
dr[1] = b.fname;
dr[2] = b.lname;
dr[3] = b.email;
dr[4] = b.phone;
ds.Tables[0].Rows.Add(dr);
dap.Update(ds);
cb = new SqlCommandBuilder(dap);
}
protected void Button4_Click(object sender, EventArgs e)
{
be be = new be {
id = Convert.ToInt32(TextBox1.Text), fname = TextBox2.Text.ToString(), lname = TextBox3.Text.ToString(), email = TextBox4.Text.ToString(), phone = TextBox5.Text.ToString()
};
int a = b.updatedata(be);
if (a > 0)
{
Response.Write("data updated");
}
else
{
Response.Write("data not updated");
}
}
public be searchdata(be b)
{
be brr = new be();
dap = new SqlDataAdapter("select * from addbook ", getconnection());
ds = new DataSet();
dap.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
if (ds.Tables[0].Rows[i][0].ToString() == b.id.ToString())
{
brr.fname = ds.Tables[0].Rows[i][1].ToString();
brr.lname = ds.Tables[0].Rows[i][2].ToString();
brr.email = ds.Tables[0].Rows[i][3].ToString();
brr.phone = ds.Tables[0].Rows[i][4].ToString();
}
}
dap.Update(ds);
cb = new SqlCommandBuilder(dap);
return(brr);
}
/// <summary>
/// Handle an input expression and generate a truth table based on relative boolean values for
/// each premise within boolean expression. It does use Djikstra's Shunting Yard algorithm
/// on RPN (Reverser Polish Notation).
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public bool handleExpression(string input)
{
log.info("Generating truth table...");
expression = new be(input);
expression.configure();
var premises = expression.getPremises();
var count = premises.Count;
var result = (int)Math.Pow(2, count);
log.warning(
string.Format("\t- {0} premise{1}\n\t- {2} result{3}",
count, count > 1 ? "s" : "",
result, result > 1 ? "s" : ""
));
var table = generateTable(premises.Count);
log.info("\n");
var tableHeader = string.Empty;
foreach (var premise in premises)
{
tableHeader += string.Format(" {0} |", premise);
}
tableHeader += " Result\n";
for (var i = 0; i <= count; i++)
{
tableHeader += "-------";
}
log.info(tableHeader);
var answer = new bool[table.GetLength(0)];
for (var i = 0; i < table.GetLength(0); i++)
{
for (var j = 0; j < table.GetLength(1); j++)
{
expression.setPremiseValue(premises[j], table[i, j]);
}
try { answer[i] = expression.solveExpression(); }
catch
{
log.error("\nExpression is invalid due missing operator statement!");
log.info("\n");
log.warning("Press any key to continue...");
cs.ReadKey(true);
cs.Clear();
return(false);
}
}
var tableBody = string.Empty;
for (var i = 0; i < table.GetLength(0); i++)
{
for (var j = 0; j < table.GetLength(1); j++)
{
tableBody += string.Format(" {0} |", table[i, j].toTruthTableFormat());
}
tableBody += string.Format(" {0}\n", answer[i].toTruthTableFormat());
}
log.info(tableBody);
return(true);
}
public int updatedata(be e)
{
return(d.update(e));
}
public be searchdata(be e)
{
return(d.searchdata(e));
}
public void deletedata(be e)
{
d.deletedata(e);
}
public void insertdata(be e)
{
d.insertdata(e);
}
