Database Backup for sql 2012

Question

0.00/5 (No votes)

See more:

SQL

How to create <pre lang="c#"></pre>Database backup in sql server 2012 with pass

Posted 19-Feb-15 1:08am

Project CSE

Add a Solution

Comments

CHill60 19-Feb-15 7:21am

What on earth is all that code for? It has nothing to do with your question

King Fisher 21-Feb-15 7:38am

its looks terrible .

Project CSE 15-Mar-15 3:11am

CREATE FUNCTION [dbo].[Split]
( @Delimiter varchar(5),
@List varchar(8000)
)
RETURNS @TableOfValues table
( RowID smallint IDENTITY(1,1),
[Value] varchar(50)
)
AS
BEGIN

DECLARE @LenString int

WHILE len( @List ) > 0
BEGIN

SELECT @LenString =
(CASE charindex( @Delimiter, @List )
WHEN 0 THEN len( @List )
ELSE ( charindex( @Delimiter, @List ) -1 )
END
)

INSERT INTO @TableOfValues
SELECT substring( @List, 1, @LenString )

SELECT @List =
(CASE ( len( @List ) - @LenString )
WHEN 0 THEN ''
ELSE right( @List, len( @List ) - @LenString - 1 )
END
)
END

RETURN

END

GO

Project CSE 15-Mar-15 3:11am

CREATE FUNCTION [dbo].[GetAttInfo](@AttValue [varchar](50), @WhichOne [int])
RETURNS [varchar](50) WITH EXECUTE AS CALLER
AS
begin
set @AttValue=Ltrim(Rtrim(@AttValue))
Declare @Name as VARCHAR(150)
DECLARE @Count AS INT

SET @Count=( SELECT COUNT(*) from [dbo].[Split](',',@AttValue))

if @Count >= @WhichOne
Begin
set @Name=(SELECT [Value] from [dbo].[Split](',',@AttValue) WHERE RowID=@WhichOne)
End
Else
begin
set @Name=''
end

return @Name
end

GO

Project CSE 15-Mar-15 3:12am

-----------------------XXXXXXXXXX---------------------------------

CREATE PROCEDURE [dbo].[SP_AttendanceDataProcessText]
@file_Path AS NVARCHAR (500)=null,
@userName nvarchar(50)=null

--With Encryption
AS

Set nocount ON

if isnull(@file_Path,'')=''
Begin

select @file_Path=AttendanceAppPath+cast(year(getdate()) as varchar(4))+Right('00'+cast(month(getdate()) as varchar(4)),2)+'\'++Right('00'+cast(day(getdate()) as varchar(4)),2)+'.txt' from BranchModuleFor
set @userName='AutoProcess'
End

DECLARE @file_exists AS INT

SET NOCOUNT ON

Declare @SadPIN nvarchar(8),@MID nvarchar(10),@attTime DATETIME,@Attdate DATETIME
declare @LastTime as int
select @LastTime=datepart(hh,UploadTime)*10000+datepart(mi,UploadTime)*100+datepart(ss,UploadTime) from [dbo].[CompanyDailyAttendanceLog] where year(convert(DateTime,UploadDate,103))*10000+month(convert(DateTime,UploadDate,103))*100+day(convert(DateTime,getdate(),103))= year(convert(DateTime,UploadDate,103))*10000+month(convert(DateTime,getdate(),103))*100+day(convert(DateTime,getdate(),103))

EXEC [master].dbo.xp_fileexist @file_Path,@file_exists OUTPUT
IF @file_exists != 0
BEGIN
DECLARE @strSQL VARCHAR (MAX)
set @strSQL=''
CREATE TABLE #tempAttendanceData(line VARCHAR(50))
CREATE TABLE #tempAttendanceRecord(EmpID VARCHAR(8),AttDate DateTime,AttTime DateTime,TerminalID varchar(10))

SET @strSQL = 'bulk Insert #tempAttendanceData from ' + ''''+@file_Path+''''
EXEC (@strSQL)
Insert into #tempAttendanceRecord
Select Right('00000000'+ [dbo].[GetAttInfo](line, 5),8)EmpID,Convert(DateTime,[dbo].[GetAttInfo](line, 3),103)AttDate,Convert(DateTime,[dbo].[GetAttInfo](line, 3)+ ' ' + SUBSTRING([dbo].[GetAttInfo](line, 4),1,2)+':'+ SUBSTRING([dbo].[GetAttInfo](line, 4),3,2)+':'+ SUBSTRING([dbo].[GetAttInfo](line, 4),5,2),103)AttTime, [dbo].[GetAttInfo](line, 6)TerminalID from #tempAttendanceData
inner join StaffStatus on SsPIN=Right('00000000'+ [dbo].[GetAttInfo](line, 5),8)

INSERT INTO StaffAttendanceDetails
Select EmpID ,AttDate,AttTime,'P',TerminalID from #tempAttendanceRecord
inner join StaffStatus on SsPIN=EmpID

if not exists(Select * from [dbo].[CompanyDailyAttendanceLog] where year(convert(DateTime,UploadDate,103))*10000+month(convert(DateTime,UploadDate,103))*100+day(convert(DateTime,getdate(),103))= year(convert(DateTime,getdate(),103))*10000+month(convert(DateTime,getdate(),103))*100+day(convert(DateTime,getdate(),103)))
Begin
INSERT INTO [dbo].[CompanyDailyAttendanceLog]([UploadDate],[UploadTime],[UserName]) VALUES(convert(DateTime,getdate(),103),getdate(),@userName)
End
Else
Begin
Update [dbo].[CompanyDailyAttendanceLog]
set [UploadTime]=getdate()
where year(convert(DateTime,UploadDate,103))*10000+month(convert(DateTime,UploadDate,103))*100+day(convert(DateTime,getdate(),103))= year(convert(DateTime,UploadDate,103))*10000+month(convert(DateTime,getdate(),103))*100+day(convert(DateTime,getdate(),103))
End

Project CSE 15-Mar-15 3:13am

----------------------Start Cursor-----------------------------------

