public string InsertRequesterDetail(RequesterDetailModel requesterModel)
{
try
{
if (requesterModel == null)
{
return("empty");
}
if (!string.IsNullOrEmpty(requesterModel.AccessNo))
{
return(InsertBREQsRequesterDetail(requesterModel));
}
var param = new DynamicParameters();
param.Add("@RequestSeriesNo ", requesterModel.TransactionSeriesNo);
param.Add("@LongName", INSTITUTION_NAME);
param.Add("@LastName", requesterModel.LastName);
param.Add("@FirstName", requesterModel.FirstName);
param.Add("@MiddleInitial", requesterModel.MiddleInitial);
param.Add("@AddressLine1", requesterModel.AddressLine1);
param.Add("@AddressLine2", requesterModel.AddressLine2);
param.Add("@Email", requesterModel.EmailAddress);
param.Add("@CountryCode", requesterModel.CountryCode);
if (Convert.ToInt16(requesterModel.CountryCode) == 608)
{
param.Add("@ProvinceCode", requesterModel.ProvinceCode);
param.Add("@MunicipalCode", requesterModel.CityMunicipalityCode);
}
else
{
param.Add("@ProvinceCode", null);
param.Add("@MunicipalCode", null);
}
param.Add("@MobileNo", requesterModel.TelephoneNumber);
param.Add("@ZipCode", requesterModel.ZipCode);
param.Add("@TIN", requesterModel.TIN);
param.Add("@CustomerNo", CUSTOMER_CODE);
param.Add("@QueueTicketNo", requesterModel.QueueTicketNumber);
param.Add("@CreatedBy", _windowsUser);
_dataService.Exec(StoredProcedure.InsertRequester, ConnectionType.CivilRegistrySystem, param);
return("Success");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public IActionResult InsertRequesterDetail(RequesterDetailModel requesterModel)
{
try
{
string response = _serbilisManager.InsertRequesterDetail(requesterModel);
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 string InsertBREQsRequesterDetail(RequesterDetailModel requesterModel)
{
try
{
if (requesterModel == null)
{
return("empty");
}
var param = new DynamicParameters();
param.Add("@LastName", requesterModel.LastName);
param.Add("@FirstName", requesterModel.FirstName);
param.Add("@MiddleInitial", requesterModel.MiddleInitial);
param.Add("@AddressLine1", requesterModel.AddressLine1);
param.Add("@AddressLine2", requesterModel.AddressLine2);
param.Add("@CountryCode", requesterModel.CountryCode);
if (Convert.ToInt16(requesterModel.CountryCode) == 608)
{
param.Add("@ProvinceCode", requesterModel.ProvinceCode);
param.Add("@MunicipalCode", requesterModel.CityMunicipalityCode);
}
else
{
param.Add("@ProvinceCode", null);
param.Add("@MunicipalCode", null);
}
param.Add("@ContactNo", requesterModel.TelephoneNumber);
param.Add("@ZipCode", requesterModel.ZipCode);
param.Add("@AccessNo", requesterModel.AccessNo);
param.Add("@RequesterID", 0, DbType.Int64, ParameterDirection.Output);
RequesterID = _dataService.Exec(StoredProcedure.BreqsInsertRequester,
ConnectionType.CivilRegistrySystem, param);
RequesterID = param.Get <long>("@RequesterID");
return(RequesterID.ToString());
}
catch (Exception ex)
{
return(ex.Message);
}
}