public async Task AddAsync(PostShare entity)
{
await DbContextManager.BeginTransactionAsync();
var spParameters = new SqlParameter[2];
spParameters[0] = new SqlParameter()
{
ParameterName = "userid", Value = entity.UserId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "postid", Value = entity.PostId
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spInsertShare", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(ChatMessage entity)
{
await DbContextManager.BeginTransactionAsync();
var spParameters = new SqlParameter[3];
spParameters[0] = new SqlParameter()
{
ParameterName = "sender", Value = entity.SenderId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "receiver", Value = entity.ReceiverId
};
spParameters[2] = new SqlParameter()
{
ParameterName = "chat", Value = entity.Message
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spInsertChatMessage", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(BookIssue parameters)
{
var spParameters = new SqlParameter[4];
spParameters[0] = new SqlParameter()
{
ParameterName = "StudentId", Value = parameters.StudentId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "BookDetailId", Value = parameters.BookDetailId
};
spParameters[2] = new SqlParameter()
{
ParameterName = "IssueDate", Value = parameters.IssueDate
};
spParameters[3] = new SqlParameter()
{
ParameterName = "ReturnDate", Value = parameters.ReturnDate
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spIssueBook ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(HotelBooking entity)
{
var spParameters = new SqlParameter[4];
spParameters[0] = new SqlParameter()
{
ParameterName = "UserId", Value = entity.UserId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "HotelId", Value = entity.HotelId
};
spParameters[2] = new SqlParameter()
{
ParameterName = "CheckIn", Value = entity.UserCheckInDate
};
spParameters[3] = new SqlParameter()
{
ParameterName = "CheckOut", Value = entity.UserCheckOutDate
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spHotelBooking ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(BookEntery parameters)
{
var spParameters = new SqlParameter[4];
spParameters[0] = new SqlParameter()
{
ParameterName = "BookTitle", Value = parameters.BookTitle
};
spParameters[1] = new SqlParameter()
{
ParameterName = "BookName", Value = parameters.BookName
};
spParameters[2] = new SqlParameter()
{
ParameterName = "Copies", Value = parameters.Copies
};
spParameters[3] = new SqlParameter()
{
ParameterName = "AuthorName", Value = parameters.AuthorName
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spBookEntery ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(BookIssue entity)
{
var spParameters = new SqlParameter[3];
spParameters[0] = new SqlParameter()
{
ParameterName = "ReturnDate", Value = entity.ReturnDate
};
spParameters[1] = new SqlParameter()
{
ParameterName = "IssueDate", Value = entity.IssueDate
};
spParameters[2] = new SqlParameter()
{
ParameterName = "BookIssueId", Value = entity.BookIssueId
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spReturnBook ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(BookTrainResult entity)
{
var spParameters = new SqlParameter[10];
spParameters[0] = new SqlParameter()
{
ParameterName = "UserId", Value = entity.UserId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "TrainName", Value = entity.TrainName
};
spParameters[2] = new SqlParameter()
{
ParameterName = "StationStartingPoint", Value = entity.StationStartingPoint
};
spParameters[3] = new SqlParameter()
{
ParameterName = "StationEndingPoint", Value = entity.StationEndingPoint
};
spParameters[4] = new SqlParameter()
{
ParameterName = "StationArriveTime", Value = entity.StationArriveTime
};
spParameters[5] = new SqlParameter()
{
ParameterName = "StationDepartTime", Value = entity.StationDepartTime
};
spParameters[6] = new SqlParameter()
{
ParameterName = "TrainObjectTypeName", Value = entity.TrainObjectTypeName
};
spParameters[7] = new SqlParameter()
{
ParameterName = "TrainAvailableDay", Value = entity.TrainAvailableDay
};
spParameters[8] = new SqlParameter()
{
ParameterName = "TrainApplicationObjectClassName", Value = entity.TrainApplicationObjectClassName
};
spParameters[9] = new SqlParameter()
{
ParameterName = "FarePerPerson", Value = entity.FarePerPerson
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spBookTrainResult ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(Transaction parameters)
{
await DbContextManager.BeginTransactionAsync();
var spParameters = new SqlParameter[7];
spParameters[0] = new SqlParameter()
{
ParameterName = "amount", Value = parameters.Amount
};
spParameters[1] = new SqlParameter()
{
ParameterName = "senderId", Value = parameters.SenderId
};
spParameters[2] = new SqlParameter()
{
ParameterName = "recieverId", Value = parameters.ReciverId
};
spParameters[3] = new SqlParameter()
{
ParameterName = "sendDate", Value = parameters.SendDate
};
spParameters[4] = new SqlParameter()
{
ParameterName = "transactionStatus", Value = parameters.TransactionStatus
};
spParameters[5] = new SqlParameter()
{
ParameterName = "remark", Value = parameters.Remarks
};
spParameters[6] = new SqlParameter()
{
ParameterName = "upiId", Value = parameters.UPIId
};
// spParameters[7] = new SqlParameter() { ParameterName = "Flag", Value = "@flag" };
// spParameters[7].Direction = System.Data.ParameterDirection.Output;
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spTransactions ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(PassengerInvoice entity)
{
var spParameters = new SqlParameter[1];
// spParameters[0] = new SqlParameter() { ParameterName = "userid", Value = entity.UserId };
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spPassengerInvoice ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
DbContextManager.RollbackTransaction();
}
}
public async Task UpdateAsync(EmployeeCreate entity)
{
await DbContextManager.BeginTransactionAsync();
try
{
var spParameters = new SqlParameter[7];
spParameters[0] = new SqlParameter()
{
ParameterName = "EmpId", Value = entity.EmployeeId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "FirstName", Value = entity.FirstName
};
spParameters[2] = new SqlParameter()
{
ParameterName = "LastName", Value = entity.LastName
};
spParameters[3] = new SqlParameter()
{
ParameterName = "Email", Value = entity.Email
};
spParameters[4] = new SqlParameter()
{
ParameterName = "MobileNumber", Value = entity.MobileNumber
};
spParameters[5] = new SqlParameter()
{
ParameterName = "Salary", Value = entity.Salary
};
spParameters[6] = new SqlParameter()
{
ParameterName = "JoinDate", Value = entity.JoinDate
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spEmployeeUpdate", spParameters);
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
Console.WriteLine(e);
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(Passenger entity)
{
var spParameters = new SqlParameter[5];
spParameters[0] = new SqlParameter()
{
ParameterName = "PassengerId", Value = entity.PassengerId
};
spParameters[1] = new SqlParameter()
{
ParameterName = "userId", Value = entity.UserId
};
spParameters[2] = new SqlParameter()
{
ParameterName = "PassengerName", Value = entity.PassengerName
};
spParameters[3] = new SqlParameter()
{
ParameterName = "PassengerAge", Value = entity.PassengerAge
};
spParameters[4] = new SqlParameter()
{
ParameterName = "PassengerGender", Value = entity.PassengerGender
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spPassengerDetails ", spParameters);
try
{
await DbContextManager.CommitAsync();
}
catch (Exception)
{
DbContextManager.RollbackTransaction();
}
}
public async Task AddAsync(EmployeeCreate entity)
{
PasswordResult passwordResult = PasswordHash.Encrypt(entity.employeePassword);
await DbContextManager.BeginTransactionAsync();
try
{
var spParameters = new SqlParameter[10];
spParameters[0] = new SqlParameter()
{
ParameterName = "FirstName", Value = entity.FirstName
};
spParameters[1] = new SqlParameter()
{
ParameterName = "LastName", Value = entity.LastName
};
spParameters[2] = new SqlParameter()
{
ParameterName = "Email", Value = entity.Email
};
spParameters[3] = new SqlParameter()
{
ParameterName = "MobileNumber", Value = entity.MobileNumber
};
spParameters[4] = new SqlParameter()
{
ParameterName = "Password", Value = passwordResult.Signature
};
spParameters[5] = new SqlParameter()
{
ParameterName = "Salt", Value = passwordResult.Salt
};
spParameters[6] = new SqlParameter()
{
ParameterName = "LoginBlocked", Value = entity.LoginBlocked
};
spParameters[7] = new SqlParameter()
{
ParameterName = "StatusId", Value = entity.StatusId
};
spParameters[8] = new SqlParameter()
{
ParameterName = "Salary", Value = entity.Salary
};
spParameters[9] = new SqlParameter()
{
ParameterName = "JoinDate", Value = entity.JoinDate
};
await DbContextManager.StoreProc <StoreProcResult>("[dbo].spEmployeeCreate", spParameters);
await DbContextManager.CommitAsync();
}
catch (Exception e)
{
Console.WriteLine(e);
DbContextManager.RollbackTransaction();
}
//User user = new User();
//user.StatusId = Status.Active;
//user.FirstName = entity.FirstName;
//user.LastName = entity.LastName;
//user.Email = entity.Email;
//user.MobileNumber = entity.MobileNumber;
//await Uow.RegisterNewAsync<User>(user);
//int UserId = await Uow.CommitAsync();
//Employee employee = new Employee();
//employee.UserId = UserId;
//employee.Salary = entity.Salary;
//employee.JoinDate = entity.JoinDate;
//await Uow.RegisterNewAsync<Employee>(employee);
//await Uow.CommitAsync();
}
