Insert two tables in a time

(Tbl_Branch)

 

 

 

The following​ is my code:

// Insert code
cmd = New SqlCommand("Branch", cnn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@name", txtBranchName.Text)
cmd.Parameters.AddWithValue("@location", txtLocation.Text)
cmd.Parameters.AddWithValue("@note", txtDescription.Text)
cmd.Parameters.AddWithValue("@inputby", txtUser.Text)
cmd.Parameters.AddWithValue("@inputdate", userDate)
cmd.ExecuteNonQuery()

 

// Stored Procedure
insert into Tbl_Branch(BranchName,Location,[Description], input_By, input_Date)
VALUES(@name,@location,@note,@inputby,@inputdate)
declare @lastrow int
select top 1 @lastrow = BranchId from Tbl_Branch
order by BranchId desc

DECLARE @insert INT
Select @insert = @@ROWCOUNT
if @insert>0

insert into Tbl_BranchHistory(BranchId,BranchName,Location,[description],status,update_By,update_Date)
VALUES(@lastrow,@name,@location,@note,@status,@updateby,@updatedate)