Reciept.cs

using LibraryCGC;
using Microsoft.Data.SqlClient;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;



namespace Library_Final
{
    public partial class Reciept : Form
    {

        // Connection string - Update with your SQL Server details
        private string connectionString = @"  Data Source=(LocalDB)\MSSQLLocalDB;
Initial Catalog=LibraryDB;
Integrated Security=True;
Encrypt=True;
Trust Server Certificate=True;
";
        private byte[] imageBytes = null;
        private string imageFileName = "";
        private bool isUpdatingFields = false;
        private System.Windows.Forms.Timer searchTimer;

        public Reciept()
        {
            InitializeComponent();

            // Configure PictureBox for auto-fit
            pbReceiptImage.SizeMode = PictureBoxSizeMode.Zoom; // Auto-fit with aspect ratio
            pbReceiptImage.Width = 250;
            pbReceiptImage.Height = 250;
            pbReceiptImage.BorderStyle = BorderStyle.FixedSingle; // Optional border

         
        }

        private void Reciept_Load(object sender, EventArgs e)
        {
            // Configure PictureBox
            pbReceiptImage.SizeMode = PictureBoxSizeMode.Zoom;
            pbReceiptImage.Width = 250;
            pbReceiptImage.Height = 250;
            pbReceiptImage.BorderStyle = BorderStyle.FixedSingle;
            LoadStudentNamesToComboBox();

            // ADD THESE LINES:
            searchTimer = new System.Windows.Forms.Timer();
            searchTimer.Interval = 500;
            searchTimer.Tick += SearchTimer_Tick;


            StudentName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            StudentName.AutoCompleteSource = AutoCompleteSource.CustomSource;
            LoadStudentAutoComplete();

            LoadReceipts();


        }

        // Configure DataGridView
        private void ConfigureDataGridView()
        {
            if (dgvReceipts.Columns.Count > 0)
            {
                // Configure the ReceiptImage column
                if (dgvReceipts.Columns.Contains("ReceiptImage"))
                {
                    DataGridViewImageColumn imgColumn = (DataGridViewImageColumn)dgvReceipts.Columns["ReceiptImage"];
                    imgColumn.ImageLayout = DataGridViewImageCellLayout.Zoom; // Auto-fit image
                    imgColumn.Width = 150; // Set appropriate width
                    imgColumn.HeaderText = "Receipt Image";
                }

                // Hide unnecessary columns
                dgvReceipts.Columns["ImageFileName"].Visible = false;
                dgvReceipts.Columns["CreatedDate"].Visible = false;
                dgvReceipts.Columns["ReceiptID"].Visible = false;
                dgvReceipts.Columns["ReceiptImage"].Visible = true;

                // Set row height to accommodate images
                dgvReceipts.RowTemplate.Height = 100;

                // Enable auto-sizing for better layout
                dgvReceipts.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

                // Except for the image column which should have fixed width
                if (dgvReceipts.Columns.Contains("ReceiptImage"))
                {
                    dgvReceipts.Columns["ReceiptImage"].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
                    dgvReceipts.Columns["ReceiptImage"].Width = 150;
                }

                // Optional: Set word wrap for text columns
                dgvReceipts.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
            }
        }

        private void btnUploadImage_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog
            {
                Filter = "Image Files|*.jpg;*.jpeg;*.png;*.bmp;*.gif",
                Title = "Select Receipt Image"
            };

            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    // Display image in PictureBox - will auto-fit with Zoom mode
                    pbReceiptImage.Image = Image.FromFile(openFileDialog.FileName);
                    pbReceiptImage.SizeMode = PictureBoxSizeMode.Zoom; // Ensure it's set

                    // Convert image to byte array
                    imageBytes = File.ReadAllBytes(openFileDialog.FileName);
                    imageFileName = Path.GetFileName(openFileDialog.FileName);

                    MessageBox.Show("Image uploaded successfully!", "Success",
                        MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error uploading image: " + ex.Message, "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }


        private void btnSave_Click(object sender, EventArgs e)
        {
            // Validation
            if (string.IsNullOrWhiteSpace(txtReceiptNumber.Text))
            {
                MessageBox.Show("Please enter Receipt Number", "Validation Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                txtReceiptNumber.Focus();
                return;
            }

            if (string.IsNullOrWhiteSpace(txtStudentID.Text))
            {
                MessageBox.Show("Please enter Student ID", "Validation Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                txtStudentID.Focus();
                return;
            }

            if (string.IsNullOrWhiteSpace(txtAmountPaid.Text))
            {
                MessageBox.Show("Please enter Amount Paid", "Validation Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                txtAmountPaid.Focus();
                return;
            }

            decimal amountPaid;
            if (!decimal.TryParse(txtAmountPaid.Text, out amountPaid))
            {
                MessageBox.Show("Please enter a valid amount", "Validation Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                txtAmountPaid.Focus();
                return;
            }

            if (string.IsNullOrWhiteSpace(txtCashierName.Text))
            {
                MessageBox.Show("Please enter Cashier Name", "Validation Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                txtCashierName.Focus();
                return;
            }

            // Save to database
            SaveReceipt();

            // ========== INHERITED FROM btnMarkReturned_Click ==========
            string clientID = ClientID.Text.Trim(); // Use ClientID from the form

            if (string.IsNullOrEmpty(clientID))
            {
                // If ClientID is not provided, skip the mark returned logic
                return;
            }

            try
            {
                using (SqlConnection con = new SqlConnection(connectionString))
                {
                    con.Open();

                    // ✅ 1. Check if record exists with 'Report filed by librarian' status
                    string checkQuery = @"
                SELECT COUNT(*) FROM IssueBooks
                WHERE ClientID = @ClientID AND Status = 'Report filed by librarian'";

                    using (SqlCommand checkCmd = new SqlCommand(checkQuery, con))
                    {
                        checkCmd.Parameters.AddWithValue("@ClientID", clientID);
                        int count = (int)checkCmd.ExecuteScalar();

                        if (count == 0)
                        {
                            MessageBox.Show("No record found with status 'Report filed by librarian' for this Client ID.",
                                "Not Found", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            ClearForm();
                            return;
                        }
                    }

                    // ✅ 2. Update IssueBooks to mark as Returned
                    string updateQuery = @"
                UPDATE IssueBooks
                SET Status = 'Returned', ReturnDate = GETDATE()
                WHERE ClientID = @ClientID AND Status = 'Report filed by librarian'";

                    using (SqlCommand updateCmd = new SqlCommand(updateQuery, con))
                    {
                        updateCmd.Parameters.AddWithValue("@ClientID", clientID);
                        int rows = updateCmd.ExecuteNonQuery();

                        if (rows > 0)
                        {
                            // ✅ 3. Automatically mark any pending penalties as paid
                            string clearPenaltyQuery = @"
                        UPDATE PendingPenalties
                        SET IsPaid = 1
                        WHERE ClientID = @ClientID AND IsPaid = 0";

                            using (SqlCommand clearPenaltyCmd = new SqlCommand(clearPenaltyQuery, con))
                            {
                                clearPenaltyCmd.Parameters.AddWithValue("@ClientID", clientID);
                                clearPenaltyCmd.ExecuteNonQuery();
                            }

                            // ✅ 4. Check if student has ANY remaining issues
                            string checkRemainingIssuesQuery = @"
                        SELECT COUNT(*) 
                        FROM IssueBooks 
                        WHERE ClientID = @ClientID 
                        AND (
                            Penalty > 0 
                            OR Status = 'Overdue' 
                            OR Status = 'Report filed by librarian'
                            OR Status = 'Issued'
                        )
                        AND Status != 'Returned'";

                            int remainingIssues = 0;
                            using (SqlCommand checkRemainingCmd = new SqlCommand(checkRemainingIssuesQuery, con))
                            {
                                checkRemainingCmd.Parameters.AddWithValue("@ClientID", clientID);
                                remainingIssues = (int)checkRemainingCmd.ExecuteScalar();
                            }

                            // ✅ 5. Check again for unpaid penalties (after clearing)
                            string checkPendingPenaltiesQuery = @"
                        SELECT COUNT(*) 
                        FROM PendingPenalties 
                        WHERE ClientID = @ClientID AND IsPaid = 0";

                            int pendingPenalties = 0;
                            using (SqlCommand checkPendingCmd = new SqlCommand(checkPendingPenaltiesQuery, con))
                            {
                                checkPendingCmd.Parameters.AddWithValue("@ClientID", clientID);
                                pendingPenalties = (int)checkPendingCmd.ExecuteScalar();
                            }

                            // ✅ 6. Update AddStudentAcc status
                            if (remainingIssues == 0 && pendingPenalties == 0)
                            {
                                string updateStatusQuery = @"
                            UPDATE AddStudentAcc 
                            SET Status = 'Inactive' 
                            WHERE ClientID = @ClientID";

                                using (SqlCommand updateStatusCmd = new SqlCommand(updateStatusQuery, con))
                                {
                                    updateStatusCmd.Parameters.AddWithValue("@ClientID", clientID);
                                    int statusUpdated = updateStatusCmd.ExecuteNonQuery();

                                    MessageBox.Show(
                                        $"✅ Receipt saved & Book successfully returned!\n\n" +
                                        $"Student status updated to 'Inactive' (Rows affected: {statusUpdated}).\n" +
                                        $"The student can now borrow books again.",
                                        "Success",
                                        MessageBoxButtons.OK,
                                        MessageBoxIcon.Information

                                    );
                                    ClearForm();
                                }
                            }
                            else
                            {
                                MessageBox.Show(
                                    $"✅ Receipt saved & Book returned successfully!\n\n" +
                                    $"⚠️ However, this student still has:\n" +
                                    $"• {remainingIssues} unreturned/overdue book(s)\n" +
                                    $"• {pendingPenalties} unpaid penalty/penalties\n\n" +
                                    $"Status remains as 'With Pending Issues'.\n" +
                                    $"Student cannot borrow until all issues are resolved.",
                                    "Partial Success",
                                    MessageBoxButtons.OK,
                                    MessageBoxIcon.Warning
                                );
                                ClearForm();
                            }

                            // ✅ 7. Log the activity
                            ActivityLog.RecordActivity(
                                SessionData.CurrentUserName,
                                "Mark Returned (Damage Report)",
                                "Receipt Module",
                                $"Marked damage report as returned for ClientID: {clientID} via receipt save"
                            );

                            // ✅ 8. Refresh CreateAcc form if open
                            foreach (Form openForm in Application.OpenForms)
                            {
                                if (openForm is CreateAcc createAccForm)
                                {
                                    createAccForm.LoadStudentAccounts();
                                    break;
                                }
                            }

                            // ✅ 9. Refresh Issue form if open
                            foreach (Form openForm in Application.OpenForms)
                            {
                                if (openForm is Issue issueForm)
                                {
                                    issueForm.LoadIssueBooks();
                                    issueForm.LoadReturnedBooks();
                                    issueForm.UpdateTotalOverdueLabel();
                                    break;
                                }
                            }

                            // ✅ 10. Refresh DamagedBookReport form if open
                            foreach (Form openForm in Application.OpenForms)
                            {
                                if (openForm is DamagedBookReport damageForm)
                                {
                                    damageForm.LoadDamageReports();
                                    break;
                                }
                            }
                        }
                        else
                        {
                            MessageBox.Show("Receipt saved, but no rows were updated in IssueBooks.",
                                "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error updating book return status: " + ex.Message,
                    "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }


        // Save Receipt to Database
        private void SaveReceipt()
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string query = @"INSERT INTO Receipts 
                        (ReceiptNumber, StudentID, AmountPaid, DatePaid, CashierName, Purpose, ReceiptImage, ImageFileName,StudentName,ClientID) 
                        VALUES 
                        (@ReceiptNumber, @StudentID, @AmountPaid, @DatePaid, @CashierName, @Purpose, @ReceiptImage, @ImageFileName,@StudentName,@ClientID)";

                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    {
                        cmd.Parameters.AddWithValue("@ReceiptNumber", txtReceiptNumber.Text.Trim());
                        cmd.Parameters.AddWithValue("@StudentID", txtStudentID.Text.Trim());
                        cmd.Parameters.AddWithValue("@AmountPaid", decimal.Parse(txtAmountPaid.Text));
                        cmd.Parameters.AddWithValue("@DatePaid", dtpDatePaid.Value.Date);
                        cmd.Parameters.AddWithValue("@CashierName", txtCashierName.Text.Trim());
                        cmd.Parameters.AddWithValue("@Purpose", string.IsNullOrWhiteSpace(txtPurpose.Text) ?
                            (object)DBNull.Value : txtPurpose.Text.Trim());
                        cmd.Parameters.AddWithValue("@ReceiptImage", imageBytes ?? (object)DBNull.Value);
                        cmd.Parameters.AddWithValue("@ImageFileName", string.IsNullOrWhiteSpace(imageFileName) ?
                            (object)DBNull.Value : imageFileName);
                        cmd.Parameters.AddWithValue("@StudentName", StudentName.Text.Trim());
                        cmd.Parameters.AddWithValue("@ClientID", ClientID.Text.Trim());
                        cmd.ExecuteNonQuery();

                        MessageBox.Show("Receipt saved successfully!", "Success",
                            MessageBoxButtons.OK, MessageBoxIcon.Information);

                        ClearForm();
                        LoadReceipts();
                    }
                }
            }
            catch (SqlException ex)
            {
                if (ex.Number == 2627) // Duplicate key error
                {
                    MessageBox.Show("Receipt Number already exists!", "Duplicate Entry",
                        MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    MessageBox.Show("Database Error: " + ex.Message, "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error saving receipt: " + ex.Message, "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void btnClear_Click(object sender, EventArgs e)
        {
            ClearForm();
        }

        // Load student names for autocomplete
        private void LoadStudentAutoComplete()
        {
            try
            {
                AutoCompleteStringCollection autoComplete = new AutoCompleteStringCollection();

                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    string query = "SELECT Name FROM AddStudentAcc ORDER BY Name";

                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            autoComplete.Add(reader["Name"].ToString());
                        }
                    }
                }

                StudentName.AutoCompleteCustomSource = autoComplete;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error loading autocomplete data: " + ex.Message, "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        // Clear Form
        private void ClearForm()
        {
            txtReceiptNumber.Clear();
            txtStudentID.Clear();
            txtAmountPaid.Clear();
            dtpDatePaid.Value = DateTime.Now;
            txtCashierName.Clear();
            txtPurpose.Clear();
            pbReceiptImage.Image = null;
            imageBytes = null;
            imageFileName = "";
            StudentName.Text = "";
            ClientID.Text = ""; // ADD THIS LINE
            txtReceiptNumber.Focus();
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            string searchTerm = txtReceiptNumber.Text.Trim();

            if (string.IsNullOrWhiteSpace(searchTerm))
            {
                MessageBox.Show("Please enter Receipt Number or Student ID to search",
                    "Search", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            SearchReceipt(searchTerm);
        }

        // Search Receipt
        private void SearchReceipt(string searchTerm)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string query = @"SELECT * FROM Receipts 
                        WHERE ReceiptNumber = @SearchTerm OR StudentID = @SearchTerm";

                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    {
                        cmd.Parameters.AddWithValue("@SearchTerm", searchTerm);

                        using (SqlDataReader reader = cmd.ExecuteReader())
                        {
                            if (reader.Read())
                            {
                                txtReceiptNumber.Text = reader["ReceiptNumber"].ToString();
                                txtStudentID.Text = reader["StudentID"].ToString();
                                ClientID.Text = reader["ClientID"].ToString();
                                txtAmountPaid.Text = reader["AmountPaid"].ToString();
                                dtpDatePaid.Value = Convert.ToDateTime(reader["DatePaid"]);
                                txtCashierName.Text = reader["CashierName"].ToString();
                                txtPurpose.Text = reader["Purpose"].ToString();
                                StudentName.Text = reader["StudentName"].ToString();

                                // Load image if exists
                                if (reader["ReceiptImage"] != DBNull.Value)
                                {
                                    imageBytes = (byte[])reader["ReceiptImage"];
                                    imageFileName = reader["ImageFileName"].ToString();

                                    using (MemoryStream ms = new MemoryStream(imageBytes))
                                    {
                                        pbReceiptImage.Image = Image.FromStream(ms);
                                    }
                                }
                                else
                                {
                                    pbReceiptImage.Image = null;
                                }

                                MessageBox.Show("Receipt found!", "Search Result",
                                    MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            else
                            {
                                MessageBox.Show("Receipt not found!", "Search Result",
                                    MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error searching receipt: " + ex.Message, "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(txtReceiptNumber.Text))
            {
                MessageBox.Show("Please search for a receipt first", "Delete",
                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            DialogResult result = MessageBox.Show(
                "Are you sure you want to delete this receipt?",
                "Confirm Delete",
                MessageBoxButtons.YesNo,
                MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                DeleteReceipt();
            }
        }
        // Delete Receipt
        private void DeleteReceipt()
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string query = "DELETE FROM Receipts WHERE ReceiptNumber = @ReceiptNumber";

                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    {
                        cmd.Parameters.AddWithValue("@ReceiptNumber", txtReceiptNumber.Text.Trim());

                        int rowsAffected = cmd.ExecuteNonQuery();

                        if (rowsAffected > 0)
                        {
                            MessageBox.Show("Receipt deleted successfully!", "Success",
                                MessageBoxButtons.OK, MessageBoxIcon.Information);
                            ClearForm();
                            LoadReceipts();
                        }
                        else
                        {
                            MessageBox.Show("Receipt not found!", "Delete",
                                MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error deleting receipt: " + ex.Message, "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        // Load All Receipts to DataGridView
        private void LoadReceipts()
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string query = "SELECT * FROM Receipts ORDER BY DatePaid DESC";

                    using (SqlDataAdapter adapter = new SqlDataAdapter(query, conn))
                    {
                        DataTable dt = new DataTable();
                        adapter.Fill(dt);

                        // Add an image column to display thumbnails
                        if (!dt.Columns.Contains("ImageThumbnail"))
                        {
                            dt.Columns.Add("ImageThumbnail", typeof(Image));
                        }

                        // Convert byte arrays to images
                        foreach (DataRow row in dt.Rows)
                        {
                            if (row["ReceiptImage"] != DBNull.Value)
                            {
                                byte[] imgBytes = (byte[])row["ReceiptImage"];
                                using (MemoryStream ms = new MemoryStream(imgBytes))
                                {
                                    Image originalImage = Image.FromStream(ms);
                                    // Create a thumbnail for better performance
                                    row["ImageThumbnail"] = ResizeImage(originalImage, 150, 100);
                                }
                            }
                        }

                        dgvReceipts.DataSource = dt;
                        ConfigureDataGridView();

                        // Make sure to show the thumbnail column instead of the byte array
                        if (dgvReceipts.Columns.Contains("ImageThumbnail"))
                        {
                            dgvReceipts.Columns["ImageThumbnail"].DisplayIndex =
                                dgvReceipts.Columns["ReceiptImage"].DisplayIndex;
                            dgvReceipts.Columns["ReceiptImage"].Visible = false;
                            dgvReceipts.Columns["ImageThumbnail"].Visible = true;
                            dgvReceipts.Columns["ImageThumbnail"].HeaderText = "Receipt Image";

                            DataGridViewImageColumn imgCol = (DataGridViewImageColumn)dgvReceipts.Columns["ImageThumbnail"];
                            imgCol.ImageLayout = DataGridViewImageCellLayout.Zoom;
                            imgCol.Width = 150;
                            imgCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error loading receipts: " + ex.Message, "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private Image ResizeImage(Image img, int maxWidth, int maxHeight)
        {
            if (img == null) return null;

            double ratioX = (double)maxWidth / img.Width;
            double ratioY = (double)maxHeight / img.Height;
            double ratio = Math.Min(ratioX, ratioY);

            int newWidth = (int)(img.Width * ratio);
            int newHeight = (int)(img.Height * ratio);

            Bitmap newImage = new Bitmap(newWidth, newHeight);
            using (Graphics g = Graphics.FromImage(newImage))
            {
                g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
                g.DrawImage(img, 0, 0, newWidth, newHeight);
            }

            return newImage;
        }


        private void LoadData(DataGridViewRow row)
        {
            if (row == null) return;

            txtReceiptNumber.Text = row.Cells["ReceiptNumber"].Value?.ToString() ?? "";
            txtStudentID.Text = row.Cells["StudentID"].Value?.ToString() ?? "";
            ClientID.Text = row.Cells["ClientID"].Value?.ToString() ?? "";

            txtAmountPaid.Text = row.Cells["AmountPaid"].Value?.ToString() ?? "";
            dtpDatePaid.Value = row.Cells["DatePaid"].Value != DBNull.Value
                ? Convert.ToDateTime(row.Cells["DatePaid"].Value)
                : DateTime.Now;

            txtCashierName.Text = row.Cells["CashierName"].Value?.ToString() ?? "";
            txtPurpose.Text = row.Cells["Purpose"].Value?.ToString() ?? "";

            // Load image
            if (row.Cells["ReceiptImage"].Value != DBNull.Value)
            {
                imageBytes = (byte[])row.Cells["ReceiptImage"].Value;
                imageFileName = row.Cells["ImageFileName"].Value?.ToString() ?? "";

                using (MemoryStream ms = new MemoryStream(imageBytes))
                {
                    pbReceiptImage.Image = Image.FromStream(ms);
                }
            }
            else
            {
                pbReceiptImage.Image = null;
                imageBytes = null;
                imageFileName = "";
            }
        }




        private void dgvReceipts_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                DataGridViewRow row = dgvReceipts.Rows[e.RowIndex];
                LoadData(row);
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            foreach (Form openForm in Application.OpenForms)
            {
                if (openForm is DamagedBookReport)
                {
                    openForm.Show();
                    this.Hide();
                    return;
                }
            }

            // If not open, create it
            DamagedBookReport form1 = new DamagedBookReport();
            form1.Show();
            this.Hide();
        }

        private void txtSearch_TextChanged(object sender, EventArgs e)
        {
            string search = txtSearch.Text.Replace("'", "''"); // Escape single quotes

            (dgvReceipts.DataSource as DataTable).DefaultView.RowFilter =
                $"ISNULL(StudentName, '') LIKE '%{search}%' " +
                $"OR ISNULL(CONVERT(StudentID, 'System.String'), '') LIKE '%{search}%'";

        }

        private void guna2CirclePictureBox1_Click(object sender, EventArgs e)
        {

        }

        private void pbReceiptImage_Click(object sender, EventArgs e)
        {

        }

        private void ClientID_TextChanged(object sender, EventArgs e)
        {
            if (isUpdatingFields) return;

            string clientIdText = ClientID.Text.Trim();

            // ADD THIS:
            if (string.IsNullOrEmpty(clientIdText))
            {
                isUpdatingFields = true;
                StudentName.SelectedIndex = -1;
                txtStudentID.Clear();
                isUpdatingFields = false;
                return;
            }

            // Check if it's a valid number
            if (!int.TryParse(clientIdText, out int clientIdValue))
            {
                return;
            }

            AutoFillFromClientID(clientIdValue);
        }

        private void StudentName_TextChanged(object sender, EventArgs e)
        {
            if (isUpdatingFields) return;

            if (searchTimer == null) return;

            // ADD THIS:
            if (string.IsNullOrWhiteSpace(StudentName.Text))
            {
                isUpdatingFields = true;
                ClientID.Clear();
                txtStudentID.Clear();
                isUpdatingFields = false;
                return;
            }
        }

        private void SearchTimer_Tick(object sender, EventArgs e)
        {
            searchTimer.Stop();

            string studentName = StudentName.Text.Trim();

            if (!string.IsNullOrEmpty(studentName))
            {
                AutoFillFromStudentName(studentName);
            }
        }

        private void LoadStudentNamesToComboBox()
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string query = "SELECT ClientID, Name, StudentNumber FROM AddStudentAcc ORDER BY Name";

                    DataTable dt = new DataTable();
                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
                    {
                        adapter.Fill(dt);
                    }

                    StudentName.DataSource = dt;
                    StudentName.DisplayMember = "Name";
                    StudentName.ValueMember = "ClientID";
                    StudentName.SelectedIndex = -1;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error loading student names: " + ex.Message);
            }
        }

        private void StudentName_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (isUpdatingFields) return;

            // ADD THIS CHECK:
            if (StudentName.SelectedIndex == -1) return;

            string studentName = StudentName.Text.Trim();

            if (!string.IsNullOrEmpty(studentName))
            {
                AutoFillFromStudentName(studentName);
            }
        }

        // Auto-fill fields based on ClientID
        private void AutoFillFromClientID(int clientId)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    string query = @"SELECT ClientID, Name, StudentNumber 
                           FROM AddStudentAcc 
                           WHERE ClientID = @ClientID";

                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    {
                        cmd.Parameters.AddWithValue("@ClientID", clientId);

                        using (SqlDataReader reader = cmd.ExecuteReader())
                        {
                            if (reader.Read())
                            {
                                isUpdatingFields = true;

                                StudentName.Text = reader["Name"].ToString();
                                txtStudentID.Text = reader["StudentNumber"].ToString();

                                isUpdatingFields = false;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                // Silently handle errors during auto-fill to avoid annoying popups
                Console.WriteLine("AutoFill Error: " + ex.Message);
            }
        }

        // Auto-fill fields based on Student Name
        private void AutoFillFromStudentName(string studentName)
        {
            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    // Use exact match first, then partial match
                    string query = @"SELECT TOP 1 ClientID, Name, StudentNumber 
                           FROM AddStudentAcc 
                           WHERE Name = @StudentName 
                           OR Name LIKE @StudentNamePattern
                           ORDER BY 
                               CASE WHEN Name = @StudentName THEN 0 ELSE 1 END,
                               Name";

                    using (SqlCommand cmd = new SqlCommand(query, conn))
                    {
                        cmd.Parameters.AddWithValue("@StudentName", studentName);
                        cmd.Parameters.AddWithValue("@StudentNamePattern", studentName + "%");

                        using (SqlDataReader reader = cmd.ExecuteReader())
                        {
                            if (reader.Read())
                            {
                                isUpdatingFields = true;

                                ClientID.Text = reader["ClientID"].ToString();
                                txtStudentID.Text = reader["StudentNumber"].ToString();

                                // Update the ComboBox text to exact match
                                StudentName.Text = reader["Name"].ToString();

                                isUpdatingFields = false;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                // Silently handle errors during auto-fill
                Console.WriteLine("AutoFill Error: " + ex.Message);
            }
        }







    }// this is the enddddddddddddddddddddddddddddddddddddd
}// haha