public GetProcessCardMasterQM GetProcessCardMaster(decimal PartCode)
{
GetProcessCardMasterQM model = new GetProcessCardMasterQM();
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new GetProcessCardMasterSelectCommand {
Connection = connection
};
model = command.Execute(PartCode);
}
return(model);
}
public GetProcessCardMasterQM Execute(decimal PartCode)
{
var response = new GetProcessCardMasterQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetProcessCardMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@PartCode", SsDbType.Decimal, ParameterDirection.Input, PartCode));
//sqlCommand.Parameters.Add(AddParameter("@SequenceNumber", SsDbType.Decimal, ParameterDirection.Input, SequenceNumber));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetProcessCardMasterModelList = reader.ToList <GetProcessCardMasterQMModel>();
}
}
return(response);
}
public AddJobCardGenerationResponseDto AddJobCardGeneration(AddJobCardGenerationRequestDto addJobCardGenerationRequestDto)
{
AddJobCardGenerationResponseDto response = new AddJobCardGenerationResponseDto();
AddJobCardMasterAndDetailsCM addJobCardMasterAndDetailsCM = new AddJobCardMasterAndDetailsCM();
foreach (var request in addJobCardGenerationRequestDto.addJobCardGenerationRequestList)
{
GetProcessCardMasterQM getProcessCardMasterQM = new GetProcessCardMasterQM();
GetProcessCardDetailsQM getProcessCardDetailsQM = new GetProcessCardDetailsQM();
AddJobCardMasterCM addJobCardMasterCM = new AddJobCardMasterCM();
AddJobCardDetailsCM addJobCardDetailsCM = new AddJobCardDetailsCM();
var addJobCardMasterList = new List <AddJobCardMasterCM>();
var addJobCardDetailsList = new List <AddJobCardDetailsCM>();
#region Process Card Master and Details Information
getProcessCardMasterQM = jobCardGenerationRepository.GetProcessCardMaster(request.PartCode);
getProcessCardDetailsQM = jobCardGenerationRepository.GetProcessCardDetails(request.PartCode);
#endregion
#region Save JobCard Master and Details
foreach (var processCardMaster in getProcessCardMasterQM.GetProcessCardMasterModelList)
{
addJobCardMasterCM = new AddJobCardMasterCM()
{
SerialNo = request.SerialNo,
JobCardDate = System.DateTime.UtcNow,
PartCode = processCardMaster.PartCode,
SequenceNumber = processCardMaster.SequenceNumber,
MachineCode = processCardMaster.MachineCode,
JigCode = processCardMaster.JigCode,
SettingTime = processCardMaster.SettingTime,
RunningTime = processCardMaster.RunningTime,
CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove
CreatedDateTime = System.DateTime.UtcNow
};
addJobCardMasterList.Add(addJobCardMasterCM);
}
foreach (var processCardDetails in getProcessCardDetailsQM.GetProcessCardDetailsQMModelList)
{
addJobCardDetailsCM = new AddJobCardDetailsCM()
{
SerialNo = request.SerialNo,
PartCode = processCardDetails.PartCode,
SequenceNumber = processCardDetails.SequenceNumber,
Serial = processCardDetails.Serial,
Description = processCardDetails.Description,
DimensionMin = processCardDetails.DimensionMin,
DimensionMax = processCardDetails.DimensionMax,
ParameterCode = processCardDetails.ParameterCode,
InstrumentCode = processCardDetails.InstrumentCode,
ToolCode = processCardDetails.ToolCode,
DRFlag = processCardDetails.DRFlag,
Symbol = processCardDetails.Symbol,
Datum = processCardDetails.Datum,
DatumDimension = processCardDetails.DatumDimension,
BooleanNumber = processCardDetails.BooleanNumber,
CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove
CreatedDateTime = System.DateTime.UtcNow
};
addJobCardDetailsList.Add(addJobCardDetailsCM);
}
addJobCardMasterAndDetailsCM = new AddJobCardMasterAndDetailsCM()
{
AddJobCardMasterCMList = addJobCardMasterList,
AddJobCardDetailsCMList = addJobCardDetailsList
};
jobCardGenerationRepository.AddJobCardMasterAndDetails(addJobCardMasterAndDetailsCM);
#endregion
}
return(response);
}
