public async Task <ActionResult <long> > Put(long id, [FromBody] MasterPackingSlip packingSlip)
{
try
{
if (id != packingSlip.Id)
{
return(BadRequest());
}
var result = await this.packingSlipService.GetMasterPackingSlipAsync(id);
if (result == null)
{
return(NotFound());
}
if (result.IsPOSUploaded)
{
return(BadRequest("POS is already uploaded. You can not update this Packing slip"));
}
await this.packingSlipService.UpdateMasterPackingSlipAsync(packingSlip);
return(id);
}
catch (Exception ex)
{
return(StatusCode(500, ex.ToString()));
}
}
public async Task <int> AddMasterPackingSlipAsync(MasterPackingSlip packingSlip)
{
var entity = await this.entityTrackerRepository.GetEntityAsync(packingSlip.CompanyId, DateTime.Now, BusinessConstants.ENTITY_TRACKER_MASTER_PACKING_SLIP);
packingSlip.MasterPackingSlipNo = entity.EntityNo;
var result = await this.masterPackingSlipRepository.AddMasterPackingSlipAsync(packingSlip);
return(result);
}
public async Task <ActionResult <Int32> > Post([FromBody] MasterPackingSlip packingSlip)
{
try
{
var result = await this.packingSlipService.AddMasterPackingSlipAsync(packingSlip);
return(result);
}
catch (Exception ex)
{
return(StatusCode(500, ex.ToString()));
}
}
public async Task <int> AddMasterPackingSlipAsync(MasterPackingSlip masterPackingSlip)
{
Int32 masterPackingSlipId = 0;
using (SqlConnection connection = new SqlConnection(ConnectionSettings.ConnectionString))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
SqlTransaction transaction;
// Start a local transaction.
transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted, "SampleTransaction");
// Must assign both transaction object and connection
// to Command object for a pending local transaction
command.Connection = connection;
command.Transaction = transaction;
try
{
string sql = string.Format($"INSERT INTO [dbo].[MasterPackingSlipMaster] ([CompanyId] ,[CustomerId] ,[MasterPackingSlipNo] ,[UpdatedDate] ,[Comment] ,[IsPOSUploaded] ,[POSPath] ,[TrakingNumber]) VALUES ('{masterPackingSlip.CompanyId}' ,'{masterPackingSlip.CustomerId}' ,'{masterPackingSlip.MasterPackingSlipNo}' ,'{DateTime.Now}' ,'{masterPackingSlip.Comment}' ,'{false}' ,'{""}' ,'{""}')");
sql = sql + " Select Scope_Identity()";
command.CommandText = sql;
masterPackingSlipId = Convert.ToInt32(command.ExecuteScalar());
masterPackingSlip.Id = Convert.ToInt32(masterPackingSlipId);
foreach (PackingSlip packingSlip in masterPackingSlip.PackingSlips)
{
sql = string.Format($"UPDATE [dbo].[PackingSlipMaster] SET [IsPOSUploaded] = '{true}', [IsMasterPackingSlip] = '{true}',[MasterPackingSlipId] = '{masterPackingSlipId}' WHERE id = '{packingSlip.Id}' ");
command.CommandText = sql;
await command.ExecuteNonQueryAsync();
}
await entityTrackerRepository.AddEntityAsync(masterPackingSlip.CompanyId, DateTime.Now, BusinessConstants.ENTITY_TRACKER_MASTER_PACKING_SLIP, command.Connection, command.Transaction, command);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
connection.Close();
}
}
return(masterPackingSlipId);
}
public async Task <bool> UpdateMasterPackingSlipAsync(MasterPackingSlip masterPackingSlip)
{
using (SqlConnection connection = new SqlConnection(ConnectionSettings.ConnectionString))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
SqlTransaction transaction;
// Start a local transaction.
transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted, "SampleTransaction");
//1. Get SupplierInvoicePoDetails po transaction detail
List <SupplierInvoicePoDetails> supplierInvoicePoDetailsList = new List <SupplierInvoicePoDetails>();
SqlConnection conn = new SqlConnection(ConnectionSettings.ConnectionString);
// Must assign both transaction object and connection
// to Command object for a pending local transaction
command.Connection = connection;
command.Transaction = transaction;
string sql = string.Empty;
try
{
sql = string.Format($"UPDATE [dbo].[MasterPackingSlipMaster] SET [UpdatedDate] = '{DateTime.Now}',[Comment] = '{masterPackingSlip.Comment}' WHERE Id = '{masterPackingSlip.Id}' ");
command.CommandText = sql;
await command.ExecuteNonQueryAsync();
sql = string.Format($"UPDATE [dbo].[PackingSlipMaster] SET [IsPOSUploaded] ='{false}', [IsMasterPackingSlip] = '{false}',[MasterPackingSlipId] = '{0}' WHERE MasterPackingSlipId = '{masterPackingSlip.Id}' ");
command.CommandText = sql;
await command.ExecuteNonQueryAsync();
foreach (PackingSlip packingSlip in masterPackingSlip.PackingSlips)
{
sql = string.Format($"UPDATE [dbo].[PackingSlipMaster] SET [IsPOSUploaded] ='{true}', [IsMasterPackingSlip] = '{true}',[MasterPackingSlipId] = '{masterPackingSlip.Id}' WHERE id = '{packingSlip.Id}' ");
command.CommandText = sql;
await command.ExecuteNonQueryAsync();
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
return(true);
}
public async Task <MasterPackingSlip> GetMasterPackingSlipAsync(long Id)
{
var masterPackingSlip = new MasterPackingSlip();
masterPackingSlip.PackingSlips = new List <PackingSlip>();
SqlConnection conn = new SqlConnection(ConnectionSettings.ConnectionString);
var commandText = string.Format($"SELECT [Id] ,[CompanyId] ,[CustomerId] ,[MasterPackingSlipNo] " +
$",[UpdatedDate] ,[Comment] ,[IsPOSUploaded] ,[POSPath] ,[TrakingNumber] FROM [dbo].[MasterPackingSlipMaster] where Id = '{Id}' ");
using (SqlCommand cmd = new SqlCommand(commandText, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
var dataReader = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection);
while (dataReader.Read())
{
masterPackingSlip.Id = Convert.ToInt32(dataReader["Id"]);
masterPackingSlip.CompanyId = Convert.ToInt32(dataReader["CompanyId"]);
masterPackingSlip.CustomerId = Convert.ToInt32(dataReader["CustomerId"]);
masterPackingSlip.MasterPackingSlipNo = Convert.ToString(dataReader["MasterPackingSlipNo"]);
masterPackingSlip.UpdatedDate = Convert.ToDateTime(dataReader["UpdatedDate"]);
masterPackingSlip.Comment = Convert.ToString(dataReader["Comment"]);
masterPackingSlip.IsPOSUploaded = Convert.ToBoolean(dataReader["IsPOSUploaded"]);
masterPackingSlip.POSPath = Convert.ToString(dataReader["POSPath"]);
masterPackingSlip.TrakingNumber = Convert.ToString(dataReader["TrakingNumber"]);
}
dataReader.Close();
conn.Close();
}
commandText = string.Format($"SELECT [Id] ,[CompanyId] ,[CustomerId] ,[PackingSlipNo] ,[ShippingDate] ,[ShipVia] ,[Crates] ," +
$"[Boxes] ,[GrossWeight] ,[ShippingCharge] ,[CustomCharge] ,[SubTotal] ,[Total] ,[IsInvoiceCreated] ,[IsPaymentReceived] ,[FOB] ,[Terms] ," +
$"[ShipmentInfoId] ,[InvoiceDate],[IsPOSUploaded],[POSPath],[TotalSurcharge],[IsMasterPackingSlip],[MasterPackingSlipId],[AllowScanning] FROM [dbo].[PackingSlipMaster] where [MasterPackingSlipId] = '{masterPackingSlip.Id}' ");
using (SqlCommand cmd = new SqlCommand(commandText, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
var dataReader = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection);
while (dataReader.Read())
{
var packingSlip = new PackingSlip();
packingSlip.Id = Convert.ToInt32(dataReader["Id"]);
packingSlip.CompanyId = Convert.ToInt32(dataReader["CompanyId"]);
packingSlip.CustomerId = Convert.ToInt32(dataReader["CustomerId"]);
packingSlip.PackingSlipNo = Convert.ToString(dataReader["PackingSlipNo"]);
packingSlip.ShippingDate = Convert.ToDateTime(dataReader["ShippingDate"]);
packingSlip.ShipVia = Convert.ToString(dataReader["ShipVia"]);
packingSlip.Crates = Convert.ToInt32(dataReader["Crates"]);
packingSlip.Boxes = Convert.ToInt32(dataReader["Boxes"]);
packingSlip.GrossWeight = Convert.ToDecimal(dataReader["GrossWeight"]);
packingSlip.ShippingCharge = Convert.ToDecimal(dataReader["ShippingCharge"]);
packingSlip.CustomCharge = Convert.ToDecimal(dataReader["CustomCharge"]);
packingSlip.SubTotal = Convert.ToDecimal(dataReader["SubTotal"]);
packingSlip.Total = Convert.ToDecimal(dataReader["Total"]);
packingSlip.IsInvoiceCreated = Convert.ToBoolean(dataReader["IsInvoiceCreated"]);
packingSlip.IsPaymentReceived = Convert.ToBoolean(dataReader["IsPaymentReceived"]);
packingSlip.FOB = Convert.ToString(dataReader["FOB"]);
packingSlip.Terms = Convert.ToString(dataReader["Terms"]);
packingSlip.ShipmentInfoId = Convert.ToInt32(dataReader["ShipmentInfoId"]);
packingSlip.InvoiceDate = Convert.ToDateTime(dataReader["InvoiceDate"]);
packingSlip.IsPOSUploaded = Convert.ToBoolean(dataReader["IsPOSUploaded"]);
packingSlip.POSPath = Convert.ToString(dataReader["POSPath"]);
packingSlip.TotalSurcharge = Convert.ToDecimal(dataReader["TotalSurcharge"]);
packingSlip.IsMasterPackingSlip = Convert.ToBoolean(dataReader["IsMasterPackingSlip"]);
packingSlip.MasterPackingSlipId = Convert.ToInt32(dataReader["MasterPackingSlipId"]);
packingSlip.AllowScanning = Convert.ToBoolean(dataReader["AllowScanning"]);
masterPackingSlip.PackingSlips.Add(packingSlip);
}
dataReader.Close();
conn.Close();
}
masterPackingSlip.PackingSlipBoxDetails = new List <PackingSlipBoxDetails>();
var packingSlipBoxDetails = new List <PackingSlipBoxDetails>();
foreach (PackingSlip packingSlip in masterPackingSlip.PackingSlips)
{
commandText = string.Format($"SELECT [Id] ,[PackingSlipId] ,[PackingSlipDetailId] ,[PartId] ,[Qty],[BoxeNo] ,[Barcode] ,[IsScanned] FROM [dbo].[PackingSlipBoxDetails] where PackingSlipId = '{packingSlip.Id}' ");
using (SqlCommand cmd1 = new SqlCommand(commandText, conn))
{
cmd1.CommandType = CommandType.Text;
conn.Open();
var dataReader1 = cmd1.ExecuteReader(CommandBehavior.CloseConnection);
while (dataReader1.Read())
{
var packingSlipBoxDetail = new PackingSlipBoxDetails();
packingSlipBoxDetail.Id = Convert.ToInt32(dataReader1["Id"]);
packingSlipBoxDetail.PackingSlipId = Convert.ToInt32(dataReader1["PackingSlipId"]);
packingSlipBoxDetail.PackingSlipDetailId = Convert.ToInt32(dataReader1["PackingSlipDetailId"]);
packingSlipBoxDetail.PartId = Convert.ToInt32(dataReader1["PartId"]);
packingSlipBoxDetail.Qty = Convert.ToInt32(dataReader1["Qty"]);
packingSlipBoxDetail.BoxeNo = Convert.ToInt32(dataReader1["BoxeNo"]);
packingSlipBoxDetail.Barcode = Convert.ToString(dataReader1["Barcode"]);
packingSlipBoxDetail.IsScanned = Convert.ToBoolean(dataReader1["IsScanned"]);
packingSlipBoxDetails.Add(packingSlipBoxDetail);
}
dataReader1.Close();
}
masterPackingSlip.PackingSlipBoxDetails = packingSlipBoxDetails;
conn.Close();
}
foreach (PackingSlipBoxDetails packingSlipBox in masterPackingSlip.PackingSlipBoxDetails)
{
var part = await partRepository.GetPartAsync(packingSlipBox.PartId);
packingSlipBox.PartCode = part.Code;
}
return(masterPackingSlip);
}
public async Task <bool> UpdateMasterPackingSlipAsync(MasterPackingSlip packingSlip)
{
var result = await this.masterPackingSlipRepository.UpdateMasterPackingSlipAsync(packingSlip);
return(result);
}