DECLARE AttStringCurFlag CURSOR FOR
SELECT EmpID PIN,AttDate,Min(AttTime)AttTime FROM #tempAttendanceRecord
Group By EmpID,AttDate
Union
SELECT EmpID PIN,AttDate,MAX(AttTime)AttTime FROM #tempAttendanceRecord
Group By EmpID,AttDate
OPEN AttStringCurFlag
FETCH FROM AttStringCurFlag INTO @SadPIN,@Attdate,@attTime
WHILE @@FETCH_STATUS = 0
BEGIN
--select @SadPIN,@Attdate,@attTime
select @MID=TerminalID from #tempAttendanceRecord where EmpID=@SadPIN And AttDate=@Attdate And AttTime=@attTime
if ISNULL(cast(Right('00'+cast(Datepart(hh,@attTime)as varchar),2)+':'+Right('00'+cast(Datepart(mi,@attTime)as varchar),2)+':'+Right('00'+cast(Datepart(ss,@attTime)as varchar),2) AS VARCHAR),'') > [dbo].[MakeTime](SUBSTRING('000000',1,2),SUBSTRING('000000',3,2),SUBSTRING('000000',5,2)) AND ISNULL(cast(Right('00'+cast(Datepart(hh,@attTime)as varchar),2)+':'+Right('00'+cast(Datepart(mi,@attTime)as varchar),2)+':'+Right('00'+cast(Datepart(ss,@attTime)as varchar),2) AS VARCHAR),'') < [dbo].[MakeTime](SUBSTRING('060000',1,2),SUBSTRING('060000',3,2),SUBSTRING('060000',5,2))
Begin
Declare @PDAttDate As DateTime
Set @PDAttDate= DATEADD(d,-1,@Attdate)
if not exists(select * from dbo.StaffDailyAttendance where SdaPIN= @SadPIN and SdaAttDate=@PDAttDate)
Begin
INSERT INTO [dbo].[StaffDailyAttendance] ([SdaPIN],[SdaAttDate] ,[SdaTimeIn] ,[SdaTimeOut],[SdaInTerminal],[SdaOutTerminal],[Setdate] ,[UserName] ,[SdaRemarks])
VALUES (@SadPIN,@PDAttDate,NULL,@attTime,NULL,@MID,GETDATE(),@UserName,NULL)

End
Else
Begin
update StaffDailyAttendance
set SdaTimeOut=@PDAttDate+@attTime
where SdaPIN= @SadPIN and SdaAttDate=@PDAttDate
End
End
Else

Project CSE 15-Mar-15 3:14am

----------------------------------------------------Start Loop for Today---------------------------------------
Begin
if not exists(select * from dbo.StaffDailyAttendance where SdaPIN= @SadPIN and SdaAttDate=@Attdate)
Begin
--select @SadPIN,@Attdate,@attTime,@MID,GETDATE(),@UserName
INSERT INTO [dbo].[StaffDailyAttendance] ([SdaPIN],[SdaAttDate] ,[SdaTimeIn],[SdaInTerminal],[Setdate] ,[UserName])
VALUES (@SadPIN,@Attdate,@attTime,@MID,GETDATE(),@UserName)

End
else
begin
Declare @RealIn int
Declare @RealOut int
declare @attTimeint int
Declare @MIDI nvarchar(15)
Declare @MIDO nvarchar(15)

select @RealIn=datepart(hh,SdaTimeIN)*10000+datepart(mi,SdaTimeIN)*100+datepart(ss,SdaTimeIN) from [dbo].[StaffDailyAttendance] where sdaPIN=@SadPIN and year(convert(DateTime,sdaAttDate,103))*10000+month(convert(DateTime,sdaAttDate,103))*100+day(convert(DateTime,sdaAttDate,103))= year(convert(DateTime,@AttDate,103))*10000+month(convert(DateTime,@AttDate,103))*100+day(convert(DateTime,@AttDate,103))
select @RealOut=datepart(hh,SdaTimeOut)*10000+datepart(mi,SdaTimeOut)*100+datepart(ss,SdaTimeOut) from [dbo].[StaffDailyAttendance] where sdaPIN=@SadPIN and year(convert(DateTime,sdaAttDate,103))*10000+month(convert(DateTime,sdaAttDate,103))*100+day(convert(DateTime,sdaAttDate,103))= year(convert(DateTime,@AttDate,103))*10000+month(convert(DateTime,@AttDate,103))*100+day(convert(DateTime,@AttDate,103))
select @MIDI=SdaInTerminal from dbo.StaffDailyAttendance where sdaPIN=@SadPIN and year(convert(DateTime,sdaAttDate,103))*10000+month(convert(DateTime,sdaAttDate,103))*100+day(convert(DateTime,sdaAttDate,103))= year(convert(DateTime,@AttDate,103))*10000+month(convert(DateTime,@AttDate,103))*100+day(convert(DateTime,@AttDate,103))
select @MIDO=SdaOutTerminal from dbo.StaffDailyAttendance where sdaPIN=@SadPIN and year(convert(DateTime,sdaAttDate,103))*10000+month(convert(DateTime,sdaAttDate,103))*100+day(convert(DateTime,sdaAttDate,103))= year(convert(DateTime,@AttDate,103))*10000+month(convert(DateTime,@AttDate,103))*100+day(convert(DateTime,@AttDate,103))
set @attTimeint=datepart(hh,@attTime)*10000+datepart(mi,@attTime)*100+datepart(ss,@attTime)
if isnull(@Attdate,'') <> '' And isnull(@attTimeint,'')<> ''
Begin

if isnull(@RealIn,'') !='' AND isnull(@RealOut,'') !=''
Begin
if (@RealOut) < (@attTimeint)
Begin
update StaffDailyAttendance set SdaTimeOut=@attTime,SdaOutTerminal=@MID
where SdaPIN= @SadPIN and SdaAttDate=@Attdate

End
Else if(@RealIn) > (@attTimeint)
Begin
update StaffDailyAttendance set SdaTimeIn=@attTime, SdaInTerminal=@MID
where SdaPIN= @SadPIN and SdaAttDate=@Attdate

End

End

Else
Begin

if isnull(@RealIn,'') !='' And (@RealIn) < (@attTimeint)
Begin

update StaffDailyAttendance set SdaTimeOut=@attTime,SdaOutTerminal=@MID
where SdaPIN= @SadPIN and SdaAttDate=@Attdate

End
Else if isnull(@RealIn,'') !='' And (@RealIn) > (@attTimeint)
Begin

update StaffDailyAttendance set SdaTimeIn=@attTime, SdaInTerminal=@MID,SdaTimeOut=@RealIn,SdaOutTerminal=@MIDI
where SdaPIN= @SadPIN and SdaAttDate=@Attdate

End
Else if isnull(@RealOut,'') !='' And (@RealOut) < (@attTimeint)
Begin

update StaffDailyAttendance set SdaTimeIn=@RealOut, SdaInTerminal=@MIDO,SdaTimeOut=@attTime,SdaOutTerminal=@MID
where SdaPIN= @SadPIN and SdaAttDate=@Attdate

End
Else i

Project CSE 15-Mar-15 3:17am

Else if isnull(@RealOut,'') !='' And (@RealOut) > (@attTimeint)
Begin

update StaffDailyAttendance set SdaTimeIn=@attTime, SdaInTerminal=@MID
where SdaPIN= @SadPIN and SdaAttDate=@Attdate

End

End

End

end
End
----------------------------------------------------End Loop for Today---------------------------------------

FETCH NEXT FROM AttStringCurFlag INTO @SadPIN,@Attdate,@attTime
END
CLOSE AttStringCurFlag
DEALLOCATE AttStringCurFlag
drop table #tempAttendanceData
drop table #tempAttendanceRecord

----------------------End Cursor-------------------------------------

END

GO

Project CSE 26-Apr-15 4:52am

--------------------------26-04-2015-------------

