Пример #1
0
    public void insert(Add_donation_detailsBLL objectBLL)
    {
        try
        {
            int        var = 0;
            SqlCommand cmd = new SqlCommand("insert_donation_details", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@select_org", objectBLL.Select_org);
            cmd.Parameters.AddWithValue("@d_id", objectBLL.D_id);
            cmd.Parameters.AddWithValue("@d_name", objectBLL.D_name);
            cmd.Parameters.AddWithValue("@blood_group", objectBLL.Blood_group);
            cmd.Parameters.AddWithValue("@blood_quantity", objectBLL.Blood_quantity);

            con.Open();

            var = cmd.ExecuteNonQuery();
            if (var > 0)
            {
                objectBLL.Status = true;
            }
        }
        catch (Exception ex)
        {
            String msg = ex.Message;
        }
        finally
        {
            con.Close();
            con.Dispose();
        }
    }
 public void insert(Add_donation_detailsBLL objectBLL)
 {
     objectDLL.insert(objectBLL);
 }