C#

Quote:

i need to help create master detail form in winform means when i click on orderno then it will be show order detail like table 2 data on gridview like item name,rice and quantity

protected void SaveButton_Click(object sender, EventArgs e)
        {
            string EmpId = Session["EmpId"].ToString();
            string StrSQL = "";
            clsDB obj = new clsDB();

            // Get the maximum TaskID from the database
            StrSQL = "SELECT MAX(TaskID) FROM Timesheet";
            object maxTaskID = obj.GetScalar(StrSQL);
            int TaskID = maxTaskID != DBNull.Value ? Convert.ToInt32(maxTaskID) + 1 : 1;

            // Save the data from the first row
            StrSQL = "INSERT INTO Timesheet ";
            StrSQL += "VALUES('" + EmpId + "','" + TaskID + "','" + txttask.Text + "','" + txttaskdate.Text + "', ";
            StrSQL += "'" + txtDescription.Text + "', '" + txttimetaken.Text + "')";

            Result = Convert.ToInt32(obj.ExecuteNonQuery(StrSQL));
            if (Result == 1)
            {
                string script = "alert('Data saved Successfully')";
                ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);
            }
            string message = "";
            int currentTaskID = TaskID;

            StrSQL = "INSERT INTO Timesheet ("+" EmployeeId, TaskId, TaskDate, TaskName, Description, TimeTaken) VALUES ";
            StrSQL += "('" + EmpId + "','" + currentTaskID + "','";
            foreach (TextBox textBox in pnlTextBoxes.Controls.OfType<TextBox>())
            {
                StrSQL += textBox.Text + "','";
            }
            StrSQL = StrSQL.Substring(0, StrSQL.Length - 2) + ");"; // Remove the extra ',' and add the closing parenthesis
            Result = Convert.ToInt32(obj.ExecuteNonQuery(StrSQL));
            ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('" + message + "');", true);

        }
    }

protected void btnAddRow_Click(object sender, EventArgs e)
       {
           int index = pnlTextBoxes.Controls.OfType<textbox>().ToList().Count + 1;
           this.CreateTextBox("ltIndex" + index);
       }

       private void CreateTextBox(string i)
       {

           Literal ltIndex = new Literal();
           ltIndex.Text = 1 + ".";
           pnlTextBoxes.Controls.Add(ltIndex);
           Literal lt = new Literal();
           lt.Text = "<br>";
           pnlTextBoxes.Controls.Add(lt);
       }

       its provoiding index value as 1 for all the newly added row,its not providing autoincrementing of indexing

public static DataTable GetAll()
{
    using DataTable dt = new();
    try
    {
        string query = "
                        select
                            l.LineID,
                            s.SheetID,
                            z.ZoneID,
                            j.JointTypeID,
                            j.JointClassID ,
                            j.PipeClassID ,
                            j.HoldID,
                            l.[LineNo] ,
                            s.Sheet,
                            s.Rev ,
                            s.RevIndex ,
                            z.Unit,
                            z.Area,
                            s.SheetStatus as LineStatus,
                            j.JointID,
                            j.JointNo ,
                            j.JointIndex ,
                            j.JointStatus ,
                            cast(CAST(j.JointSize as decimal(18,2)) as float) as JointSize,
                            j.[Location],
                            j.Spool,
                            jt.JointType,
                            jc.JointClassName as Class,
                            pc.PipeClass,
                            m.MaterialName as Mat,
                            j.Thk
                        from
                        Joint  as j
                        inner join Sheet as s on s.SheetID = j.SheetID and s.VoidDate is null
                        inner join  Line as l on l.LineID=s.LineID
                        left join Zone as z on z.ZoneID = j.ZoneID
                        left join JointType as jt on jt.JointTypeID = j.JointTypeID
                        left join JointClass as jc on jc.JointClassID = j.JointClassID
                        left join PipingClass as pc on pc.PipeClassID = j.PipeClassID
                        left join Material as m on m.MaterialID = pc.MaterialID
                        left join MTO as m1 on m1.SheetID = j.SheetID AND m1.PTNo = Mat1
                        left join MTO as m2 on m2.SheetID = j.SheetID AND m2.PTNo = Mat2
                        ";
        using SqlCommand cmd = new SqlCommand(query, Connection.Conn);
        Connection.Open();
        using SqlDataReader rd = cmd.ExecuteReader();
        dt.Load(rd);

    }
    catch (SqlException ex)
    {
        Error = ex.Message;
    }
    finally
    {
        Connection.Close();
    }
    return dt;
}

public static DataTable GetAll()
      {
          return JointDAL.GetAll();
      }

DG_Joint.DataSource = JointBLL.GetAll();

I don't know if I wrote it explicitly or not, but what I mean by creating this topic is to review the multi-layer program, what codes should be written in each layer.