Search Posts

Category: sql-server

Angular JS with C# and SQL Server [on hold]

I’m working on inserting a calendar component in my application using moment.js as well. I would like to know how I can display the selected date in the textbox with the following conditions: If the selected date is today then the textbox should display the current date and the time should be one hr from the time date is selected. If the date selected is in future, then a default time has to be displayed […]

Linq Query Return Duplicate Record From Sql Database

I am trying to join three linq queries into single query and display the records into an angular js application. But the problem is when I enter the account number and click the submit button, it also displays the duplicate record. Here is the Linq Query: public string TranscationDetails(string Account_Number) { var accountNumber = int.Parse(Account_Number);//It could be better to use TryParse using (HalifaxDatabaseEntities context = new HalifaxDatabaseEntities()) { var CombinedQuery = (from x in context.Current_Account_Deposit […]

Index does not display data from SQL Server

I wanted to do some CRUD operations in ASP.NET web API application. I have connected successfully from index.html to the web API. My goal is to add new items via index.html to database. But, unfortunately, I am not able to display any data on index.html. Could you please check and let me know what I am doing wrong? <label for=”nameAdd”>Album: </label> <input type=”text” class=”form-control” ng-model=”createVM.Name” id=”nameAdd” placeholder=”Wprowadź nazwę albumu” name=”nameAdd” required> </div> <div class=”form-group”> <label […]

How to paginate in angular to display that i have reached the end of the blog?

If I click on loadnextPosts and the pageno exceeds the pagesize, it shouldn’t load any posts or it should alert that I have reached the last page. I do not know the logic for it to work. When I click on loadnextposts, it just keeps on incrementing the pagesize and when the number of posts is exceeded it keeps on incrementing. I want it to alert me that I have reached the end of the […]

Realtime Database Records Working Design in Web Application

I have a question, that how do we design/achieve the design pattern for the web application in an existing ERP System in such a way that if one user fetches a record(s) in browser for editing purpose and the same record is also being used by another user, then how do we tackle with changes made by first user or wise versa and keep the updated information for both the users. Actually I am trying […]