public CustomerBLL CustomerIdentity(PointsBLL id)
{
CustomerBLL cb = new CustomerBLL();
SqlConnection con = new SqlConnection(myconnstring);
string sql = "SELECT cust_id from Customers WHERE id='" + id + "' ";
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
cb.cust_id = int.Parse(dt.Rows[0]["cust_id"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(cb);
}
public bool Insert(PointsBLL pb)
{
bool isSucces = false;
SqlConnection con = new SqlConnection(myconnstring);
try
{
string sql = "INSERT into Points(billAmount,ReceiptNo,pointsAdded,pointsRedeemed,pointBalance,cust_id,date,operations) VALUES (@billAmount,@ReceiptNo,@pointsAdded,@pointsRedeemed,@pointBalance,@cust_id,'" + DateTime.Now + "',@operations) ";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@billAmount", pb.billAmount);
cmd.Parameters.AddWithValue("@ReceiptNo", pb.ReceiptNo);
cmd.Parameters.AddWithValue("@pointsAdded", pb.pointsAdded);
cmd.Parameters.AddWithValue("@pointsRedeemed", pb.pointsRedeemed);
cmd.Parameters.AddWithValue("@pointBalance", pb.pointBalance);
cmd.Parameters.AddWithValue("@cust_id", pb.cust_id);
cmd.Parameters.AddWithValue("@date", pb.date);
cmd.Parameters.AddWithValue("@operations", pb.operations);
int row = cmd.ExecuteNonQuery();
string sql1 = "UPDATE Customers SET PointsAvailable=PointsAvailable + @PointAdded WHERE CustomerID=@CustomerID";
SqlCommand cmd1 = new SqlCommand(sql1, con);
//cmd1.Parameters.AddWithValue("@PointsAdded",)
if (row > 0)
{
//Insertion successful
isSucces = true;
}
else
{
// Insetion failed
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(isSucces);
}
