C#

I managed to start from the Winform service but it doesn't work when the user is logged out

Member 12608039 wrote:

it doesn't work when the user is logged out

Dictionary<string, int> items = new Dictionary<string, int>();
for (int i = 500; i >= 350; i--)
    {
    string combine = $"offset_y_bar_{i}";
    items[combine] = i;
    }
Console.WriteLine(items["offset_y_bar_421"]);

(prefix_text)+' '+ (next_id+1) + ' _ '+ Current_year.

Fidele Okito wrote:

using entity framework.

declare @lastId int;
update table1 set next_id = next_id + 1 where prefix_text='xxx' and table_name='fff';
select @lastId = next_id from table1 where prefix_text='xxx' and table_name='fff';
insert into table2 (invoice_number) values('xxx' + '-' + @lastId + '-' + ...);
select @lastId;

Gerry Schmitz wrote:

"Drilling"? "Primary Key" was mentioned in passing because that is typically a "novice" mistake; on the other hand, it's amazing how something so simple can be made so complicated; particularly since every party to the transaction has to now quote and enter and reference it when it means absolutely nothing to them.

Gerry Schmitz wrote:

I also don't see anything to indicate that you have actually worked with AP, AR and ERP systems and integrated them.

Gerry Schmitz wrote:

what it means because you used the word "drilling" and "primary key".

create function NextInvoiceValue()
return nvarchar(30)
Begin
declare @lastId int;
declare @valueinvoice nvarchar(30)

--update table1 set next_id = next_id + 1 where prefix_text='xxx' and table_name='fff';
select @lastId = next_id from table1 where prefix_text='xxx' and table_name='fff';
--insert into table2 (invoice_number) values('xxx' + '-' + @lastId + '-' + ...);
set @valueinvoice='xxx' + '-' + (@lastId +1) + '-' + ...;
return @valueinvoice;

end

update table1 set next_id = next_id + 1 where prefix_text='xxx' and table_name='fff';

Fidele Okito wrote:

I m wondering if this will make sense for daily traffic of 100 000 insertions