public IHttpActionResult Post(BatchAllocation batchAllocation) { OperationStatus operationStatus = new OperationStatus() { ServiceMethod = "POST", ServiceName = "AddBatchAllocation", RequestProcessed = false, RequestSuccessful = false }; if (batchAllocation != null) { if (batchAllocation.Id == 0) { operationStatus = GetBatchAllocationDbService().AddBatchAllocation(batchAllocation); } else { operationStatus.Messages.Add(new Message() { DTOName = "BatchAllocation", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use PUT method to update state of object." }); } } return(Ok(operationStatus)); }
public BatchViewModel(ProjectAllocation p, BatchAllocation b) { batch = b; project = p; }
OperationStatus IBatchAllocationDbService.AddBatchAllocation(BatchAllocation data) { OperationStatus operationStatus = new OperationStatus() { RequestProcessed = false, RequestSuccessful = false }; try { var parameterList = new List <System.Data.IDbDataParameter> { new SqlParameter() { ParameterName = "@BatchAllocationId", Value = data.Id, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@BatchMasterId", Value = data.BatchMasterId, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@AssessorId", Value = data.AssessorId, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@AssessmentDate", Value = data.AssessmentDate, SqlDbType = SqlDbType.Date }, new SqlParameter() { ParameterName = "@Timing", Value = data.Timing, SqlDbType = SqlDbType.Bit }, new SqlParameter() { ParameterName = "@CreatedBy", Value = data.CreatedBy, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@ModifiedBy", Value = data.ModifiedBy, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@IsActive", Value = data.IsActive, SqlDbType = SqlDbType.Bit }, new SqlParameter() { ParameterName = "BatchAllocationId", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.ReturnValue } }; //Comment : Here get DbConnector object var rowEffeted = GetDbConnector().ExecuteNonQuery("MaintainBatchAllocation", QueryCommandType.StoredProcedure, parameterList); //if successfully executed if (rowEffeted > 0) { Int64 batchAllocationId = Convert.ToInt64(parameterList[parameterList.Count() - 1].Value); operationStatus.RequestProcessed = true; operationStatus.RequestSuccessful = true; operationStatus.ServiceName = "AddBatchAllocation"; operationStatus.ServiceMethod = "POST"; operationStatus.AffectedIds.Add(new AffectedId() { DTOName = "BatchAllocation", DTOProperty = "BatchAllocationId", IdValue = batchAllocationId.ToString(), OperationType = OperationType.DELETE }); } else { //LoggingService.Instance.Fatal(string.Format("Unable to remove organisation-role :{0}{1}", Environment.NewLine, object)); } } catch (Exception ex) { operationStatus.RequestProcessed = true; operationStatus.RequestSuccessful = false; operationStatus.Messages.Add(new Message() { DTOName = "JobRole", DTOProperty = "", MessageType = MessageType.SystemError, Text = ex.Message }); } return(operationStatus); }