Search Posts

Category: sql-server

How to deal with master tables in asp. Net Mvc?

I am working on an Asp. NET MVC(Angular JS) project which is targeted for 500 users, we are not using entity framework as we thought it is not an option for such a large number of users and costs performance. we are creating Data Access Layer separately. I have multiple master tables around 40 like inventory, category, error type..etc. My Question is for retrieving each transaction record we may need to refer 10 to 15 […]

create Facebook type comment system in angularJS

<div class=”row”> <div class=”form-group col-sm-12″> <div class=”input-group input-group-sm”> <span class=”input-group-addon”> <span class=”glyphicon glyphicon-hand-left”></span> </span> <a href=”blog” title=”Back To Blog” class=”btn btn-success form-control”><span>Back To Blog</span></a> </div> </div> </div> <div class=”row”> <div class=”col-sm-12″> <div class=”well well-sm”> <div class=”row”> <div class=”col-md-12″> <img ng-src=”{{}}” class=”img-responsive img-rounded well-image” /> </div> </div> <div class=”row”> <div class=”col-md-12 text-center” style=”font-family: Rockwell; font-size: 14px; letter-spacing: 2px;”> <h2 class=”h4″>{{}}</h2> </div> </div> <form class=”comment-form”> <div class=”row”> <div class=”col-md-12″> <p style=”font-size: 12px; font-family: Arial;”> {{}} </p> </div> […]

How correct method delete navbar in angularjs and SQL

I have a navbar containing 4 words (Dashboard, Agenda, Config, Compte), when I went to the database and I delete for example (Agenda) by its id, the word (Agenda) deletes in menu but its contents (calendar) remains displayed, I want deleted also its contents(calendar)and the page went automatically to the next page(Dashboard or Config or Compte), how to finish this Source: AngularJS

Does my program architecture make sense? AngularJS + ASP.NET Web API + SQL Server

I have been getting a bit lost in the creation of my program architecture and I want to take a step back to see if I’m approaching it correctly. I am wondering if my setup makes sense. I’m starting to think it doesn’t. I am creating intranet applications (We were creating Internet applications, but now the scope has changed). We use an onsite Active Directory (Windows Server 2012 R2). We have a SQL Server Database. […]

Insert dropdown options into SQL Server table

I have an app written in AngularJS. For every user logged in I would like to save certain user selections to my SQL Server table at the click of a button. So far, I am able to save the logged in users name to my table. The options are stored in selectfilter.html and are called in performancehealth.html as a directive. Here is my code for performancehealth.html <div class=”form-group form-group-sm”> <div class=”input-group input-group-sm”> <div> <usbeefcorp-prefdb-search-filter selection=”performance.nboid” […]

Inserting data into SQL Server

I am trying to pass data to my SQL Server table from my frontend. I am trying to use this Tutorial but I am getting an error saying that dataperfservice.AddEmp is not a function. My app uses the MVVM architecture and is written using C#, AngularJs, Entity Framework and my table is in SQL Server. I have a controller UserNameController.cs with the following code using System; using System.Collections.Generic; using System.Linq; using System.Web; using Performance_Dashboard.Models; namespace […]

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 […]

Next Page »