public RequestDetailModel GetRequestDetailsByRequestNumber(int requestNumber)
{
RequestDetailModel requestDetail = null;
SqlConnection conn = new SqlConnection(_conn);
SqlCommand sqlCommand = new SqlCommand("GetRequestDetails", conn);
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
sqlCommand.Parameters.AddWithValue("@RequestNumber", requestNumber);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
requestDetail = new RequestDetailModel
{
RequestNumber = reader.GetInt32(0),
IncidentInformation = reader.GetString(1),
IncidentReason = reader.GetString(2),
BrigadeNumber = reader.GetInt32(3),
BrigadeCallDate = reader.GetDateTime(4),
BrigadeArrivalDate = reader.GetDateTime(5),
BrigadeEndDate = reader.GetDateTime(6),
BrigadeReturnDate = reader.GetDateTime(7)
};
}
}
catch (SqlException ex)
{
_logger.Log(LogLevel.Error, ex.Message);
}
return(requestDetail);
}
/// <summary>
/// Get request model.
/// </summary>
private static RequestDetailModel GetRequestModel(int reqId)
{
var model = new RequestDetailModel();
model.SetReqDetails(reqId);
return(model);
}
public void Create(RequestDetailModel requestDetailModel)
{
SqlConnection conn = new SqlConnection(_conn);
SqlCommand command = new SqlCommand("InsertRequestDetails", conn)
{
CommandType = CommandType.StoredProcedure
};
try
{
conn.Open();
SqlParameter[] sqlParameters =
{
new SqlParameter()
{
ParameterName = "@RequestNumber", Value = requestDetailModel.RequestNumber
},
new SqlParameter()
{
ParameterName = "@IncidentInformation", Value = requestDetailModel.IncidentInformation
},
new SqlParameter()
{
ParameterName = "@IncidentReason", Value = requestDetailModel.IncidentReason
},
new SqlParameter()
{
ParameterName = "@BrigadeNumber", Value = requestDetailModel.BrigadeNumber
},
new SqlParameter()
{
ParameterName = "@BrigadeCallDate", Value = requestDetailModel.BrigadeCallDate
},
new SqlParameter()
{
ParameterName = "@BrigadeArrivalDate", Value = requestDetailModel.BrigadeArrivalDate
},
new SqlParameter()
{
ParameterName = "@BrigadeEndDate", Value = requestDetailModel.BrigadeEndDate
},
new SqlParameter()
{
ParameterName = "@BrigadeReturnDate", Value = requestDetailModel.BrigadeReturnDate
}
};
command.Parameters.AddRange(sqlParameters);
command.ExecuteNonQuery();
conn.Close();
}
catch (SqlException ex)
{
_logger.Log(LogLevel.Error, ex.Message);
}
}
private RequestDetailViewModel ParseRequestDetailModelToViewModel(RequestDetailModel requestDetailModel)
{
RequestDetailViewModel requestModel = new RequestDetailViewModel
{
RequestNumber = requestDetailModel.RequestNumber,
IncidentInformation = requestDetailModel.IncidentInformation,
IncidentReason = requestDetailModel.IncidentReason,
BrigadeArrivalDate = requestDetailModel.BrigadeArrivalDate,
BrigadeCallDate = requestDetailModel.BrigadeCallDate,
BrigadeEndDate = requestDetailModel.BrigadeEndDate,
BrigadeNumber = requestDetailModel.BrigadeNumber,
BrigadeReturnDate = requestDetailModel.BrigadeReturnDate
};
return(requestModel);
}
public IActionResult InsertRequestDetail(RequestDetailModel requestModel)
{
try
{
requestModel.PrimaryFirstName = GetUnknownAscii(requestModel.PrimaryFirstName);
requestModel.PrimaryLastName = GetUnknownAscii(requestModel.PrimaryLastName);
requestModel.SecondaryFirstName = GetUnknownAscii(requestModel.SecondaryFirstName);
requestModel.SecondaryLastName = GetUnknownAscii(requestModel.SecondaryLastName);
requestModel.AuxFirstName = GetUnknownAscii(requestModel.AuxFirstName);
requestModel.AuxLastName = GetUnknownAscii(requestModel.AuxLastName);
string response = _serbilisManager.InsertRequestDetail(requestModel);
if (string.IsNullOrEmpty(response))
{
return(Problem("Problem with execution", null, 500));
}
return(Ok(response));
}
catch (Exception ex)
{
_logger.LogError(ex, ex.Message);
return(Problem(ex.Message, null, 500));
}
}
public object getRequestDetailList()
{
string json = GetJson();
RequestDetailModel model = JsonConvert.DeserializeObject <RequestDetailModel>(json);
List <object> lstData = new List <object>();
for (int i = 0; i < 50; i++)
{
List <object> details = new List <object>();
for (int j = 0; j < 3; j++)
{
details.Add(new { storageNo = $"储位{j}", packageNo = $"包装XI{j * 2}", stockQty = i * (j + 1) / 3 + 5 });
}
lstData.Add(new
{
requestTableId = GuidString,
requestTableNo = $"abcd{i}",
requestDepartment = departments[i % 4],
salesTableNo = $"NACD180012345789{i}",
articlePartName = $"部位{i * 2}",
size = $"{i % 7 + 6}",
requestQty = i + 20,
unIssueQty = i % 5 + 12,
stockQty = i + 15,
requiredIssueDate = DateTime.Now.AddHours(-i).ToString("yyyy-MM-dd HH:mm:ss"),
stockList = details
});
}
var datas = lstData.Skip((model.pageIndex - 1) * model.pageSize).Take(model.pageSize).ToArray();
return(new JsonResultModel()
{
success = true, data = new { recordCount = lstData.Count, list = datas }
});
}
private RequestDetailCreateViewModel ParseRequestDetailModelToCreatViewModel(RequestDetailModel requestDetailModel)
{
RequestDetailCreateViewModel requestModel = new RequestDetailCreateViewModel();
if (requestDetailModel != null)
{
requestModel = new RequestDetailCreateViewModel
{
RequestNumber = requestDetailModel.RequestNumber,
IncidentInformation = requestDetailModel.IncidentInformation,
IncidentReason = requestDetailModel.IncidentReason,
BrigadeArrivalDate = requestDetailModel.BrigadeArrivalDate,
BrigadeCallDate = requestDetailModel.BrigadeCallDate,
BrigadeEndDate = requestDetailModel.BrigadeEndDate,
BrigadeNumber = requestDetailModel.BrigadeNumber,
BrigadeReturnDate = requestDetailModel.BrigadeReturnDate
};
}
else
{
return(null);
}
return(requestModel);
}
public string InsertBREQSRequestDetail(RequestDetailModel requestModel)
{
try
{
var param = new DynamicParameters();
if (requestModel == null)
{
return(null);
}
var transType = requestModel.TransactionType;
var transsubtype = requestModel.TransactionSubType;
param.Add("@RequesterId", requestModel.RequesterID);
switch (requestModel.Certificate)
{
case CertificateType.Birth:
param.Add("@RequestSubType", transsubtype);
param.Add("@RequestType", transType);
break;
case CertificateType.Marriage:
param.Add("@RequestSubType", transsubtype);
param.Add("@RequestType", transType);
break;
case CertificateType.Death:
param.Add("@RequestSubType", transsubtype);
param.Add("@RequestType", transType);
break;
case CertificateType.CENOMAR:
switch (requestModel.TransactionType)
{
case "CI":
param.Add("@RequestType", TRAN_TYPE_CENOMAR);
param.Add("@RequestSubType", transsubtype);
break;
case "VO":
param.Add("@RequestType", transType);
param.Add("@RequestSubType", transsubtype);
break;
}
break;
case CertificateType.CenoDeath:
switch (requestModel.TransactionType)
{
case "CI":
param.Add("@RequestType", TRAN_TYPE_CENODEATH);
param.Add("@RequestSubType", transsubtype);
break;
case "VO":
param.Add("@RequestType", transType);
param.Add("@RequestSubType", transsubtype);
break;
}
break;
default:
return(null);
}
param.Add("@RequestDate", DateTime.Now);
param.Add("@RequestPurposeCode", requestModel.RequestPurpose);
param.Add("@PurposeParticulars", "cccn");
param.Add("@Copies", Convert.ToInt16(requestModel.Copies));
param.Add("@EventDate", requestModel.EventDate);
//param.Add("@EventDate", requestModel.EventDate);
param.Add("@CountryCode", requestModel.CountryCode);
if (Convert.ToInt16(requestModel.CountryCode) == 608)
{
param.Add("@ProvinceCode", requestModel.ProvinceCode);
param.Add("@MunicipalCode", requestModel.MunicipalCode);
}
else
{
param.Add("@ProvinceCode", null);
param.Add("@MunicipalCode", null);
}
param.Add("@PriLastName", requestModel.PrimaryLastName);
param.Add("@PriFirstName", requestModel.PrimaryFirstName);
param.Add("@PriMiddleName", requestModel.PrimaryMiddleName);
param.Add("@PriGender ", requestModel.PrimarySex);
param.Add("@SecLastName", requestModel.SecondaryLastName);
param.Add("@SecFirstName", requestModel.SecondaryFirstName);
param.Add("@SecMiddleName", requestModel.SecondaryMiddleName);
param.Add("@AuxLastName", requestModel.AuxLastName);
param.Add("@AuxFirstName", requestModel.AuxFirstName);
param.Add("@AuxMiddleName", requestModel.AuxMiddleName);
param.Add("@AccessNo", requestModel.AccessNo);
param.Add("@ID", 0, DbType.Int64, ParameterDirection.Output);
_dataService.Exec(StoredProcedure.BreqsInsertRequest, ConnectionType.CivilRegistrySystem, param);
return(param.Get <long>("@ID").ToString());
}
catch (Exception exe)
{
return(exe.ToString());
}
}
public string InsertRequestDetail(RequestDetailModel requestModel)
{
if (requestModel == null)
{
return("request is empty");
}
if (!string.IsNullOrEmpty(requestModel.AccessNo))
{
return(InsertBREQSRequestDetail(requestModel));
}
var param = new DynamicParameters();
if (requestModel == null)
{
return(null);
}
var transType = requestModel.TransactionType;
var transsubtype = requestModel.TransactionSubType;
switch (requestModel.Certificate)
{
case CertificateType.Birth:
case CertificateType.EEBirth:
param.Add("@DocumentType");
param.Add("@DocumentSubType");
param.Add("@RequestSubType", transsubtype);
param.Add("@RequestType", transType);
break;
case CertificateType.Marriage:
case CertificateType.EEMarriage:
param.Add("@DocumentType");
param.Add("@DocumentSubType");
param.Add("@RequestSubType", transsubtype);
param.Add("@RequestType", transType);
break;
case CertificateType.Death:
case CertificateType.EEDeath:
param.Add("@DocumentType");
param.Add("@DocumentSubType");
param.Add("@RequestSubType", transsubtype);
param.Add("@RequestType", transType);
break;
case CertificateType.CENOMAR:
param.Add("@DocumentType");
param.Add("@DocumentSubType");
switch (requestModel.TransactionType)
{
case "CI":
param.Add("@RequestType", TRAN_TYPE_CENOMAR);
param.Add("@RequestSubType", transsubtype);
break;
case "VO":
param.Add("@RequestType", transType);
param.Add("@RequestSubType", transsubtype);
break;
}
break;
case CertificateType.CenoDeath:
param.Add("@DocumentType");
param.Add("@DocumentSubType");
switch (requestModel.TransactionType)
{
case "CI":
param.Add("@RequestType", TRAN_TYPE_CENODEATH);
param.Add("@RequestSubType", transsubtype);
break;
case "VO":
param.Add("@RequestType", transType);
param.Add("@RequestSubType", transsubtype);
break;
}
break;
default:
return(null);
}
param.Add("@SeriesNo", requestModel.TransactionSeriesNo);
param.Add("@OutletCode", requestModel.OutletCode);
param.Add("@RequestDate", DateTime.Now);
param.Add("@WebReferenceNo", REFERENCE_NO);
param.Add("@CreatedBy", _windowsUser);
param.Add("@RequestSource", requestModel.OutletCode == "992" ? "WP" : TRAN_SOURCE);
if (requestModel.TransactionType == "EE")
{
param.Add("@RequestStatusCode", TRANSTATUS_WAITDOCMNT);
}
else
{
param.Add("@RequestStatusCode", TRANSTATUS_WAITPYMNT);
}
param.Add("@ConversionFlag", string.IsNullOrEmpty(requestModel.ConvertedFlag) ? "Y" : requestModel.ConvertedFlag);
param.Add("@RequestPurposeCode", requestModel.RequestPurpose);
param.Add("@PurposeParticulars", requestModel.PurposeParticulars);
param.Add("@RelationshipType", requestModel.RequestRelationship);
param.Add("@PaymentStatusCode", PYMT_STATUS);
param.Add("@NoOfPages", NO_OF_PAGES);
param.Add("@Copies", requestModel.Copies);
param.Add("@DocumentFlag", DOC_FLAG);
param.Add("@EventDate", requestModel.EventDate);
param.Add("@CountryCode", requestModel.CountryCode);
param.Add("@ProvinceCode", requestModel.ProvinceCode);
param.Add("@MunicipalCode", requestModel.MunicipalCode);
param.Add("@PriLastName", requestModel.PrimaryLastName);
param.Add("@PriFirstName", requestModel.PrimaryFirstName);
param.Add("@PriMiddleName", requestModel.PrimaryMiddleName);
param.Add("@PriTIN", PRIM_TIN);
param.Add("@PriGender ", requestModel.PrimarySex);
param.Add("@SecLastName", requestModel.SecondaryLastName);
param.Add("@SecFirstName", requestModel.SecondaryFirstName);
param.Add("@SecMiddleName", requestModel.SecondaryMiddleName);
param.Add("@SecTIN", SEC_TIN);
param.Add("@AuxLastName", requestModel.AuxLastName);
param.Add("@AuxFirstName", requestModel.AuxFirstName);
param.Add("@AuxMiddleName", requestModel.AuxMiddleName);
var transactionSeqNo = 0;
param.Add("@TranSeqNo", transactionSeqNo, DbType.Int32, ParameterDirection.Output);
param.Add("@BatchReferenceNumber", "", DbType.String, ParameterDirection.Output);
_dataService.Exec(StoredProcedure.InsertRequest, ConnectionType.CivilRegistrySystem, param);
string batchRefNumber = param.Get <string>("@BatchReferenceNumber");
//var seqLength = transactionSeqNo.ToString().Length;
//return Hyphenate(requestModel.TransactionSeriesNo +
// Stuff("000", 3 - seqLength, seqLength, transactionSeqNo.ToString()), 4);
return(batchRefNumber);
}
public void Edit(RequestDetailModel requestDetailModel)
{
_repos.Edit(requestDetailModel);
}
public void Create(RequestDetailModel requestDetailModel)
{
_repos.Create(requestDetailModel);
}
