Click here to download the source code

CREATE VIEW VW_GETEMPLOYEE

select e.emp_id as 'ID',e.emp_name as 'Name',d.dept_name as 'Department',e.emp_cnic as 'CNIC',E.emp_dob as 'Date of Birth',

e.emp_email as 'Email',e.emp_hiredate as 'Hire Date',s.status_year as 'Year', s.status_basicsalary as 'Basic Salary',s.status_bonus as 'Annual Bonus',s.status_medical as 'Medical Allownace', s.status_casualleaves as 'Annual Casual Leaves',s.status_sickleaves as 'Sick Leaves',s.status_annualleaves as 'Annual Leaves'

from tbl_employee e inner join TBL_EMPLOYEEWORKINGSTATUS s on e.emp_id = s.status_emp_fk

inner join tbl_departments d on d.dept_id=s.status_dep_fk

SELECT * FROM VW_GETEMPLOYEE

How to store input values in an array in Angular|| Basics of Angular JS ...

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title></title>

<link href="Content/bootstrap.css" rel="stylesheet" />

<link href="Content/bootstrap.min.css" rel="stylesheet" />

<script src="Scripts/angular.js"></script>

<script src="Scripts/angular.min.js"></script>

<style>

ul li{

list-style-type:none;

}

</style>

</head>

<body ng-app="myapp" ng-controller="myctrl">

<h1>To do List</h1>

<form ng-submit="todoAdd()">

<input type="text" class="form-control" placeholder="Enter name here...." ng-model="todoInput" />

<input type="submit" value="Add" class="btn btn-success" />

</form>

<input type="button" value="Delete" class="btn btn-danger" ng-click="remove()" />

<div class="form-control">

<ul ng-repeat="x in todoList">

<li>

<input type="checkbox" ng-model="x.done" /> <span>{{x.todoText}}</span>

</li>

</ul>

</div>

</body>

</html>

<script>

var app = angular.module("myapp", []);

app.controller("myctrl", function ($scope)

{

$scope.todoList = [{ todoText: 'salman masood', done: false }];

$scope.todoAdd = function ()

{

$scope.todoList.push({ todoText: $scope.todoInput, done: false });

$scope.todoInput = "";

};

$scope.remove = function ()

{

var oldList = $scope.todoList;

$scope.todoList = [];

angular.forEach(oldList, function (x)

{

if (!x.done) $scope.todoList.push(x);

});

};

});

</script>

The Concept Academy By Ideas Solution

Wednesday 5 December 2018

Pay Roll Management System in net Application C# 5

Click here to download the source code

How to store input values in an array in Angular|| Basics of Angular JS ...

How to store input values in an array in Angular|| Basics of Angular JS ...

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

About Me