public void UpdateProcessCard(UpdateProcessCardCM updateProcessCardCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new ProcessCardUpdateCommand {
Connection = connection
};
command.Execute(updateProcessCardCM.PartCode, updateProcessCardCM.SequenceNumber, updateProcessCardCM.MachineCode, updateProcessCardCM.JigCode,
updateProcessCardCM.SettingTime, updateProcessCardCM.RunningTime, updateProcessCardCM.ListUpdateProcessCardDetails.ToDataTableWithNull(), updateProcessCardCM);
}
}
public void Execute(decimal PartCode, decimal SequenceNumber, string MachineCode, string JigCode, string SettingTime,
string RunningTime, DataTable dataTableForProcessCardDetails, UpdateProcessCardCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspUpdateProcessCard]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@PartCode", SsDbType.Decimal, ParameterDirection.Input, PartCode));
sqlCommand.Parameters.Add(AddParameter("@SequenceNumber", SsDbType.Decimal, ParameterDirection.Input, SequenceNumber));
sqlCommand.Parameters.Add(AddParameter("@MachineCode", SsDbType.VarChar, ParameterDirection.Input, MachineCode));
sqlCommand.Parameters.Add(AddParameter("@JigCode", SsDbType.VarChar, ParameterDirection.Input, JigCode));
sqlCommand.Parameters.Add(AddParameter("@SettingTime", SsDbType.VarChar, ParameterDirection.Input, SettingTime));
sqlCommand.Parameters.Add(AddParameter("@RunningTime", SsDbType.VarChar, ParameterDirection.Input, RunningTime));
sqlCommand.Parameters.Add(AddParameter("@ProcessCardDetails", SsDbType.Structured, ParameterDirection.Input, dataTableForProcessCardDetails));
sqlCommand.ExecuteNonQuery();
}
}
public AddProcessCardResponseDto AddProcessCard(AddProcessCardRequestDto addProcessCardRequestDto)
{
AddProcessCardResponseDto response = new AddProcessCardResponseDto();
AddProcessCardCM addProcessCardCM = new AddProcessCardCM();
UpdateProcessCardCM updateProcessCardCM = new UpdateProcessCardCM();
var addProcessCardDetailsCmModel = new List <ProcessCardDetailsCmModel>();
var updateProcessCardDetailsCmModelList = new List <UpdateProcessCardDetailsCmModel>();
var processCardMasterCmModel = new ProcessCardMasterCmModel();
var processCardDetailsCmModel = new ProcessCardDetailsCmModel();
var updateProcessCardMasterCmModel = new UpdateProcessCardMasterCmModel();
var updateProcessCardDetailsCmModel = new UpdateProcessCardDetailsCmModel();
processCardMasterCmModel = new ProcessCardMasterCmModel
{
PartCode = addProcessCardRequestDto.PartCode,
SequenceNumber = addProcessCardRequestDto.SequenceNumber,
MachineCode = addProcessCardRequestDto.MachineCode,
JigCode = addProcessCardRequestDto.JigCode,
SettingTime = addProcessCardRequestDto.SettingTime,
RunningTime = addProcessCardRequestDto.RunningTime
};
//addProcessCardMasterCmModel.Add(processCardMasterCmModel);
foreach (var processCardDetails in addProcessCardRequestDto.ListProcessCardDetails.Where(x => x.IsNew == true))
{
processCardDetailsCmModel = new ProcessCardDetailsCmModel
{
PartCode = processCardDetails.PartCode,
SequenceNumber = processCardDetails.SequenceNumber,
SerialNo = processCardDetails.SerialNo,
Description = processCardDetails.Description,
DimensionMax = processCardDetails.DimensionMax,
DimensionMin = processCardDetails.DimensionMin,
ParameterCode = processCardDetails.ParameterCode,
InstrumentCode = processCardDetails.InstrumentCode,
ToolCode = processCardDetails.ToolCode,
DRFlag = processCardDetails.DRFlag,
Symbol = processCardDetails.Symbol,
Datum = processCardDetails.Datum,
DatumDimension = processCardDetails.DatumDimension,
BooleanNumber = processCardDetails.BooleanNumber
};
addProcessCardDetailsCmModel.Add(processCardDetailsCmModel);
}
if (addProcessCardDetailsCmModel != null && addProcessCardDetailsCmModel.ToList().Count > 0)
{
addProcessCardCM = new AddProcessCardCM()
{
//ListProcessCardMaster = addProcessCardMasterCmModel,
IsNew = addProcessCardRequestDto.IsNew,
PartCode = processCardMasterCmModel.PartCode,
SequenceNumber = processCardMasterCmModel.SequenceNumber,
MachineCode = processCardMasterCmModel.MachineCode,
JigCode = processCardMasterCmModel.JigCode,
SettingTime = processCardMasterCmModel.SettingTime,
RunningTime = processCardMasterCmModel.RunningTime,
ListProcessCardDetails = addProcessCardDetailsCmModel
};
processCardRepository.AddProcessCard(addProcessCardCM);
}
foreach (var processCardDetails in addProcessCardRequestDto.ListProcessCardDetails.Where(x => x.IsNew == false))
{
updateProcessCardDetailsCmModel = new UpdateProcessCardDetailsCmModel
{
PartCode = processCardDetails.PartCode,
SequenceNumber = processCardDetails.SequenceNumber,
SerialNo = processCardDetails.SerialNo,
Description = processCardDetails.Description,
DimensionMax = processCardDetails.DimensionMax,
DimensionMin = processCardDetails.DimensionMin,
ParameterCode = processCardDetails.ParameterCode,
InstrumentCode = processCardDetails.InstrumentCode,
ToolCode = processCardDetails.ToolCode,
DRFlag = processCardDetails.DRFlag,
Symbol = processCardDetails.Symbol,
Datum = processCardDetails.Datum,
DatumDimension = processCardDetails.DatumDimension,
BooleanNumber = processCardDetails.BooleanNumber
};
updateProcessCardDetailsCmModelList.Add(updateProcessCardDetailsCmModel);
}
;
if (updateProcessCardDetailsCmModelList != null && updateProcessCardDetailsCmModelList.ToList().Count > 0)
{
updateProcessCardCM = new UpdateProcessCardCM()
{
//ListProcessCardMaster = addProcessCardMasterCmModel,
PartCode = processCardMasterCmModel.PartCode,
SequenceNumber = processCardMasterCmModel.SequenceNumber,
MachineCode = processCardMasterCmModel.MachineCode,
JigCode = processCardMasterCmModel.JigCode,
SettingTime = processCardMasterCmModel.SettingTime,
RunningTime = processCardMasterCmModel.RunningTime,
ListUpdateProcessCardDetails = updateProcessCardDetailsCmModelList
};
processCardRepository.UpdateProcessCard(updateProcessCardCM);
}
return(response);
}
