public IndividualConsignee GetIndividualConsignee(string indivdualTRN)
{
IndividualConsignee individualConsignee = null;
try
{
using (var SqlConnection = new SqlConnection(_DBConnectionString))
{
//TODO STORED PROCS
individualConsignee = SqlConnection.Query <IndividualConsignee>("SELECT * FROM IndividualConsignee WHERE TRN = @IndividualTRN",
new { @IndividualTRN = indivdualTRN }, commandType: CommandType.Text, commandTimeout: 60).FirstOrDefault();
}
}
catch (Exception ex)
{
//TODO
_logger.Error(ex, "Error occured getting consignee data from database.");
var ext = ex.ToString();
//LOG
//TODO
}
return(individualConsignee);
}
public int CreateIndividualConsignee(IndividualConsigneeBindingModel individualConsigneeModel)
{
int?createdConsigneeId = null;
var individualConsignee = new IndividualConsignee();
individualConsignee.FirstName = individualConsigneeModel.FirstName;
individualConsignee.LastName = individualConsigneeModel.LastName;
individualConsignee.TRN = individualConsigneeModel.TRN;
individualConsignee.CustomerCode = individualConsigneeModel.CustomerCode;
individualConsignee.Address = individualConsigneeModel.Address;
using (var sqlConnection = new SqlConnection(_DBConnectionString))
{
try
{
sqlConnection.Open();
createdConsigneeId = sqlConnection.ExecuteScalar <int>(
@"INSERT INTO IndividualConsignee (FirstName,LastName,TRN,Address,CustomerCode)
OUTPUT Inserted.Id Values (@indivdualConsignee)", individualConsignee,
commandType: CommandType.Text, commandTimeout: 60);
}
catch (Exception ex)
{
ex.ToString();
//log exceptions here
}
}
return(createdConsigneeId.Value);
}
public int CreateIndividualConsignee(IndividualConsigneeBindingModel individualConsigneeModel)
{
int? createdConsigneeId = null;
var individualConsignee = new IndividualConsignee();
individualConsignee.FirstName = individualConsigneeModel.FirstName;
individualConsignee.LastName = individualConsigneeModel.LastName;
individualConsignee.TRN = individualConsigneeModel.TRN;
individualConsignee.CustomerCode = individualConsigneeModel.CustomerCode;
individualConsignee.Address = individualConsigneeModel.Address;
using (var sqlConnection = new SqlConnection(_DBConnectionString))
{
try
{
sqlConnection.Open();
createdConsigneeId = sqlConnection.ExecuteScalar<int>(
@"INSERT INTO IndividualConsignee (FirstName,LastName,TRN,Address,CustomerCode)
OUTPUT Inserted.Id Values (@indivdualConsignee)", individualConsignee,
commandType: CommandType.Text, commandTimeout: 60);
}
catch (Exception ex)
{
ex.ToString();
//log exceptions here
}
}
return createdConsigneeId.Value;
}
