public INewHireRequestTestDetails Insert(INewHireRequestTestDetails oModelIn)
{
DataSet results;
SqlDatabase oSqlDatabase = new SqlDatabase(NewHireSettingsFactory.GetCurrent.NewHireConnectionString);
using (
DbCommand command = oSqlDatabase.GetStoredProcCommand("up_Insert_RequestTestDetails"))
{
var newGuid = Guid.NewGuid();
Console.WriteLine(newGuid);
oSqlDatabase.AddInParameter(command, "@id", SqlDbType.UniqueIdentifier, newGuid);
oSqlDatabase.AddInParameter(command, "@EmployeeName", SqlDbType.VarChar, oModelIn.EmpName);
oSqlDatabase.AddInParameter(command, "@RequestDate", SqlDbType.VarChar, oModelIn.Date);
oSqlDatabase.AddInParameter(command, "@RequestTime", SqlDbType.VarChar, oModelIn.Time);
oSqlDatabase.AddInParameter(command, "@Emailto", SqlDbType.VarChar, oModelIn.Emailto);
oSqlDatabase.AddInParameter(command, "@Department", SqlDbType.VarChar, oModelIn.Department);
oSqlDatabase.AddInParameter(command, "@CreatedBy", SqlDbType.VarChar, oModelIn.CreatedBy);
oSqlDatabase.AddInParameter(command, "@Status", SqlDbType.VarChar, oModelIn.Status);
results = oSqlDatabase.ExecuteDataSet(command);
}
if (results == null || results.Tables.Count <= 0)
{
return(null);
}
if (results.Tables[0].Rows.Count <= 0)
{
return(null);
}
return(NewHireRequestTestDetailsDataMapperFactory.GetCurrent.MapSingle(results.Tables[0].Rows[0]));
}
public NewHireRequestTestViewModel(INewHireRequestTestDetails oModelIn)
{
Id = oModelIn.Id;
EmpName = oModelIn.EmpName;
Date = oModelIn.Date;
Time = oModelIn.Time;
CreatedBy = oModelIn.CreatedBy;
Emailto = oModelIn.Emailto;
Department = oModelIn.Department;
Status = oModelIn.Status;
}
public INewHireRequestTestDetails Insert(INewHireRequestTestDetails oModelIn)
{
return(NewHireRequestTestDetailsRepositoryFactory.GetCurrent.Insert(oModelIn));
}
