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)); }