public TransRecordViewModel Update(TransRecordViewModel transRecord, Enums.TransactionStatus transactionStatus)
{
transRecord.WeightStatus = ToleranceCheck.CheckWtPerPackageActual(transRecord.TolActualWt,
transRecord.WtPerPackageActual, transRecord.EmptyPackageWt, transRecord.WtPerPackage);
var parameters = InitParameters(transRecord);
StringBuilder tranQuery = new StringBuilder();
tranQuery.AppendLine("update TransactionRecords set");
tranQuery.AppendLine($"{nameof(transRecord.ForkliftNum)}={nameof(transRecord.ForkliftNum).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.PalletNum)}={nameof(transRecord.PalletNum).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.PackagingTypeId)}={nameof(transRecord.PackagingTypeId).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.WtPerPackage)}={nameof(transRecord.WtPerPackage).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.EmptyPackageWt)}={nameof(transRecord.EmptyPackageWt).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.WtPerPackageActual)}={nameof(transRecord.WtPerPackageActual).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.Quantity)}={nameof(transRecord.Quantity).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.RawMaterialId)}={nameof(transRecord.RawMaterialId).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.BinLocationId)}={nameof(transRecord.BinLocationId).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.BinNum)}={nameof(transRecord.BinNum).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.LocationId)}={nameof(transRecord.LocationId).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.WarehouseId)}={nameof(transRecord.WarehouseId).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.ActualNetWt)}={nameof(transRecord.ActualNetWt).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.ModifiedById)}={nameof(transRecord.ModifiedById).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.ModifiedDate)}={nameof(transRecord.ModifiedDate).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.WeightStatus)}={nameof(transRecord.WeightStatus).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.TransferLimitId)}={nameof(transRecord.TransferLimitId).Parameterize()}" + (char)44);
tranQuery.AppendLine($"{nameof(transRecord.Remarks)}={nameof(transRecord.Remarks).Parameterize()}");
tranQuery.AppendLine($" WHERE {nameof(transRecord.TransactionId)}={nameof(transRecord.TransactionId).Parameterize()}");
if (transactionStatus == Enums.TransactionStatus.PENDING)
{
tranQuery.AppendLine($" AND {nameof(transRecord.DTOutbound)} IS NULL");
}
else if (transactionStatus == Enums.TransactionStatus.COMPLETED)
{
tranQuery.AppendLine($" AND {nameof(transRecord.DTOutbound)} IS NOT NULL");
}
using IDbConnection objConnection = new SqlConnection(ServerUtils.ConnectionString());
objConnection.Open();
using var transaction = objConnection.BeginTransaction();
try
{
SqlMapper.Execute(objConnection, tranQuery.ToString(), parameters.ToDynamicParams(), commandType: CommandType.Text, transaction: transaction);
transaction.Commit();
return(transRecord);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex);
transaction.Rollback();
throw new Exception(ex.Message);
}
}
public void Delete(string[] ids, Enums.TransactionStatus tStatus)
{
string strIds = string.Format("'{0}'", string.Join("','", ids));
StringBuilder qry = new StringBuilder();
qry.AppendLine($"Delete from TransactionRecords where {nameof(TransRecord.TransactionId)} in ({strIds})");
if (tStatus == Enums.TransactionStatus.PENDING)
{
qry.AppendLine(string.Format("and DTOutbound is null"));
}
else if (tStatus == Enums.TransactionStatus.COMPLETED)
{
qry.AppendLine(string.Format("and DTOutbound is not null"));
}
DBContext.ExecuteQuery(qry.ToString());
}
public TransRecordViewModel Get(Int64 id, Enums.TransactionStatus transactionStatus)
{
var filter = new TransRecordFilter
{
TransactionId = id,
TableName = "TransactionRecordViews",
TransactionStatus = transactionStatus.ToString()
};
var result = DBContext.GetRecord <TransRecordViewModel>(filter.ToString());
if (result != null)
{
result.TransactionStatus = transactionStatus.ToString();
}
return(result);
}
