static List <ICommand> getCommands()
{
List <ICommand> ret = new List <ICommand>();
ret.Add(new Help());
ret.Add(new Vars());
Start start = new Start();
ret.Add(start);
ret.Add(new Close(start));
ret.Add(new AliasProvider());
ret.Add(new Echo());
ret.Add(new Config());
Exit exit = new Exit();
ret.Add(exit);
ret.Add(new Alias("stop", exit));
ret.Add(new Equals());
Packing packer = new Packing();
ret.Add(packer);
ret.Add(new Alias("pack", new String[] { "pack" }, packer));
ret.Add(new Alias("unpack", new String[] { "unpack" }, packer));
ret.Add(new Test());
GuiDesigner designer = new GuiDesigner();
ret.Add(designer);
ret.Add(new Alias("ui", designer));
return(ret);
}
private void MajooriPer_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
Packing.Focus();
}
}
public void K_Thousand_Packs_Test(int N)
{
float[] weights = new float[N];
for (int i = 0; i < N; i++)
{
weights[i] = random.Next(0, 1000);
}
// weights {w1, w2, w3, ... , wn}
// Reweight for each wi: wi / max(weights)
Packing.ReWeight(ref weights);
List <float> bfContainers = new List <float>();
int bfCount = Packing.BestFit(weights, ref bfContainers);
List <float> ffContainers = new List <float>();
int ffCount = Packing.FirstFit(weights, ref ffContainers);
List <float> nfContainers = new List <float>();
int nfCount = Packing.NextFit(weights, ref nfContainers);
List <float> ffoContainers = new List <float>();
Array.Sort(weights, new ReverseComparer());
int ffoCount = Packing.FirstFit(weights, ref ffoContainers);
Console.WriteLine($"-- {N} items bin packing --");
Console.WriteLine($"Next Fit = {nfCount}");
Console.WriteLine($"First Fit = {ffCount}");
Console.WriteLine($"Best Fit = {bfCount}");
Console.WriteLine($"Order First Fit = {ffoCount}");
}
public static string MainProgram(string[] args)
{
if (args.Length == 0)
{
return(GetHelpInfo());
}
switch (args[0])
{
case "/h":
return(GetHelpInfo());
case "/v":
return(GetVersionInfo());
default:
using (var enumerator = GetEnumrator(args))
{
haveCurrentValue = enumerator.MoveNext();
var target = GetTargetPath(enumerator);
var packName = GetPackFileName(enumerator);
var setting = GetPackagingSetting(enumerator);
var key = GetEncryptKey(enumerator);
var ignore = GetIgnoreFilePath(enumerator).ToList();
Packing.Run(target, packName, setting, ignore, key);
}
break;
}
return("パッキング終了");
}
private void Package()
{
var bPass = Password.TakeWhile(c => c != 0x00).Select(sb => (byte)sb).ToArray();
var pass = Encoding.UTF8.GetString(bPass, 0, bPass.Length);
Packing.Run(SrcPath, DstPath, Setting, new string[] { }, pass);
}
/// <inheritdoc />
public bool Equals([AllowNull] Tiling other)
{
if (other == null)
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
Packing == other.Packing ||
Packing != null &&
Packing.Equals(other.Packing)
) &&
(
SquarifyRatio == other.SquarifyRatio ||
SquarifyRatio != null &&
SquarifyRatio.Equals(other.SquarifyRatio)
) &&
(
Flip == other.Flip ||
Flip != null &&
Flip.Equals(other.Flip)
) &&
(
Pad == other.Pad ||
Pad != null &&
Pad.Equals(other.Pad)
));
}
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
int hashCode = 41;
if (Packing != null)
{
hashCode = hashCode * 59 + Packing.GetHashCode();
}
if (SquarifyRatio != null)
{
hashCode = hashCode * 59 + SquarifyRatio.GetHashCode();
}
if (Flip != null)
{
hashCode = hashCode * 59 + Flip.GetHashCode();
}
if (Pad != null)
{
hashCode = hashCode * 59 + Pad.GetHashCode();
}
return(hashCode);
}
}
public void TestGenerateSlip()
{
IPacking packing = new Packing();
packing.GenerateSlip();
Assert.IsTrue(true);
}
public void Knapsack()
{
var expected = new long[] { 3, 2 };
var actual = Packing.Knapsack(new long[] { 1, 2, 3 }, 5);
Assert.True(expected.SequenceEqual(actual));
}
/// <summary>
/// This member is the entry point for the send thread. As this connection may wait for a remote to connect,
/// send will accept and queue messages until ready.This thread will block until signalled that a connection is
/// made, or that there are new messages to transmit.
/// </summary>
private void SendThreadFunction()
{
byte[] buildBuffer = new byte[UDP_MAX_DATAGRAM_SIZE]; // working memory for building udp packets
int maxPayloadSize = buildBuffer.Length - HEADERSIZE;
try
{
do
{
sendsignal.WaitOne(); // waits until there is some data to send
while (messagestosend.Count > 0)
{
ReferenceCountedMessage m = (ReferenceCountedMessage)messagestosend.Dequeue();
if (m.length == 0)
{
m.Release();
continue; // don't send empty messages.
}
if (m.length > maxPayloadSize)
{
Debug.LogException(new Exception(string.Format("Message size {0} exceeds the maximum payload size of {1} bytes", m.length, maxPayloadSize)));
m.Release();
continue;
}
Packing.GetBytes(m.length, buildBuffer, 0);
Buffer.BlockCopy(m.bytes, m.start, buildBuffer, HEADERSIZE, m.length);
int datagramSize = HEADERSIZE + m.length;
int sent = socket.Send(buildBuffer, 0, datagramSize, SocketFlags.None);
if (sent != datagramSize)
{
Debug.LogException(new Exception("Socket.Send() sent the wrong number of bytes in UDP mode. This is unexpected."));
}
m.Release();
}
} while (true);
}
catch (ThreadInterruptedException)
{
Debug.Log(def.ToString() + " Send Shutdown.");
return;
}
catch (ObjectDisposedException)
{
Debug.Log(def.ToString() + " Send Shutdown.");
return;
}
catch (Exception e)
{
// promote any unhandled exceptions up to Unity via the Debug Log
Debug.LogError("Unhandled Exception in " + def.ToString());
Debug.LogException(e);
}
}
public ActionResult DeleteConfirmed(int id)
{
Packing packing = db.Packings.Find(id);
db.Packings.Remove(packing);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void Majdoori_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
this.CalculateOtherCharges();
Packing.Focus();
}
}
public ActionResult Add(Packing packing)
{
ResponseMsg response = new ResponseMsg();
PackingLogic.AddPacking(packing);
response.IsSuccess = true;
return(Json(response));
}
public void Cuboids_OneBin_CanPackWithLeftovers()
{
// Arrange
var bin = new List <Cuboid> {
Cuboid.ByLengths(400, 500, 300)
};
var items = new List <Cuboid>
{
Cuboid.ByLengths(100, 200, 100),
Cuboid.ByLengths(200, 200, 250),
Cuboid.ByLengths(100, 150, 300),
Cuboid.ByLengths(300, 200, 350),
Cuboid.ByLengths(150, 200, 500),
Cuboid.ByLengths(200, 100, 100),
Cuboid.ByLengths(100, 150, 200),
Cuboid.ByLengths(200, 150, 200),
Cuboid.ByLengths(250, 200, 300)
};
var expectedIndices = new List <List <int> > {
new List <int> {
3, 7, 6, 8, 1
}
};
var expectedPackedContainerVolumes = new List <List <int> > {
new List <int> {
3, 7, 6, 8, 1
}
};
var expectedPercentageContainerVolumePacked = 91.67;
var expectedPercentageItemVolumePacked = 70.06;
// Act
Dictionary <string, object> result = Packing.PackCuboids(items, bin);
// Assert
// Check if the result is a dictionary that contains the expected output port keys
CollectionAssert.AreEqual(result.Keys, expectedNodeOutputDictionaryKeys);
// extract results from dictionary
var actualPackeditems = (List <List <Cuboid> >)result[packedItemsOutputPort];
var actualRemainItems = (List <int>)result[remainingIndicesOutputPort];
var actualPackedIndices = (List <List <int> >)result[indicesOutputPort];
var actualPercentContVol = (result[percentContainerVolumePackedPort] as IEnumerable <double>).First();
var actualPercentItemVol = (result[percentItemVolumePackedPort] as IEnumerable <double>).First();
// Checks if the right amount of items has been packed
Assert.AreEqual(1, actualPackeditems.Count); // the number of bins this was packed into is 1
Assert.AreEqual(5, actualPackeditems.Sum(x => x.Count)); // total number of packed cuboids is 5
Assert.AreEqual(4, actualRemainItems.Count);
// Check the packing percentages are correct
Assert.AreEqual(expectedPercentageContainerVolumePacked, Math.Round(actualPercentContVol, 2));
Assert.AreEqual(expectedPercentageItemVolumePacked, Math.Round(actualPercentItemVol, 2));
// Checks that the right items has been packed
Assert.AreEqual(1, actualPackedIndices.Count); // the number of bins this was packed into is 1
CollectionAssert.AreEqual(actualPackedIndices, expectedIndices);
}
protected override void OnOpenNew()
{
Packing = new Packing
{
Date = DateTime.Now,
Mix = ContextManager.ActiveMixes.FirstOrDefault(),
Package = ContextManager.ActivePackages.FirstOrDefault()
};
}
public static void AddPacking(Packing packing)
{
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("@ID", packing.ID);
param.Add("@Name", packing.Name.Trim());
param.Add("@ConversionFactor", packing.ConversionFactorWithLtr.Trim());
DBHelper.ExecuteNonQuery("AddPacking", param, true);
}
public void Knapsack01ZeroItems()
{
var items = Array.Empty <BigInteger>();
var expected = new BigInteger(0);
var actual = Packing.Knapsack01(15, items, out _);
Assert.Equal(expected, actual);
}
public ActionResult Edit([Bind(Include = "Packing_Id,Packing_Type")] Packing packing)
{
if (ModelState.IsValid)
{
db.Entry(packing).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(packing));
}
public static bool Delete(Packing packing)
{
using (_d = new DataRepository <Packing>())
{
_d.Delete(packing);
_d.SaveChanges();
}
return(true);
}
public ActionResult Addpacking(Packing packing)
{
if (ModelState.IsValid)
{
cont.Packings.Add(packing);
cont.SaveChanges();
TempData["message"] = string.Format("Упаковка товара '{0}' сохранена", packing.Name);
}
return(RedirectToAction("Addpacking"));
}
public void Knapsack01OneItem()
{
var items = Enumerable.Range(1, 1)
.Select(i => new BigInteger(i))
.ToArray();
var expected = new BigInteger(1);
var actual = Packing.Knapsack01(15, items, out List <BigInteger> bag);
Assert.Equal(expected, actual);
}
public ActionResult Create([Bind(Include = "Packing_Id,Packing_Type")] Packing packing)
{
if (ModelState.IsValid)
{
db.Packings.Add(packing);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(packing));
}
public async Task <HttpResponseMessage> AddPacking([FromBody] Packing pack)
{
try
{
await packOp.AddPacking(pack);
return(Request.CreateResponse(HttpStatusCode.Created, pack));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// GET: Packings/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Packing packing = db.Packings.Find(id);
if (packing == null)
{
return(HttpNotFound());
}
return(View(packing));
}
public void Rectangles_MultiBin_CanPackAndHaveLeftovers()
{
// Arrange
var bins = new List <Rectangle> {
Rectangle.ByWidthLength(30, 30),
Rectangle.ByWidthLength(30, 30),
Rectangle.ByWidthLength(30, 30),
};
var items = new List <Rectangle>
{
Rectangle.ByWidthLength(20, 23),
Rectangle.ByWidthLength(12, 30),
Rectangle.ByWidthLength(33, 20),
Rectangle.ByWidthLength(32, 31),
Rectangle.ByWidthLength(12, 22),
Rectangle.ByWidthLength(15, 15)
};
var expectedIndices = new List <List <int> > {
new List <int> {
0
},
new List <int> {
1, 4
},
new List <int> {
5
}
};
// Act
Dictionary <string, object> result = Packing.PackRectangles(items, bins, RectanglePackingStrategy.BestShortSideFits);
// Assert
Assert.IsTrue(result.Keys.Contains(packedItemsOutputPort));
Assert.IsTrue(result.Keys.Contains(remainingIndicesOutputPort));
Assert.IsTrue(result.Keys.Contains(indicesOutputPort));
var packedRectangles = (List <List <Rectangle> >)result[packedItemsOutputPort];
Assert.AreEqual(3, packedRectangles.Count); // 3 bins were packed
Assert.AreEqual(4, packedRectangles.Sum(x => x.Count)); // the number of rectangles packed is 4
var remainItems = (List <int>)result[remainingIndicesOutputPort];
Assert.AreEqual(2, remainItems.Count); // 2 rectangles were not packed
var packedIndices = (List <List <int> >)result[indicesOutputPort];
CollectionAssert.AreEqual(packedIndices, expectedIndices); // the rectangles were packed in the order and grouping expected
}
public frmPacking(String CustomerID, String Teacher, String Student)
{
InitializeComponent();
oOrder = new Packing(Global.GetParameter("CurrentCompany"));
this.CompanyID = Global.GetParameter("CurrentCompany");
txtOrderID.Text = CustomerID;
txtOrderID.Enabled = false;
txtTeacher.Text = Teacher;
txtTeacher.Enabled = false;
txtStudent.Text = Student;
txtStudent.Enabled = false;
//if (!ShowOrder())
// MessageBox.Show("This Order doen't exist...");
this.txtProductID.Focus();
}
private void ProcessPacket(ref RawStreamBuffer cReceiveBuffer)
{
while (cReceiveBuffer.WriteIndex - cReceiveBuffer.ReadIndex >= ProtocolHeader.HeadLength)
{
StreamBuffer sb = Packing.GetPacketBufferWithHeader(ref cReceiveBuffer);
if (sb != null)
{
m_peerListener.OnPktReceive(sb);
}
else
{
break;
}
}
//cReceiveBuffer.ClearBuffer();
}
public OperationResponse Add(Packing entity)
{
var result = new OperationResponse();
try
{
var dbLocator = AmbientDbContextLocator.Get <FunzaDBContext>();
dbLocator.Add(entity);
}
catch (Exception ex)
{
result.AddException($"Error adding Funza Packing", ex);
}
return(result);
}
/// <summary>
/// 发送
/// </summary>
public void Send()
{
//
try
{
PacketBase pb;
if (this.m_cSendQueue.Dequeue(out pb))
{
if (this.m_cSocket == null)
{
throw new Exception("The socket is null.");
}
//MemoryStream ms = new MemoryStream();
//BinaryFormatter bf = new BinaryFormatter();
//byte[] buffer = null;
//bf.Serialize(ms, pb);
//buffer = ms.ToArray();
byte[] buffer = null;
StreamBuffer sb = new StreamBuffer();
pb.Write(sb);
buffer = sb.m_lstBuffer;
if (buffer == null)
{
throw new Exception("The the send buffer is null.");
}
buffer = Packing.PackingEncode(buffer, pb.GetSize());
SocketAsyncEventArgs e = new SocketAsyncEventArgs();
e.Completed += this.SendCompleteCallBack;
e.SetBuffer(buffer, 0, Packing.GetPacketHeadSize() + pb.GetSize());
bool done = this.m_cSocket.SendAsync(e);
if (!done)
{
SendProcess(e);
}
//this.m_cSocket.BeginSend(buffer, 0, Packing.GetPacketHeadSize() + pb.GetSize(),
// SocketFlags.DontRoute, new AsyncCallback(SendCallBack), this.m_cSocket);
}
}
catch (Exception ee)
{
WriteFiles.WritFile.Log(LogerType.ERROR, ee.ToString());
DisConnect();
}
}
private void btn_export_Click(object sender, EventArgs e)
{
if (!System.IO.Directory.Exists(targetPath))
{
System.Windows.Forms.MessageBox.Show("ディレクトリが設定されていません。");
return;
}
var dialog = new SaveFileDialog();
dialog.Filter = "パックファイル(*.pack)|*.pack";
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Packing.Run(targetPath, dialog.FileName, PackagingSetting.IgnoreHiddenAttribute, new string[] { }, txt_password.Text);
System.Windows.Forms.MessageBox.Show("パッケージを出力しました。");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region Packing
Packing _Packing = new Packing();
_Packing.Order_ID = int.Parse(ddlOrderNo.SelectedValue);
_Packing.Style_ID = int.Parse(ddlStyle.SelectedValue);
_Packing.Size_ID = int.Parse(ddlSize.SelectedValue);
_Packing.Date = Convert.ToDateTime(txtDate.Text);
#endregion
if (Validate_Date(_Packing))
{
if (ValidatePage())
{
InsertPacking();
ClearFields();
}
}
}
private void MapPacking(Widget child, Packing packing)
{
if (packing_map.ContainsKey (child)) {
packing_map[child] = packing;
} else {
packing_map.Add (child, packing);
}
}
protected void InsertPacking()
{
#region Packing
Packing _Packing = new Packing();
//_Packing.Employee_ID = int.Parse(ddlPacker.SelectedValue);
_Packing.Order_ID = int.Parse(ddlOrderNo.SelectedValue);
_Packing.Style_ID = int.Parse(ddlStyle.SelectedValue);
_Packing.Size_ID = int.Parse(ddlSize.SelectedValue);
_Packing.Pairs_Packed = int.Parse(txtPairs.Text);
_Packing.Date = Convert.ToDateTime(txtDate.Text);
_Packing.Description = txtDescription.Text;
_Packing.IsDeleted = false;
#endregion
lblMessage.Text += Packing_DA.InsertPacking(_Packing);
if (!lblMessage.Text.Contains(Constants.ALREADY_EXIST))
{
UpdateStitchingForPacking();
lblMessage.ForeColor = System.Drawing.Color.Green;
Response.Write("<script>alert('Inserted Successfully'); document.location='/forms/formPacking';</script>");
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void Fill_Style()
{
Packing _Packing = new Packing();
if (ddlOrderNo.SelectedValue != "")
{
_Packing.Order_ID = int.Parse(ddlOrderNo.SelectedValue);
}
if (ddlStyle.SelectedValue != "")
{
_Packing.Style_ID = int.Parse(ddlStyle.SelectedValue);
}
if (ddlSize.SelectedValue != "")
{
_Packing.Size_ID = int.Parse(ddlSize.SelectedValue);
}
DataTable dt = Rejection_DA.Get_Style_From_Stitching_For_Rejection(_Packing);
if (ddlStyle.SelectedValue == "")
{
if (dt.Rows.Count == 0)
ddlStyle.Items.Clear();
else
{
ddlStyle.DataSource = dt;
ddlStyle.DataTextField = "Name";
ddlStyle.DataValueField = "Id";
ddlStyle.DataBind();
}
ddlStyle.Items.Insert(0, new ListItem(Constants.SELECT_HERE, ""));
ddlStyle.SelectedIndex = 0;
}
}
public static string UpdatePacking(Packing _Packing)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_UpdatePacking";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Id";
param.Value = _Packing.Id;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Order_ID";
param.Value = _Packing.Order_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Style_ID";
param.Value = _Packing.Style_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Size_ID";
param.Value = _Packing.Size_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Pairs_Packed";
param.Value = _Packing.Pairs_Packed;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Date";
param.Value = _Packing.Date;
param.DbType = DbType.Date;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Description";
param.Value = _Packing.Description;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
if (command.Parameters["@Return"].Value.ToString() == Constants.SP_ALREADY_EXIST)
{
return Constants.ALREADY_EXIST;
}
else
{
return Constants.SUCESS_UPDATE;
}
}
public List<Styles> GetStyle(int Order_ID, int Style_ID, int Size_ID)
{
List<Styles> _Styles = new List<Styles>();
Packing _Packing = new Packing();
if (Order_ID != 0)
_Packing.Order_ID = Order_ID;
if (Style_ID != 0)
_Packing.Style_ID = Style_ID;
if (Size_ID != 0)
_Packing.Size_ID = Size_ID;
DataTable dt = Rejection_DA.Get_Style_From_Stitching_For_Rejection(_Packing);
foreach (DataRow row in dt.Rows)
{
_Styles.Add(new Styles
{
Id = int.Parse(row["Id"].ToString()),
Name = row["Name"].ToString(),
});
}
return _Styles;
}
private bool IsOSSsame(Packing _Packing, int OldOrder_ID, int OldStyle_ID, int OldSize_ID, int OldPairs)
{
if (_Packing.Order_ID == OldOrder_ID && _Packing.Style_ID == OldStyle_ID && _Packing.Size_ID == OldSize_ID)
return true;
else
return false;
}
public string Update(int Id, string Description, int Order_ID, int Style_ID, int Size_ID, int Pairs_Packed, string DateString)
{
Packing _Packing = new Packing();
_Packing.Id = Id;
_Packing.Description = Description;
_Packing.Order_ID = Order_ID;
_Packing.Style_ID = Style_ID;
_Packing.Size_ID = Size_ID;
_Packing.Pairs_Packed = Pairs_Packed;
_Packing.Date = Convert.ToDateTime(DateString);
string msg = Validate_Date(_Packing);
if (msg == "")
{
DataTable dt = Packing_DA.Get_Packing_By_ID(Id);
int OldOrder_ID = int.Parse(dt.Rows[0]["Order_ID"].ToString());
int OldStyle_ID = int.Parse(dt.Rows[0]["Style_ID"].ToString());
int OldSize_ID = int.Parse(dt.Rows[0]["Size_ID"].ToString());
int OldPairs = int.Parse(dt.Rows[0]["Pairs_Packed"].ToString());
msg = Validate(_Packing, OldOrder_ID, OldStyle_ID, OldSize_ID, OldPairs);
if (msg == "")
{
//DataTable dt = Packing_DA.Get_Packing_By_ID(_Packing.Id);
msg = Packing_DA.UpdatePacking(_Packing);
if (msg == "Updated Sucessfully" && Session["User"].ToString().ToUpper() != ("Mustafa Piracha").ToUpper())
{
SendNotification(_Packing, dt);
}
//if (!msg.Contains(Constants.SP_ALREADY_EXIST))
//{
// OldPairsCuttingEntry(OldOrder_ID, OldStyle_ID, OldSize_ID, OldPairs);
// UpdateCuttingForPacking(_Packing);
//}
}
}
return msg;
}
public List<Size> GetSize(int Order_ID, int Style_ID, int Size_ID)
{
List<Size> _Size = new List<Size>();
Packing _Packing = new Packing();
if (Order_ID != 0)
_Packing.Order_ID = Order_ID;
if (Style_ID != 0)
_Packing.Style_ID = Style_ID;
if (Size_ID != 0)
_Packing.Size_ID = Size_ID;
DataTable dt = Packing_DA.Get_Size_From_Stitching_For_Packing(_Packing);
foreach (DataRow row in dt.Rows)
{
_Size.Add(new Size
{
Id = int.Parse(row["Id"].ToString()),
No = int.Parse(row["No"].ToString())
});
}
return _Size;
}
protected bool ValidatePage()
{
bool flag = true;
lblMessage.Text = "";
#region Packing
Packing _Packing = new Packing();
//_Packing.Employee_ID = int.Parse(ddlPacker.SelectedValue);
_Packing.Order_ID = int.Parse(ddlOrderNo.SelectedValue);
_Packing.Style_ID = int.Parse(ddlStyle.SelectedValue);
_Packing.Size_ID = int.Parse(ddlSize.SelectedValue);
_Packing.Pairs_Packed = int.Parse(txtPairs.Text);
#endregion
validatingPairs(ref flag, ref _Packing);
if (flag == false)
lblMessage.ForeColor = System.Drawing.Color.Red;
else
lblMessage.ForeColor = System.Drawing.Color.Green;
return flag;
}
protected void validatingPairs(ref bool flag, ref Packing _Packing)
{
DataTable dt = Packing_DA.Get_Pairs_SUM_From_Stitching(_Packing);
if (dt.Rows.Count > 0)
{
if (_Packing.Pairs_Packed > int.Parse(dt.Rows[0][0].ToString()))
{
lblMessage.Text += "USing More Pairs then Have </br>";
flag = false;
}
}
}
private bool Validate_Date(Packing _Packing)
{
lblMessage.Text = "";
lblMessage.ForeColor = System.Drawing.Color.Red;
bool flag = false;
flag = Packing_DA.IsStitchingBeforePacking(_Packing);
if (!flag)
{
lblMessage.Text = "Your Packing Date is earlier than Stitching";
}
return flag;
}
public static DataTable Get_Style_From_Stitching_For_Packing(Packing _Packing)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_Get_Style_From_Stitching_For_Packing";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@OrderId";
param.Value = _Packing.Order_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@SizeId";
param.Value = _Packing.Size_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
return Catalog_Access.ExecuteSelectCommand(command);
}
private void Pack(Widget child, Packing packing, bool end)
{
MapPacking (child, packing);
Add (child);
}
private void SendNotification(Packing _Packing, DataTable dt)
{
string MessageBody = "Edited By : <b>" + Session["User"].ToString().ToUpper() + "</b><br><br>" + DateTime.UtcNow.AddHours(5) + "<br><h3>Before Edit</h3>";
string tableStart = "<table style=\" width:100%;border-collapse: collapse;\">";//border: 1px solid #ddd;
string tableEnd = "</table>";
string MessageHeader = "<tr>";
string MessageDataOld = "<tr>";
string MessageDataNew = "<tr>";
#region Old Header New
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + Convert.ToDateTime(dt.Rows[0]["Date"].ToString()).ToString("MM/dd/yyyy") + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Date" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _Packing.Date.ToString("MM/dd/yyyy") + "</td>";
if (dt.Rows[0]["Order_ID"].ToString() == "")
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Order_DA.Get_Order_By_Id(int.Parse(dt.Rows[0]["Order_ID"].ToString()))).Rows[0]["Order_No"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Order" + "</th>";
if (_Packing.Order_ID == null)
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Order_DA.Get_Order_By_Id(int.Parse(_Packing.Order_ID.ToString()))).Rows[0]["Order_No"] + "</td>";
if (dt.Rows[0]["Style_ID"].ToString() == "")
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Style_DA.Get_Style_By_Id(int.Parse(dt.Rows[0]["Style_ID"].ToString()))).Rows[0]["Name"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Style" + "</th>";
if (_Packing.Style_ID == null)
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Style_DA.Get_Style_By_Id(int.Parse(_Packing.Style_ID.ToString()))).Rows[0]["Name"] + "</td>";
if (dt.Rows[0]["Size_ID"].ToString() == "")
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Style_DA.Get_Size_By_Id(int.Parse(dt.Rows[0]["Size_ID"].ToString()))).Rows[0]["No"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Size" + "</th>";
if (_Packing.Size_ID == null)
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Style_DA.Get_Size_By_Id(int.Parse(_Packing.Size_ID.ToString()))).Rows[0]["No"] + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Pairs_Packed"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Pairs Packed" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _Packing.Pairs_Packed + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Description"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Description" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _Packing.Description + "</td>";
#endregion
MessageDataOld += "</tr>";
MessageHeader += "</tr>";
MessageDataNew += "</tr>";
MessageBody += tableStart + MessageDataOld + MessageHeader + MessageDataNew + tableEnd + "<h3>After Edit</h3>";
sendMail.sendEmailMessage(ConfigurationManager.AppSettings["From"], ConfigurationManager.AppSettings["To"], ConfigurationManager.AppSettings["Password"], "Packing Edit", MessageBody);
}
private string Validate(Packing _Packing, int OldOrder_ID, int OldStyle_ID, int OldSize_ID, int OldPairs)
{
DataTable dt = Packing_DA.Get_Pairs_SUM_From_Stitching(_Packing);
int result;
if (!int.TryParse(dt.Rows[0][0].ToString(), out result))
{
return "No Pairs to Pack<br>";
}
else
{
if (IsOSSsame(_Packing, OldOrder_ID, OldStyle_ID, OldSize_ID, OldPairs))
{
if (OldPairs + int.Parse(dt.Rows[0][0].ToString()) >= _Packing.Pairs_Packed)
return "";
else
return "Packing More Pairs Then Stitched<br>";
}
else
{
if (int.Parse(dt.Rows[0][0].ToString()) >= _Packing.Pairs_Packed)
return "";
else
return "Packing More Pairs Then Stitched<br>";
}
}
}
protected void Fill_PairsBox()
{
if (ddlOrderNo.SelectedValue != "" && ddlSize.SelectedValue != "" && ddlStyle.SelectedValue != "")
{
Packing _Packing = new Packing();
_Packing.Order_ID = int.Parse(ddlOrderNo.SelectedValue);
_Packing.Style_ID = int.Parse(ddlStyle.SelectedValue);
_Packing.Size_ID = int.Parse(ddlSize.SelectedValue);
DataTable dt = Packing_DA.Get_Pairs_SUM_From_Stitching(_Packing);
if (dt.Rows.Count > 0)
{
txtPairs.Text = dt.Rows[0][0].ToString();
}
else
{
txtPairs.Text = "";
}
}
}
private string Validate_Date(Packing _Packing)
{
string msg = "";
bool flag = false;
flag = Packing_DA.IsStitchingBeforePacking(_Packing);
if (!flag)
{
msg = "-1";
}
return msg;
}
public List<Order> GetOrder(int Order_ID, int Style_ID, int Size_ID)
{
List<Order> _Order = new List<Order>();
Packing _Packing = new Packing();
if (Order_ID != 0)
_Packing.Order_ID = Order_ID;
if (Style_ID != 0)
_Packing.Style_ID = Style_ID;
if (Size_ID != 0)
_Packing.Size_ID = Size_ID;
DataTable dt = Rejection_DA.Get_Order_From_Stitching_For_Rejection(_Packing);
foreach (DataRow row in dt.Rows)
{
_Order.Add(new Order
{
Id = int.Parse(row["Id"].ToString()),
Order_No = row["Order_No"].ToString()
});
}
return _Order;
}
protected void UpdateStitchingForPacking()
{
Packing _Packing = new Packing();
_Packing.Order_ID = int.Parse(ddlOrderNo.SelectedValue);
_Packing.Style_ID = int.Parse(ddlStyle.SelectedValue);
_Packing.Size_ID = int.Parse(ddlSize.SelectedValue);
int BalancePairs = int.Parse(txtPairs.Text);
DataTable dt = Packing_DA.Get_Pairs_ANd_ID_From_Stitching(_Packing);
for (int i = 0; i < dt.Rows.Count; i++)
{
int pairs = int.Parse(dt.Rows[i][1].ToString());
if (pairs >= BalancePairs)
{
Packing_DA.Update_Stitching_By_ID_For_Packing_Pairs(BalancePairs, dt.Rows[i][0].ToString());
BalancePairs = 0;
break;
}
else
{
Packing_DA.Update_Stitching_By_ID_For_Packing_Pairs(pairs, dt.Rows[i][0].ToString());
BalancePairs -= pairs;
}
}
}
public Packing Get(int Id)
{
Packing _Packing = new Packing();
DataTable dt = Packing_DA.Get_Packing_By_ID(Id);
foreach (DataRow row in dt.Rows)
{
_Packing.Order_ID = int.Parse(row["Order_ID"].ToString());
_Packing.Style_ID = int.Parse(row["Style_ID"].ToString());
_Packing.Size_ID = int.Parse(row["Size_ID"].ToString());
_Packing.Pairs_Packed = int.Parse(row["Pairs_Packed"].ToString());
_Packing.DateString = Convert.ToDateTime(row["Date"].ToString()).ToString("MM/dd/yyyy");
_Packing.Description = row["Description"].ToString();
}
return _Packing;
}
public static bool IsStitchingBeforePacking(Packing _Packing)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_IsStitchingBeforePacking";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@OrderId";
param.Value = _Packing.Order_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@StyleId";
param.Value = _Packing.Style_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@SizeId";
param.Value = _Packing.Size_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Date";
param.Value = _Packing.Date;
param.DbType = DbType.Date;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
if (command.Parameters["@Return"].Value.ToString() == "1")
{
return true;
}
else
{
return false;
}
}
public static string InsertPacking(Packing _Packing)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_InsertPacking";
DbParameter param;
//param = command.CreateParameter();
//param.ParameterName = "@Employee_ID";
//param.Value = _Packing.Employee_ID;
//param.DbType = DbType.Int32;
//command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Order_ID";
param.Value = _Packing.Order_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Style_ID";
param.Value = _Packing.Style_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Size_ID";
param.Value = _Packing.Size_ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Pairs_Packed";
param.Value = _Packing.Pairs_Packed;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Date";
param.Value = _Packing.Date;
param.DbType = DbType.Date;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Description";
param.Value = _Packing.Description;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@IsDeleted";
param.Value = _Packing.IsDeleted;
param.DbType = DbType.Boolean;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
if (Return == Constants.SP_ALREADY_EXIST)
{
return Constants.ALREADY_EXIST;
}
else
{
return Constants.SUCESS_INSERT;
}
}
public string GetPairs(int Order_ID, int Style_ID, int Size_ID)
{
Packing _Packing = new Packing();
_Packing.Order_ID = Order_ID;
_Packing.Style_ID = Style_ID;
_Packing.Size_ID = Size_ID;
DataTable dt = Packing_DA.Get_Pairs_SUM_From_Stitching(_Packing);
return dt.Rows[0][0].ToString();
}