@model SCALED.Core.Models.Security.Login
@{
var applicationName = Convert.ToString(Session["ApplicationName"]);
var applicationIcon = Convert.ToString(Session["ApplicationIcon"]);
Layout = null;
}

@Styles.Render("~/Content/css")
@Scripts.Render("~/bundles/modernizr")

<title>@applicationName

body {
background: radial-gradient(circle farthest-corner at center top, #9DE098, #488943 80%) repeat fixed 0 0 #99CE8E;
}

fieldset {
margin: 4px;
border: 1px solid silver;
padding: 4px;
border-radius: 2px;
}

legend {
padding: 2px;
}

@using (Html.BeginForm())
{
@Html.AntiForgeryToken()

Login

@Html.ValidationSummary(true)
@if (ViewBag.Message != null)
{

@ViewBag.Message

}

@Html.TextBoxFor(model => model.Username, new { @class = "form-control", @autocomplete = "off", @placeholder = "Username" })
@Html.ValidationMessageFor(model => model.Username)

@Html.PasswordFor(model => model.Password, new { @class = "form-control", @autocomplete = "off", @placeholder = "Password" })
@Html.ValidationMessageFor(model => model.Password)

</

Project CSE 26-Apr-15 4:53am

Log In

}

@Scripts.Render("~/bundles/jquery")
@Scripts.Render("~/bundles/madmin")

$(document).ready(function () {
$("#Username").focus();
});

Project CSE 26-Apr-15 4:54am

---------------Controlar--------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Mime;
using System.Web.Mvc;
using SCALED.Core.BLL.EmployeeInfo.PersonalInfo.Manager;
using SCALED.Core.BLL.Security.Interfaces;
using SCALED.Core.BLL.Security.Manager;
using SCALED.Core.Models.EmployeeInfo.PersonalInfo;
using SCALED.Core.Models.Security;
using SCALED.License;
using Utility.BLL.Manager;
using Utility.Models;
using Utility.Models.ActionFilters;

namespace SCALED.Controllers
{

public class LoginController : Controller
{
private readonly IUserManager _iUserManager;

public LoginController(IUserManager iUserManager)
{
_iUserManager = iUserManager;
}

public ActionResult Index()
{

Session.RemoveAll();
var organizationInformation = new OrganizationInformation();
if (organizationInformation.GetSolutionAccessLevel())
{
Session["ApplicationIcon"] = "SF-PLUS-01.png";
Session["ApplicationName"] = "Smart Fusion Plus";
}
else
{
Session["ApplicationIcon"] = "SCALED-01.png";
Session["ApplicationName"] = "SCALED";
}
return View();
}

[HttpPost]
public ActionResult Index(Login login)
{
var message = new Message();
if (ModelState.IsValid)
{
var user = new User();
message = _iUserManager.DoLogin(login, ref user);

if (message.MessageType == MessageTypes.Success)
{
var client = new ApplicationClientManager().Get(user.UserId.Substring(0, 4));
var company = new ClientCompanyManager().Get(user.AccessLevel.Substring(0, 8));

var organizationInformation = new OrganizationInformation();

if (company != null)
{
if (organizationInformation.GetOrganizationName() != client.ClientName)
{
ViewBag.Message = "Unauthorized access!";
return View();
}

List<keyvaluepair<string, string="">> companies = organizationInformation.GetClientCompanies();

bool isValidCompany = companies.Any(data => data.Key == company.CompanyId && data.Value == company.CompanyName);

if (!isValidCompany)
{
ViewBag.Message = "Unauthorized access!";
return View();
}

if (new DateTimeUtilityManager().GetServerDate() > organizationInformation.GetLicenseExpiryDate())
{
ViewBag.Message = "License expired. Contact with the vendor";
return View();
}
}

var log = _iUserManager.InsertLoginInformation(SetLoginInfo(user));
CreateSession(user);
Session["LoginLog"] = log;
Session["LoginAttemptCount"] = null;
var userDetails = _iUserManager.GetUserDetails(user.UserId);
if (userDetails != null)
{
userDetails.LastLogInDate = new DateTimeUtilityManager().GetServerDate();
userDetails.IsLoggedIn = true;
_iUserManager.UpdateUserDetailsForLogin(userDetails);
}

if (organizationInformation.GetSolutionAccessLevel() || company == null)
{

Project CSE 26-Apr-15 4:56am

return RedirectToAction("_ModuleList", "Dashboard");
}
else
{
Session["SetModule"] = "01";
return RedirectToAction("Index", "Dashboard");
}
}
else
{
if (user != null && message.CurrentMessage != "Either your account is in-active or locked")
{
if (IsLoginAttemptExceedSecurityPolicy(user))
{
LockLoginUser(user);
}

}
}
}

ViewBag.Message = message.CurrentMessage;
return View();
}

Project CSE 26-Apr-15 4:56am

private void CreateSession(User user)
{

var image = System.IO.File.ReadAllBytes(System.Web.HttpContext.Current.Server.MapPath("~/Images/no_image.jpg"));

var employeePicture = new EmployeePicture();

if (!string.IsNullOrEmpty(user.AccessLevel.Substring(0, 8)) && !string.IsNullOrEmpty(user.EmployeeID))
{
employeePicture = new EmployeeManager().GetEmployeePicture(user.AccessLevel.Substring(0, 8), user.EmployeeID);
}
else
{
employeePicture.EmployeeImage = image;
}
if (employeePicture == null)
{
employeePicture = new EmployeePicture();
employeePicture.EmployeeImage = image;
}

var employee = new Employee();
if (!string.IsNullOrEmpty(user.EmployeeID))
{
employee = new EmployeeManager().Get(user.AccessLevel.Substring(0, 8), user.EmployeeID);

}

var client = new ApplicationClientManager().Get(user.UserId.Substring(0, 4));

var session = new AppSession
{
UserId = user.UserId,
UserName = user.UserName,
RoleId = user.UserRole.RoleId,
AppClientId = user.UserId.Substring(0, 4),
AccessLevel = user.AccessLevel,
ChangePassword = user.ChangePassword,
IdentityCode = user.AccessLevel.Substring(0,8),
EmployeeId = user.EmployeeID,
EmployeeImage = employeePicture.EmployeeImage,
EmployeeName = employee == null ? "" : employee.EmployeeFullName,
UserFullName = user.UserFullName,
ClientName = client.ClientName

};
Session.RemoveAll();

var organizationInformation = new OrganizationInformation();
if (organizationInformation.GetSolutionAccessLevel())
{
Session["ApplicationIcon"] = "SF-PLUS-01.png";
Session["ApplicationName"] = "Smart Fusion Plus";
}
else
{
Session["ApplicationIcon"] = "SCALED-01.png";
Session["ApplicationName"] = "SCALED";
}

Session["Session"] = session;
}

public ActionResult Logout()
{

var session = CurrentSession.GetCurrentSession();

var info = Session["LoginLog"] as UserLoginInformation;
if (info != null)
{
info.LogoutTime = new DateTimeUtilityManager().GetServerDate();
_iUserManager.UpdateLoginInformation(info);

}

if (session != null)
{
var userDetails = _iUserManager.GetUserDetails(session.UserId);
if (userDetails != null)
{
userDetails.IsLoggedIn = false;
_iUserManager.UpdateUserDetailsForLogout(userDetails);
}

}

Session.RemoveAll();

return RedirectToAction("Index", "Login");
}

Project CSE 26-Apr-15 4:57am

private UserLoginInformation SetLoginInfo(User user)
{
var info = new UserLoginInformation();
info.UserName = user.UserName;
info.LoginTime = new DateTimeUtilityManager().GetServerDate();

info.MachineName = Request.UserHostName;
info.IpAddress = Request.UserHostAddress;

//info.MachineName = ControllerContext.HttpContext.Request.UserHostName;
//info.IpAddress =ControllerContext.HttpContext.Request.UserHostAddress;

//var machineName1 = Dns.GetHostName();
//var ip1 = Dns.GetHostByName(Dns.GetHostName()).AddressList[0].ToString();

//var machineName2 = Request.ServerVariables["REMOTE_USER"];
//var ip2 = Request.ServerVariables["REMOTE_HOST"];

return info;

}

private WrongLoginInformation SetWrongLoginInfo(User user,int counter)
{
var info = new WrongLoginInformation();
info.UserName = user.UserName;
info.LoginTime = new DateTimeUtilityManager().GetServerDate();
info.MachineName = Request.UserHostName;
info.IpAddress = Request.UserHostAddress;
info.WrongLoginCounter = counter;
return info;

}

#region Private Method

private void LockLoginUser(User user)
{
var session = new AppSession();
user.IsLockedOut = true;
_iUserManager.LockOrUnLockUser(user.UserId, session);
}

private bool IsLoginAttemptExceedSecurityPolicy(User user)
{
var policy = new SecurityPolicyManager().Get(user.AccessLevel.Substring(0, 8));
if (policy != null)
{
if (!String.IsNullOrEmpty(Convert.ToString(Session["LoginAttemptCount"])))
{
_iUserManager.InsertWrongLoginInformation(SetWrongLoginInfo(user, Convert.ToInt32(Session["LoginAttemptCount"])));

if (Convert.ToInt32(Session["LoginAttemptCount"]) + 1 > policy.MaximumWrongLoginTry)
{
Session.Remove("LoginAttemptCount");
return true;
}
}
}
Session["LoginAttemptCount"] = Convert.ToInt32(Session["LoginAttemptCount"]) + 1;
return false;
}

#endregion

}
}

Project CSE 4-May-15 1:25am

---------------04-May-2015-------------

/****** Object: StoredProcedure [dbo].[USP_HR_REP_StaffSeparation] Script Date: 05/04/2015 09:50:37 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[USP_HR_REP_StaffSeparation]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[USP_HR_REP_StaffSeparation]
GO

/****** Object: StoredProcedure [dbo].[USP_HR_REP_StaffSeparation] Script Date: 05/04/2015 09:50:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- EXEC USP_HR_REP_StaffSeparation '0004','%','%','01-jan-2010','01-jan-2016'

CREATE PROCEDURE [dbo].[USP_HR_REP_StaffSeparation]

@HrmsOfficeId as varchar(04),
@SeparationType as nvarchar(4),
@AreaID as nvarchar(4),
@FromDate as Datetime,
@ToDate as DateTime

--WITH ENCRYPTION
AS

SELECT DT_StaffSeperation.SspPIN, DT_StaffSeperation.SspSeparationType, DT_StaffSeperation.SspEffectiveDate,
StatusType.StatusDesc ,Area.AreaID, Area.AreaName, Project.ProjectName, DT_StaffSeperation.SspVerified,
Staff.StaFname, Staff.StaLname, IsNull(Staff.StaMname,' ') StaMname , JobLevel.JLevelDesc, Designation.DesName
Into #tmpStaffseparation
FROM DT_StaffSeperation INNER JOIN
Staff ON DT_StaffSeperation.SspPIN = Staff.StaPIN INNER JOIN
StatusType ON DT_StaffSeperation.SspSeparationType = StatusType.StatusID INNER JOIN
Area ON DT_StaffSeperation.SspAreaCode = Area.AreaID INNER JOIN
Project ON DT_StaffSeperation.SspProjCode = Project.ProjectId INNER JOIN
JobLevel INNER JOIN
StaffStatus ON JobLevel.JLevelID = StaffStatus.SsJLevelID ON Staff.StaPIN = StaffStatus.SsPIN INNER JOIN
Designation ON StaffStatus.SsDesID = Designation.DesID
Where DT_StaffSeperation.SspEffectiveDate Between @FromDate And @ToDate

If @AreaID = '%'
Begin
Select * from #tmpStaffseparation Where AreaID
In (Select Distinct AreaID from DT_AttachedAreaList Where RootAreaID = @HrmsOfficeId)
And SspSeparationType Like @SeparationType
End
Else
Begin
Select * from #tmpStaffseparation Where AreaID = @AreaID
And SspSeparationType Like @SeparationType
End

Drop table #tmpStaffseparation

GO

Project CSE 5-May-15 5:47am

-----------05-May-2015---------

begin tran

delete from LnLoanCollectionStatus
delete from LnLoanFinalRealization
delete from LnLoanDisbursementDetails
delete from LnStaffLoan_Audit
delete from LnStaffLoan

declare @Pin as Varchar(8)
declare @FebBal as Decimal
declare @MarBal as Decimal
declare @Installment as decimal
declare @NewBal as decimal
declare @Edate as date
declare @LoanType as Varchar(500)
declare @CurrentLoanSerial as int
declare @LoanTypeId as varchar(4)

DECLARE Cur_LoanEntry CURSOR FOR SELECT [PIN],[FebBal],[MarBal],[Installment],[NewBal],case when isnull([EDate],'')='' then '01-Feb-2015' Else CONVERT(DateTime,[EDate],103) End EDate,case when isnull([LoanType],'')='' then '0002' Else '0003' End [LoanType] FROM [dbo].[LoanInformation]
open Cur_LoanEntry
fetch next from Cur_LoanEntry into @Pin,@FebBal,@MarBal,@Installment,@NewBal,@Edate,@LoanType
while @@FETCH_STATUS=0
begin
select @CurrentLoanSerial=isnull(Max(StlSlNo),0)+1 From LnStaffLoan

declare @NoIn as int
if IsNull(@FebBal,@MarBal) % @Installment >0
Begin
set @NoIn=IsNull(@FebBal,@MarBal)/@Installment+1
End
Else
Begin
set @NoIn=IsNull(@FebBal,@MarBal)/@Installment
End

insert into LnStaffLoan values(@CurrentLoanSerial,@LoanType,RIGHT('0000000'+LTRIM(RTRIM(@Pin)),8),
@Edate,dateadd(mm,1,@Edate),ISNULL(@FebBal,@MarBal),
ISNULL(@FebBal,@MarBal),@Edate,@Installment,@NoIn
,1,ISNULL(@FebBal,@MarBal),@Edate,Null,@Edate,'Support',NULL,0,1,0,1,'0001')

insert into LnLoanDisbursementDetails values(@CurrentLoanSerial,@Edate,ISNULL(@FebBal,@MarBal),0,@Edate,'Support','U')

insert into LnStaffLoan_Audit values(@CurrentLoanSerial,@LoanType,RIGHT('0000000'+LTRIM(RTRIM(@Pin)),8),@Edate,dateadd(mm,1,@Edate),ISNULL(@FebBal,@MarBal),NULL,NULL,@Installment,@NoIn,1,NULL,NULL,NULL,@Edate,'Support',NULL,0,1,0,1,'0001','C')

FETCH NEXT FROM Cur_LoanEntry INTO @Pin,@FebBal,@MarBal,@Installment,@NewBal,@Edate,@LoanType
end
close Cur_LoanEntry
deallocate Cur_LoanEntry
commit tran

Project CSE 6-May-15 1:50am

using System;
using System.Data;

namespace SCALED.Core.Models.Leave.Configuration
{
public class LeaveTypeSetup
{
public string IdentityCode { get; set; }
public string LeaveTypeId { get; set; }
public string LeaveName { get; set; }
public string Flag { get; set; }
public string HalfFlag { get; set; }
//public int MaxSanctServiceLife { get; set; }
//public int IntervalDaysInSameLeave { get; set; }
//public bool AppliedInMultipleYear { get; set; }
//public bool EarnEarlyYn { get; set; }

public static LeaveTypeSetup ConvertToModel(DataRow row)
{
var model = new LeaveTypeSetup();
model.IdentityCode = Convert.ToString(row["IdentityCode"]);
model.LeaveTypeId = Convert.ToString(row["LeaveTypeId"]);
model.LeaveName = Convert.ToString(row["LeaveName"]);
model.Flag = Convert.ToString(row["Flag"]);
model.HalfFlag = Convert.ToString(row["HalfFlag"]);

return model;
}
}
}

Project CSE 6-May-15 1:51am

using System.Collections.Generic;
using SCALED.Core.Models.Leave.Configuration;
using Utility.Models;

namespace SCALED.Core.Data.Leave.Configuration.Interfaces
{
public interface ILeaveTypeSetupRepository
{
int Create(LeaveTypeSetup leaveTypeSetup, AppSession appSession);
int Update(LeaveTypeSetup leaveTypeSetup, AppSession appSession);
int Delete(string identityCode, string leaveTypeId);
IEnumerable<leavetypesetup> GetAll();
IEnumerable<leavetypesetup> GetAll(string identityCode);
IEnumerable<leavetypesetup> GetAllByAppClientId(string appClientId);
LeaveTypeSetup Get(string identityCode, string leaveTypeId);
string GetNewId(string identityCode);
}
}

Project CSE 6-May-15 1:52am

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using SCALED.Core.Data.Leave.Configuration.Interfaces;
using SCALED.Core.Models.Leave.Configuration;
using Utility.Models;

namespace SCALED.Core.Data.Leave.Configuration.Repositories
{
internal class LeaveTypeSetupRepository : DataCommon, ILeaveTypeSetupRepository
{
public LeaveTypeSetupRepository(DbContext dbContext)
{
_dbContext = dbContext;
}

public int Create(LeaveTypeSetup leaveTypeSetup, AppSession appSession)
{
var query = new StringBuilder();
query.Append("INSERT INTO Leave.LeaveTypeSetup(IdentityCode, LeaveTypeId, LeaveName, Flag, HalfFlag, SetDate, UserID)");
query.Append("VALUES( @IdentityCode,@LeaveTypeId,@LeaveName,@Flag,@HalfFlag,GETDATE(),@UserId)");
_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "@IdentityCode", Type = DbType.String, Value = leaveTypeSetup.IdentityCode });
_inputParameters.Add(new Parameter { Name = "@LeaveTypeId", Type = DbType.String, Value = leaveTypeSetup.LeaveTypeId });
_inputParameters.Add(new Parameter { Name = "@LeaveName", Type = DbType.String, Value = string.IsNullOrEmpty(leaveTypeSetup.LeaveName) ? (object)DBNull.Value : leaveTypeSetup.LeaveName });
_inputParameters.Add(new Parameter { Name = "@Flag", Type = DbType.String, Value = string.IsNullOrEmpty(leaveTypeSetup.Flag) ? (object)DBNull.Value : leaveTypeSetup.Flag });
_inputParameters.Add(new Parameter { Name = "@HalfFlag", Type = DbType.String, Value = string.IsNullOrEmpty(leaveTypeSetup.HalfFlag) ? (object)DBNull.Value : leaveTypeSetup.HalfFlag });
_inputParameters.Add(new Parameter { Name = "@UserId", Type = DbType.String, Value = appSession.UserId });
return _dbContext.ExecuteQuery(query.ToString(), _inputParameters);
}

public int Update(LeaveTypeSetup leaveTypeSetup, AppSession appSession)
{
var query = new StringBuilder();
query.Append(" UPDATE Leave.LeaveTypeSetup SET LeaveName=@LeaveName,Flag=@Flag,HalfFlag = @HalfFlag, ");
query.Append(" SetDate=GETDATE(),UserId=@UserId ");
query.Append(" WHERE IdentityCode=@IdentityCode AND LeaveTypeId=@LeaveTypeId");

_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "@IdentityCode", Type = DbType.String, Value = leaveTypeSetup.IdentityCode });
_inputParameters.Add(new Parameter { Name = "@LeaveTypeId", Type = DbType.String, Value = leaveTypeSetup.LeaveTypeId });
_inputParameters.Add(new Parameter { Name = "@LeaveName", Type = DbType.String, Value = string.IsNullOrEmpty(leaveTypeSetup.LeaveName) ? (object)DBNull.Value : leaveTypeSetup.LeaveName });
_inputParameters.Add(new Parameter { Name = "@Flag", Type = DbType.String, Value = string.IsNullOrEmpty(leaveTypeSetup.Flag) ? (object)DBNull.Value : leaveTypeSetup.Flag });
_inputParameters.Add(new Parameter { Name = "@HalfFlag", Type = DbType.String, Value = string.IsNullOrEmpty(leaveTypeSetup.HalfFlag) ? (object)DBNull.Value : leaveTypeSetup.HalfFlag });
_inputParameters.Add(new Parameter { Name = "@UserId", Type = DbType.String, Value = appSession.UserId });

return _dbContext.ExecuteQuery(query.ToString(), _inputParameters);
}

public int Delete(string identityCode, string leaveTypeId)
{
var query = new StringBuilder();
query.Append("DELETE FROM Leave.LeaveTypeSetup ");
query.Append("WHERE IdentityCode=@IdentityCode AND LeaveTypeId=@LeaveTypeId");
_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "@IdentityCode", Type = DbType.String, Value = identityCode });
_inputP

Project CSE 6-May-15 1:53am

_inputParameters.Add(new Parameter { Name = "@LeaveTypeId", Type = DbType.String, Value = leaveTypeId });
return _dbContext.ExecuteQuery(query.ToString(), _inputParameters);
}

public IEnumerable<leavetypesetup> GetAll()
{
var dt = _dbContext.GetDataTable("SELECT * FROM Leave.LeaveTypeSetup Order By LeaveTypeId");
if (dt.Rows.Count > 0)
return from DataRow row in dt.Rows select LeaveTypeSetup.ConvertToModel(row);
return null;
}

public IEnumerable<leavetypesetup> GetAll(string identityCode)
{
_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "IdentityCode", Type = DbType.String, Value = identityCode });
var dt = _dbContext.GetDataTable("SELECT * FROM Leave.LeaveTypeSetup WHERE IdentityCode=@IdentityCode Order By LeaveTypeId", _inputParameters);
if (dt.Rows.Count > 0)
return from DataRow row in dt.Rows select LeaveTypeSetup.ConvertToModel(row);
return null;
}

public IEnumerable<leavetypesetup> GetAllByAppClientId(string appClientId)
{
_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "IdentityCode", Type = DbType.String, Value = appClientId });
var dt = _dbContext.GetDataTable("SELECT * FROM Leave.LeaveTypeSetup WHERE SUBSTRING(IdentityCode,1,4)=@IdentityCode Order By LeaveTypeId", _inputParameters);
if (dt.Rows.Count > 0)
return from DataRow row in dt.Rows select LeaveTypeSetup.ConvertToModel(row);
return null;
}

public LeaveTypeSetup Get(string identityCode, string leaveTypeId)
{
_query = "SELECT * FROM Leave.LeaveTypeSetup WHERE IdentityCode=@IdentityCode AND LeaveTypeId=@LeaveTypeId";

_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "@IdentityCode", Type = DbType.String, Value = identityCode });
_inputParameters.Add(new Parameter { Name = "@LeaveTypeId", Type = DbType.String, Value = leaveTypeId });
var dt = _dbContext.GetDataTable(_query, _inputParameters);
if (dt.Rows.Count > 0)
return LeaveTypeSetup.ConvertToModel(dt.Rows[0]);
return null;
}

public string GetNewId(string identityCode)
{
_query = "SELECT Max(LeaveTypeId) +1 LeaveTypeId FROM Leave.LeaveTypeSetup WHERE IdentityCode=@IdentityCode ";

_inputParameters.Clear();
_inputParameters.Add(new Parameter { Name = "@IdentityCode", Type = DbType.String, Value = identityCode });
var value = _dbContext.GetSingleString(_query, _inputParameters);
if (!string.IsNullOrEmpty(value))
return Convert.ToString(value);
return "01";
}
}
}

Project CSE 6-May-15 1:54am

using System.Collections.Generic;
using SCALED.Core.Models.Leave.Configuration;
using Utility.Models;

namespace SCALED.Core.BLL.Leave.Configuration.Interfaces
{
public interface ILeaveTypeSetupManager
{
Message Create(LeaveTypeSetup leaveTypeSetup, AppSession appSession);
Message Update(LeaveTypeSetup leaveTypeSetup, AppSession appSession);
Message Delete(string identityCode, string leaveTypeId);
IEnumerable<leavetypesetup> GetAll();
IEnumerable<leavetypesetup> GetAll(string identityCode);
IEnumerable<leavetypesetup> GetAllByAppClientId(string appClientId);
LeaveTypeSetup Get(string identityCode, string leaveTypeId);
string GetNewId(string identityCode);
}
}

Project CSE 6-May-15 1:55am

using System;
using System.Collections.Generic;
using System.Transactions;
using SCALED.Core.BLL.Leave.Configuration.Interfaces;
using SCALED.Core.Data.Leave.Configuration.Interfaces;
using SCALED.Core.Data.Leave.Configuration.Repositories;
using SCALED.Core.Models.Leave.Configuration;
using Utility.BLL;
using Utility.Models;

namespace SCALED.Core.BLL.Leave.Configuration.Manager
{
public class LeaveTypeSetupManager : BllCommon, ILeaveTypeSetupManager
{
private readonly ILeaveTypeSetupRepository _iLeaveTypeSetupRepository;

public LeaveTypeSetupManager()
{
_iLeaveTypeSetupRepository = new LeaveTypeSetupRepository(_dbContext);
}

public Message Create(LeaveTypeSetup leaveTypeSetup, AppSession appSession)
{
var transactionOptions = new TransactionOptions
{
Timeout = new TimeSpan(0, 0, 9999)
};

using (var ts = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOptions))
{
Message message;
try
{
_dbContext.Open();

var info = _iLeaveTypeSetupRepository.Get(leaveTypeSetup.IdentityCode, leaveTypeSetup.LeaveTypeId);

if (info != null)
{

var affectedRow = _iLeaveTypeSetupRepository.Update(leaveTypeSetup, appSession);

message = affectedRow > 0
? SetMessages.SetSuccessMessage("Leave Type Successfully.")
: SetMessages.SetSuccessMessage("Leave Type Update Failed.");
}
else
{
_iLeaveTypeSetupRepository.Create(leaveTypeSetup, appSession);
message = SetMessages.SetSuccessMessage("Leave Type Create Successfully.");
}

ts.Complete();

}
catch (Exception ex)
{
message = SetMessages.SetErrorMessage(ex.Message);
}
finally
{
_dbContext.Close();
}
return message;
}
}

public Message Update(LeaveTypeSetup leaveTypeSetup, AppSession appSession)
{
Message message;
try
{
_dbContext.Open();
var affectedRow = _iLeaveTypeSetupRepository.Update(leaveTypeSetup, appSession);

message = affectedRow > 0
? SetMessages.SetSuccessMessage("Leave Type Update Successfully.")
: SetMessages.SetSuccessMessage("Leave Type Update Failed.");

}
catch (Exception ex)
{
message = SetMessages.SetErrorMessage(ex.Message);
}
finally
{
_dbContext.Close();
}
return message;
}

public Message Delete(string identityCode, string leaveTypeId)
{
var transactionOptions = new TransactionOptions
{
Timeout = new TimeSpan(0, 0, 9999)
};

using (var ts = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOptions))
{
Message message;
try
{
_dbContext.Open();

var affectedRow = _iLeaveTypeSetupRepository.Delete(identityCode, leaveTypeId);

message = affectedRow > 0
? SetMessages.SetSuccessMessage("Leave Type deleted successfully")
: SetMessages.SetErrorMessage(

Project CSE 6-May-15 1:56am

: SetMessages.SetErrorMessage("Leave Type is not deleted ");

ts.Complete();
}
catch (Exception exception)
{
message = SetMessages.SetErrorMessage(exception.Message.Substring(0, 50)
== "The DELETE statement conflicted with the REFERENCE"
? "You can't delete this Leave Type because it's already used."
: "Delete operation failed.");
}
finally
{
_dbContext.Close();
}
return message;

}
}

public IEnumerable<leavetypesetup> GetAll()
{
try
{
_dbContext.Open();
return _iLeaveTypeSetupRepository.GetAll();
}
catch (Exception ex)
{
throw new Exception("Leave Type Information Retrival Failure.");
}
finally
{
_dbContext.Close();
}
}

public IEnumerable<leavetypesetup> GetAll(string identityCode)
{
try
{
_dbContext.Open();
return _iLeaveTypeSetupRepository.GetAll(identityCode);
}
catch (Exception ex)
{
throw new Exception("Leave Type Information Retrival Failure.");
}
finally
{
_dbContext.Close();
}
}

public IEnumerable<leavetypesetup> GetAllByAppClientId(string appClientId)
{
try
{
_dbContext.Open();
return _iLeaveTypeSetupRepository.GetAllByAppClientId(appClientId);
}
catch (Exception ex)
{
throw new Exception("Leave Type Information Retrival Failure.");
}
finally
{
_dbContext.Close();
}
}

public LeaveTypeSetup Get(string identityCode, string leaveTypeId)
{
try
{
_dbContext.Open();
return _iLeaveTypeSetupRepository.Get(identityCode, leaveTypeId);
}
catch (Exception ex)
{
throw new Exception("Leave Type Information Retrival Failure.");
}
finally
{
_dbContext.Close();
}
}

public string GetNewId(string identityCode)
{
try
{
_dbContext.Open();
return _iLeaveTypeSetupRepository.GetNewId(identityCode);
}
catch (Exception ex)
{
throw new Exception("Leave Type Information Retrival Failure.");
}
finally
{
_dbContext.Close();
}
}
}
}

Project CSE 6-May-15 1:57am

using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;
using SCALED.Core.BLL.Leave.Configuration.Interfaces;
using SCALED.Core.BLL.Leave.Configuration.Manager;
using SCALED.Core.BLL.Security.Interfaces;
using SCALED.Core.BLL.Security.Manager;
using SCALED.Core.Models.Leave.Configuration;
using SCALED.Core.Models.Security;
using Utility.Models;

namespace Leave.Controllers
{
public class Con_LeaveTypeSetupController : Controller
{
readonly ILeaveTypeSetupManager _leaveTypeSetupManager = new LeaveTypeSetupManager();
readonly IUserRoleManager _iUserRoleManager = new UserRoleManager();
readonly IClientCompanyManager _iClientCompanyManager = new ClientCompanyManager();

public ActionResult Index()
{
var model = new LeaveTypeSetup();

var session = CurrentSession.GetCurrentSession();
var screenPermission = _iUserRoleManager.GetRoleWiseScreenPermission(session.RoleId, ScreenList.LeaveTypeSetup);
TempData["ScreenPermission"] = screenPermission;
var clientCompanies = _iClientCompanyManager.GetAll(session.AppClientId).Select(o => new SelectListItem
{
Value = o.CompanyId,
Text = o.CompanyName
}).ToList();
if (session.UserAccessLevelType != UserAccessLevelTypes.Application)
{
clientCompanies = clientCompanies.Where(a => a.Value == session.IdentityCode).ToList();
model.IdentityCode = session.IdentityCode;
}

ViewBag.Companies = clientCompanies;
ViewBag.Message = TempData["Message"];
return View(model);
}

[HttpPost]
public ActionResult Save(LeaveTypeSetup leaveTypeSetup)
{
var currentSession = CurrentSession.GetCurrentSession();
var message = _leaveTypeSetupManager.Create(leaveTypeSetup, currentSession);
return Json(message, JsonRequestBehavior.AllowGet);
}

[HttpPost]
public ActionResult Delete(string identityCode, string leaveTypeId)
{
var message = _leaveTypeSetupManager.Delete(identityCode, leaveTypeId);
return Json(message, JsonRequestBehavior.AllowGet);
}

[HttpGet]
public JsonResult Get(string identityCode, string leaveTypeId)
{
var data = _leaveTypeSetupManager.Get(identityCode, leaveTypeId);
return Json(data, JsonRequestBehavior.AllowGet);
}

[HttpGet]
public JsonResult GetNewId(string identityCode)
{
var data = _leaveTypeSetupManager.GetNewId(identityCode);
return Json(data, JsonRequestBehavior.AllowGet);
}

[HttpGet]
public JsonResult GetLeaveTypes(string identityCode)
{
var session = CurrentSession.GetCurrentSession();
IEnumerable<leavetypesetup> list = null;
if (session.UserAccessLevelType == UserAccessLevelTypes.Application)
{
list = _leaveTypeSetupManager.GetAllByAppClientId(session.IdentityCode.Substring(0, 4));
}
if (session.UserAccessLevelType == UserAccessLevelTypes.Company)
{
list = _leaveTypeSetupManager.GetAll(session.IdentityCode);
}
if (!string.IsNullOrEmpty(identityCode) && list != null)
{
list = list.Where(a => a.IdentityCode == identityCode).ToList();
}
return Json(list, JsonRequestBehavior.AllowGet);
}
}
}

Project CSE 6-May-15 1:59am

$(document).ready(function () {
Clear();
LoadLeaveTypes();

$('#LeaveTypeId').bind('keyup blur', function (e) {
if (this.value.match(/[^0-9 ]/g)) {
this.value = this.value.replace(/[^0-9 ]/g, '');
}
});

$('#LeaveTypeId').bind('keyup', function (e) {
if (e.keyCode == 13) {
e.preventDefault();
if ($('#LeaveTypeId').val() == "") {
$('#LeaveTypeId').focus();
} else {
$('#LeaveName').focus();
}
}
});

$('.numberValue').bind('keyup blur', function (e) {
if (this.value.match(/[^0-9 ]/g)) {
this.value = this.value.replace(/[^0-9 ]/g, '');
}
});

$('#IdentityCode').change(function () {
LoadLeaveTypes();
Clear();
});

$('#LeaveTypeId').change(function () {
var tempValue = "00" + $('#LeaveTypeId').val();
var value = tempValue.substring(tempValue.length - 2, tempValue.length);
if (value == "00") {
$('#LeaveTypeId').val('');
$('#LeaveTypeId').focus();

} else {

var identityCode = $('#IdentityCode').val();
var url = 'Con_LeaveTypeSetup/Get';
$.getJSON(url, { identityCode: identityCode, leaveTypeId: value }, function (data) {
if (data != null) {
ShowNotification(3, "Duplicate Leave ID.");

$('#LeaveTypeId').val('');
$('#LeaveTypeId').focus();
} else {
{
$('#LeaveTypeId').val(value);
}
}
});
}
});

$('#BtnGetNewId').click(function () {
var identityCode = $('#IdentityCode').val();
var url = 'Con_LeaveTypeSetup/GetNewId';
$.getJSON(url, { identityCode: identityCode }, function (data) {
if (data != null) {
Clear();
var tempValue = "00" + data;
var value = tempValue.substring(tempValue.length - 2, tempValue.length);
$('#LeaveTypeId').val(value);
$('#LeaveName').focus();
} else {

}
});
});

// Validate the form manually
$('#BtnSave').click(function () {

if (true) {
var status = true;
var l = Ladda.create(this);

var url = 'Con_LeaveTypeSetup/Save';

var IdentityCode = $('#IdentityCode').val();
var LeaveTypeId = $('#LeaveTypeId').val();
var LeaveName = $('#LeaveName').val();
var Flag = $('#Flag').val();
var HalfFlag = $('#HalfFlag').val();

if (LeaveTypeId == "") {
status = false;
ShowNotification(2, "The Leave Type Id field is required.");
$('#LeaveTypeId').focus();
return false;
}
if (LeaveName == "") {
status = false;
ShowNotification(2, "The Leave Name field is required.");
$('#LeaveName').focus();
return false;
}
if (Flag == "") {
status = false;
ShowNotification(2, "The Flag is required.");
$('#Flag').focus();
return false;
}

if (status) {
l.start();

$.ajax({
url: url,
method: 'post',
data: {
IdentityCode: IdentityCode,
LeaveTypeId: LeaveTypeId,
LeaveName: LeaveName,
Flag: Flag,
HalfFlag: HalfFlag,

},
success: f

Project CSE 6-May-15 2:00am

success: function (data) {
Clear();
var vmMsg = data;
ShowNotification(vmMsg.MessageType, vmMsg.CurrentMessage);
LoadLeaveTypes();
l.stop();

},
error: function () {
l.stop();
}
});
}

} else {
}
});

});

function LoadLeaveTypes() {

var identityCode = $('#IdentityCode').val();

$.ajax({
url: '/Con_LeaveTypeSetup/GetLeaveTypes',
type: 'get',
async: false,
data: {
identityCode: identityCode
},
success: function (res) {
if (res != null) {
var templateWithData = Mustache.to_html($("#templateLeaveTypeSetup").html(), { LeaveTypeSetup: res });
$("#div-list").empty().html(templateWithData);
}
MakePagination('LeaveTypeSetupTable');

},
error: function () {

}
});

}

function Clear() {
$('#LeaveTypeId').val('');
$('#LeaveName').val('');
$('#Flag').val('');
$('#HalfFlag').val('');
$('#LeaveTypeId').prop('disabled', false);
}

function OnDelete(identityCode, leaveTypeId) {
var url = 'Con_LeaveTypeSetup/Delete';
bootbox.confirm("Do you want to delete this record ?", function (result) {
if (result) {
$.ajax({
url: url,
method: 'post',
data: {
identityCode: identityCode,
leaveTypeId: leaveTypeId,
},
success: function (data) {
var vmMsg = data;
window.ShowNotification(vmMsg.MessageType, vmMsg.CurrentMessage);
LoadLeaveTypes();
},
error: function () { }
});
}
});

}

function OnEdit(identityCode, leaveTypeId) {
var url = 'Con_LeaveTypeSetup/Get';
$.ajax({
url: url,
method: 'get',
data: {
identityCode: identityCode,
leaveTypeId: leaveTypeId,
},
success: function (data) {

$('#IdentityCode').val(data.IdentityCode);
$('#LeaveTypeId').val(data.LeaveTypeId);
$('#LeaveName').val(data.LeaveName);
$('#Flag').val(data.Flag);
$('#HalfFlag').val(data.HalfFlag);

$('#LeaveTypeId').prop('disabled', true);
$('#LeaveName').focus();
},
error: function () { }
});
}

Project CSE 6-May-15 2:02am

@using SCALED.Core.Models.Security
@using Utility.Models
@model SCALED.Core.Models.Leave.Configuration.LeaveTypeSetup
@{
var session = Session["Session"] as AppSession;
var permission = TempData["ScreenPermission"] as ScreenPermission;

var collapse = "collapse";

if (session.UserAccessLevelType == UserAccessLevelTypes.Application)
{
collapse = "";
}
}

<table class="table table-bordered table-striped table-hover" id="LeaveTypeSetupTable">
<thead> <th class="collapse">IdentityCode</th> <th>ID</th> <th>Name</th> <th>FullDay Flag</th> <th>HalfDay Flag</th> <th>Action</th> <th>Action</th> </thead> <tbody> {{#LeaveTypeSetup}}

<tr> <td class="collapse"> {{IdentityCode}}</td> <td> {{LeaveTypeId}}</td> <td> {{LeaveName}}</td> <td>{{Flag}}</td> <td>{{HalfFlag}}</td> @if (session.UserAccessLevelType == UserAccessLevelTypes.Application || permission.CanAdd || permission.CanModify)
{
<td class="action-sm"> <a class="btn btn-primary btn-xs" onclick="OnEdit('{{IdentityCode}}', '{{LeaveTypeId}}')"><i class="fa fa-edit"></i> Edit</a>
</td> }
else
{
<td></td> }

@if (session.UserAccessLevelType == UserAccessLevelTypes.Application || permission.CanDelete)
{
<td class="action-sm"> <a class="btn btn-danger btn-xs" onclick="OnDelete('{{IdentityCode}}', '{{LeaveTypeId}}')"><i class="fa fa-trash-o"></i> Delete</a>
</td> }
else
{
<td></td> }

</tr> {{/LeaveTypeSetup}}
</tbody> </table>

@if (session.UserAccessLevelType == UserAccessLevelTypes.Application || permission.CanAdd || permission.CanModify)
{

Leave Type Setup

Company

@Html.DropDownList("IdentityCode", ViewBag.Companies as IEnumerable<selectlistitem>, new { @class = "form-control", @name = "IdentityCode" })

Leave Type Id
*

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-02-19T01:26:00

Solution 1

I don't quite understand why you posted the create scripts for the database but if you want to take a backup, follow the instructions in Create a Full Database Backup (SQL Server)[^]

Posted 19-Feb-15 1:26am

Wendelius

Updated 19-Feb-15 1:29am

v2

CHill60 · Answer 2 · 2015-02-19T01:27:00

Quote:
Beginning with SQL Server 2012 the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups.

How to create full database backup in SQL 2012[^]

Quote:
The WITH PASSWORD feature didn't really encrypt your backup. It just made it difficult for someone to accidentally restore the backup when they were not allowed to and the password option was weak and could be broken easily. The only true way to protect the data is to use a 3rd party backup tool that creates an encrypted backup or to backup to an encrypted media. For sensitive data you should be backing up to encrypted tape anyway as tapes easily get lost and go missing.

Otherwise you can encrypt the data at the source by encrypting the database.

Sean Massey on the SQL Forum[^]

Rajat_RJT · Answer 3 · 2015-02-19T01:31:00

Solution 3

try

https://technet.microsoft.com/en-us/library/ms191304(v=sql.105).aspx[^]
and
https://msdn.microsoft.com/en-IN/library/ms187510.aspx[^]

Posted 19-Feb-15 1:31am

Rajat_RJT