/// <summary>
/// update hvoyagetable
/// </summary>
/// <param name="hblid">int</param>
protected void update_dimensions()
{
//voyageid
int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));
if (_pid > 0)
{
try
{
//get instance of record
DeliverySubSubTable _tbl = new DeliverySubSubTable(_pid);
ASPxTextBox _txt = null;
//depth
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtDepthEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookDepth = wwi_func.vdecimal(_txt.Text.ToString());
}
//length
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtLengthEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookLength = wwi_func.vdecimal(_txt.Text.ToString());
}
//weight
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtWeightEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookWeight = wwi_func.vdecimal(_txt.Text.ToString());
}
//width
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtWidthEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookWidth = wwi_func.vdecimal(_txt.Text.ToString());
}
//update
_tbl.Save();
//get values off edit form
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
}
else
{
string _ex = "Can't update record ID = 0";
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
}
protected void bind_formview(string mode)
{
//have to use a collection as formview needs to bind to enumerable
DeliverySubSubTableCollection _tbl = new DeliverySubSubTableCollection();
if (mode != "Insert")
{
int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));
DeliverySubSubTable _ct = new DeliverySubSubTable(_pid);
_tbl.Add(_ct);
this.fmvDimensions.DataSource = _tbl;
this.fmvDimensions.DataBind();
}
else //there's no insert option on this form it's jsut fer editting book/cartrton dimension
{
this.dxlblErr.Text = "This option is not available";
this.dxpnlErr.ClientVisible = true;
}
}
public void Insert(int? DeliveryID,int? TitleID,string Title,int? Copies,int? CurrentStatusID,string Remarks,int? CopiesPerCarton,float? TotalConsignmentWeight,float? TotalConsignmentCube,decimal? CartonLength,decimal? CartonDepth,decimal? CartonHeight,int? TotalCartons,float? CartonWeight,float? LastCarton,int? Jackets,int? FullPallets,int? CartonsPerFullPallet,int? PartPallets,int? CartonsPerPartPallet,decimal? ActualPPC,byte[] Ts,decimal? EstimatedPPC,decimal? BookLength,decimal? BookWidth,decimal? BookDepth,decimal? BookWeight)
{
DeliverySubSubTable item = new DeliverySubSubTable();
item.DeliveryID = DeliveryID;
item.TitleID = TitleID;
item.Title = Title;
item.Copies = Copies;
item.CurrentStatusID = CurrentStatusID;
item.Remarks = Remarks;
item.CopiesPerCarton = CopiesPerCarton;
item.TotalConsignmentWeight = TotalConsignmentWeight;
item.TotalConsignmentCube = TotalConsignmentCube;
item.CartonLength = CartonLength;
item.CartonDepth = CartonDepth;
item.CartonHeight = CartonHeight;
item.TotalCartons = TotalCartons;
item.CartonWeight = CartonWeight;
item.LastCarton = LastCarton;
item.Jackets = Jackets;
item.FullPallets = FullPallets;
item.CartonsPerFullPallet = CartonsPerFullPallet;
item.PartPallets = PartPallets;
item.CartonsPerPartPallet = CartonsPerPartPallet;
item.ActualPPC = ActualPPC;
item.Ts = Ts;
item.EstimatedPPC = EstimatedPPC;
item.BookLength = BookLength;
item.BookWidth = BookWidth;
item.BookDepth = BookDepth;
item.BookWeight = BookWeight;
item.Save(UserName);
}
public void Update(int SubDeliveryID, int? DeliveryID, int? TitleID, string Title, int? Copies, int? CurrentStatusID, string Remarks, int? CopiesPerCarton, float? TotalConsignmentWeight, float? TotalConsignmentCube, decimal? CartonLength, decimal? CartonDepth, decimal? CartonHeight, int? TotalCartons, float? CartonWeight, float? LastCarton, int? Jackets, int? FullPallets, int? CartonsPerFullPallet, int? PartPallets, int? CartonsPerPartPallet, decimal? PencePerCopy, byte[] Ts)
{
DeliverySubSubTable item = new DeliverySubSubTable();
item.MarkOld();
item.IsLoaded = true;
item.SubDeliveryID = SubDeliveryID;
item.DeliveryID = DeliveryID;
item.TitleID = TitleID;
item.Title = Title;
item.Copies = Copies;
item.CurrentStatusID = CurrentStatusID;
item.Remarks = Remarks;
item.CopiesPerCarton = CopiesPerCarton;
item.TotalConsignmentWeight = TotalConsignmentWeight;
item.TotalConsignmentCube = TotalConsignmentCube;
item.CartonLength = CartonLength;
item.CartonDepth = CartonDepth;
item.CartonHeight = CartonHeight;
item.TotalCartons = TotalCartons;
item.CartonWeight = CartonWeight;
item.LastCarton = LastCarton;
item.Jackets = Jackets;
item.FullPallets = FullPallets;
item.CartonsPerFullPallet = CartonsPerFullPallet;
item.PartPallets = PartPallets;
item.CartonsPerPartPallet = CartonsPerPartPallet;
item.ActualPPC = PencePerCopy;
item.Ts = Ts;
item.Save(UserName);
}
/// <summary>
/// insert new title
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgridTitles_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView _grd = (ASPxGridView)sender;
int _deliveryid = wwi_func.vint(_grd.GetMasterRowKeyValue().ToString());
try
{
if (_deliveryid > 0)
{
//need to get title from edit itemtemplate it won't be found in NewValues
string _title = "";
int? _titleid = null;
int? _intnull = null;
GridViewDataColumn _col = (GridViewDataColumn)_grd.Columns["colTitle"];
ASPxComboBox _cbo = (ASPxComboBox)_grd.FindEditRowCellTemplateControl(_col, "dxcbotitle");
if (_cbo != null)
{
_title = _cbo.Text != null ? _cbo.Text.ToString() : "";
_titleid = _cbo.Value != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull;
}
DeliverySubSubTable _t = new DeliverySubSubTable();
//required
_t.DeliveryID = _deliveryid;
//
_t.Title = _title;
_t.TitleID = _titleid;
//18.02.15 pencepercopy field renamed actualppc
if (e.NewValues["ActualPPC"] != null) { _t.ActualPPC = wwi_func.vdecimal(e.NewValues["ActualPPC"].ToString()); } else { _t.ActualPPC = null; }
if (e.NewValues["Copies"] != null) { _t.Copies = wwi_func.vint(e.NewValues["Copies"].ToString()); } else { _t.Copies = null; }
if (e.NewValues["CopiesPerCarton"] != null) { _t.CopiesPerCarton = wwi_func.vint(e.NewValues["CopiesPerCarton"].ToString()); } else { _t.CopiesPerCarton = null; }
if (e.NewValues["CartonLength"] != null) { _t.CartonLength = wwi_func.vdecimal(e.NewValues["CartonLength"].ToString()); } else { _t.CartonLength = null; }
if (e.NewValues["CartonDepth"] != null) { _t.CartonDepth = wwi_func.vdecimal(e.NewValues["CartonDepth"].ToString()); } else { _t.CartonDepth = null; }
if (e.NewValues["CartonHeight"] != null) { _t.CartonHeight = wwi_func.vdecimal(e.NewValues["CartonHeight"].ToString()); } else { _t.CartonHeight = null; }
if (e.NewValues["TotalCartons"] != null) { _t.TotalCartons = wwi_func.vint(e.NewValues["TotalCartons"].ToString()); } else { _t.TotalCartons = null; }
if (e.NewValues["CartonWeight"] != null) { _t.CartonWeight = wwi_func.vfloat(e.NewValues["CartonWeight"].ToString()); } else { _t.CartonWeight = null; }
if (e.NewValues["LastCarton"] != null) { _t.LastCarton = wwi_func.vfloat(e.NewValues["LastCarton"].ToString()); } else { _t.LastCarton = null; }
if (e.NewValues["CartonsPerFullPallet"] != null) { _t.CartonsPerFullPallet = wwi_func.vint(e.NewValues["CartonsPerFullPallet"].ToString()); } else { _t.CartonsPerFullPallet = null; }
if (e.NewValues["FullPallets"] != null) { _t.FullPallets = wwi_func.vint(e.NewValues["FullPallets"].ToString()); } else { _t.FullPallets = null; }
if (e.NewValues["CartonsPerPartPallet"] != null) { _t.CartonsPerPartPallet = wwi_func.vint(e.NewValues["CartonsPerPartPallet"].ToString()); } else { _t.CartonsPerPartPallet = null; }
if (e.NewValues["Jackets"] != null) { _t.Jackets = wwi_func.vint(e.NewValues["Jackets"].ToString()); } else { _t.Jackets = null; }
if (e.NewValues["PartPallets"] != null) { _t.PartPallets = wwi_func.vint(e.NewValues["PartPallets"].ToString()); } else { _t.PartPallets = null; }
if (e.NewValues["TotalConsignmentWeight"] != null) { _t.TotalConsignmentWeight = wwi_func.vfloat(e.NewValues["TotalConsignmentWeight"].ToString()); } else { _t.TotalConsignmentWeight = null; }
if (e.NewValues["TotalConsignmentCube"] != null) { _t.TotalConsignmentCube = wwi_func.vfloat(e.NewValues["TotalConsignmentCube"].ToString()); } else { _t.TotalConsignmentCube = null; }
if (e.NewValues["Remarks"] != null) { _t.Remarks = e.NewValues["Remarks"].ToString(); } else { _t.Remarks = ""; }
//new fields 18.02.15
if (e.NewValues["EstimatedPPC"] != null) { _t.EstimatedPPC = wwi_func.vdecimal(e.NewValues["EstimatedPPC"].ToString()); } else { _t.EstimatedPPC = null; }
if (e.NewValues["BookLength"] != null) { _t.BookLength = wwi_func.vdecimal(e.NewValues["BookLength"].ToString()); } else { _t.BookLength = null; }
if (e.NewValues["BookWidth"] != null) { _t.BookWidth = wwi_func.vdecimal(e.NewValues["BookWidth"].ToString()); } else { _t.BookWidth = null; }
if (e.NewValues["BookDepth"] != null) { _t.BookDepth = wwi_func.vdecimal(e.NewValues["BookDepth"].ToString()); } else { _t.BookDepth = null; }
if (e.NewValues["BookWeight"] != null) { _t.BookWeight = wwi_func.vdecimal(e.NewValues["BookWeight"].ToString()); } else { _t.BookWeight = null; }
//append new record
_t.Save();
}
}
catch (Exception ex)
{
string _orderno = wwi_security.DecryptString(get_token("pno"), "publiship");
string _ex = ex.Message.ToString();
this.dxlblErr.Text = string.Format("Title # {0} NOT added. Error: {1}", _deliveryid, _ex);
this.dxpnlErr.ClientVisible = true;
}
finally
{
//MUST call this after insert or error: Specified method is not supported
e.Cancel = true;
_grd.CancelEdit();
_grd.DataBind();
}
}
/// <summary>
/// update hvoyagetable
/// </summary>
/// <param name="hblid">int</param>
protected void update_dimensions()
{
//voyageid
int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));
if (_pid > 0)
{
try
{
//get instance of record
DeliverySubSubTable _tbl = new DeliverySubSubTable(_pid);
ASPxTextBox _txt = null;
//depth
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtDepthEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookDepth = wwi_func.vdecimal(_txt.Text.ToString());
}
//length
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtLengthEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookLength = wwi_func.vdecimal(_txt.Text.ToString());
}
//weight
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtWeightEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookWeight = wwi_func.vdecimal(_txt.Text.ToString());
}
//width
_txt = (ASPxTextBox)this.fmvDimensions.FindControl("dxtxtWidthEdit");
if (_txt != null && _txt.Text != "")
{
_tbl.BookWidth = wwi_func.vdecimal(_txt.Text.ToString());
}
//update
_tbl.Save();
//get values off edit form
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
}
else
{
string _ex = "Can't update record ID = 0";
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
}
protected void bind_formview(string mode)
{
//have to use a collection as formview needs to bind to enumerable
DeliverySubSubTableCollection _tbl = new DeliverySubSubTableCollection();
if (mode != "Insert")
{
int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship"));
DeliverySubSubTable _ct = new DeliverySubSubTable(_pid);
_tbl.Add(_ct);
this.fmvDimensions.DataSource = _tbl;
this.fmvDimensions.DataBind();
}
else //there's no insert option on this form it's jsut fer editting book/cartrton dimension
{
this.dxlblErr.Text = "This option is not available";
this.dxpnlErr.ClientVisible = true;
}
}