protected override void Dispose(bool disposing) {
try {
if (disposing) {
if (objectWindowAction != null) {
objectWindowAction.Execute -= objectWindowAction_OnExecute;
objectWindowAction.CustomizePopupWindowParams -= objectWindowAction_OnCustomizePopupWindowParams;
objectWindowAction.Dispose();
objectWindowAction = null;
}
if (control != null) {
control.Buttons.Clear();
control.Dispose();
control = null;
}
}
} finally {
base.Dispose(disposing);
}
}
private string GetClientScript(ASPxButtonEdit editor) {
string resultFunc = @"
window.ProcessObjectEditResult" + editor.ClientID + @" = function() {
window." + editor.ClientID + @".SetText(window.resultObject);
}";
return resultFunc;
}
protected string AddOrUpdate()
{
ASPxTextBox txt_pId = this.grid.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
ASPxTextBox txtCode = grid.FindEditFormTemplateControl("txt_ProductCode") as ASPxTextBox;
string pId = SafeValue.SafeString(txt_pId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(RefProduct), "Id='" + pId + "'");
RefProduct product = C2.Manager.ORManager.GetObject(query) as RefProduct;
bool action = false;
string code = "";
if (product == null)
{
action = true;
product = new RefProduct();
string sql = "select Code from ref_product";
DataTable dt = C2.Manager.ORManager.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
code = dt.Rows[i]["Code"].ToString();
if (txtCode.Text.ToUpper() == code.ToUpper())
{
throw new Exception("Please enter another value of the Code again!");
return("");
}
}
}
}
if (txtCode.Text == "")
{
code = C2Setup.GetNextNo("", "Product", DateTime.Now);
}
else
{
code = txtCode.Text;
}
product.Code = code;
ASPxTextBox txtName = grid.FindEditFormTemplateControl("txt_Name") as ASPxTextBox;
string name = txtName.Text.Trim();
if (txtName.Text == "")
{
throw new Exception("Full Name not be null!!!");
return("");
}
product.Name = name;
ASPxButtonEdit txt_PartyId = grid.FindEditFormTemplateControl("btnParty") as ASPxButtonEdit;
product.PartyId = txt_PartyId.Text;
ASPxComboBox cbProductClass = grid.FindEditFormTemplateControl("cbProductClass") as ASPxComboBox;
product.ProductClass = cbProductClass.Text.Trim();
//ASPxComboBox cbCountry = grid.FindEditFormTemplateControl("cbCountry") as ASPxComboBox;
//product.Country= cbCountry.Text;
ASPxTextBox txt_BrandName = grid.FindEditFormTemplateControl("txt_BrandName") as ASPxTextBox;
product.BrandName = txt_BrandName.Text;
ASPxSpinEdit txt_QtyPackingWhole = grid.FindEditFormTemplateControl("txt_QtyPackingWhole") as ASPxSpinEdit;
product.QtyPackingWhole = SafeValue.SafeInt(txt_QtyPackingWhole.Text, 0);
ASPxMemo txt_Description = grid.FindEditFormTemplateControl("txt_Description") as ASPxMemo;
product.Description = txt_Description.Text;
ASPxSpinEdit txt_QtyWholeLoose = grid.FindEditFormTemplateControl("txt_QtyWholeLoose") as ASPxSpinEdit;
product.QtyWholeLoose = SafeValue.SafeInt(txt_QtyWholeLoose.Text, 0);
ASPxSpinEdit spin_LengthPacking = grid.FindEditFormTemplateControl("spin_LengthPacking") as ASPxSpinEdit;
product.LengthPacking = SafeValue.SafeDecimal(spin_LengthPacking.Text);
ASPxSpinEdit spin_WidthPacking = grid.FindEditFormTemplateControl("spin_WidthPacking") as ASPxSpinEdit;
product.WidthPacking = SafeValue.SafeDecimal(spin_WidthPacking.Text);
ASPxSpinEdit spin_HeightPacking = grid.FindEditFormTemplateControl("spin_HeightPacking") as ASPxSpinEdit;
product.HeightPacking = SafeValue.SafeDecimal(spin_HeightPacking.Text);
ASPxSpinEdit spin_VolumePacking = grid.FindEditFormTemplateControl("spin_VolumePacking") as ASPxSpinEdit;
product.VolumePacking = SafeValue.SafeDecimal(spin_VolumePacking.Text);
ASPxButtonEdit spin_UomPacking = grid.FindEditFormTemplateControl("spin_UomPacking") as ASPxButtonEdit;
product.UomPacking = spin_UomPacking.Text;
ASPxSpinEdit spin_LengthWhole = grid.FindEditFormTemplateControl("spin_LengthWhole") as ASPxSpinEdit;
product.LengthWhole = SafeValue.SafeDecimal(spin_LengthWhole.Text);
ASPxSpinEdit spin_WidthWhole = grid.FindEditFormTemplateControl("spin_WidthWhole") as ASPxSpinEdit;
product.WidthWhole = SafeValue.SafeDecimal(spin_WidthWhole.Text);
ASPxSpinEdit spin_HeightWhole = grid.FindEditFormTemplateControl("spin_HeightWhole") as ASPxSpinEdit;
product.HeightWhole = SafeValue.SafeDecimal(spin_HeightWhole.Text);
ASPxSpinEdit spin_VolumeWhole = grid.FindEditFormTemplateControl("spin_VolumeWhole") as ASPxSpinEdit;
product.VolumeWhole = SafeValue.SafeDecimal(spin_VolumeWhole.Text);
ASPxButtonEdit spin_UomWhole = grid.FindEditFormTemplateControl("spin_UomWhole") as ASPxButtonEdit;
product.UomWhole = spin_UomWhole.Text;
ASPxSpinEdit spin_VolumeLoose = grid.FindEditFormTemplateControl("spin_VolumeLoose") as ASPxSpinEdit;
product.VolumeLoose = SafeValue.SafeDecimal(spin_VolumeLoose.Text);
ASPxSpinEdit spin_LengthLoose = grid.FindEditFormTemplateControl("spin_LengthLoose") as ASPxSpinEdit;
product.LengthLoose = SafeValue.SafeDecimal(spin_LengthLoose.Text);
ASPxSpinEdit spin_WidthLoose = grid.FindEditFormTemplateControl("spin_WidthLoose") as ASPxSpinEdit;
product.WidthLoose = SafeValue.SafeDecimal(spin_WidthLoose.Text);
ASPxSpinEdit spin_HeightLoose = grid.FindEditFormTemplateControl("spin_HeightLoose") as ASPxSpinEdit;
product.HeightLoose = SafeValue.SafeDecimal(spin_HeightLoose.Text);
ASPxButtonEdit spin_UomLoose = grid.FindEditFormTemplateControl("spin_UomLoose") as ASPxButtonEdit;
product.UomLoose = spin_UomLoose.Text;
ASPxSpinEdit spin_CostPrice = grid.FindEditFormTemplateControl("spin_CostPrice") as ASPxSpinEdit;
product.CostPrice = SafeValue.SafeDecimal(spin_CostPrice.Text);
ASPxSpinEdit spin_Saleprice = grid.FindEditFormTemplateControl("spin_Saleprice") as ASPxSpinEdit;
product.Saleprice = SafeValue.SafeDecimal(spin_Saleprice.Text);
product.CreateBy = HttpContext.Current.User.Identity.Name;
ASPxTextBox hsCode = grid.FindEditFormTemplateControl("txt_HsCode") as ASPxTextBox;
product.HsCode = hsCode.Text;
ASPxSpinEdit QtyLooseBase = grid.FindEditFormTemplateControl("txt_QtyLooseBase") as ASPxSpinEdit;
product.QtyLooseBase = SafeValue.SafeInt(QtyLooseBase.Text, 0);
ASPxButtonEdit txt_UomBase = grid.FindEditFormTemplateControl("txt_UomBase") as ASPxButtonEdit;
product.UomBase = txt_UomBase.Text;
product.CreateDateTime = DateTime.Now;
ASPxComboBox cb_Att1 = grid.FindEditFormTemplateControl("cb_Att1") as ASPxComboBox;
product.Att4 = SafeValue.SafeString(cb_Att1.Text);
ASPxComboBox cb_Att2 = grid.FindEditFormTemplateControl("cb_Att2") as ASPxComboBox;
product.Att5 = SafeValue.SafeString(cb_Att2.Text);
ASPxComboBox cb_Att3 = grid.FindEditFormTemplateControl("cb_Att3") as ASPxComboBox;
product.Att6 = SafeValue.SafeString(cb_Att3.Text);
ASPxComboBox cb_Att4 = grid.FindEditFormTemplateControl("cb_Att4") as ASPxComboBox;
product.Att7 = SafeValue.SafeString(cb_Att4.Text);
ASPxComboBox cb_Att5 = grid.FindEditFormTemplateControl("cb_Att5") as ASPxComboBox;
product.Att8 = SafeValue.SafeString(cb_Att5.Text);
ASPxComboBox cb_Att6 = grid.FindEditFormTemplateControl("cb_Att6") as ASPxComboBox;
product.Att9 = SafeValue.SafeString(cb_Att6.Text);
ASPxTextBox txt_ArCode = grid.FindEditFormTemplateControl("txt_ArCode") as ASPxTextBox;
product.ArCode = SafeValue.SafeString(txt_ArCode.Text.Trim());
ASPxTextBox txt_ApCode = grid.FindEditFormTemplateControl("txt_ApCode") as ASPxTextBox;
product.ApCode = SafeValue.SafeString(txt_ApCode.Text.Trim());
if (txt_ArCode.Text.Trim() == "")
{
product.ArCode = System.Configuration.ConfigurationManager.AppSettings["ItemArCode"];
}
if (txt_ApCode.Text.Trim() == "")
{
product.ApCode = System.Configuration.ConfigurationManager.AppSettings["ItemApCode"];
}
ASPxTextBox txt_PartNo = grid.FindEditFormTemplateControl("txt_PartNo") as ASPxTextBox;
product.PartNo = SafeValue.SafeString(txt_PartNo.Text.Trim());
ASPxSpinEdit MinOrderQty = grid.FindEditFormTemplateControl("spin_MinOrderQty") as ASPxSpinEdit;
product.MinOrderQty = SafeValue.SafeInt(MinOrderQty.Text, 0);
ASPxSpinEdit NewOrderQty = grid.FindEditFormTemplateControl("spin_NewOrderQty") as ASPxSpinEdit;
product.NewOrderQty = SafeValue.SafeInt(NewOrderQty.Text, 0);
//ASPxComboBox cb_Att7 = grid.FindEditFormTemplateControl("cb_Att7") as ASPxComboBox;
//product.Att10 = SafeValue.SafeString(cb_Att7.Text);
//ASPxComboBox cb_Att8 = grid.FindEditFormTemplateControl("cb_Att8") as ASPxComboBox;
//product.Att11 = SafeValue.SafeString(cb_Att8.Text);
//ASPxComboBox cb_Att9 = grid.FindEditFormTemplateControl("cb_Att9") as ASPxComboBox;
//product.Att12 = SafeValue.SafeString(cb_Att9.Text);
//ASPxComboBox cb_Att10 = grid.FindEditFormTemplateControl("cb_Att10") as ASPxComboBox;
//product.Att13 = SafeValue.SafeString(cb_Att10.Text);
product.Att1 = "1" + product.UomPacking;
if (product.QtyPackingWhole > 0 && product.UomWhole.Length > 0)
{
product.Att1 += string.Format("x{0}{1}", product.QtyPackingWhole, product.UomWhole);
}
if (product.QtyWholeLoose > 0 && product.UomLoose.Length > 0)
{
product.Att1 += string.Format("x{0}{1}", product.QtyWholeLoose, product.UomLoose);
}
if (product.QtyLooseBase > 0 && product.UomBase.Length > 0)
{
product.Att1 += string.Format("x{0}{1}", product.QtyLooseBase, product.UomBase);
}
ASPxComboBox cmb_OptionType = grid.FindEditFormTemplateControl("cmb_OptionType") as ASPxComboBox;
product.OptionType = SafeValue.SafeString(cmb_OptionType.Value);
product.Att4 = SafeValue.SafeString(cb_Att1.Text);
if (txt_UomBase.Text == "Packing")
{
product.Att3 = spin_UomPacking.Text;
}
else if (txt_UomBase.Text == "Whole")
{
product.Att3 = spin_UomWhole.Text;
}
else
{
product.Att3 = spin_UomLoose.Text;
}
if (cbProductClass.Text == "CIGR")
{
product.UomPacking = "PKG";
product.UomWhole = "BOX";
product.UomLoose = "PKT";
product.UomBase = "STK";
}
if (action)
{
product.StatusCode = "USE";
product.CreateBy = EzshipHelper.GetUserName();
product.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(product, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(product);
txt_pId.Text = product.Id.ToString();
C2Setup.SetNextNo("", "Product", code, DateTime.Now);
}
else
{
product.UpdateBy = EzshipHelper.GetUserName();
product.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(product, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(product);
}
Session["SkuWhere"] = "Code='" + product.Code + "'";
this.dsProduct.FilterExpression = Session["SkuWhere"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
return(product.Code);
}
protected void SaveLocation(ASPxGridView grid)
{
ASPxPageControl pageControl_Location = grid.FindEditFormTemplateControl("pageControl_Location") as ASPxPageControl;
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_WarehouseCode = pageControl.FindControl("txt_Code") as ASPxTextBox;
ASPxTextBox txt_Id = pageControl_Location.FindControl("txt_Id") as ASPxTextBox;
ASPxTextBox txt_Code = pageControl_Location.FindControl("txt_Location_Code") as ASPxTextBox;
string id = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(RefLocation), "Id='" + id + "'");
RefLocation obj = C2.Manager.ORManager.GetObject(query) as RefLocation;
bool action = false;
string code = "";
if (obj == null)
{
action = true;
obj = new RefLocation();
string sql = "select Code from ref_location where LocLevel='Unit' and WarehouseCode='" + txt_WarehouseCode.Text + "'";
DataTable dt = C2.Manager.ORManager.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
code = dt.Rows[i]["Code"].ToString();
if (txt_Code.Text.ToUpper() == code.ToUpper())
{
throw new Exception("Please enter another value of the Code again!");
return;
}
}
}
}
if (txt_Code.Text == "")
{
throw new Exception("Code not be null!!!");
return;
}
obj.Code = txt_Code.Text;
ASPxTextBox txtName = pageControl_Location.FindControl("txt_Location_Name") as ASPxTextBox;
string name = txtName.Text.Trim();
//if (txtName.Text == "")
//{
// throw new Exception("Name not be null!!!");
// return;
//}
obj.Name = name;
obj.Code = txt_Code.Text;
obj.WarehouseCode = txt_WarehouseCode.Text;
ASPxButtonEdit txt_ZoneCode = pageControl_Location.FindControl("btn_L_ZoneCode") as ASPxButtonEdit;
obj.ZoneCode = txt_ZoneCode.Text;
ASPxButtonEdit txt_PartyId = pageControl_Location.FindControl("txt_PartyId") as ASPxButtonEdit;
obj.PartyId = txt_PartyId.Text;
ASPxButtonEdit txt_StoreCode = pageControl_Location.FindControl("btn_L_StoreCode") as ASPxButtonEdit;
obj.StoreCode = txt_StoreCode.Text;
ASPxSpinEdit txt_Length = pageControl_Location.FindControl("txt_Length") as ASPxSpinEdit;
obj.Length = SafeValue.SafeDecimal(txt_Length.Text);
ASPxSpinEdit txt_Width = pageControl_Location.FindControl("txt_Width") as ASPxSpinEdit;
obj.Width = SafeValue.SafeDecimal(txt_Width.Text);
ASPxSpinEdit txt_Height = pageControl_Location.FindControl("txt_Height") as ASPxSpinEdit;
obj.Height = SafeValue.SafeDecimal(txt_Height.Text);
ASPxSpinEdit txt_SpaceM3 = pageControl_Location.FindControl("txt_SpaceM3") as ASPxSpinEdit;
obj.SpaceM3 = SafeValue.SafeDecimal(txt_SpaceM3.Text);
ASPxMemo memoRemark = pageControl_Location.FindControl("memo_Remark") as ASPxMemo;
obj.Remark = memoRemark.Text;
if (action)
{
obj.CreateBy = EzshipHelper.GetUserName();
obj.CreateDateTime = DateTime.Now;
obj.Loclevel = "Unit";
Manager.ORManager.StartTracking(obj, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(obj);
}
else
{
obj.UpdateBy = EzshipHelper.GetUserName();
obj.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(obj, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(obj);
}
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxTextBox invNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxDateEdit ExpireDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_ToDt") as ASPxDateEdit;
ASPxDateEdit QuoteDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocDt") as ASPxDateEdit;
ASPxComboBox QuoteType = this.ASPxGridView1.FindEditFormTemplateControl("cbx_QuoteType") as ASPxComboBox;
ASPxTextBox PartyTo = this.ASPxGridView1.FindEditFormTemplateControl("txt_CustId") as ASPxTextBox;
ASPxTextBox PartyName = this.ASPxGridView1.FindEditFormTemplateControl("txt_CustName") as ASPxTextBox;
ASPxTextBox Tel = this.ASPxGridView1.FindEditFormTemplateControl("txt_Tel") as ASPxTextBox;
ASPxTextBox Fax = this.ASPxGridView1.FindEditFormTemplateControl("txt_Fax") as ASPxTextBox;
ASPxTextBox Contact = this.ASPxGridView1.FindEditFormTemplateControl("txt_Contact") as ASPxTextBox;
ASPxTextBox Pol = this.ASPxGridView1.FindEditFormTemplateControl("txt_Pol") as ASPxTextBox;
ASPxTextBox Pod = this.ASPxGridView1.FindEditFormTemplateControl("txt_Pod") as ASPxTextBox;
ASPxTextBox FinDest = this.ASPxGridView1.FindEditFormTemplateControl("txt_FinDest") as ASPxTextBox;
ASPxTextBox Vessel = this.ASPxGridView1.FindEditFormTemplateControl("txt_Vessel") as ASPxTextBox;
ASPxTextBox Voyage = this.ASPxGridView1.FindEditFormTemplateControl("txt_Voyage") as ASPxTextBox;
ASPxDateEdit Eta = this.ASPxGridView1.FindEditFormTemplateControl("txt_Eta") as ASPxDateEdit;
ASPxDateEdit Etd = this.ASPxGridView1.FindEditFormTemplateControl("txt_Etd") as ASPxDateEdit;
ASPxDateEdit EtaDest = this.ASPxGridView1.FindEditFormTemplateControl("txt_EtaDest") as ASPxDateEdit;
ASPxTextBox CurrencyId = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxTextBox;
ASPxSpinEdit ExRate = this.ASPxGridView1.FindEditFormTemplateControl("spin_exRate") as ASPxSpinEdit;
ASPxButtonEdit SalesmanId = this.ASPxGridView1.FindEditFormTemplateControl("txt_SalesmanId") as ASPxButtonEdit;
ASPxTextBox Subject = this.ASPxGridView1.FindEditFormTemplateControl("txt_Subject") as ASPxTextBox;
ASPxMemo Rmk = this.ASPxGridView1.FindEditFormTemplateControl("txt_Remarks1") as ASPxMemo;
ASPxMemo Note1 = this.ASPxGridView1.FindEditFormTemplateControl("txt_Note1") as ASPxMemo;
ASPxMemo Note2 = this.ASPxGridView1.FindEditFormTemplateControl("txt_Note2") as ASPxMemo;
ASPxMemo Note3 = this.ASPxGridView1.FindEditFormTemplateControl("txt_Note3") as ASPxMemo;
ASPxMemo Note4 = this.ASPxGridView1.FindEditFormTemplateControl("txt_Note4") as ASPxMemo;
string invN = docN.Text;
C2.SeaQuotation inv = C2.Manager.ORManager.GetObject(typeof(C2.SeaQuotation), SafeValue.SafeInt(invNCtr.Text, 0)) as C2.SeaQuotation;
if (inv == null)
{
string counterType = "SeaFcl-Quotation";
inv = new C2.SeaQuotation();
invN = C2Setup.GetNextNo(counterType);
inv.QuoteNo = invN;
inv.ExpireDate = ExpireDate.Date;
inv.QuoteDate = QuoteDate.Date;
inv.QuoteType = QuoteType.Text;
inv.PartyTo = PartyTo.Text;
inv.PartyName = PartyName.Text;
inv.Tel = Tel.Text;
inv.Fax = Fax.Text;
inv.Contact = Contact.Text;
inv.Pol = Pol.Text;
inv.Pod = Pod.Text;
inv.FinDest = FinDest.Text;
inv.Vessel = Vessel.Text;
inv.Voyage = Voyage.Text;
inv.Eta = Eta.Date;
inv.Etd = Etd.Date;
inv.EtaDest = EtaDest.Date;
inv.CurrencyId = CurrencyId.Text;
inv.ExRate = SafeValue.SafeDecimal(ExRate.Value, 1);
inv.SalesmanId = SalesmanId.Text;
inv.Subject = Subject.Text;
inv.Rmk = Rmk.Text;
inv.Note1 = Note1.Text;
inv.Note2 = Note2.Text;
inv.Note3 = Note3.Text;
inv.Note4 = Note4.Text;
inv.CreateUser = HttpContext.Current.User.Identity.Name;
inv.CreateDate = DateTime.Now;
inv.UpdateUser = HttpContext.Current.User.Identity.Name;
inv.UpdateDate = DateTime.Now;
try
{
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(inv);
C2Setup.SetNextNo(counterType, inv.QuoteNo);
}
catch
{
}
}
else
{
inv.ExpireDate = ExpireDate.Date;
inv.QuoteDate = QuoteDate.Date;
inv.QuoteType = QuoteType.Text;
inv.PartyTo = PartyTo.Text;
inv.PartyName = PartyName.Text;
inv.Tel = Tel.Text;
inv.Fax = Fax.Text;
inv.Contact = Contact.Text;
inv.Pol = Pol.Text;
inv.Pod = Pod.Text;
inv.FinDest = FinDest.Text;
inv.Vessel = Vessel.Text;
inv.Voyage = Voyage.Text;
inv.Eta = Eta.Date;
inv.Etd = Etd.Date;
inv.EtaDest = EtaDest.Date;
inv.CurrencyId = CurrencyId.Text;
inv.ExRate = SafeValue.SafeDecimal(ExRate.Value, 1);
inv.SalesmanId = SalesmanId.Text;
inv.Subject = Subject.Text;
inv.Rmk = Rmk.Text;
inv.Note1 = Note1.Text;
inv.Note2 = Note2.Text;
inv.Note3 = Note3.Text;
inv.Note4 = Note4.Text;
inv.UpdateUser = HttpContext.Current.User.Identity.Name;
inv.UpdateDate = DateTime.Now;
try
{
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(inv);
}
catch
{
}
}
Session["SeaQuoteEditWhere"] = "Id=" + inv.Id;
this.dsSeaQuotation.FilterExpression = Session["SeaQuoteEditWhere"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
private void SaveBill()
{
#region save
ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
ASPxComboBox partyTo = this.ASPxGridView1.FindEditFormTemplateControl("cmb_PartyTo") as ASPxComboBox;
ASPxTextBox otherPartyName = this.ASPxGridView1.FindEditFormTemplateControl("txt_OtherPartyName") as ASPxTextBox;
ASPxComboBox docType = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType") as ASPxComboBox;
ASPxComboBox docType1 = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType1") as ASPxComboBox;
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxDateEdit docDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocDt") as ASPxDateEdit;
ASPxMemo remark = this.ASPxGridView1.FindEditFormTemplateControl("txt_Remarks1") as ASPxMemo;
ASPxButtonEdit docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit;
ASPxSpinEdit exRate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocExRate") as ASPxSpinEdit;
ASPxButtonEdit acCode = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcCode") as ASPxButtonEdit;
ASPxTextBox slipNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_SlipNo") as ASPxTextBox;
ASPxTextBox bankName = this.ASPxGridView1.FindEditFormTemplateControl("txt_BankName") as ASPxTextBox;
ASPxTextBox acDorc = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcDorc") as ASPxTextBox;
ASPxTextBox chqNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_ChequeNo") as ASPxTextBox;
ASPxDateEdit chqDt = this.ASPxGridView1.FindEditFormTemplateControl("txt_ChqDt") as ASPxDateEdit;
ASPxTextBox pic = this.ASPxGridView1.FindEditFormTemplateControl("txt_Pic") as ASPxTextBox;
ASPxSpinEdit docAmt = this.ASPxGridView1.FindEditFormTemplateControl("spin_DocAmt") as ASPxSpinEdit;
ASPxCheckBox isReturn = this.ASPxGridView1.FindEditFormTemplateControl("ck_IsReturn") as ASPxCheckBox;
C2.jnl_doc inv = Manager.ORManager.GetObject(typeof(jnl_doc), SafeValue.SafeInt(oidCtr.Text, 0)) as jnl_doc;
if (null == inv)// first insert invoice
{
//string invN = C2Setup.GetNextNo("AR-RECEIPT");
inv = new C2.jnl_doc();
inv.PartyTo = SafeValue.SafeString(partyTo.Value, "");
//inv.DocNo = invN;
inv.DocType = docType.Value.ToString();
inv.DocType1 = docType1.Value.ToString();
inv.DocDate = docDate.Date;
inv.ChqDate = chqDt.Date;
inv.Remark = remark.Text;
inv.DocCurrency = docCurr.Text.ToString();
inv.DocExRate = SafeValue.SafeDecimal(exRate.Value, 1);
if (inv.DocExRate <= 0)
{
inv.DocExRate = 1;
}
inv.AcCode = acCode.Text;
inv.BankName = bankName.Text;
inv.SlipNo = slipNo.Text;
inv.ChqNo = chqNo.Text;
inv.ExportInd = "N";
if (inv.DocType1.ToLower() == "refund")
{
inv.AcSource = "CR";
}
else
{
inv.AcSource = "DB";
}
inv.DocAmt = SafeValue.SafeDecimal(docAmt.Value, 0);
inv.LocAmt = inv.DocAmt * inv.DocExRate;
inv.CancelDate = new DateTime(1900, 1, 1);
inv.CancelInd = "N";
inv.BankRec = "N";
inv.BankDate = new DateTime(1900, 1, 1);
inv.OtherPartyName = otherPartyName.Text;
string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date);
inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year);
inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month);
inv.Pic = pic.Text;
inv.IsReturn = isReturn.Checked;
try
{
inv.GenerateInd = "N";
inv.CreateBy = HttpContext.Current.User.Identity.Name;
inv.CreateDateTime = DateTime.Now;
inv.UpdateBy = HttpContext.Current.User.Identity.Name;
inv.UpdateDateTime = DateTime.Now;
inv.PostBy = "";
inv.PostDateTime = new DateTime(1900, 1, 1);
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(inv);
inv.DocNo = inv.Id.ToString();
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(inv);
//C2Setup.SetNextNo("AR-RECEIPT", invN);
}
catch
{
}
}
else
{
inv.PartyTo = SafeValue.SafeString(partyTo.Value, "");
inv.DocDate = docDate.Date;
inv.ChqDate = chqDt.Date;
inv.Remark = remark.Text;
inv.DocCurrency = docCurr.Text.ToString();
inv.DocExRate = SafeValue.SafeDecimal(exRate.Value, 1);
if (inv.DocExRate <= 0)
{
inv.DocExRate = 1;
}
inv.AcCode = acCode.Text;
inv.BankName = bankName.Text;
inv.SlipNo = slipNo.Text;
inv.ChqNo = chqNo.Text;
inv.DocAmt = SafeValue.SafeDecimal(docAmt.Value, 0);
inv.LocAmt = inv.DocAmt * inv.DocExRate;
string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date);
inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year);
inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month);
inv.OtherPartyName = otherPartyName.Text;
inv.Pic = pic.Text;
inv.IsReturn = isReturn.Checked;
try
{
inv.UpdateBy = HttpContext.Current.User.Identity.Name;
inv.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(inv, InitialState.Updated);
Manager.ORManager.PersistChanges(inv);
}
catch
{ }
}
ASPxWebControl.RedirectOnCallback("jnl_edit.aspx?no=" + inv.DocNo);
//Session["ArRecWhere"] = "Id=" + inv.Id;
//this.dsArReceipt.FilterExpression = Session["ArRecWhere"].ToString();
//if (this.ASPxGridView1.GetRow(0) != null)
// this.ASPxGridView1.StartEdit(0);
#endregion
}
// Methods
public static void AssignButtonClickScript(ASPxButtonEdit editor, WebApplication application, PopupWindowShowAction objectWindowAction)
{
string str = string.Format("function Add_{0}_ButtonClickHandler(sender, e)", editor.ClientID) + "{" + application.PopupWindowManager.GetShowPopupWindowScript(objectWindowAction, GetButtonEditProcessResultFunction(editor), editor.ClientID, false, false) + "; }";
editor.ClientSideEvents.ButtonClick = str;
}
protected void grid_ref_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
if (this.grid_ref.EditingRowVisibleIndex > -1)
{
ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxButtonEdit whId = pageControl.FindControl("txt_WhId") as ASPxButtonEdit;
ASPxButtonEdit crAgentId = pageControl.FindControl("txt_CrAgentId") as ASPxButtonEdit;
ASPxButtonEdit nvoccAgentId = pageControl.FindControl("txt_NvoccAgentId") as ASPxButtonEdit;
ASPxButtonEdit agentId = pageControl.FindControl("txt_AgentId") as ASPxButtonEdit;
ASPxTextBox whName = pageControl.FindControl("txt_WhName") as ASPxTextBox;
ASPxTextBox crAgentName = pageControl.FindControl("txt_CrAgentName") as ASPxTextBox;
ASPxTextBox nvoccAgentName = pageControl.FindControl("txt_NvoccAgentName") as ASPxTextBox;
ASPxTextBox agentName = pageControl.FindControl("txt_AgentName") as ASPxTextBox;
ASPxTextBox localCustName = pageControl.FindControl("txt_LocalCustName") as ASPxTextBox;
whName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "WarehouseId" }));
crAgentName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "CrAgentId" }));
nvoccAgentName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "NvoccAgentId" }));
agentName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "AgentId" }));
localCustName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "LocalCust" }));
string oid = SafeValue.SafeString(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "SequenceId" }));
if (this.txt_RefType.Text.ToLower() == "sec")
{
for (int i = 0; i < pageControl.TabPages.Count; i++)
{
if (pageControl.TabPages[i].Text == "Booking")
{
pageControl.TabPages[i].ClientVisible = true;
break;
}
}
}
if (oid.Length > 0)
{
ASPxDateEdit date_RefDate = pageControl.FindControl("date_RefDate") as ASPxDateEdit;
date_RefDate.BackColor = ((DevExpress.Web.ASPxEditors.ASPxTextBox)(pageControl.FindControl("cbx_JobType"))).BackColor;
date_RefDate.ReadOnly = true;
string userId = HttpContext.Current.User.Identity.Name;
ASPxLabel jobStatusStr = pageControl.FindControl("lb_JobStatus") as ASPxLabel;
string sql = string.Format("select StatusCode from SeaExportRef where SequenceId='{0}'", oid);
string statusCode = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");// closeIndStr.Text;
ASPxButton btn = this.grid_ref.FindEditFormTemplateControl("btn_RefCloseJob") as ASPxButton;
ASPxButton btn_VoidMaster = this.grid_ref.FindEditFormTemplateControl("btn_VoidMaster") as ASPxButton;
if (statusCode == "CNL")
{
btn_VoidMaster.Text = "Unvoid";
jobStatusStr.Text = "Void";
}
else if (statusCode == "USE")
{
btn.Text = "Close Job";
btn_VoidMaster.Text = "Void";
jobStatusStr.Text = "USE";
}
else if (statusCode == "CLS")
{
btn.Text = "Open Job";
jobStatusStr.Text = "Closed";
}
}
}
}
protected void grid_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
ASPxTextBox txt_TransferNo = this.grid.FindEditFormTemplateControl("txt_TransferNo") as ASPxTextBox;
ASPxButtonEdit txt_PartyId = this.grid.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit;
ASPxTextBox txt_PartyName = this.grid.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox;
string sql = "";
string refNo = SafeValue.SafeString(txt_TransferNo.Text);
if (s == "CloseJob")
{
#region close job
sql = "select StatusCode from wh_Transfer where TransferNo='" + refNo + "'";
string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");//
if (closeInd == "CLS")
{
sql = string.Format("update wh_Transfer set StatusCode='USE' where TransferNo='{0}'", refNo);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
string doInId = "";
string doOutId = "";
sql = string.Format(@"select DoInId,DoOutId from wh_TransferDet where TransferNo='{0}'", refNo);
DataTable tab = ConnectSql.GetTab(sql);
for (int i = 0; i < tab.Rows.Count; i++)
{
doInId = SafeValue.SafeString(tab.Rows[i]["DoInId"]);
doOutId = SafeValue.SafeString(tab.Rows[i]["DoOutId"]);
sql = string.Format("delete from Wh_DoDet2 where Id={0}", doInId);
C2.Manager.ORManager.ExecuteCommand(sql);
sql = string.Format("delete from Wh_DoDet2 where Id={0}", doOutId);
C2.Manager.ORManager.ExecuteCommand(sql);
}
}
else
{
e.Result = "Fail";
}
}
else
{
sql = string.Format("update wh_Transfer set StatusCode='CLS' where TransferNo='{0}'", refNo);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
sql = string.Format(@"select * from wh_TransferDet where TransferNo='{0}'", refNo);
DataTable tab = ConnectSql.GetTab(sql);
for (int i = 0; i < tab.Rows.Count; i++)
{
int id = SafeValue.SafeInt(tab.Rows[i]["Id"], 0);
string doInId = "";
string doOutId = "";
string sku = SafeValue.SafeString(tab.Rows[i]["Product"]);
string des = SafeValue.SafeString(tab.Rows[i]["Des1"]);
string fromLoc = SafeValue.SafeString(tab.Rows[i]["FromLocId"]);
string toLoc = SafeValue.SafeString(tab.Rows[i]["ToLocId"]);
string lotNo = SafeValue.SafeString(tab.Rows[i]["LotNo"]);
decimal price = SafeValue.SafeDecimal(tab.Rows[i]["Price"], 0);
int qty1 = SafeValue.SafeInt(tab.Rows[i]["Qty1"], 0);
int qty2 = SafeValue.SafeInt(tab.Rows[i]["Qty2"], 0);;
int qty3 = SafeValue.SafeInt(tab.Rows[i]["Qty3"], 0);;
string uom1 = SafeValue.SafeString(tab.Rows[i]["Uom1"]);
string uom2 = SafeValue.SafeString(tab.Rows[i]["Uom2"]);
string uom3 = SafeValue.SafeString(tab.Rows[i]["Uom3"]);
string uom4 = SafeValue.SafeString(tab.Rows[i]["Uom4"]);
int qtyPackWhole = SafeValue.SafeInt(tab.Rows[i]["QtyPackWhole"], 0);
int qtyWholeLoose = SafeValue.SafeInt(tab.Rows[i]["QtyWholeLoose"], 0);
int qtyLooseBase = SafeValue.SafeInt(tab.Rows[i]["QtyLooseBase"], 0);
string att1 = SafeValue.SafeString(tab.Rows[i]["Att1"]);
string att2 = SafeValue.SafeString(tab.Rows[i]["Att2"]);
string att3 = SafeValue.SafeString(tab.Rows[i]["Att3"]);
string att4 = SafeValue.SafeString(tab.Rows[i]["Att4"]);
string att5 = SafeValue.SafeString(tab.Rows[i]["Att5"]);
string att6 = SafeValue.SafeString(tab.Rows[i]["Att6"]);
string packing = SafeValue.SafeString(tab.Rows[i]["Packing"]);
string partyId = SafeValue.SafeString(txt_PartyId.Text);
string partyName = SafeValue.SafeString(txt_PartyName.Text);
ASPxDateEdit de_TransferDate = this.grid.FindEditFormTemplateControl("de_TransferDate") as ASPxDateEdit;
DateTime doDate = de_TransferDate.Date;
//From Location-----To Location,Do Out
doOutId = AddDoDet2("", refNo, "OUT", fromLoc, sku, lotNo, des, price, qty1, qty2, qty3, uom1, uom2, uom3, uom4, qtyPackWhole, qtyWholeLoose, qtyLooseBase, att1, att2, att3, att4, att5, att6, packing, partyId, partyName, doDate);
//From Location-----To Location,Do In
doInId = AddDoDet2("", refNo, "IN", toLoc, sku, lotNo, des, price, qty1, qty2, qty3, uom1, uom2, uom3, uom4, qtyPackWhole, qtyWholeLoose, qtyLooseBase, att1, att2, att3, att4, att5, att6, packing, partyId, partyName, doDate);
sql = string.Format(@"update wh_TransferDet set DoInId={1},DoOutId={2} where Id={0}", id, doInId, doOutId);
C2.Manager.ORManager.ExecuteCommand(sql);
}
}
else
{
e.Result = "Fail";
}
}
#endregion
}
if (s == "Void")
{
#region void master
sql = "select StatusCode from wh_Transfer where TransferNo='" + refNo + "'";
string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "N");// closeIndStr.Text;
if (closeInd == "CNL")
{
sql = string.Format("update wh_Transfer set StatusCode='USE' where TransferNo='{0}'", refNo);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
else
{
sql = string.Format("update wh_Transfer set StatusCode='CNL' where TransferNo='{0}'", refNo);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
#endregion
}
}
protected void SaveJob()
{
try
{
ASPxPageControl pageControl = this.grid_Transport.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox idCtr = pageControl.FindControl("txt_Id") as ASPxTextBox;
ASPxTextBox jobNoCtr = pageControl.FindControl("txt_JobNo") as ASPxTextBox;
string jobNo = jobNoCtr.Text;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.TptJob), "Id='" + idCtr.Text + "'");
C2.TptJob tj = C2.Manager.ORManager.GetObject(query) as C2.TptJob;
bool isNew = false;
string runType = "LocalTpt";
ASPxDateEdit jobDate = pageControl.FindControl("date_JobDate") as ASPxDateEdit;
if (tj == null)
{
tj = new C2.TptJob();
isNew = true;
tj.JobType = this.txt_type.Text;
jobNo = C2Setup.GetNextNo(tj.JobType, runType, jobDate.Date);
tj.JobNo = jobNo;
tj.UserId = HttpContext.Current.User.Identity.Name;
tj.EntryDate = DateTime.Now;
}
tj.JobDate = jobDate.Date;
ASPxButtonEdit cust = pageControl.FindControl("btn_Cust") as ASPxButtonEdit;
tj.Cust = cust.Text;
ASPxTextBox bkgRef = pageControl.FindControl("txt_BkgRef") as ASPxTextBox;
tj.BkgRef = bkgRef.Text;
ASPxTextBox ves = pageControl.FindControl("txt_Ves") as ASPxTextBox;
tj.Vessel = ves.Text;
ASPxTextBox voy = pageControl.FindControl("txt_Voy") as ASPxTextBox;
tj.Voyage = voy.Text;
ASPxButtonEdit pol = pageControl.FindControl("txt_Pol") as ASPxButtonEdit;
tj.Pol = pol.Text;
ASPxButtonEdit pod = pageControl.FindControl("txt_Pod") as ASPxButtonEdit;
tj.Pod = pod.Text;
ASPxDateEdit eta = pageControl.FindControl("date_Eta") as ASPxDateEdit;
tj.Eta = eta.Date;
ASPxDateEdit etd = pageControl.FindControl("date_Etd") as ASPxDateEdit;
tj.Etd = etd.Date;
ASPxTextBox blRef = pageControl.FindControl("txt_BlRef") as ASPxTextBox;
tj.BlRef = blRef.Text;
ASPxSpinEdit qty = pageControl.FindControl("spin_Qty") as ASPxSpinEdit;
tj.Qty = SafeValue.SafeInt(qty.Value, 0);
ASPxButtonEdit pkgType = pageControl.FindControl("txt_PackType") as ASPxButtonEdit;
tj.PkgType = pkgType.Text;
ASPxSpinEdit wt = pageControl.FindControl("spin_Wt") as ASPxSpinEdit;
tj.Wt = SafeValue.SafeDecimal(wt.Value, 0);
ASPxSpinEdit m3 = pageControl.FindControl("spin_M3") as ASPxSpinEdit;
tj.M3 = SafeValue.SafeDecimal(m3.Value, 0);
ASPxMemo pickFrm1 = pageControl.FindControl("txt_PickupFrm1") as ASPxMemo;
tj.PickFrm1 = pickFrm1.Text;
ASPxMemo deliveryTo1 = pageControl.FindControl("txt_DeliveryTo1") as ASPxMemo;
tj.DeliveryTo1 = deliveryTo1.Text;
ASPxMemo jobRmk = pageControl.FindControl("txt_JobRmk") as ASPxMemo;
tj.JobRmk = jobRmk.Text;
ASPxMemo mkg = pageControl.FindControl("txt_cargoMkg") as ASPxMemo;
tj.CargoMkg = mkg.Text;
ASPxMemo des = pageControl.FindControl("txt_cargoDes") as ASPxMemo;
tj.CargoDesc = des.Text;
if (isNew)
{
tj.CreateBy = EzshipHelper.GetUserName();
tj.CreateDateTime = DateTime.Now;
tj.StatusCode = "USE";
C2.Manager.ORManager.StartTracking(tj, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(tj);
}
else
{
tj.UpdateBy = EzshipHelper.GetUserName();
tj.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(tj, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(tj);
}
if (isNew)
{
jobNoCtr.Text = jobNo;
C2Setup.SetNextNo(tj.JobType, runType, jobNo, tj.JobDate);
string where = "JobNo='" + jobNo + "'";
Session["TptJob_" + this.txt_type.Text] = where;
this.dsTransport.FilterExpression = where;
if (this.grid_Transport.GetRow(0) != null)
{
this.grid_Transport.StartEdit(0);
}
}
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
}
protected void Save()
{
try
{
ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox oidCtr = pageControl.FindControl("txtSequenceId") as ASPxTextBox;
int oid = SafeValue.SafeInt(oidCtr.Text, 0);
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(SeaExportRef), "SequenceId='" + oid + "'");
SeaExportRef expRef = C2.Manager.ORManager.GetObject(query) as SeaExportRef;
ASPxDateEdit refDate = pageControl.FindControl("date_RefDate") as ASPxDateEdit;
string refType = this.txt_RefType.Text;
string runType = "EXPORTREF";//SEF/SEL/SEC/ SCF/SCL/SCC/ SAE/SAC/SLT
if (refType == "SAE")
{
runType = "AirExport";
}
else if (refType == "SAC")
{
runType = "AirCrossTrade";
}
else if (refType == "SCF" || refType == "SCL" || refType == "SCC")
{
runType = "SeaCrossTrade";
}
else if (refType == "SLT")
{
runType = "LocalTpt";
}
bool isNew = false;
if (expRef == null)
{
expRef = new SeaExportRef();
isNew = true;
expRef.RefType = refType;
expRef.RefNo = C2Setup.GetNextNo(refType, runType, refDate.Date);
expRef.RefDate = refDate.Date;
}
ASPxTextBox ves = pageControl.FindControl("txt_Ves") as ASPxTextBox;
expRef.Vessel = ves.Text;
ASPxTextBox voy = pageControl.FindControl("txt_Voy") as ASPxTextBox;
expRef.Voyage = voy.Text;
ASPxButtonEdit pol = pageControl.FindControl("txt_Pol") as ASPxButtonEdit;
expRef.Pol = pol.Text;
ASPxButtonEdit pod = pageControl.FindControl("txt_Pod") as ASPxButtonEdit;
expRef.Pod = pod.Text;
ASPxButtonEdit portFin = pageControl.FindControl("txt_PortFinName") as ASPxButtonEdit;
expRef.FinDest = portFin.Text;
ASPxTextBox jobType = pageControl.FindControl("cbx_JobType") as ASPxTextBox;
expRef.JobType = jobType.Text;
ASPxDateEdit eta = pageControl.FindControl("date_Eta") as ASPxDateEdit;
expRef.Eta = eta.Date;
ASPxDateEdit etd = pageControl.FindControl("date_Etd") as ASPxDateEdit;
expRef.Etd = etd.Date;
ASPxDateEdit etaDest = pageControl.FindControl("date_EtaDest") as ASPxDateEdit;
expRef.EtaDest = etaDest.Date;
ASPxButtonEdit crAgentId = pageControl.FindControl("txt_CrAgentId") as ASPxButtonEdit;
expRef.CrAgentId = crAgentId.Text;
ASPxTextBox crBkgRefN = pageControl.FindControl("txt_CrBkgRefN") as ASPxTextBox;
expRef.CrBkgNo = crBkgRefN.Text;
ASPxButtonEdit whId = pageControl.FindControl("txt_WhId") as ASPxButtonEdit;
expRef.WarehouseId = whId.Text;
ASPxDateEdit stuffD = pageControl.FindControl("date_Stuff") as ASPxDateEdit;
expRef.StuffDate = stuffD.Date;
ASPxButtonEdit nvoccAgentId = pageControl.FindControl("txt_NvoccAgentId") as ASPxButtonEdit;
expRef.NvoccAgentId = nvoccAgentId.Text;
ASPxTextBox nvoccBl = pageControl.FindControl("txt_NvoccBl") as ASPxTextBox;
expRef.NvoccBl = nvoccBl.Text;
ASPxSpinEdit transitDay = pageControl.FindControl("spin_Ref_TransitDay") as ASPxSpinEdit;
expRef.TransitDay = SafeValue.SafeInt(transitDay.Value, 0);
ASPxButtonEdit localCust = pageControl.FindControl("txt_LocalCust") as ASPxButtonEdit;
expRef.LocalCust = localCust.Text;
ASPxButtonEdit agentId = pageControl.FindControl("txt_AgentId") as ASPxButtonEdit;
expRef.AgentId = agentId.Text;
ASPxComboBox schFax = pageControl.FindControl("cbx_SchFaxInd") as ASPxComboBox;
expRef.SchFaxInd = schFax.Text;
ASPxTextBox oceanBl = pageControl.FindControl("txt_OceanBl") as ASPxTextBox;
expRef.OblNo = oceanBl.Text;
ASPxComboBox term = pageControl.FindControl("cbx_Term") as ASPxComboBox;
expRef.OblTerm = SafeValue.SafeString(term.Value);
ASPxComboBox express = pageControl.FindControl("cbx_ExpressBl") as ASPxComboBox;
expRef.ExpressBl = express.Text;
ASPxButtonEdit currency = pageControl.FindControl("cbx_Currency") as ASPxButtonEdit;
ASPxSpinEdit crExRate = pageControl.FindControl("spin_CrExRate") as ASPxSpinEdit;
expRef.CurrencyId = currency.Text;
expRef.ExRate = crExRate.Number;
ASPxMemo shipper = pageControl.FindControl("txt_Shipper2") as ASPxMemo;
expRef.SShipperRemark = shipper.Text;
ASPxMemo con = pageControl.FindControl("txt_Consigee2") as ASPxMemo;
expRef.SConsigneeRemark = con.Text;
ASPxMemo party = pageControl.FindControl("txt_Party2") as ASPxMemo;
expRef.SNotifyPartyRemark = party.Text;;
ASPxMemo agt = pageControl.FindControl("txt_Agt2") as ASPxMemo;
expRef.SAgentRemark = agt.Text;
//haulier info
ASPxSpinEdit haulierQty = pageControl.FindControl("spin_HaulierPkgs") as ASPxSpinEdit;
ASPxTextBox haulierPkgType = pageControl.FindControl("txt_HaulierPkgsType") as ASPxTextBox;
ASPxSpinEdit haulierWt = pageControl.FindControl("spin_HaulierWt") as ASPxSpinEdit;
ASPxSpinEdit haulierM3 = pageControl.FindControl("spin_HaulierM3") as ASPxSpinEdit;
expRef.HaulierQty = SafeValue.SafeInt(haulierQty.Value, 0);
ASPxTextBox haulier = pageControl.FindControl("txt_Ref_H_Hauler") as ASPxTextBox;
expRef.HaulierName = haulier.Text;
ASPxTextBox crno = pageControl.FindControl("txt_Ref_H_CrNo") as ASPxTextBox;
expRef.HaulierCrNo = crno.Text;
ASPxTextBox fax = pageControl.FindControl("txt_Ref_H_Fax") as ASPxTextBox;
expRef.HaulierFax = fax.Text;
ASPxTextBox attention = pageControl.FindControl("txt_Ref_H_Attention") as ASPxTextBox;
expRef.HaulierAttention = attention.Text;
ASPxMemo collectFrm1 = pageControl.FindControl("txt_Ref_H_CltFrm") as ASPxMemo;
expRef.HaulierCollect = collectFrm1.Text;
ASPxMemo truckTo1 = pageControl.FindControl("txt_Ref_H_TruckTo") as ASPxMemo;
expRef.HaulierTruck = truckTo1.Text;
ASPxDateEdit collectDate = pageControl.FindControl("date_Ref_H_CltDate") as ASPxDateEdit;
expRef.HaulierCollectDate = collectDate.Date;
ASPxTextBox collectTime = pageControl.FindControl("date_Ref_H_CltTime") as ASPxTextBox;
expRef.HaulierCollectTime = collectTime.Text;
ASPxMemo haulerRmk = pageControl.FindControl("txt_Ref_H_Rmk1") as ASPxMemo;
expRef.HaulierRemark = haulerRmk.Text;
ASPxTextBox txt_DriverName = pageControl.FindControl("txt_DriverName") as ASPxTextBox;
expRef.DriverName = txt_DriverName.Text;
ASPxTextBox txt_DriverMobile = pageControl.FindControl("txt_DriverMobile") as ASPxTextBox;
expRef.DriverMobile = txt_DriverMobile.Text;
ASPxTextBox txt_DriverLicense = pageControl.FindControl("txt_DriverLicense") as ASPxTextBox;
expRef.DriverLicense = txt_DriverLicense.Text;
ASPxTextBox txt_VehicleNo = pageControl.FindControl("txt_VehicleNo") as ASPxTextBox;
expRef.VehicleNo = txt_VehicleNo.Text;
ASPxTextBox txt_VehicleType = pageControl.FindControl("txt_VehicleType") as ASPxTextBox;
expRef.VehicleType = txt_VehicleType.Text;
ASPxTextBox me_DriverRemark = pageControl.FindControl("me_DriverRemark") as ASPxTextBox;
expRef.DriverRemark = me_DriverRemark.Text;
ASPxDateEdit h_deliveryDate = pageControl.FindControl("date_Ref_H_DlvDate") as ASPxDateEdit;
expRef.HaulierDeliveryDate = h_deliveryDate.Date;
ASPxTextBox h_deliveryTime = pageControl.FindControl("date_Ref_H_DlvTime") as ASPxTextBox;
expRef.HaulierDeliveryTime = h_deliveryTime.Text;
ASPxTextBox sendTo = pageControl.FindControl("txt_H_SendTo") as ASPxTextBox;
expRef.HaulierSendTo = sendTo.Text;
ASPxTextBox stuffBy = pageControl.FindControl("txt_H_StuffBy") as ASPxTextBox;
expRef.HaulierStuffBy = stuffBy.Text;
ASPxTextBox coload = pageControl.FindControl("txt_H_Coload") as ASPxTextBox;
expRef.HaulierCoload = coload.Text;
ASPxTextBox person = pageControl.FindControl("txt_H_Person") as ASPxTextBox;
expRef.HaulierPerson = person.Text;
ASPxTextBox personTel = pageControl.FindControl("txt_H_PersonTel") as ASPxTextBox;
expRef.HaulierPersonTel = personTel.Text;
ASPxMemo permit = pageControl.FindControl("txt_Hbl_Permit") as ASPxMemo;
expRef.PermitRmk = permit.Text;
if (expRef.HaulierQty == 0)
{
expRef.HaulierQty = expRef.Qty;
}
expRef.HaulierPkgType = haulierPkgType.Text;
if (SafeValue.SafeString(expRef.HaulierPkgType, "").Length == 0)
{
expRef.HaulierPkgType = expRef.PackageType;
}
expRef.HaulierM3 = SafeValue.SafeDecimal(haulierM3.Value, 0);
if (expRef.HaulierM3 == 0)
{
expRef.HaulierM3 = expRef.Volume;
}
expRef.HaulierWt = SafeValue.SafeDecimal(haulierWt.Value, 0);
if (expRef.HaulierWt == 0)
{
expRef.HaulierWt = expRef.Weight;
}
ASPxMemo rmk = pageControl.FindControl("txt_Rmk") as ASPxMemo;
expRef.Remark = rmk.Text;
ASPxTextBox portnetNo = pageControl.FindControl("txt_PortnetNo") as ASPxTextBox;
expRef.PortnetNo = portnetNo.Text;
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
expRef.Pol = SafeValue.SafeString(System.Configuration.ConfigurationManager.AppSettings["LocalPort"], "SGSIN");
expRef.CreateBy = userId;
expRef.CreateDateTime = DateTime.Now;
expRef.UpdateBy = userId;
expRef.UpdateDateTime = DateTime.Now;
expRef.StatusCode = "USE";
expRef.IsRef = true;
expRef.IsSch = false;
expRef.PoNo = this.txt_MasterNo.Text;
Manager.ORManager.StartTracking(expRef, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(expRef);
C2Setup.SetNextNo(refType, runType, expRef.RefNo, refDate.Date);
}
else
{
expRef.UpdateBy = userId;
expRef.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(expRef, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(expRef);
jobType.Enabled = false;
}
if (isNew)
{
Session["ExportMast_" + this.txt_RefType.Text] = "SequenceId=" + expRef.SequenceId;
this.dsExportRef.FilterExpression = Session["ExportMast_" + this.txt_RefType.Text].ToString();
if (this.grid_ref.GetRow(0) != null)
{
this.grid_ref.StartEdit(0);
}
}
}
catch { }
}
private void Save()
{
try
{
ASPxPageControl pageControl = this.grid_WhPoR.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txtId = pageControl.FindControl("txt_Id") as ASPxTextBox;
string id = SafeValue.SafeString(txtId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhPOReceipt), "Id='" + id + "'");
WhPOReceipt whPOR = C2.Manager.ORManager.GetObject(query) as WhPOReceipt;
bool isNew = false;
string porNo = "";
if (whPOR == null)
{
whPOR = new WhPOReceipt();
isNew = true;
porNo = C2Setup.GetNextNo("PurchaseOrdersReceipt");
}
ASPxTextBox txt_PartyRefNo = pageControl.FindControl("txt_PartyRefNo") as ASPxTextBox;
whPOR.PartyRefNo = txt_PartyRefNo.Text;
ASPxButtonEdit txt_PartyId = pageControl.FindControl("txt_PartyId") as ASPxButtonEdit;
whPOR.PartyId = txt_PartyId.Text;
ASPxDateEdit de_ReceiptDate = pageControl.FindControl("de_ReceiptDate") as ASPxDateEdit;
whPOR.ReceiptDate = de_ReceiptDate.Date;
ASPxComboBox cbo_ReceiptType = pageControl.FindControl("cbo_ReceiptType") as ASPxComboBox;
whPOR.ReceiptType = SafeValue.SafeString(cbo_ReceiptType.Value);
ASPxButtonEdit txt_WarehouseId = pageControl.FindControl("txt_WarehouseId") as ASPxButtonEdit;
whPOR.WarehouseId = txt_WarehouseId.Text;
ASPxButtonEdit txt_SalesmanId = pageControl.FindControl("txt_SalesmanId") as ASPxButtonEdit;
whPOR.SalesmanId = txt_SalesmanId.Text;
ASPxButtonEdit txt_Currency = pageControl.FindControl("txt_Currency") as ASPxButtonEdit;
whPOR.Currency = txt_Currency.Text;
ASPxSpinEdit spin_ExRate = pageControl.FindControl("spin_ExRate") as ASPxSpinEdit;
whPOR.ExRate = SafeValue.SafeDecimal(spin_ExRate.Value, 1);
ASPxMemo txt_Remark = pageControl.FindControl("txt_Remark") as ASPxMemo;
whPOR.Remark = txt_Remark.Text;
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
whPOR.CreateBy = userId;
whPOR.CreateDateTime = DateTime.Now;
whPOR.ReceiptNo = porNo.ToString();
whPOR.StatusCode = "USE";
Manager.ORManager.StartTracking(whPOR, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(whPOR);
C2Setup.SetNextNo("PurchaseOrdersReceipt", porNo);
}
else
{
whPOR.UpdateBy = userId;
whPOR.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(whPOR, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(whPOR);
}
Session["PORWhere"] = "ReceiptNo='" + whPOR.ReceiptNo + "'";
this.dsWhPOReceipt.FilterExpression = Session["PORWhere"].ToString();
if (this.grid_WhPoR.GetRow(0) != null)
{
this.grid_WhPoR.StartEdit(0);
}
}
catch { }
}
private string job_save()
{
string res = "";
try
{
ASPxPageControl pageControl = this.grid_job.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_JobNo = this.grid_job.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox;
string jobNo = SafeValue.SafeString(txt_JobNo.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + jobNo + "'");
C2.CtmJob ctmJob = C2.Manager.ORManager.GetObject(query) as C2.CtmJob;
ASPxDateEdit jobDate = this.grid_job.FindEditFormTemplateControl("txt_JobDate") as ASPxDateEdit;
bool isNew = false;
if (ctmJob == null)
{
isNew = true;
ctmJob = new C2.CtmJob();
ctmJob.JobNo = C2Setup.GetNextNo("", "CTM_Job", jobDate.Date);
}
ASPxComboBox cbb_JobType = this.grid_job.FindEditFormTemplateControl("cbb_JobType") as ASPxComboBox;
ASPxButtonEdit btn_ClientId = this.grid_job.FindEditFormTemplateControl("btn_ClientId") as ASPxButtonEdit;
ASPxTextBox txt_ClientRefNo = this.grid_job.FindEditFormTemplateControl("txt_ClientRefNo") as ASPxTextBox;
ASPxTextBox txt_notifiEmail = this.grid_job.FindEditFormTemplateControl("txt_notifiEmail") as ASPxTextBox;
ASPxButtonEdit btn_SubClientId = this.grid_job.FindEditFormTemplateControl("btn_SubClientId") as ASPxButtonEdit;
ASPxButtonEdit txt_WareHouseId = this.grid_job.FindEditFormTemplateControl("txt_WareHouseId") as ASPxButtonEdit;
ASPxTextBox txt_ClientContact = this.grid_job.FindEditFormTemplateControl("txt_ClientContact") as ASPxTextBox;
ctmJob.ClientContact = SafeValue.SafeString(txt_ClientContact.Text);
ctmJob.JobDate = SafeValue.SafeDate(jobDate.Date, new DateTime(1753, 1, 1));
ctmJob.JobType = cbb_JobType.Text;
ctmJob.ClientId = btn_ClientId.Text;
ctmJob.ClientRefNo = txt_ClientRefNo.Text;
ctmJob.EmailAddress = txt_notifiEmail.Text;
ctmJob.SubClientId = btn_SubClientId.Text;
if (txt_WareHouseId != null)
{
ctmJob.WareHouseCode = txt_WareHouseId.Text;
}
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
ctmJob.StatusCode = "USE";
ctmJob.CreateBy = userId;
ctmJob.CreateDateTime = DateTime.Now;
ctmJob.UpdateBy = userId;
ctmJob.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(ctmJob);
}
else
{
ctmJob.UpdateBy = userId;
ctmJob.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(ctmJob);
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isJOB(ctmJob.Id);
elog.Remark = "Job Update";
elog.log();
}
if (isNew)
{
txt_JobNo.Text = ctmJob.JobNo;
//txt_search_JobNo.Text = txt_JobNo.Text;
C2Setup.SetNextNo("", "CTM_Job", ctmJob.JobNo, jobDate.Date);
}
//res = Job_Check_JobLevel(ctmJob.JobNo);
Session["CTM_Job_" + txt_search_JobNo.Text] = "JobNo='" + ctmJob.JobNo + "'";
this.dsJob.FilterExpression = Session["CTM_Job_" + txt_search_JobNo.Text].ToString();
if (this.grid_job.GetRow(0) != null)
{
this.grid_job.StartEdit(0);
}
}
catch { }
return(res);
}
protected void AddOrUpdate()
{
try
{
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_Id = this.grid.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
ASPxTextBox txt_Name = grid.FindEditFormTemplateControl("txt_Name") as ASPxTextBox;
ASPxTextBox txtIcNo = pageControl.FindControl("txtIcNo") as ASPxTextBox;
string Id = SafeValue.SafeString(txt_Id.Text, "");
string name = txt_Name.Text;
//throw new Exception(name);
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(HrPerson), "Id='" + Id + "'");
HrPerson person = C2.Manager.ORManager.GetObject(query) as HrPerson;
bool action = false;
if (SafeValue.SafeString(txt_Name.Text, "") == "")
{
throw new Exception("Name not be null!!!");
return;
}
//if (SafeValue.SafeString(txtIcNo.Text,"") == "")
//{
// throw new Exception("Ic No not be null!!!");
// return;
//}
string sql = string.Format(@"select count(*) from Hr_Person where IcNo='{0}' and Id<>{1}", SafeValue.SafeString(txtIcNo.Text, ""), SafeValue.SafeString(txt_Id.Text, "0"));
//string sql=string.Format(@"select count(*) from Hr_Person where Id={0}",SafeValue.SafeString(txt_Id.Text,""),SafeValue.SafeString(txt_Name.Text,""));
//throw new Exception(sql);
int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (cnt > 0)
{
throw new Exception("Please enter another value of the Ic No again!");
return;
}
if (person == null || person.Id == 0)
{
action = true;
person = new HrPerson();
}
//throw new Exception(name);
person.Name = name;
ASPxTextBox interviewId = this.grid.FindEditFormTemplateControl("txt_InterviewId") as ASPxTextBox;
person.InterviewId = SafeValue.SafeString(interviewId.Text, "");
ASPxTextBox recruitId = this.grid.FindEditFormTemplateControl("txt_RecruitId") as ASPxTextBox;
person.RecruitId = SafeValue.SafeString(recruitId.Text, "");
ASPxComboBox gender = pageControl.FindControl("cbo_Gender") as ASPxComboBox;
person.Gender = gender.Text;
ASPxTextBox icno = pageControl.FindControl("txtIcNo") as ASPxTextBox;
person.IcNo = icno.Text;
ASPxDateEdit birthday = pageControl.FindControl("date_Birthday") as ASPxDateEdit;
person.BirthDay = birthday.Date;
ASPxTextBox ss1 = pageControl.FindControl("txt_s1") as ASPxTextBox;
person.Status1 = S.Text(ss1.Text);
ASPxTextBox ss2 = pageControl.FindControl("txt_s2") as ASPxTextBox;
person.Status2 = S.Text(ss2.Text);
ASPxDateEdit dd1 = pageControl.FindControl("date_d1") as ASPxDateEdit;
person.Date1 = S.Date(dd1.Date);
ASPxDateEdit dd2 = pageControl.FindControl("date_d2") as ASPxDateEdit;
person.Date2 = S.Date(dd2.Date);
ASPxButtonEdit country = pageControl.FindControl("txt_Country") as ASPxButtonEdit;
person.Country = country.Text;
ASPxTextBox race = pageControl.FindControl("txt_Race") as ASPxTextBox;
person.Race = race.Text;
ASPxTextBox religion = pageControl.FindControl("txt_Religion") as ASPxTextBox;
person.Religion = religion.Text;
ASPxCheckBox married = pageControl.FindControl("ckb_Married") as ASPxCheckBox;
if (married.Checked)
{
person.Married = "Y";
}
else
{
person.Married = "N";
}
ASPxTextBox telephone = pageControl.FindControl("txt_Telephone") as ASPxTextBox;
person.Telephone = telephone.Text;
ASPxTextBox email = pageControl.FindControl("txt_Email") as ASPxTextBox;
person.Email = email.Text;
ASPxComboBox hrGroup = pageControl.FindControl("cmb_HrGroup") as ASPxComboBox;
person.HrGroup = hrGroup.Text;
ASPxComboBox department = pageControl.FindControl("cmb_Department") as ASPxComboBox;
person.Department = department.Text;
ASPxComboBox hrRole = pageControl.FindControl("cmb_Role") as ASPxComboBox;
person.HrRole = hrRole.Text;
ASPxMemo address = pageControl.FindControl("memo_Address") as ASPxMemo;
person.Address = address.Text;
ASPxMemo remark = pageControl.FindControl("memo_Remark") as ASPxMemo;
person.Remark = remark.Text;
ASPxMemo remark1 = pageControl.FindControl("memo_Profile") as ASPxMemo;
person.Remark1 = remark1.Text;
ASPxMemo remark2 = pageControl.FindControl("memo_Work") as ASPxMemo;
person.Remark2 = remark2.Text;
ASPxMemo remark3 = pageControl.FindControl("memo_Education") as ASPxMemo;
person.Remark3 = remark3.Text;
ASPxMemo remark4 = pageControl.FindControl("memo_Family") as ASPxMemo;
person.Remark4 = remark4.Text;
ASPxMemo remark5 = pageControl.FindControl("memo_Emergency") as ASPxMemo;
person.Remark5 = remark5.Text;
ASPxSpinEdit spin_Amount1 = pageControl.FindControl("spin_Amount1") as ASPxSpinEdit;
person.Amount1 = SafeValue.SafeDecimal(spin_Amount1.Value);
ASPxSpinEdit spin_Amount2 = pageControl.FindControl("spin_Amount2") as ASPxSpinEdit;
person.Amount2 = SafeValue.SafeDecimal(spin_Amount2.Value);
ASPxSpinEdit spin_Amount3 = pageControl.FindControl("spin_Amount3") as ASPxSpinEdit;
person.Amount3 = SafeValue.SafeDecimal(spin_Amount3.Value);
//throw new Exception(person.Name);
if (action)
{
person.Status = txt_Status.Text;
person.CreateBy = HttpContext.Current.User.Identity.Name;
person.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(person, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(person);
}
else
{
ASPxComboBox newStatus = grid.FindEditFormTemplateControl("cmb_Type") as ASPxComboBox;
person.Status = newStatus.Text;
string oldStatus = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(string.Format("select Status from Hr_Person where Id={0}", Id)));
if (oldStatus != SafeValue.SafeString(newStatus.Text))
{
this.grid.CancelEdit();
}
//this.Response.Write("<script>if(confirm('Confirm change this'+txt_Status.GetText()+' To'+cmb_Type.GetText()+'?')){alert('Sucess!');};</script>");
person.UpdateBy = HttpContext.Current.User.Identity.Name;
person.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(person, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(person);
}
Session["PersonWhere" + txt_Status.Text] = "Id='" + person.Id + "' and Status='" + txt_Status.Text + "'";
this.dsPerson.FilterExpression = Session["PersonWhere" + txt_Status.Text].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
else
{
Session["PersonWhere" + txt_Status.Text] = "Id>0 and Status='" + txt_Status.Text + "'";
this.dsPerson.FilterExpression = Session["PersonWhere" + txt_Status.Text].ToString();
}
}
catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); }
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxTextBox invNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
ASPxTextBox title = this.ASPxGridView1.FindEditFormTemplateControl("txt_Title") as ASPxTextBox;
ASPxButtonEdit partyTo = this.ASPxGridView1.FindEditFormTemplateControl("txt_CustId") as ASPxButtonEdit;
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxDateEdit docDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocDt") as ASPxDateEdit;
ASPxMemo note = this.ASPxGridView1.FindEditFormTemplateControl("txt_Note") as ASPxMemo;
ASPxMemo rmk = this.ASPxGridView1.FindEditFormTemplateControl("txt_Remarks1") as ASPxMemo;
// ASPxComboBox termId = this.ASPxGridView1.FindEditFormTemplateControl("txt_TermId") as ASPxComboBox;
ASPxDateEdit expireDt = this.ASPxGridView1.FindEditFormTemplateControl("txt_toDt") as ASPxDateEdit;
ASPxButtonEdit docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit;
ASPxButtonEdit pol = this.ASPxGridView1.FindEditFormTemplateControl("txt_Pol") as ASPxButtonEdit;
ASPxButtonEdit pod = this.ASPxGridView1.FindEditFormTemplateControl("txt_Pod") as ASPxButtonEdit;
ASPxButtonEdit viaPort = this.ASPxGridView1.FindEditFormTemplateControl("txt_ViaPort") as ASPxButtonEdit;
ASPxTextBox frequency = this.ASPxGridView1.FindEditFormTemplateControl("txt_Frequency") as ASPxTextBox;
ASPxTextBox attention = this.ASPxGridView1.FindEditFormTemplateControl("txt_Attention") as ASPxTextBox;
ASPxTextBox tsDay = this.ASPxGridView1.FindEditFormTemplateControl("spin_TsDay") as ASPxTextBox;
//ASPxSpinEdit gp20 = this.ASPxGridView1.FindEditFormTemplateControl("spin_Gp20") as ASPxSpinEdit;
// ASPxSpinEdit gp40 = this.ASPxGridView1.FindEditFormTemplateControl("spin_Gp40") as ASPxSpinEdit;
//ASPxSpinEdit hc40 = this.ASPxGridView1.FindEditFormTemplateControl("spin_Hc40") as ASPxSpinEdit;
ASPxComboBox contType = this.ASPxGridView1.FindEditFormTemplateControl("cbx_ContType") as ASPxComboBox;
ASPxSpinEdit contPrice = this.ASPxGridView1.FindEditFormTemplateControl("spin_contPrice") as ASPxSpinEdit;
ASPxSpinEdit exRate = this.ASPxGridView1.FindEditFormTemplateControl("spin_exRate") as ASPxSpinEdit;
string invN = docN.Text;
C2.SeaQuote1 inv = Manager.ORManager.GetObject(typeof(SeaQuote1), SafeValue.SafeInt(invNCtr.Text, 0)) as SeaQuote1;
if (inv == null)// first insert invoice
{
string counterType = "SeaFcl-Quotation";
inv = new SeaQuote1();
invN = C2Setup.GetNextNo(counterType);
inv.Title = title.Text;
inv.PartyTo = SafeValue.SafeString(partyTo.Value, "");
inv.QuoteNo = invN.ToString();
inv.QuoteDate = docDate.Date;
inv.ImpExpInd = "E";
inv.FclLclInd = "Fcl";
// inv.Term = termId.Text;
//inv.DocFromDate =SafeValue.SafeDate(fromDt.Text, DateTime.Now);
inv.ExpireDate = SafeValue.SafeDate(expireDt.Text, DateTime.Now);
inv.Rmk = rmk.Text;
inv.Note = note.Text;
inv.CurrencyId = docCurr.Text.ToString();
inv.Frequency = frequency.Text;
inv.Pol = pol.Text;
inv.Pod = pod.Text;
inv.ViaPort = viaPort.Text;
inv.Attention = attention.Text;
inv.TransmitDay = tsDay.Text;
inv.Gp20 = 0; // SafeValue.SafeDecimal(gp20.Value, 0);
inv.Gp40 = 0; //SafeValue.SafeDecimal(gp40.Value, 0);
inv.Hc40 = 0; //SafeValue.SafeDecimal(hc40.Value, 0);
inv.ContType = contType.Text;
inv.ContPrice = SafeValue.SafeDecimal(contPrice.Value, 0);
inv.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
inv.CreateUser = HttpContext.Current.User.Identity.Name;
inv.CreateDate = DateTime.Now;
inv.UpdateUser = HttpContext.Current.User.Identity.Name;
inv.UpdateDate = DateTime.Now;
try
{
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(inv);
C2Setup.SetNextNo(counterType, inv.QuoteNo);
}
catch
{
}
}
else
{
inv.Title = title.Text;
inv.PartyTo = SafeValue.SafeString(partyTo.Value, "");
inv.ExpireDate = SafeValue.SafeDate(expireDt.Text, DateTime.Now);
inv.Rmk = rmk.Text;
inv.Note = note.Text;
inv.CurrencyId = docCurr.Text.ToString();
inv.Pol = pol.Text;
inv.Pod = pod.Text;
inv.ViaPort = viaPort.Text;
inv.Attention = attention.Text;
inv.TransmitDay = tsDay.Text;
inv.Gp20 = 0; // SafeValue.SafeDecimal(gp20.Value, 0);
inv.Gp40 = 0; //SafeValue.SafeDecimal(gp40.Value, 0);
inv.Hc40 = 0; //SafeValue.SafeDecimal(hc40.Value, 0);
inv.ContType = contType.Text;
inv.ContPrice = SafeValue.SafeDecimal(contPrice.Value, 0);
inv.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
inv.Frequency = frequency.Text;
inv.UpdateUser = HttpContext.Current.User.Identity.Name;
inv.UpdateDate = DateTime.Now;
try
{
Manager.ORManager.StartTracking(inv, InitialState.Updated);
Manager.ORManager.PersistChanges(inv);
}
catch
{
}
}
Session["SeaQuoteEditWhere"] = "SequenceId=" + inv.SequenceId;
this.dsQuotation.FilterExpression = Session["SeaQuoteEditWhere"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
protected void AddOrUpdate()
{
ASPxTextBox txt_pId = this.grid.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string pId = SafeValue.SafeString(txt_pId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhTransfer), "Id='" + pId + "'");
WhTransfer transfer = C2.Manager.ORManager.GetObject(query) as WhTransfer;
bool action = false;
string transferNo = "";
if (transfer == null)
{
action = true;
transfer = new WhTransfer();
transferNo = C2Setup.GetNextNo("Transfer");
}
ASPxTextBox txt_TransferNo = this.grid.FindEditFormTemplateControl("txt_TransferNo") as ASPxTextBox;
transfer.TransferNo = txt_TransferNo.Text.Trim();
ASPxTextBox txt_RequestPerson = this.grid.FindEditFormTemplateControl("txt_RequestPerson") as ASPxTextBox;
transfer.RequestPerson = txt_RequestPerson.Text;
ASPxDateEdit de_RequestDate = this.grid.FindEditFormTemplateControl("de_RequestDate") as ASPxDateEdit;
transfer.RequestDate = de_RequestDate.Date;
ASPxDateEdit de_TransferDate = this.grid.FindEditFormTemplateControl("de_TransferDate") as ASPxDateEdit;
transfer.TransferDate = de_TransferDate.Date;
//ASPxComboBox cbo_StatusCode =this.grid.FindEditFormTemplateControl("cbo_StatusCode") as ASPxComboBox;
//transfer.StatusCode = cbo_StatusCode.Text;
ASPxTextBox txt_Pic = this.grid.FindEditFormTemplateControl("txt_Pic") as ASPxTextBox;
transfer.Pic = txt_Pic.Text;
ASPxTextBox txt_ConfirmPerson = this.grid.FindEditFormTemplateControl("txt_ConfirmPerson") as ASPxTextBox;
transfer.ConfirmPerson = txt_ConfirmPerson.Text;
ASPxDateEdit de_ConfirmDate = this.grid.FindEditFormTemplateControl("de_ConfirmDate") as ASPxDateEdit;
transfer.ConfirmDate = de_ConfirmDate.Date;
ASPxTextBox txt_UomWhole = this.grid.FindEditFormTemplateControl("txt_UomWhole") as ASPxTextBox;
ASPxButtonEdit txt_PartyId = this.grid.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit;
transfer.PartyId = txt_PartyId.Text;
ASPxTextBox txt_PartyName = this.grid.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox;
transfer.PartyName = txt_PartyName.Text;
if (action)
{
transfer.TransferNo = transferNo;
transfer.CreateBy = HttpContext.Current.User.Identity.Name;
transfer.CreateDateTime = DateTime.Now;
C2Setup.SetNextNo("Transfer", transferNo);
Manager.ORManager.StartTracking(transfer, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(transfer);
Session["NameWhere"] = "TransferNo='" + transferNo + "'";
this.dsTransfer.FilterExpression = Session["NameWhere"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
}
else
{
transfer.UpdateBy = HttpContext.Current.User.Identity.Name;
transfer.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(transfer, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(transfer);
}
}
protected void SaveJob()
{
try
{
ASPxGridView g = this.grid_Transport;
ASPxTextBox houseId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
int Id = SafeValue.SafeInt(houseId.Text, 0);
ASPxTextBox docNo = g.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(ContAsset), "Id='" + Id + "'");
ContAsset contA = C2.Manager.ORManager.GetObject(query) as ContAsset;
bool isNew = false;
if (Id == 0)
{
isNew = true;
contA = new ContAsset();
contA.DocNo = C2Setup.GetNextNo("StoringOrder");
contA.DocType = "SO";
}
ASPxTextBox jobNo = g.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox;
contA.JobNo = jobNo.Text;
ASPxComboBox depotCode = g.FindEditFormTemplateControl("cmb_DepotCode") as ASPxComboBox;
contA.DepotCode = depotCode.Text;
ASPxTextBox shipVessel = g.FindEditFormTemplateControl("txt_ShipVessel") as ASPxTextBox;
contA.ShipVessel = shipVessel.Text;
ASPxTextBox shipVoyage = g.FindEditFormTemplateControl("txt_ShipVoyage") as ASPxTextBox;
contA.ShipVoyage = shipVoyage.Text;
ASPxDateEdit shipEta = g.FindEditFormTemplateControl("date_ShipEta") as ASPxDateEdit;
contA.ShipEta = shipEta.Date;
ASPxDateEdit shipEtd = g.FindEditFormTemplateControl("date_ShipEtd") as ASPxDateEdit;
contA.ShipEtd = shipEtd.Date;
ASPxButtonEdit shipPol = g.FindEditFormTemplateControl("btn_ShipPol") as ASPxButtonEdit;
contA.ShipPol = shipPol.Text;
ASPxButtonEdit shipPod = g.FindEditFormTemplateControl("btn_ShipPod") as ASPxButtonEdit;
contA.ShipPod = shipPod.Text;
ASPxMemo shipNote = g.FindEditFormTemplateControl("txt_ShipNote") as ASPxMemo;
contA.ShipNote = shipNote.Text;
ASPxButtonEdit shipCarrierCode = g.FindEditFormTemplateControl("btn_ShipCarrierCode") as ASPxButtonEdit;
contA.ShipCarrierCode = shipCarrierCode.Text;
ASPxTextBox shipCarrierRef = g.FindEditFormTemplateControl("txt_ShipCarrierRef") as ASPxTextBox;
contA.ShipCarrierRef = shipCarrierRef.Text;
ASPxTextBox demurrageRef = g.FindEditFormTemplateControl("txt_DemurrageRef") as ASPxTextBox;
contA.DemurrageRef = demurrageRef.Text;
ASPxSpinEdit demurrageFreeDay = g.FindEditFormTemplateControl("spin_DemurrageFreeDay") as ASPxSpinEdit;
contA.DemurrageFreeDay = SafeValue.SafeInt(demurrageFreeDay.Text, 0);
ASPxDateEdit demurrageStartDate = g.FindEditFormTemplateControl("date_DemurrageStartDate") as ASPxDateEdit;
contA.DemurrageStartDate = demurrageStartDate.Date;
ASPxTextBox detentionRef = g.FindEditFormTemplateControl("txt_DetentionRef") as ASPxTextBox;
contA.DetentionRef = detentionRef.Text;
ASPxSpinEdit detentionFreeDay = g.FindEditFormTemplateControl("spin_DetentionFreeDay") as ASPxSpinEdit;
contA.DetentionFreeDay = SafeValue.SafeInt(detentionFreeDay.Text, 0);
ASPxDateEdit detentionStartDate = g.FindEditFormTemplateControl("date_DetentionStartDate") as ASPxDateEdit;
contA.DetentionStartDate = detentionStartDate.Date;
ASPxComboBox returnType = g.FindEditFormTemplateControl("cmb_ReturnType") as ASPxComboBox;
contA.ReturnType = returnType.Text;
ASPxButtonEdit shipperCode = g.FindEditFormTemplateControl("btn_ShipperCode") as ASPxButtonEdit;
contA.ShipperCode = shipperCode.Text;
ASPxTextBox shipperName = g.FindEditFormTemplateControl("txt_ShipperName") as ASPxTextBox;
contA.ShipperName = shipperName.Text;
ASPxButtonEdit consigneeCode = g.FindEditFormTemplateControl("btn_ConsigneeCode") as ASPxButtonEdit;
contA.ConsigneeCode = consigneeCode.Text;
ASPxTextBox consigneeName = g.FindEditFormTemplateControl("txt_ConsigneeName") as ASPxTextBox;
contA.ConsigneeName = consigneeName.Text;
ASPxButtonEdit haulierCode = g.FindEditFormTemplateControl("btn_HaulierCode") as ASPxButtonEdit;
contA.HaulierCode = haulierCode.Text;
ASPxDateEdit haulierCompleteDate = g.FindEditFormTemplateControl("date_HaulierCompleteDate") as ASPxDateEdit;
contA.HaulierCompleteDate = haulierCompleteDate.Date;
ASPxTextBox instruction = g.FindEditFormTemplateControl("txt_Instruction") as ASPxTextBox;
contA.Instruction = instruction.Text;
if (isNew)
{
contA.CreateBy = EzshipHelper.GetUserName();
contA.CreateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(contA, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(contA);
C2Setup.SetNextNo("StoringOrder", contA.DocNo);
houseId.Text = contA.Id.ToString();
//this.txt_JobNo.Text = tpt1.JobNo;
docNo.Text = contA.DocNo;
Session["ExpWhere"] = "Id='" + contA.Id + "'";
this.dsTransport.FilterExpression = Session["ExpWhere"].ToString();
if (this.grid_Transport.GetRow(0) != null)
{
this.grid_Transport.StartEdit(0);
}
}
else
{
contA.UpdateBy = EzshipHelper.GetUserName();
contA.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(contA, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(contA);
string sql = "update cont_assetEvent set pod='" + shipPod.Text + "',pol='" + shipPol.Text + "' where docNo='" + docNo.Text + "' ";
C2.Manager.ORManager.ExecuteCommand(sql);
}
}
catch (Exception ex)
{ throw new Exception(ex.Message + ex.StackTrace); }
}
private void Save()
{
try
{
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txtId = pageControl.FindControl("txt_Id") as ASPxTextBox;
string id = SafeValue.SafeString(txtId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhSORelease), "Id='" + id + "'");
WhSORelease obj = C2.Manager.ORManager.GetObject(query) as WhSORelease;
bool isNew = false;
string soNo = "";
if (obj == null)
{
obj = new WhSORelease();
isNew = true;
soNo = C2Setup.GetNextNo("SaleOrdersRelease");
}
ASPxTextBox txt_PartyRefNo = pageControl.FindControl("txt_PartyRefNo") as ASPxTextBox;
obj.PartyRefNo = txt_PartyRefNo.Text;
ASPxButtonEdit txt_PartyId = pageControl.FindControl("txt_PartyId") as ASPxButtonEdit;
obj.PartyId = txt_PartyId.Text;
ASPxDateEdit de_ReleaseDate = pageControl.FindControl("de_ReleaseDate") as ASPxDateEdit;
obj.ReleaseDate = de_ReleaseDate.Date;
ASPxButtonEdit txt_WarehouseId = pageControl.FindControl("txt_WarehouseId") as ASPxButtonEdit;
obj.WarehouseId = txt_WarehouseId.Text;
ASPxButtonEdit txt_SalesmanId = pageControl.FindControl("txt_SalesmanId") as ASPxButtonEdit;
obj.SalesmanId = txt_SalesmanId.Text;
ASPxButtonEdit txt_Currency = pageControl.FindControl("txt_Currency") as ASPxButtonEdit;
obj.Currency = txt_Currency.Text;
ASPxSpinEdit spin_ExRate = pageControl.FindControl("spin_ExRate") as ASPxSpinEdit;
obj.ExRate = SafeValue.SafeDecimal(spin_ExRate.Value, 1);
ASPxMemo txt_Remark = pageControl.FindControl("txt_Remark") as ASPxMemo;
obj.Remark = txt_Remark.Text;
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
obj.CreateBy = userId;
obj.CreateDateTime = DateTime.Now;
obj.ReleaseNo = soNo.ToString();
obj.StatusCode = "USE";
Manager.ORManager.StartTracking(obj, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(obj);
C2Setup.SetNextNo("SaleOrdersRelease", soNo);
}
else
{
obj.UpdateBy = userId;
obj.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(obj, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(obj);
}
Session["SORWhere"] = "ReleaseNo='" + obj.ReleaseNo + "'";
this.dsWhSORelease.FilterExpression = Session["SORWhere"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
}
catch { }
}
private static string GetButtonEditProcessResultFunction(ASPxButtonEdit editor)
{
return("ProcessObjectEditResult(" + editor.ClientID + ")");
}
protected string SaveJob()
{
try
{
ASPxPageControl pageControl = this.grid_Transport.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox idCtr = pageControl.FindControl("txt_Id") as ASPxTextBox;
ASPxTextBox jobNoCtr = pageControl.FindControl("txt_JobNo") as ASPxTextBox;
string jobNo = jobNoCtr.Text;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.TptJob), "Id='" + idCtr.Text + "'");
C2.TptJob tj = C2.Manager.ORManager.GetObject(query) as C2.TptJob;
bool isNew = false;
bool isAddTripLog = false;
string runType = "LocalTpt";
ASPxDateEdit jobDate = pageControl.FindControl("date_JobDate") as ASPxDateEdit;
if (tj == null)
{
tj = new C2.TptJob();
isNew = true;
tj.JobType = this.txt_type.Text;
jobNo = C2Setup.GetNextNo(tj.JobType, runType, jobDate.Date);
tj.JobNo = jobNo;
}
tj.JobDate = jobDate.Date;
ASPxComboBox jobType = pageControl.FindControl("cmb_JobType") as ASPxComboBox;
tj.JobType = jobType.Text;
ASPxButtonEdit cust = pageControl.FindControl("btn_Cust") as ASPxButtonEdit;
tj.Cust = cust.Text;
ASPxTextBox bkgRef = pageControl.FindControl("txt_BkgRef") as ASPxTextBox;
tj.BkgRef = bkgRef.Text;
ASPxTextBox pic = pageControl.FindControl("txt_CustPic") as ASPxTextBox;
tj.CustPic = pic.Text;
ASPxTextBox email = pageControl.FindControl("txt_CustEmail") as ASPxTextBox;
tj.CustEmail = email.Text;
ASPxTextBox docNo = pageControl.FindControl("txt_CustDocNo") as ASPxTextBox;
tj.CustDocNo = docNo.Text;
ASPxComboBox custDocType = pageControl.FindControl("txt_CustDocType") as ASPxComboBox;
tj.CustDocType = custDocType.Text;
ASPxTextBox ves = pageControl.FindControl("txt_Ves") as ASPxTextBox;
tj.Vessel = ves.Text;
ASPxTextBox voy = pageControl.FindControl("txt_Voy") as ASPxTextBox;
tj.Voyage = voy.Text;
ASPxButtonEdit pol = pageControl.FindControl("txt_Pol") as ASPxButtonEdit;
tj.Pol = pol.Text;
ASPxButtonEdit pod = pageControl.FindControl("txt_Pod") as ASPxButtonEdit;
tj.Pod = pod.Text;
ASPxDateEdit eta = pageControl.FindControl("date_Eta") as ASPxDateEdit;
tj.Eta = eta.Date;
ASPxDateEdit etd = pageControl.FindControl("date_Etd") as ASPxDateEdit;
tj.Etd = etd.Date;
ASPxTextBox blRef = pageControl.FindControl("txt_BlRef") as ASPxTextBox;
tj.BlRef = blRef.Text;
ASPxDateEdit bkgDate = pageControl.FindControl("date_BkgDate") as ASPxDateEdit;
tj.BkgDate = SafeValue.SafeDate(bkgDate.Date, new DateTime(1753, 1, 1));
ASPxTextBox bkgTime = pageControl.FindControl("txt_BkgTime") as ASPxTextBox;
tj.BkgTime = bkgTime.Text;
ASPxTextBox jobRmk = pageControl.FindControl("txt_JobRmk") as ASPxTextBox;
tj.JobRmk = jobRmk.Text;
ASPxSpinEdit bkgqty = pageControl.FindControl("spin_BkgQty") as ASPxSpinEdit;
tj.BkgQty = SafeValue.SafeInt(bkgqty.Value, 0);
ASPxButtonEdit bkgpkgType = pageControl.FindControl("txt_BkgPackType") as ASPxButtonEdit;
tj.BkgPkgType = bkgpkgType.Text;
ASPxSpinEdit bkgwt = pageControl.FindControl("spin_BkgWt") as ASPxSpinEdit;
tj.BkgWt = SafeValue.SafeDecimal(bkgwt.Value, 0);
ASPxSpinEdit bkgm3 = pageControl.FindControl("spin_BkgM3") as ASPxSpinEdit;
tj.BkgM3 = SafeValue.SafeDecimal(bkgm3.Value, 0);
ASPxMemo pickFrm1 = pageControl.FindControl("txt_PickupFrm1") as ASPxMemo;
tj.PickFrm1 = pickFrm1.Text;
ASPxMemo deliveryTo1 = pageControl.FindControl("txt_DeliveryTo1") as ASPxMemo;
tj.DeliveryTo1 = deliveryTo1.Text;
ASPxMemo mkg = pageControl.FindControl("txt_cargoMkg") as ASPxMemo;
tj.CargoMkg = mkg.Text;
ASPxMemo des = pageControl.FindControl("txt_cargoDes") as ASPxMemo;
tj.CargoDesc = des.Text;
ASPxDateEdit tptDate = pageControl.FindControl("date_TptDate") as ASPxDateEdit;
tj.TptDate = SafeValue.SafeDate(tptDate.Date, new DateTime(1753, 1, 1));
ASPxTextBox tptTime = pageControl.FindControl("txt_TptTime") as ASPxTextBox;
tj.TptTime = tptTime.Text;
ASPxComboBox JobProgress = pageControl.FindControl("cmb_JobStatus") as ASPxComboBox;
if (!isNew && tj.JobProgress != JobProgress.Text)
{
isAddTripLog = true;
}
tj.JobProgress = JobProgress.Text;
ASPxComboBox tptType = pageControl.FindControl("cmb_TptType") as ASPxComboBox;
tj.TptType = tptType.Text;
ASPxComboBox tipCode = pageControl.FindControl("cbb_Trip_TripCode") as ASPxComboBox;
tj.TripCode = tipCode.Text;
ASPxButtonEdit driver = pageControl.FindControl("btn_DriverCode") as ASPxButtonEdit;
tj.Driver = driver.Text;
ASPxButtonEdit vehicle = pageControl.FindControl("btn_vehicle") as ASPxButtonEdit;
tj.VehicleNo = vehicle.Text;
ASPxSpinEdit qty = pageControl.FindControl("spin_Qty") as ASPxSpinEdit;
tj.Qty = SafeValue.SafeInt(qty.Value, 0);
ASPxButtonEdit pkgType = pageControl.FindControl("txt_PackType") as ASPxButtonEdit;
tj.PkgType = pkgType.Text;
ASPxSpinEdit wt = pageControl.FindControl("spin_Wt") as ASPxSpinEdit;
tj.Wt = SafeValue.SafeDecimal(wt.Value, 0);
ASPxSpinEdit m3 = pageControl.FindControl("spin_M3") as ASPxSpinEdit;
tj.M3 = SafeValue.SafeDecimal(m3.Value, 0);
ASPxSpinEdit FeeTpt = pageControl.FindControl("spin_FeeTpt") as ASPxSpinEdit;
tj.FeeTpt = SafeValue.SafeDecimal(FeeTpt.Value, 0);
ASPxSpinEdit FeeLabour = pageControl.FindControl("spin_FeeLabour") as ASPxSpinEdit;
tj.FeeLabour = SafeValue.SafeDecimal(FeeLabour.Value, 0);
ASPxSpinEdit FeeOt = pageControl.FindControl("spin_FeeOt") as ASPxSpinEdit;
tj.FeeOt = SafeValue.SafeDecimal(FeeOt.Value, 0);
ASPxSpinEdit FeeAdmin = pageControl.FindControl("spin_FeeAdmin") as ASPxSpinEdit;
tj.FeeAdmin = SafeValue.SafeDecimal(FeeAdmin.Value, 0);
ASPxSpinEdit FeeReimberse = pageControl.FindControl("spin_FeeReimberse") as ASPxSpinEdit;
tj.FeeReimberse = SafeValue.SafeDecimal(FeeReimberse.Value, 0);
ASPxSpinEdit FeeMisc = pageControl.FindControl("spin_FeeMisc") as ASPxSpinEdit;
tj.FeeMisc = SafeValue.SafeDecimal(FeeMisc.Value, 0);
tj.FeeTotal = tj.FeeTpt + tj.FeeLabour + tj.FeeOt + tj.FeeAdmin + tj.FeeReimberse + tj.FeeMisc;
ASPxTextBox FeeRemark = pageControl.FindControl("txt_FeeRemark") as ASPxTextBox;
tj.FeeRemark = FeeRemark.Text;
if (isNew)
{
tj.CreateBy = EzshipHelper.GetUserName();
tj.CreateDateTime = DateTime.Now;
tj.StatusCode = "USE";
C2.Manager.ORManager.StartTracking(tj, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(tj);
if (tj.JobProgress == "Assigned")
{
InsertTripLog(tj);
}
}
else
{
tj.UpdateBy = EzshipHelper.GetUserName();
tj.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(tj, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(tj);
if (isAddTripLog)
{
InsertTripLog(tj);
}
}
if (isNew)
{
jobNoCtr.Text = jobNo;
C2Setup.SetNextNo(tj.JobType, runType, jobNo, tj.JobDate);
string where = "JobNo='" + jobNo + "'";
Session["TptJob_" + this.txt_type.Text] = where;
this.dsTransport.FilterExpression = where;
if (this.grid_Transport.GetRow(0) != null)
{
this.grid_Transport.StartEdit(0);
}
}
string re = HttpContext.Current.User.Identity.Name + "," + tj.Driver + "," + tj.JobNo;
return(re);
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
}
private void SaveAndUpdate()
{
ASPxTextBox cerId = this.ASPxGridView1.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
ASPxComboBox cmb_PartyTo = this.ASPxGridView1.FindEditFormTemplateControl("cmb_PartyTo") as ASPxComboBox;
ASPxDateEdit txt_CerDt = this.ASPxGridView1.FindEditFormTemplateControl("txt_CerDt") as ASPxDateEdit;
ASPxTextBox txt_GstPermitNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_GstPermitNo") as ASPxTextBox;
ASPxSpinEdit spin_GstPaidAmt = this.ASPxGridView1.FindEditFormTemplateControl("spin_GstPaidAmt") as ASPxSpinEdit;
ASPxTextBox serialNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_SerialNo") as ASPxTextBox;
ASPxTextBox mastRefNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_MastRefNo") as ASPxTextBox;
ASPxTextBox jobRefNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_JobRefNo") as ASPxTextBox;
ASPxTextBox jobType = this.ASPxGridView1.FindEditFormTemplateControl("txt_MastType") as ASPxTextBox;
ASPxButtonEdit btn_RefCurrency = this.ASPxGridView1.FindEditFormTemplateControl("btn_RefCurrency") as ASPxButtonEdit;
ASPxSpinEdit txt_RefExRate = this.ASPxGridView1.FindEditFormTemplateControl("txt_RefExRate") as ASPxSpinEdit;
C2.SeaCertificate cer = Manager.ORManager.GetObject(typeof(SeaCertificate), SafeValue.SafeInt(cerId.Text, 0)) as SeaCertificate;
if (cer == null)// first insert invoice
{
cer = new SeaCertificate();
cer.GstPermitNo = txt_GstPermitNo.Text;
cer.GstPaidAmt = SafeValue.SafeDecimal(spin_GstPaidAmt.Value);
cer.HandingAgent = SafeValue.SafeString(cmb_PartyTo.Value);
cer.CerDate = txt_CerDt.Date;
cer.RefNo = mastRefNCtr.Text;
cer.JobNo = jobRefNCtr.Text;
cer.RefType = jobType.Text;
cer.SerialNo = serialNo.Text;
cer.Currency = btn_RefCurrency.Text;
cer.ExRate = SafeValue.SafeDecimal(txt_RefExRate.Value);
try
{
C2.Manager.ORManager.StartTracking(cer, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(cer);
}
catch
{
}
}
else
{
cer.GstPermitNo = txt_GstPermitNo.Text;
cer.GstPaidAmt = SafeValue.SafeDecimal(spin_GstPaidAmt.Value);
cer.HandingAgent = SafeValue.SafeString(cmb_PartyTo.Value);
cer.CerDate = txt_CerDt.Date;
cer.RefNo = mastRefNCtr.Text;
cer.JobNo = jobRefNCtr.Text;
cer.RefType = jobType.Text;
cer.SerialNo = serialNo.Text;
cer.Currency = btn_RefCurrency.Text;
cer.ExRate = SafeValue.SafeDecimal(txt_RefExRate.Value);
try
{
Manager.ORManager.StartTracking(cer, InitialState.Updated);
Manager.ORManager.PersistChanges(cer);
}
catch
{
}
}
Session["ExportCertificate"] = "Id=" + cer.Id;
this.dsCertificate.FilterExpression = Session["ExportCertificate"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
protected void AddOrUpdate()
{
try
{
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_Id = pageControl.FindControl("txt_Id") as ASPxTextBox;
ASPxTextBox txtPartyId = pageControl.FindControl("txtPartyId") as ASPxTextBox;
ASPxTextBox txtCode = pageControl.FindControl("txtCode") as ASPxTextBox;
ASPxLabel lblMess = pageControl.FindControl("lblMessage") as ASPxLabel;
string id = SafeValue.SafeString(txt_Id.Text, "");
string partyId = SafeValue.SafeString(txtPartyId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(RefPersonInfo), "Id='" + id + "'");
RefPersonInfo party = C2.Manager.ORManager.GetObject(query) as RefPersonInfo;
bool action = false;
if (party == null)
{
action = true;
party = new RefPersonInfo();
partyId = partyId.Replace(" ", "_");
string sql = string.Format("select count(PartyId) from Ref_PersonInfo where PartyId='{0}'", partyId);
int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (cnt > 0)
{
throw new Exception(string.Format("Duplicate Code!"));
return;
}
sql = string.Format("select count(ICNo) from Ref_PersonInfo where ICNo='{0}'", partyId);
cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
if (cnt > 0)
{
throw new Exception(string.Format("Duplicate ICNo!"));
return;
}
party.PartyId = partyId;
}
ASPxTextBox txtName = pageControl.FindControl("txtName") as ASPxTextBox;
string name = txtName.Text.Trim();
party.Name = name;
ASPxMemo memoAddress = pageControl.FindControl("txtAddress") as ASPxMemo;
party.Address = memoAddress.Text;
ASPxTextBox txtICNo = pageControl.FindControl("txtICNo") as ASPxTextBox;
party.ICNo = txtICNo.Text;
ASPxTextBox txtTel = pageControl.FindControl("txtTel") as ASPxTextBox;
party.Tel = txtTel.Text;
ASPxTextBox txtContact = pageControl.FindControl("txtContact") as ASPxTextBox;
party.Contact = txtContact.Text;
ASPxTextBox txt_ZipCode = pageControl.FindControl("txt_ZipCode") as ASPxTextBox;
party.ZipCode = txt_ZipCode.Text;
ASPxComboBox cbCountry = pageControl.FindControl("cbCountry") as ASPxComboBox;
party.Country = SafeValue.SafeString(cbCountry.Value);
ASPxComboBox cbCity = pageControl.FindControl("cbCity") as ASPxComboBox;
party.City = SafeValue.SafeString(cbCity.Value);
ASPxComboBox cmb_Type = pageControl.FindControl("cmb_Type") as ASPxComboBox;
party.Type = SafeValue.SafeString(cmb_Type.Value);
ASPxButtonEdit txt_Customer = pageControl.FindControl("txt_Customer") as ASPxButtonEdit;
party.RelationId = txt_Customer.Text;
ASPxTextBox txtAccountNo = pageControl.FindControl("txtAccountNo") as ASPxTextBox;
party.AccountNo = txtAccountNo.Text;
if (action)
{
Manager.ORManager.StartTracking(party, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(party);
}
else
{
Manager.ORManager.StartTracking(party, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(party);
}
Session["NameWhere"] = "PartyId='" + party.PartyId + "'";
this.dsPersonInfo.FilterExpression = Session["NameWhere"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void AddOrUpdate()
{
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_Id = pageControl.FindControl("txt_Id") as ASPxTextBox;
ASPxTextBox txt_Code = pageControl.FindControl("txt_Code") as ASPxTextBox;
ASPxLabel lblMess = pageControl.FindControl("lblMessage") as ASPxLabel;
string id = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(RefLocation), "Id='" + id + "'");
RefLocation obj = C2.Manager.ORManager.GetObject(query) as RefLocation;
bool action = false;
string code = "";
string pId = "";
if (obj == null)
{
action = true;
obj = new RefLocation();
string sql = "select Code from ref_location";
DataTable dt = C2.Manager.ORManager.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
code = dt.Rows[i]["Code"].ToString();
if (txt_Code.Text.ToUpper() == code.ToUpper())
{
throw new Exception("Please enter another value of the Short Name again!");
return;
}
}
}
}
if (txt_Code.Text == "")
{
throw new Exception("Code not be null!!!");
return;
}
obj.Code = txt_Code.Text;
ASPxTextBox txtName = pageControl.FindControl("txt_Name") as ASPxTextBox;
string name = txtName.Text.Trim();
//if (txtName.Text == "")
//{
// throw new Exception("Name not be null!!!");
// return;
//}
obj.Name = name;
obj.Code = txt_Code.Text;
ASPxButtonEdit txt_WarehouseCode = pageControl.FindControl("txt_WarehouseCode") as ASPxButtonEdit;
obj.WarehouseCode = txt_WarehouseCode.Text;
ASPxButtonEdit btn_ZoneCode = pageControl.FindControl("btn_ZoneCode") as ASPxButtonEdit;
obj.ZoneCode = btn_ZoneCode.Text;
ASPxButtonEdit txt_PartyId = pageControl.FindControl("txt_PartyId") as ASPxButtonEdit;
obj.PartyId = txt_PartyId.Text;
ASPxButtonEdit btn_StoreCode = pageControl.FindControl("btn_StoreCode") as ASPxButtonEdit;
obj.StoreCode = btn_StoreCode.Text;
ASPxSpinEdit txt_Length = pageControl.FindControl("txt_Length") as ASPxSpinEdit;
obj.Length = SafeValue.SafeDecimal(txt_Length.Text);
ASPxSpinEdit txt_Width = pageControl.FindControl("txt_Width") as ASPxSpinEdit;
obj.Width = SafeValue.SafeDecimal(txt_Width.Text);
ASPxSpinEdit txt_Height = pageControl.FindControl("txt_Height") as ASPxSpinEdit;
obj.Height = SafeValue.SafeDecimal(txt_Height.Text);
ASPxSpinEdit txt_SpaceM3 = pageControl.FindControl("txt_SpaceM3") as ASPxSpinEdit;
obj.SpaceM3 = SafeValue.SafeDecimal(txt_SpaceM3.Text);
ASPxMemo memoRemark = pageControl.FindControl("memo_Remark") as ASPxMemo;
obj.Remark = memoRemark.Text;
ASPxTextBox txt_Loclevel = pageControl.FindControl("txt_Loclevel") as ASPxTextBox;
obj.Loclevel = txt_Loclevel.Text;
if (action)
{
obj.CreateBy = HttpContext.Current.User.Identity.Name;
obj.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(obj, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(obj);
Session["NameWhere"] = "Id='" + obj.Id + "'";
this.dsRefLocation.FilterExpression = Session["NameWhere"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
}
else
{
obj.UpdateBy = HttpContext.Current.User.Identity.Name;
obj.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(obj, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(obj);
}
}
private string SavePo()
{
try
{
ASPxPageControl pageControl = this.grd_Do.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxDateEdit txt_Date = this.grd_Do.FindEditFormTemplateControl("txt_Date") as ASPxDateEdit;
ASPxTextBox txt_Id = grd_Do.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string pId = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhTrans), "Id='" + pId + "'");
WhTrans whTrans = C2.Manager.ORManager.GetObject(query) as WhTrans;
bool action = false;
string poNo = "";
if (whTrans == null)
{
action = true;
whTrans = new WhTrans();
poNo = C2Setup.GetNextNo("", "BlanketPO", txt_Date.Date);
}
ASPxComboBox cmb_Status = this.grd_Do.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
whTrans.DoStatus = SafeValue.SafeString(cmb_Status.Value);
ASPxButtonEdit txt_PartyId = grd_Do.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit;
whTrans.PartyId = SafeValue.SafeString(txt_PartyId.Text);
whTrans.DoDate = SafeValue.SafeDate(txt_Date.Date, DateTime.Today);
ASPxDateEdit txt_ExpectedDate = this.grd_Do.FindEditFormTemplateControl("txt_ExpectedDate") as ASPxDateEdit;
whTrans.ExpectedDate = txt_ExpectedDate.Date;
ASPxTextBox txt_PartyName = grd_Do.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox;
whTrans.PartyName = txt_PartyName.Text;
ASPxMemo txt_PartyAdd = grd_Do.FindEditFormTemplateControl("txt_PartyAdd") as ASPxMemo;
whTrans.PartyAdd = txt_PartyAdd.Text;
//ASPxTextBox txt_PostalCode = grd_Do.FindEditFormTemplateControl("txt_PostalCode") as ASPxTextBox;
//whTrans.PartyPostalcode = txt_PostalCode.Text;
//ASPxButtonEdit txt_PartyCity = grd_Do.FindEditFormTemplateControl("txt_PartyCity") as ASPxButtonEdit;
//whTrans.PartyCity = txt_PartyCity.Text;
//ASPxButtonEdit txt_PartyCountry = grd_Do.FindEditFormTemplateControl("txt_PartyCountry") as ASPxButtonEdit;
//whTrans.PartyCountry = txt_PartyCountry.Text;
ASPxMemo txt_Remark1 = grd_Do.FindEditFormTemplateControl("txt_Remark1") as ASPxMemo;
whTrans.Remark1 = txt_Remark1.Text;
ASPxMemo txt_Remark2 = grd_Do.FindEditFormTemplateControl("txt_Remark2") as ASPxMemo;
whTrans.Remark2 = txt_Remark2.Text;
ASPxMemo txt_CollectFrom = grd_Do.FindEditFormTemplateControl("txt_CollectFrom") as ASPxMemo;
whTrans.CollectFrom = txt_CollectFrom.Text;
ASPxMemo txt_DeliveryTo = grd_Do.FindEditFormTemplateControl("txt_DeliveryTo") as ASPxMemo;
whTrans.DeliveryTo = txt_DeliveryTo.Text;
ASPxButtonEdit txt_WareHouseId = grd_Do.FindEditFormTemplateControl("txt_WareHouseId") as ASPxButtonEdit;
whTrans.WareHouseId = txt_WareHouseId.Text;
ASPxTextBox pic = grd_Do.FindEditFormTemplateControl("txt_Pic") as ASPxTextBox;
whTrans.Pic = pic.Text;
ASPxButtonEdit currency = grd_Do.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit;
whTrans.Currency = currency.Text;
ASPxSpinEdit exRate = grd_Do.FindEditFormTemplateControl("spin_ExRate") as ASPxSpinEdit;
whTrans.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
ASPxComboBox payTerm = grd_Do.FindEditFormTemplateControl("cmb_PayTerm") as ASPxComboBox;
whTrans.PayTerm = payTerm.Text;
ASPxComboBox incoTerm = grd_Do.FindEditFormTemplateControl("cmb_IncoTerm") as ASPxComboBox;
whTrans.IncoTerm = incoTerm.Text;
ASPxTextBox txt_MasterDocNo = grd_Do.FindEditFormTemplateControl("txt_MasterDocNo") as ASPxTextBox;
whTrans.MasterDocNo = txt_MasterDocNo.Text;
ASPxComboBox cmb_OrderType = grd_Do.FindEditFormTemplateControl("cmb_OrderType") as ASPxComboBox;
whTrans.OrderType = cmb_OrderType.Text;
//shipment info
ASPxTextBox txt_Vessel = pageControl.FindControl("txt_Vessel") as ASPxTextBox;
whTrans.Vessel = txt_Vessel.Text;
ASPxTextBox txt_Voyage = pageControl.FindControl("txt_Voyage") as ASPxTextBox;
whTrans.Voyage = txt_Voyage.Text;
ASPxDateEdit date_Etd = pageControl.FindControl("date_Etd") as ASPxDateEdit;
whTrans.Etd = date_Etd.Date;
ASPxButtonEdit txt_Pol = pageControl.FindControl("txt_Pol") as ASPxButtonEdit;
whTrans.Pol = txt_Pol.Text;
ASPxButtonEdit txt_Pod = pageControl.FindControl("txt_Pod") as ASPxButtonEdit;
whTrans.Pod = txt_Pod.Text;
ASPxDateEdit date_Eta = pageControl.FindControl("date_Eta") as ASPxDateEdit;
whTrans.Eta = date_Eta.Date;
ASPxTextBox txt_OceanBl = pageControl.FindControl("txt_OceanBl") as ASPxTextBox;
whTrans.Obl = txt_OceanBl.Text;
ASPxTextBox txt_HouseBl = pageControl.FindControl("txt_HouseBl") as ASPxTextBox;
whTrans.Hbl = txt_HouseBl.Text;
ASPxDateEdit date_EtaDest = pageControl.FindControl("date_EtaDest") as ASPxDateEdit;
whTrans.EtaDest = date_EtaDest.Date;
ASPxTextBox txt_VehicleNo = pageControl.FindControl("txt_VehicleNo") as ASPxTextBox;
whTrans.Vehicle = txt_VehicleNo.Text;
ASPxTextBox txt_COO = pageControl.FindControl("txt_COO") as ASPxTextBox;
whTrans.Coo = txt_COO.Text;
ASPxButtonEdit txt_Carrier = pageControl.FindControl("txt_Carrier") as ASPxButtonEdit;
whTrans.Carrier = txt_Carrier.Text;
//party
ASPxButtonEdit txt_AgentId = pageControl.FindControl("txt_AgentId") as ASPxButtonEdit;
whTrans.AgentId = txt_AgentId.Text;
ASPxTextBox txt_AgentName = pageControl.FindControl("txt_AgentName") as ASPxTextBox;
whTrans.AgentName = txt_AgentName.Text;
ASPxTextBox txt_AgentZip = pageControl.FindControl("txt_AgentZip") as ASPxTextBox;
whTrans.AgentZip = txt_AgentZip.Text;
ASPxMemo txt_AgentAdd = pageControl.FindControl("txt_AgentAdd") as ASPxMemo;
whTrans.AgentAdd = txt_AgentAdd.Text;
ASPxTextBox txt_AgentTel = pageControl.FindControl("txt_AgentTel") as ASPxTextBox;
whTrans.AgentTel = txt_AgentTel.Text;
ASPxTextBox txt_AgentContact = pageControl.FindControl("txt_AgentContact") as ASPxTextBox;
whTrans.AgentContact = txt_AgentContact.Text;
ASPxButtonEdit txt_AgentCountry = pageControl.FindControl("txt_AgentCountry") as ASPxButtonEdit;
whTrans.AgentCountry = txt_AgentCountry.Text;
ASPxButtonEdit txt_AgentCity = pageControl.FindControl("txt_AgentCity") as ASPxButtonEdit;
whTrans.AgentCity = txt_AgentCity.Text;
ASPxButtonEdit txt_NotifyId = pageControl.FindControl("txt_NotifyId") as ASPxButtonEdit;
whTrans.NotifyId = txt_NotifyId.Text;
ASPxTextBox txt_NotifyName = pageControl.FindControl("txt_NotifyName") as ASPxTextBox;
whTrans.NotifyName = txt_NotifyName.Text;
ASPxTextBox txt_NotifyZip = pageControl.FindControl("txt_NotifyZip") as ASPxTextBox;
whTrans.NotifyZip = txt_NotifyZip.Text;
ASPxMemo txt_NotifyAdd = pageControl.FindControl("txt_NotifyAdd") as ASPxMemo;
whTrans.NotifyAdd = txt_NotifyAdd.Text;
ASPxTextBox txt_NotifyTel = pageControl.FindControl("txt_NotifyTel") as ASPxTextBox;
whTrans.NotifyTel = txt_NotifyTel.Text;
ASPxTextBox txt_NotifyContact = pageControl.FindControl("txt_NotifyContact") as ASPxTextBox;
whTrans.NotifyContact = txt_NotifyContact.Text;
ASPxButtonEdit txt_NotifyCountry = pageControl.FindControl("txt_NotifyCountry") as ASPxButtonEdit;
whTrans.NotifyCountry = txt_NotifyCountry.Text;
ASPxButtonEdit txt_NotifyCity = pageControl.FindControl("txt_NotifyCity") as ASPxButtonEdit;
whTrans.NotifyCity = txt_NotifyCity.Text;
ASPxButtonEdit txt_ConsigneeId = pageControl.FindControl("txt_ConsigneeId") as ASPxButtonEdit;
whTrans.ConsigneeId = txt_ConsigneeId.Text;
ASPxTextBox txt_ConsigneeName = pageControl.FindControl("txt_ConsigneeName") as ASPxTextBox;
whTrans.ConsigneeName = txt_ConsigneeName.Text;
ASPxTextBox txt_ConsigneeZip = pageControl.FindControl("txt_ConsigneeZip") as ASPxTextBox;
whTrans.ConsigneeZip = txt_ConsigneeZip.Text;
ASPxMemo txt_ConsigneeAdd = pageControl.FindControl("txt_ConsigneeAdd") as ASPxMemo;
whTrans.ConsigneeAdd = txt_ConsigneeAdd.Text;
ASPxTextBox txt_ConsigneeTel = pageControl.FindControl("txt_ConsigneeTel") as ASPxTextBox;
whTrans.ConsigneeTel = txt_ConsigneeTel.Text;
ASPxTextBox txt_ConsigneeContact = pageControl.FindControl("txt_ConsigneeContact") as ASPxTextBox;
whTrans.ConsigneeContact = txt_ConsigneeContact.Text;
ASPxButtonEdit txt_ConsigneeCountry = pageControl.FindControl("txt_ConsigneeCountry") as ASPxButtonEdit;
whTrans.ConsigneeCountry = txt_ConsigneeCountry.Text;
ASPxButtonEdit txt_ConsigneeCity = pageControl.FindControl("txt_ConsigneeCity") as ASPxButtonEdit;
whTrans.ConsigneeCity = txt_ConsigneeCity.Text;
ASPxButtonEdit btn_Lc = grd_Do.FindEditFormTemplateControl("btn_Lc") as ASPxButtonEdit;
whTrans.LcNo = btn_Lc.Text;
if (action)
{
whTrans.DoNo = poNo;
whTrans.DoType = "BP";
whTrans.CreateBy = EzshipHelper.GetUserName();
whTrans.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(whTrans, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(whTrans);
C2Setup.SetNextNo("", "BlanketPO", poNo, txt_Date.Date);
}
else
{
whTrans.UpdateBy = EzshipHelper.GetUserName();
whTrans.UpdateDateTime = DateTime.Now;
bool isAddLog = false;
if (whTrans.DoStatus == SafeValue.SafeString(ConnectSql.ExecuteScalar("Select DoStatus from wh_trans where DoNo='" + whTrans.DoNo + "'")))
{
}
else
{
isAddLog = true;
}
Manager.ORManager.StartTracking(whTrans, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(whTrans);
if (isAddLog)
{
EzshipLog.Log(whTrans.DoNo, "", "PO", whTrans.DoStatus);
}
}
Session["BPWhere"] = "DoNo='" + whTrans.DoNo + "'";
this.dsDo.FilterExpression = Session["BPWhere"].ToString();
if (this.grd_Do.GetRow(0) != null)
{
this.grd_Do.StartEdit(0);
}
return(whTrans.DoNo);
}
catch { }
return("");
}
public override void BreakLinksToControl(bool unwireEventsOnly) {
if (!unwireEventsOnly) {
control = null;
}
base.BreakLinksToControl(unwireEventsOnly);
}
protected void grd_Do_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
ASPxPageControl pageControl = this.grd_Do.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox id = grd_Do.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
ASPxTextBox txt_DoNo = this.grd_Do.FindEditFormTemplateControl("txt_DoNo") as ASPxTextBox;
ASPxButtonEdit txt_WareHouseId = grd_Do.FindEditFormTemplateControl("txt_WareHouseId") as ASPxButtonEdit;
ASPxButtonEdit txt_PartyId = grd_Do.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit;
ASPxTextBox txt_PartyName = grd_Do.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox;
if (s == "Save")
{
#region Save
if (txt_PartyId.Text.Trim() == "")
{
e.Result = "Fail";
return;
}
ASPxComboBox doStatus = grd_Do.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
if (doStatus.Text == "Confirmed")
{
//check purchase price and sell price
string sql1 = string.Format(@"select count(id) from wh_transdet
where dono='{0}' and DoType='po'", txt_DoNo.Text);
if (SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql1), 0) == 0)
{
e.Result = "NO SKU";
return;
}
sql1 = string.Format(@"select (case when Price=0 then 0 else 1 end) Result from Wh_TransDet where dono='{0}' and DoType='po'", txt_DoNo.Text);
DataTable tab = ConnectSql.GetTab(sql1);
for (int i = 0; i < tab.Rows.Count; i++)
{
if (SafeValue.SafeInt(tab.Rows[i]["Result"], 0) == 0)
{
e.Result = "No Price";
return;
}
}
}
if (txt_DoNo.Text.Length > 4)
{
SavePo();
e.Result = "";//update old one
}
else
{
e.Result = SavePo();// new one
}
return;
#endregion
}
//string sql = "select Count(*) from Wh_TransDet where DoNo='" + SafeValue.SafeString(txt_DoNo.Text) + "' and (JobStatus='Draft' or JobStatus='Waiting')";
// int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0);
//if (cnt == 0)
// {
if (s == "CloseJob")
{
#region close job
string sql = "select DoStatus from Wh_Trans where DoNo='" + txt_DoNo.Text + "'";
string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");//
if (closeInd == "Closed")
{
sql = string.Format("update Wh_Trans set DoStatus='Draft' where DoNo='{0}'", txt_DoNo.Text);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
EzshipLog.Log(txt_DoNo.Text, "", "PO", "Open Job");
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
else
{
sql = string.Format("update Wh_Trans set DoStatus='Closed' where DoNo='{0}'", txt_DoNo.Text);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
EzshipLog.Log(txt_DoNo.Text, "", "PO", "Closed Job");
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
#endregion
}
//}
//else
//{
// e.Result = "NotClose";
//}
if (s == "Void")
{
#region void master
string sql_cnt = string.Format("select count(SequenceId) from XAArInvoiceDet where MastType='WH' and MastRefNo='{0}'", txt_DoNo.Text);
int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_cnt), 0);
if (cnt > 0)
{
e.Result = "Billing";
return;
}
string sql = "select StatusCode from Wh_Trans where DoNo='" + txt_DoNo.Text + "'";
string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "N");// closeIndStr.Text;
if (closeInd == "CNL")
{
sql = string.Format("update Wh_Trans set StatusCode='USE' where DoNo='{0}'", txt_DoNo.Text);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
else
{
sql = string.Format("update Wh_Trans set StatusCode='CNL' where DoNo='{0}'", txt_DoNo.Text);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
#endregion
}
else if (s == "Confirm")
{
#region Confirm
if (txt_PartyId.Text.Trim() == "")
{
e.Result = "Fail";
return;
}
string sql = "select StatusCode from Wh_Trans where DoNo='" + txt_DoNo.Text + "'";
string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "Draft");//
if (closeInd == "Draft")
{
bool closeByEst = true;//EzshipHelper.GetCloseEstInd(refN.Text, refType);
if (closeByEst)
{
sql = string.Format("update Wh_Trans set DoStatus='Confirmed',UpdateBy='{1}',UpdateDateTime='{2}' where DoNo='{0}'", txt_DoNo.Text, EzshipHelper.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
//string poNo = AddPurchase(tab, txt_DoNo.Text, txt_PartyId.Text, txt_PartyName.Text, txt_WareHouseId.Text);
//TransferToStock(txt_DoNo.Text, "PO");
EzshipLog.Log(txt_DoNo.Text, "", "PO", "Confirmed");
e.Result = "Success";
}
else
{
e.Result = "Fail";
}
}
else
{
e.Result = "NoMatch";
}
}
else
{
}
#endregion
}
else if (s == "CreatePO")
{
#region Create PO
string sql = string.Format(@"select * from Wh_TransDet where DoNo='{0}' and Qty1>0", txt_DoNo.Text);
DataTable tab = ConnectSql.GetTab(sql);
if (tab.Rows.Count > 0)
{
sql = string.Format(@"select count(*) from (select sum(Qty1) as TotalQty1,mast.DoNo from Wh_TransDet det inner join Wh_Trans mast on det.DoNo=mast.DoNo and mast.DoType='BP' group by mast.DoNo) as tab_bp
left join (select sum(Qty1) as TotalQty2,BlanketNo from Wh_TransDet det inner join Wh_Trans mast on det.DoNo=mast.DoNo and mast.DoType='PO' group by BlanketNo) as tab_so on tab_so.BlanketNo=tab_bp.DoNo
where TotalQty1-TotalQty2=0 and BlanketNo='{0}'", txt_DoNo.Text);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > 0)
{
e.Result = "The purchase qty has been complete";
return;
}
string poNo = AddPurchase(tab, txt_DoNo.Text, txt_PartyId.Text, txt_PartyName.Text, txt_WareHouseId.Text);
e.Result = "Success! " + "Purcharse Order No is " + poNo;
}
else
{
e.Result = "NO Qty";
}
#endregion
}
}
protected override WebControl CreateEditModeControlCore() {
if (objectWindowAction == null) {
objectWindowAction = new PopupWindowShowAction(null, "ShowObjectDetailViewPopup", PredefinedCategory.Unspecified.ToString());
objectWindowAction.Execute += objectWindowAction_OnExecute;
objectWindowAction.CustomizePopupWindowParams += objectWindowAction_OnCustomizePopupWindowParams;
objectWindowAction.Application = application;
}
control = new ASPxButtonEdit { EnableClientSideAPI = true };
control.Load += buttonEdit_Load;
control.Buttons.Clear();
control.Buttons.Add("");
ASPxImageHelper.SetImageProperties(control.Buttons[0].Image, "Editor_Edit");
if (control.Buttons[0].Image.IsEmpty) {
control.Buttons[0].Text = "Edit";
}
control.Enabled = true;
control.ReadOnly = true;
return control;
}
protected void SavePrice()
{
try
{
ASPxPageControl pageControl = this.grid_Price.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl;
ASPxTextBox txt_Id = grid_Price.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string pId = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhTrans), "Id='" + pId + "'");
WhTrans whTrans = C2.Manager.ORManager.GetObject(query) as WhTrans;
ASPxDateEdit issueDate = grid_Price.FindEditFormTemplateControl("date_IssueDate") as ASPxDateEdit;
bool isNew = false;
//const string runType = "DOOUT";
string issueN = "";
if (whTrans == null)
{
whTrans = new WhTrans();
isNew = true;
issueN = C2Setup.GetNextNo("", "PuchasePrice", issueDate.Date);
whTrans.DoDate = issueDate.Date;
}
ASPxDateEdit doDate = grid_Price.FindEditFormTemplateControl("date_IssueDate") as ASPxDateEdit;
whTrans.DoDate = doDate.Date;
ASPxDateEdit txt_ExpectedDate = this.grid_Price.FindEditFormTemplateControl("txt_ExpectedDate") as ASPxDateEdit;
whTrans.ExpectedDate = txt_ExpectedDate.Date;
ASPxComboBox doStatus = grid_Price.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
whTrans.DoStatus = SafeValue.SafeString(doStatus.Value);
//Main Info
ASPxButtonEdit txt_PartyId = grid_Price.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit;
whTrans.PartyId = txt_PartyId.Text;
ASPxTextBox txt_PartyName = grid_Price.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox;
whTrans.PartyName = txt_PartyName.Text;
if (txt_PartyName.Text == "")
{
throw new Exception("Supplier not be null!!!");
return;
}
ASPxMemo remark = grid_Price.FindEditFormTemplateControl("txt_Remark") as ASPxMemo;
whTrans.Remark = remark.Text;
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
whTrans.StatusCode = "USE";
whTrans.CreateBy = userId;
whTrans.CreateDateTime = DateTime.Now;
whTrans.UpdateBy = userId;
whTrans.UpdateDateTime = DateTime.Now;
whTrans.DoType = "PQ";
whTrans.DoNo = issueN;
Manager.ORManager.StartTracking(whTrans, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(whTrans);
C2Setup.SetNextNo("", "PuchasePrice", issueN, issueDate.Date);
}
else
{
whTrans.UpdateBy = userId;
whTrans.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(whTrans, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(whTrans);
}
Session["PriceWhere"] = "DoNo='" + whTrans.DoNo + "'";
this.dsPrice.FilterExpression = Session["PriceWhere"].ToString();
if (this.grid_Price.GetRow(0) != null)
{
this.grid_Price.StartEdit(0);
}
}
catch { }
}
protected string SaveJob()
{
try
{
ASPxPageControl pageControl = this.grid_Issue.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl;
ASPxTextBox DoNo = grid_Issue.FindEditFormTemplateControl("txt_DoNo") as ASPxTextBox;
ASPxTextBox txt_Id = grid_Issue.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string pId = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(JobInfo), "Id='" + pId + "'");
JobInfo job = C2.Manager.ORManager.GetObject(query) as JobInfo;
ASPxDateEdit issueDate = grid_Issue.FindEditFormTemplateControl("date_IssueDate") as ASPxDateEdit;
bool isNew = false;
//const string runType = "DOOUT";
string issueN = "";
if (job == null)
{
job = new JobInfo();
isNew = true;
job.JobType = "IBTemp";
//issueN = C2Setup.GetNextNo("", "JobOrder", issueDate.Date);
issueN = "IBTemp-01";
job.JobDate = issueDate.Date;
}
job.Attribute = "Temp";
ASPxDateEdit doDate = grid_Issue.FindEditFormTemplateControl("date_IssueDate") as ASPxDateEdit;
job.JobDate = doDate.Date;
ASPxComboBox cmb_Status = grid_Issue.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
job.JobStage = SafeValue.SafeString(cmb_Status.Value);
ASPxComboBox cmb_JobType = grid_Issue.FindEditFormTemplateControl("cmb_JobType") as ASPxComboBox;
job.JobType = SafeValue.SafeString(cmb_JobType.Value);
//Main Info
ASPxMemo remark = grid_Issue.FindEditFormTemplateControl("txt_Remark") as ASPxMemo;
job.Remark = remark.Text;
ASPxButtonEdit currency = grid_Issue.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit;
job.Currency = currency.Text;
ASPxSpinEdit exRate = grid_Issue.FindEditFormTemplateControl("spin_ExRate") as ASPxSpinEdit;
job.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
ASPxComboBox payTerm = grid_Issue.FindEditFormTemplateControl("cmb_PayTerm") as ASPxComboBox;
job.PayTerm = payTerm.Text;
ASPxDateEdit date_ExpiryDate = grid_Issue.FindEditFormTemplateControl("date_ExpiryDate") as ASPxDateEdit;
job.ExpiryDate = date_ExpiryDate.Date;
ASPxMemo txt_PackRemark = grid_Issue.FindEditFormTemplateControl("txt_PackRemark") as ASPxMemo;
job.PackRmk = txt_PackRemark.Text;
ASPxMemo txt_MoveRemark = grid_Issue.FindEditFormTemplateControl("txt_MoveRemark") as ASPxMemo;
job.MoveRmk = txt_MoveRemark.Text;
ASPxButtonEdit txt_WareHouseId = grid_Issue.FindEditFormTemplateControl("txt_WareHouseId") as ASPxButtonEdit;
job.WareHouseId = txt_WareHouseId.Text;
ASPxSpinEdit spin_Volumne = grid_Issue.FindEditFormTemplateControl("spin_Volumne") as ASPxSpinEdit;
job.Volumne = SafeValue.SafeDecimal(spin_Volumne.Value);
ASPxMemo memo_Description = grid_Issue.FindEditFormTemplateControl("memo_Description") as ASPxMemo;
job.ItemDes = memo_Description.Text;
ASPxTextBox memo_Volumn = grid_Issue.FindEditFormTemplateControl("memo_Volumn") as ASPxTextBox;
job.VolumneRmk = memo_Description.Text;
ASPxSpinEdit spin_HeadCount = grid_Issue.FindEditFormTemplateControl("spin_HeadCount") as ASPxSpinEdit;
job.HeadCount = SafeValue.SafeInt(spin_HeadCount.Value, 0);
ASPxDateEdit date_Pack = grid_Issue.FindEditFormTemplateControl("date_Pack") as ASPxDateEdit;
job.PackDate = date_Pack.Date;
ASPxComboBox cmb_Via = grid_Issue.FindEditFormTemplateControl("cmb_Via") as ASPxComboBox;
job.ViaWh = cmb_Via.Text;
ASPxDateEdit date_StorageStartDate = grid_Issue.FindEditFormTemplateControl("date_StorageStartDate") as ASPxDateEdit;
job.StorageStartDate = date_StorageStartDate.Date;
ASPxSpinEdit spin_StorageFreeDays = grid_Issue.FindEditFormTemplateControl("spin_StorageFreeDays") as ASPxSpinEdit;
job.StorageFreeDays = SafeValue.SafeInt(spin_StorageFreeDays.Value, 0);
ASPxSpinEdit spin_STotalDays = grid_Issue.FindEditFormTemplateControl("spin_STotalDays") as ASPxSpinEdit;
job.StorageTotalDays = Helper.Safe.SafeInt(spin_STotalDays.Value);
ASPxTextBox txt_TripNo = grid_Issue.FindEditFormTemplateControl("txt_TripNo") as ASPxTextBox;
job.TripNo = txt_TripNo.Text;
ASPxDateEdit date_MoveDate = grid_Issue.FindEditFormTemplateControl("date_MoveDate") as ASPxDateEdit;
job.MoveDate = date_MoveDate.Date;
ASPxSpinEdit spin_Charges = grid_Issue.FindEditFormTemplateControl("spin_Charges") as ASPxSpinEdit;
job.Charges = SafeValue.SafeDecimal(spin_Charges.Value);
ASPxButtonEdit btn_PortOfEntry = grid_Issue.FindEditFormTemplateControl("btn_PortOfEntry") as ASPxButtonEdit;
job.EntryPort = btn_PortOfEntry.Text;
ASPxComboBox txt_Mode = grid_Issue.FindEditFormTemplateControl("cmb_Mode") as ASPxComboBox;
job.Mode = txt_Mode.Text;
ASPxDateEdit date_Eta = grid_Issue.FindEditFormTemplateControl("date_Eta") as ASPxDateEdit;
job.Eta = date_Eta.Date;
ASPxTextBox txt_TruckNo = grid_Issue.FindEditFormTemplateControl("txt_TruckNo") as ASPxTextBox;
job.TruckNo = txt_TruckNo.Text;
ASPxComboBox cmb_ServiceType = grid_Issue.FindEditFormTemplateControl("cmb_ServiceType") as ASPxComboBox;
job.ServiceType = cmb_ServiceType.Text;
//Additional
ASPxComboBox cmb_FullPacking = pageControl.FindControl("cmb_FullPacking") as ASPxComboBox;
job.Item1 = SafeValue.SafeString(cmb_FullPacking.Value);
ASPxComboBox cmb_UnFull = pageControl.FindControl("cmb_UnFull") as ASPxComboBox;
job.Item2 = SafeValue.SafeString(cmb_UnFull.Value);
ASPxTextBox txt_Details = pageControl.FindControl("txt_Details") as ASPxTextBox;
job.ItemDetail1 = txt_Details.Text;
ASPxTextBox txt_UnpackDetails = pageControl.FindControl("txt_UnpackDetails") as ASPxTextBox;
job.ItemDetail2 = txt_UnpackDetails.Text;
ASPxComboBox cmb_Insurance = pageControl.FindControl("cmb_Insurance") as ASPxComboBox;
job.Item3 = SafeValue.SafeString(cmb_Insurance.Value);
ASPxTextBox txt_Percentage = pageControl.FindControl("txt_Percentage") as ASPxTextBox;
job.ItemValue3 = txt_Percentage.Text;
ASPxTextBox txt_Value = pageControl.FindControl("txt_Value") as ASPxTextBox;
job.ItemData3 = txt_Value.Text;
ASPxSpinEdit txt_Premium = pageControl.FindControl("txt_Premium") as ASPxSpinEdit;
job.ItemPrice3 = SafeValue.SafeDecimal(txt_Premium.Text);
ASPxComboBox cmb_PianoApply = pageControl.FindControl("cmb_PianoApply") as ASPxComboBox;
job.Item4 = SafeValue.SafeString(cmb_PianoApply.Value);
ASPxTextBox txt_PainoDetails = pageControl.FindControl("txt_PainoDetails") as ASPxTextBox;
job.ItemDetail4 = txt_PainoDetails.Text;
ASPxSpinEdit spin_Charges1 = pageControl.FindControl("spin_Charges1") as ASPxSpinEdit;
job.ItemPrice4 = SafeValue.SafeDecimal(spin_Charges1.Value);
ASPxComboBox cmb_Safe = pageControl.FindControl("cmb_Safe") as ASPxComboBox;
job.Item5 = cmb_Safe.Text;
ASPxTextBox txt_Brand = pageControl.FindControl("txt_Brand") as ASPxTextBox;
job.ItemValue5 = SafeValue.SafeString(txt_Brand.Value);
ASPxSpinEdit spin_Weight = pageControl.FindControl("spin_Weight") as ASPxSpinEdit;
job.ItemPrice5 = SafeValue.SafeDecimal(spin_Weight.Value);
ASPxComboBox cmb_Crating = pageControl.FindControl("cmb_Crating") as ASPxComboBox;
job.Item6 = SafeValue.SafeString(cmb_Crating.Value);
ASPxTextBox txt_Details1 = pageControl.FindControl("txt_Details1") as ASPxTextBox;
job.ItemDetail6 = txt_Details1.Text;
ASPxSpinEdit spin_Charges2 = pageControl.FindControl("spin_Charges2") as ASPxSpinEdit;
job.ItemPrice6 = SafeValue.SafeDecimal(spin_Charges2.Value);
ASPxComboBox cmb_Handyman = pageControl.FindControl("cmb_Handyman") as ASPxComboBox;
job.Item7 = SafeValue.SafeString(cmb_Handyman.Value);
ASPxComboBox cmb_Complimentory = pageControl.FindControl("cmb_Complimentory") as ASPxComboBox;
job.ItemValue7 = SafeValue.SafeString(cmb_Complimentory.Value);
ASPxTextBox txt_Details2 = pageControl.FindControl("txt_Details2") as ASPxTextBox;
job.ItemDetail7 = txt_Details2.Text;
ASPxSpinEdit spin_Charges3 = pageControl.FindControl("spin_Charges3") as ASPxSpinEdit;
job.ItemPrice7 = SafeValue.SafeDecimal(spin_Charges3.Value);
ASPxComboBox cmb_Maid = pageControl.FindControl("cmb_Maid") as ASPxComboBox;
job.Item8 = SafeValue.SafeString(cmb_Maid.Value);
ASPxComboBox cmb_Complimentory1 = pageControl.FindControl("cmb_Complimentory1") as ASPxComboBox;
job.ItemValue8 = SafeValue.SafeString(cmb_Complimentory1.Value);
ASPxTextBox txt_Details3 = pageControl.FindControl("txt_Details3") as ASPxTextBox;
job.ItemDetail8 = txt_Details3.Text;
ASPxSpinEdit spin_Charges4 = pageControl.FindControl("spin_Charges4") as ASPxSpinEdit;
job.ItemPrice8 = SafeValue.SafeDecimal(spin_Charges4.Value);
ASPxComboBox cmb_Shifting = pageControl.FindControl("cmb_Shifting") as ASPxComboBox;
job.Item9 = SafeValue.SafeString(cmb_Shifting.Value);
ASPxComboBox cmb_Complimentory2 = pageControl.FindControl("cmb_Complimentory2") as ASPxComboBox;
job.ItemValue9 = SafeValue.SafeString(cmb_Complimentory2.Value);
ASPxTextBox txt_Details4 = pageControl.FindControl("txt_Details4") as ASPxTextBox;
job.ItemDetail9 = txt_Details4.Text;
ASPxSpinEdit spin_Charges5 = pageControl.FindControl("spin_Charges5") as ASPxSpinEdit;
job.ItemPrice9 = SafeValue.SafeDecimal(spin_Charges5.Value);
ASPxComboBox cmb_Disposal = pageControl.FindControl("cmb_Disposal") as ASPxComboBox;
job.Item10 = cmb_Disposal.Text;
ASPxComboBox cmb_Complimentory3 = pageControl.FindControl("cmb_Complimentory3") as ASPxComboBox;
job.ItemValue10 = cmb_Complimentory3.Text;
ASPxTextBox txt_Details5 = pageControl.FindControl("txt_Details5") as ASPxTextBox;
job.ItemDetail10 = txt_Details5.Text;
ASPxSpinEdit spin_Charges6 = pageControl.FindControl("spin_Charges6") as ASPxSpinEdit;
job.ItemPrice10 = SafeValue.SafeDecimal(spin_Charges6.Value);
ASPxComboBox cmb_PickUp = pageControl.FindControl("cmb_PickUp") as ASPxComboBox;
job.Item11 = SafeValue.SafeString(cmb_PickUp.Value);
ASPxTextBox txt_Details6 = pageControl.FindControl("txt_Details6") as ASPxTextBox;
job.ItemDetail11 = txt_Details6.Text;
ASPxComboBox cmb_Additional = pageControl.FindControl("cmb_Additional") as ASPxComboBox;
job.Item12 = cmb_Additional.Text;
ASPxTextBox txt_Details7 = pageControl.FindControl("txt_Details7") as ASPxTextBox;
job.ItemDetail12 = txt_Details7.Text;
ASPxComboBox cmb_BadAccess = pageControl.FindControl("cmb_BadAccess") as ASPxComboBox;
job.Item13 = SafeValue.SafeString(cmb_BadAccess.Value);
ASPxComboBox cmb_Origin = pageControl.FindControl("cmb_Origin") as ASPxComboBox;
job.ItemValue13 = cmb_Origin.Text;
ASPxComboBox cmb_Destination = pageControl.FindControl("cmb_Destination") as ASPxComboBox;
job.ItemData13 = SafeValue.SafeString(cmb_Destination.Value);
ASPxComboBox cmb_Storage = pageControl.FindControl("cmb_Storage") as ASPxComboBox;
job.Item14 = SafeValue.SafeString(cmb_Storage.Value);
ASPxComboBox cmb_Complimentory4 = pageControl.FindControl("cmb_Complimentory4") as ASPxComboBox;
job.ItemValue14 = SafeValue.SafeString(cmb_Complimentory4.Value);
ASPxTextBox txt_Details8 = pageControl.FindControl("txt_Details8") as ASPxTextBox;
job.ItemDetail14 = txt_Details8.Text;
ASPxSpinEdit spin_Charges7 = pageControl.FindControl("spin_Charges7") as ASPxSpinEdit;
job.ItemPrice14 = SafeValue.SafeDecimal(spin_Charges7.Value);
ASPxTextBox txt_How = pageControl.FindControl("txt_How") as ASPxTextBox;
job.Answer1 = txt_How.Text;
ASPxTextBox txt_Other = pageControl.FindControl("txt_Other") as ASPxTextBox;
job.Answer2 = txt_Other.Text;
ASPxTextBox txt_Move = pageControl.FindControl("txt_Move") as ASPxTextBox;
job.Answer3 = txt_Move.Text;
ASPxTextBox txt_UnsuccessRemark = pageControl.FindControl("txt_UnsuccessRemark") as ASPxTextBox;
job.Answer4 = txt_UnsuccessRemark.Text;
ASPxComboBox cmb_WorkStatus = grid_Issue.FindEditFormTemplateControl("cmb_WorkStatus") as ASPxComboBox;
job.WorkStatus = SafeValue.SafeString(cmb_WorkStatus.Value);
//Quotation
ASPxHtmlEditor txt_Attention1 = pageControl.FindControl("txt_Attention1") as ASPxHtmlEditor;
if (txt_Attention1 != null)
{
job.Attention1 = txt_Attention1.Html;
}
ASPxHtmlEditor txt_Attention2 = pageControl.FindControl("txt_Attention2") as ASPxHtmlEditor;
if (txt_Attention2 != null)
{
job.Attention2 = txt_Attention2.Html;
}
ASPxHtmlEditor txt_Attention3 = pageControl.FindControl("txt_Attention3") as ASPxHtmlEditor;
if (txt_Attention3 != null)
{
job.Attention3 = txt_Attention3.Html;
}
ASPxHtmlEditor txt_Attention4 = pageControl.FindControl("txt_Attention4") as ASPxHtmlEditor;
if (txt_Attention4 != null)
{
job.Attention4 = txt_Attention4.Html;
}
ASPxComboBox cmb_SalesId = grid_Issue.FindEditFormTemplateControl("cmb_SalesId") as ASPxComboBox;
job.Value4 = cmb_SalesId.Text;
ASPxMemo memo_Notes = pageControl.FindControl("memo_Notes") as ASPxMemo;
job.Notes = memo_Notes.Text;
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
job.CreateBy = userId;
job.CreateDateTime = DateTime.Now;
job.UpdateBy = userId;
job.UpdateDateTime = DateTime.Now;
job.JobNo = issueN;
Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(job);
// C2Setup.SetNextNo("", "JobOrder", issueN, issueDate.Date);
}
else
{
job.UpdateBy = userId;
job.UpdateDateTime = DateTime.Now;
bool isAddLog = false;
if (job.JobStatus == SafeValue.SafeString(ConnectSql.ExecuteScalar("Select JobStatus from JobInfo where JobNo='" + job.JobNo + "'")))
{
}
else
{
isAddLog = true;
}
Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(job);
if (isAddLog)
{
EzshipLog.Log(job.JobNo, "", "JO", job.JobStatus);
}
}
Session["SoWhere"] = "JobNo='" + job.JobNo + "'";
this.dsIssue.FilterExpression = Session["SoWhere"].ToString();
if (this.grid_Issue.GetRow(0) != null)
{
this.grid_Issue.StartEdit(0);
}
return(job.JobNo);
}
catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); }
return("");
}
private void Trip_Update(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxLabel lb_tripId = grd.FindEditFormTemplateControl("lb_tripId") as ASPxLabel;
string tripId = SafeValue.SafeString(lb_tripId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");;
C2.CtmJobDet2 trip = C2.ManagerEdi.ORManager.GetObject(query) as C2.CtmJobDet2;
string Driver_old = "";
bool isNew = false;
if (trip == null)
{
isNew = true;
trip = new C2.CtmJobDet2();
}
else
{
Driver_old = trip.DriverCode;
}
ASPxDropDownEdit dde_Trip_ContNo = grd.FindEditFormTemplateControl("dde_Trip_ContNo") as ASPxDropDownEdit;
ASPxTextBox dde_Trip_ContId = grd.FindEditFormTemplateControl("dde_Trip_ContId") as ASPxTextBox;
//ASPxButtonEdit btn_CfsCode = grd.FindEditFormTemplateControl("btn_CfsCode") as ASPxButtonEdit;
//ASPxComboBox cbb_Trip_BayCode = grd.FindEditFormTemplateControl("cbb_Trip_BayCode") as ASPxComboBox;
//ASPxComboBox cbb_Carpark = grd.FindEditFormTemplateControl("cbb_Carpark") as ASPxComboBox;
ASPxComboBox cbb_Trip_TripCode = grd.FindEditFormTemplateControl("cbb_Trip_TripCode") as ASPxComboBox;
ASPxButtonEdit btn_DriverCode = grd.FindEditFormTemplateControl("btn_DriverCode") as ASPxButtonEdit;
ASPxButtonEdit btn_TowheadCode = grd.FindEditFormTemplateControl("btn_TowheadCode") as ASPxButtonEdit;
ASPxButtonEdit btn_ChessisCode = grd.FindEditFormTemplateControl("btn_ChessisCode") as ASPxButtonEdit;
//ASPxComboBox cbb_Trip_SubletFlag = grd.FindEditFormTemplateControl("cbb_Trip_SubletFlag") as ASPxComboBox;
//ASPxTextBox txt_SubletHauliername = grd.FindEditFormTemplateControl("txt_SubletHauliername") as ASPxTextBox;
//ASPxComboBox cbb_StageCode = grd.FindEditFormTemplateControl("cbb_StageCode") as ASPxComboBox;
//ASPxComboBox cbb_StageStatus = grd.FindEditFormTemplateControl("cbb_StageStatus") as ASPxComboBox;
ASPxComboBox cbb_Trip_StatusCode = grd.FindEditFormTemplateControl("cbb_Trip_StatusCode") as ASPxComboBox;
ASPxComboBox cmb_DoubleMounting = grd.FindEditFormTemplateControl("cmb_DoubleMounting") as ASPxComboBox;
ASPxDateEdit txt_FromDate = grd.FindEditFormTemplateControl("txt_FromDate") as ASPxDateEdit;
ASPxTextBox txt_Trip_fromTime = grd.FindEditFormTemplateControl("txt_Trip_fromTime") as ASPxTextBox;
ASPxDateEdit date_Trip_toDate = grd.FindEditFormTemplateControl("date_Trip_toDate") as ASPxDateEdit;
ASPxTextBox txt_Trip_toTime = grd.FindEditFormTemplateControl("txt_Trip_toTime") as ASPxTextBox;
ASPxMemo txt_Trip_Remark = grd.FindEditFormTemplateControl("txt_Trip_Remark") as ASPxMemo;
ASPxMemo txt_Trip_FromCode = grd.FindEditFormTemplateControl("txt_Trip_FromCode") as ASPxMemo;
ASPxMemo txt_Trip_ToCode = grd.FindEditFormTemplateControl("txt_Trip_ToCode") as ASPxMemo;
//ASPxSpinEdit spin_Price = grd.FindEditFormTemplateControl("spin_Price") as ASPxSpinEdit;
ASPxComboBox cbb_zone = grd.FindEditFormTemplateControl("cbb_zone") as ASPxComboBox;
//ASPxSpinEdit spin_Incentive1 = grd.FindEditFormTemplateControl("spin_Incentive1") as ASPxSpinEdit;
//ASPxSpinEdit spin_Incentive2 = grd.FindEditFormTemplateControl("spin_Incentive2") as ASPxSpinEdit;
//ASPxSpinEdit spin_Incentive3 = grd.FindEditFormTemplateControl("spin_Incentive3") as ASPxSpinEdit;
//ASPxComboBox cbb_Incentive4 = grd.FindEditFormTemplateControl("cbb_Incentive4") as ASPxComboBox;
//ASPxComboBox cbb_Overtime = grd.FindEditFormTemplateControl("cbb_Overtime") as ASPxComboBox;
ASPxMemo txt_driver_remark = grd.FindEditFormTemplateControl("txt_driver_remark") as ASPxMemo;
//ASPxComboBox cbb_OverDistance = grd.FindEditFormTemplateControl("cbb_OverDistance") as ASPxComboBox;
ASPxTextBox fromPackingLot = grd.FindEditFormTemplateControl("txt_FromPL") as ASPxTextBox;
ASPxTextBox toPackingLot = grd.FindEditFormTemplateControl("txt_ToPL") as ASPxTextBox;
//check_Trip_Status("0", trip.DriverCode,trip.Statuscode);
//ASPxSpinEdit spin_Charge1 = grd.FindEditFormTemplateControl("spin_Charge1") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge2 = grd.FindEditFormTemplateControl("spin_Charge2") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge3 = grd.FindEditFormTemplateControl("spin_Charge3") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge4 = grd.FindEditFormTemplateControl("spin_Charge4") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge5 = grd.FindEditFormTemplateControl("spin_Charge5") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge6 = grd.FindEditFormTemplateControl("spin_Charge6") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge7 = grd.FindEditFormTemplateControl("spin_Charge7") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge8 = grd.FindEditFormTemplateControl("spin_Charge8") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge9 = grd.FindEditFormTemplateControl("spin_Charge9") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge10 = grd.FindEditFormTemplateControl("spin_Charge10") as ASPxSpinEdit;
ASPxSpinEdit txt_trip_qty = grd.FindEditFormTemplateControl("txt_trip_qty") as ASPxSpinEdit;
ASPxButtonEdit txt_Trip_PkgsType = grd.FindEditFormTemplateControl("txt_Trip_PkgsType") as ASPxButtonEdit;
ASPxSpinEdit txt_trip_Wt = grd.FindEditFormTemplateControl("txt_trip_Wt") as ASPxSpinEdit;
ASPxSpinEdit txt_trip_M3 = grd.FindEditFormTemplateControl("txt_trip_M3") as ASPxSpinEdit;
if (dde_Trip_ContNo != null)
{
trip.ContainerNo = SafeValue.SafeString(dde_Trip_ContNo.Value);
}
if (dde_Trip_ContId != null)
{
trip.Det1Id = SafeValue.SafeInt(dde_Trip_ContId.Text, 0);
}
//trip.CfsCode = SafeValue.SafeString(btn_CfsCode.Value);
//trip.BayCode = SafeValue.SafeString(cbb_Trip_BayCode.Value);
if (btn_DriverCode != null)
{
trip.DriverCode = SafeValue.SafeString(btn_DriverCode.Value);
}
if (btn_TowheadCode != null)
{
trip.TowheadCode = SafeValue.SafeString(btn_TowheadCode.Value);
}
if (btn_ChessisCode != null)
{
trip.ChessisCode = SafeValue.SafeString(btn_ChessisCode.Value);
}
//trip.SubletFlag = SafeValue.SafeString(cbb_Trip_SubletFlag.Value);
//trip.SubletHauliername = SafeValue.SafeString(txt_SubletHauliername.Text);
if (cbb_Trip_TripCode != null)
{
trip.TripCode = SafeValue.SafeString(cbb_Trip_TripCode.Value);
}
if (cmb_DoubleMounting != null)
{
trip.DoubleMounting = SafeValue.SafeString(cmb_DoubleMounting.Value, "No");
}
//trip.StageCode = SafeValue.SafeString(cbb_StageCode.Value);
//trip.Carpark = SafeValue.SafeString(cbb_Carpark.Value);
//trip.StageStatus = SafeValue.SafeString(cbb_StageStatus.Value);
if (cbb_Trip_StatusCode != null)
{
trip.Statuscode = SafeValue.SafeString(cbb_Trip_StatusCode.Value);
}
if (txt_FromDate != null)
{
trip.FromDate = SafeValue.SafeDate(txt_FromDate.Date, new DateTime(1990, 1, 1));
}
if (txt_Trip_fromTime != null)
{
trip.FromTime = SafeValue.SafeString(txt_Trip_fromTime.Text);
}
if (date_Trip_toDate != null)
{
trip.ToDate = SafeValue.SafeDate(date_Trip_toDate.Date, new DateTime(1990, 1, 1));
}
if (txt_Trip_toTime != null)
{
trip.ToTime = SafeValue.SafeString(txt_Trip_toTime.Text);
}
if (txt_Trip_Remark != null)
{
trip.Remark = SafeValue.SafeString(txt_Trip_Remark.Text);
}
if (txt_Trip_FromCode != null)
{
trip.FromCode = SafeValue.SafeString(txt_Trip_FromCode.Text);
}
if (txt_Trip_ToCode != null)
{
trip.ToCode = SafeValue.SafeString(txt_Trip_ToCode.Text);
}
//trip.Incentive1 = SafeValue.SafeDecimal(spin_Price.Text);
if (cbb_zone != null)
{
trip.ParkingZone = SafeValue.SafeString(cbb_zone.Value);
}
//trip.Incentive1 = SafeValue.SafeDecimal(spin_Incentive1.Text);
//trip.Incentive2 = SafeValue.SafeDecimal(spin_Incentive2.Text);
//trip.Incentive3 = SafeValue.SafeDecimal(spin_Incentive3.Text);
//trip.Incentive4 = SafeValue.SafeDecimal(cbb_Incentive4.Value);
//trip.Overtime = SafeValue.SafeSqlString(cbb_Overtime.Value);
//trip.OverDistance = SafeValue.SafeSqlString(cbb_OverDistance.Value);
if (txt_driver_remark != null)
{
trip.Remark1 = SafeValue.SafeString(txt_driver_remark.Text);
}
if (fromPackingLot != null)
{
trip.FromParkingLot = SafeValue.SafeString(fromPackingLot.Text);
}
if (toPackingLot != null)
{
trip.ToParkingLot = SafeValue.SafeString(toPackingLot.Text);
}
//trip.Charge1 = SafeValue.SafeDecimal(spin_Charge1.Text);
//trip.Charge2 = SafeValue.SafeDecimal(spin_Charge2.Text);
//trip.Charge3 = SafeValue.SafeDecimal(spin_Charge3.Text);
//trip.Charge4 = SafeValue.SafeDecimal(spin_Charge4.Text);
//trip.Charge5 = SafeValue.SafeDecimal(spin_Charge5.Text);
//trip.Charge6 = SafeValue.SafeDecimal(spin_Charge6.Text);
//trip.Charge7 = SafeValue.SafeDecimal(spin_Charge7.Text);
//trip.Charge8 = SafeValue.SafeDecimal(spin_Charge8.Text);
//trip.Charge9 = SafeValue.SafeDecimal(spin_Charge9.Text);
//trip.Charge10 = SafeValue.SafeDecimal(spin_Charge10.Text);
if (txt_trip_qty != null)
{
trip.Qty = SafeValue.SafeInt(txt_trip_qty.Text, 0);
}
if (txt_Trip_PkgsType != null)
{
trip.PackageType = SafeValue.SafeString(txt_Trip_PkgsType.Text);
}
if (txt_trip_Wt != null)
{
trip.Weight = SafeValue.SafeDecimal(txt_trip_Wt.Text);
}
if (txt_trip_M3 != null)
{
trip.Volume = SafeValue.SafeDecimal(txt_trip_M3.Text);
}
if (isNew)
{
trip.JobNo = "0";
C2.ManagerEdi.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Inserted);
C2.ManagerEdi.ORManager.PersistChanges(trip);
Event_Log("", "TRIP", 1, SafeValue.SafeInt(trip.Id, 0), "");
}
else
{
C2.ManagerEdi.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
C2.ManagerEdi.ORManager.PersistChanges(trip);
Event_Log("", "TRIP", 3, SafeValue.SafeInt(trip.Id, 0), "");
//EGL_JobTrip_AfterEndTrip("", dde_Trip_ContId.Text);
}
string re = HttpContext.Current.User.Identity.Name + "," + trip.Id + "," + trip.DriverCode;
if (!trip.DriverCode.Equals(Driver_old))
{
re += "," + Driver_old;
}
Session["NameTrip_" + trip.Id] = "Id=" + trip.Id + "";
this.dsTrip.FilterExpression = Session["NameTrip_" + trip.Id].ToString();
if (this.grid_Trip.GetRow(0) != null)
{
this.grid_Trip.CancelEdit();
}
e.Result = re;
}
private void Save()
{
ASPxTextBox invNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
ASPxComboBox partyTo = this.ASPxGridView1.FindEditFormTemplateControl("cmb_PartyTo") as ASPxComboBox;
ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxComboBox docType = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType") as ASPxComboBox;
ASPxDateEdit docDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocDt") as ASPxDateEdit;
ASPxMemo remarks1 = this.ASPxGridView1.FindEditFormTemplateControl("txt_Remarks1") as ASPxMemo;
ASPxComboBox termId = this.ASPxGridView1.FindEditFormTemplateControl("txt_TermId") as ASPxComboBox;
ASPxDateEdit dueDt = this.ASPxGridView1.FindEditFormTemplateControl("txt_DueDt") as ASPxDateEdit;
ASPxButtonEdit docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit;
ASPxSpinEdit exRate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocExRate") as ASPxSpinEdit;
ASPxTextBox acCode = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcCode") as ASPxTextBox;
ASPxComboBox acSource = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcSource") as ASPxComboBox;
ASPxTextBox txt_MastRefNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_MastRefNo") as ASPxTextBox;
ASPxComboBox cbo_DocCate = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocCate") as ASPxComboBox;
string invN = docN.Text;
C2.XAArInvoice inv = Manager.ORManager.GetObject(typeof(XAArInvoice), SafeValue.SafeInt(invNCtr.Text, 0)) as XAArInvoice;
if (inv == null)// first insert invoice
{
string counterType = "AR-IV";
if (docType.Value.ToString() == "DN")
{
counterType = "AR-DN";
}
inv = new XAArInvoice();
inv.DocType = docType.Value.ToString();
inv.DocDate = docDate.Date;
invN = C2Setup.GetNextNo(inv.DocType, counterType, inv.DocDate);
inv.PartyTo = SafeValue.SafeString(partyTo.Value, "");
inv.DocNo = invN.ToString();
string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date);
inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year);
inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month);
inv.Term = termId.Text;
//
int dueDay = SafeValue.SafeInt(termId.Text.ToUpper().Replace("DAYS", "").Trim(), 0);
inv.DocDueDate = inv.DocDate.AddDays(dueDay);//SafeValue.SafeDate(dueDt.Text, DateTime.Now);
inv.Description = remarks1.Text;
inv.CurrencyId = docCurr.Text.ToString();
inv.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
if (inv.ExRate <= 0)
{
inv.ExRate = 1;
}
inv.AcCode = EzshipHelper.GetAccArCode(inv.PartyTo, inv.CurrencyId);;
inv.AcSource = acSource.Value.ToString();
inv.MastRefNo = "0";
inv.JobRefNo = "0";
inv.MastType = "";
inv.ExportInd = "N";
inv.UserId = HttpContext.Current.User.Identity.Name;
inv.EntryDate = DateTime.Now;
inv.CancelDate = new DateTime(1900, 1, 1);
inv.CancelInd = "N";
try
{
C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(inv);
C2Setup.SetNextNo("", counterType, invN, inv.DocDate);
}
catch
{
}
}
else
{
inv.PartyTo = SafeValue.SafeString(partyTo.Value, "");
inv.Term = termId.Text;
inv.DocDate = docDate.Date;
string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date);
inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year);
inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month);
int dueDay = SafeValue.SafeInt(termId.Text.ToUpper().Replace("DAYS", "").Trim(), 0);
inv.DocDueDate = inv.DocDate.AddDays(dueDay);//SafeValue.SafeDate(dueDt.Text, DateTime.Now);
inv.Description = remarks1.Text;
inv.CurrencyId = docCurr.Text.ToString();
inv.ExRate = SafeValue.SafeDecimal(exRate.Value, 1);
if (inv.ExRate <= 0)
{
inv.ExRate = 1;
}
inv.AcCode = EzshipHelper.GetAccArCode(inv.PartyTo, inv.CurrencyId);
inv.AcSource = acSource.Text;
inv.MastRefNo = txt_MastRefNo.Text;
inv.MastType = SafeValue.SafeString(cbo_DocCate.Value);
try
{
Manager.ORManager.StartTracking(inv, InitialState.Updated);
Manager.ORManager.PersistChanges(inv);
}
catch
{
}
UpdateMaster(inv.SequenceId);
}
Session["InvoiceEditWhere"] = "SequenceId=" + inv.SequenceId;
this.dsArInvoice.FilterExpression = Session["InvoiceEditWhere"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
private void SaveJob()
{
try
{
ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txtRefNo = this.grid_ref.FindEditFormTemplateControl("txtRefNo") as ASPxTextBox;
ASPxTextBox txt_Id = this.grid_ref.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
ASPxDateEdit refDate = this.grid_ref.FindEditFormTemplateControl("date_RefDate") as ASPxDateEdit;
string refNo = SafeValue.SafeString(txt_RefNo.Text, "");
int id = SafeValue.SafeInt(txt_Id.Text, 0);
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(AirImportRef), "Id=" + id + "");
AirImportRef airRef = C2.Manager.ORManager.GetObject(query) as AirImportRef;
bool isNew = false;
string userId = HttpContext.Current.User.Identity.Name;
if (airRef == null)
{
airRef = new AirImportRef();
isNew = true;
refNo = C2Setup.GetNextNo("ACT", "AirCrossTrade", refDate.Date);
AirImport air = new AirImport();
air.JobNo = C2Setup.GetSubNo(refNo, "ACT");
air.CloseInd = "N";
air.CreateBy = userId;
air.CreateDateTime = DateTime.Now;
air.RefNo = refNo;
air.Total = "0";
air.RefType = "ACT";
air.StatusCode = "USE";
C2.Manager.ORManager.StartTracking(air, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(air);
}
ASPxButtonEdit txt_AgentId = this.grid_ref.FindEditFormTemplateControl("txt_AgentId") as ASPxButtonEdit;
airRef.AgentId = txt_AgentId.Text;
ASPxButtonEdit localCust = this.grid_ref.FindEditFormTemplateControl("txt_LocalCust") as ASPxButtonEdit;
airRef.LocalCust = localCust.Text;
ASPxMemo remarks = pageControl.FindControl("txt_Remarks") as ASPxMemo;
airRef.Remarks = remarks.Text;
ASPxButtonEdit tbxAirportCode0 = pageControl.FindControl("tbxAirportCode0") as ASPxButtonEdit;
airRef.AirportCode0 = tbxAirportCode0.Text;
ASPxTextBox tbxAirportName0 = pageControl.FindControl("tbxAirportName0") as ASPxTextBox;
airRef.AirportName0 = tbxAirportName0.Text;
ASPxDateEdit date_FlightDate0 = pageControl.FindControl("date_FlightDate0") as ASPxDateEdit;
airRef.FlightDate0 = date_FlightDate0.Date;
ASPxTextBox tbxFlightTime0 = pageControl.FindControl("tbxFlightTime0") as ASPxTextBox;
airRef.FlightTime0 = tbxFlightTime0.Text;
airRef.RefDate = refDate.Date;
ASPxButtonEdit tbxAirportCode1 = pageControl.FindControl("txt_AirportCode1") as ASPxButtonEdit;
airRef.AirportCode1 = tbxAirportCode1.Text;
ASPxTextBox tbxAirportName1 = pageControl.FindControl("txt_AirportName1") as ASPxTextBox;
airRef.AirportName1 = tbxAirportName1.Text;
ASPxDateEdit spin_FlightDate1 = pageControl.FindControl("spin_FlightDate1") as ASPxDateEdit;
airRef.FlightDate1 = spin_FlightDate1.Date;
ASPxTextBox txt_FlightTime1 = pageControl.FindControl("txt_FlightTime1") as ASPxTextBox;
airRef.FlightTime1 = txt_FlightTime1.Text;
ASPxTextBox tbxAirlineCode1 = pageControl.FindControl("tbxAirlineCode1") as ASPxTextBox;
airRef.AirlineCode1 = tbxAirlineCode1.Text;
ASPxTextBox tbxAirlineName1 = pageControl.FindControl("tbxAirlineName1") as ASPxTextBox;
airRef.AirlineName1 = tbxAirlineName1.Text;
ASPxTextBox tbxFlightNo1 = pageControl.FindControl("tbxFlightNo1") as ASPxTextBox;
airRef.FlightNo1 = tbxFlightNo1.Text;
ASPxDateEdit tbxAirFlightDate1 = pageControl.FindControl("tbxAirFlightDate1") as ASPxDateEdit;
airRef.AirFlightDate1 = tbxAirFlightDate1.Date;
ASPxTextBox tbxAirFlightTime1 = pageControl.FindControl("tbxAirFlightTime1") as ASPxTextBox;
airRef.AirFlightTime1 = tbxAirFlightTime1.Text;
ASPxButtonEdit tbxAirLinePortCode1 = pageControl.FindControl("tbxAirLinePortCode1") as ASPxButtonEdit;
airRef.AirLinePortCode1 = tbxAirLinePortCode1.Text;
ASPxTextBox tbxAirLinePortName1 = pageControl.FindControl("tbxAirLinePortName1") as ASPxTextBox;
airRef.AirLinePortName1 = tbxAirLinePortName1.Text;
ASPxTextBox tbxAirlineCode2 = pageControl.FindControl("tbxAirlineCode2") as ASPxTextBox;
airRef.AirlineCode2 = tbxAirlineCode2.Text;
ASPxTextBox tbxAirlineName2 = pageControl.FindControl("tbxAirlineName2") as ASPxTextBox;
airRef.AirlineName2 = tbxAirlineName2.Text;
ASPxTextBox tbxFlightNo2 = pageControl.FindControl("tbxFlightNo2") as ASPxTextBox;
airRef.FlightNo2 = tbxFlightNo2.Text;
ASPxDateEdit tbxFlightDate2 = pageControl.FindControl("tbxFlightDate2") as ASPxDateEdit;
airRef.FlightDate2 = tbxFlightDate2.Date;
ASPxTextBox tbxFlightTime2 = pageControl.FindControl("tbxFlightTime2") as ASPxTextBox;
airRef.FlightTime2 = tbxFlightTime2.Text;
ASPxButtonEdit tbxAirportCode2 = pageControl.FindControl("tbxAirportCode2") as ASPxButtonEdit;
airRef.AirportCode2 = tbxAirportCode2.Text;
ASPxTextBox AirportName2 = pageControl.FindControl("tbxAirportName2") as ASPxTextBox;
airRef.AirportName2 = AirportName2.Text;
ASPxTextBox tbxAirlineCode3 = pageControl.FindControl("tbxAirlineCode3") as ASPxTextBox;
airRef.AirlineCode3 = tbxAirlineCode3.Text;
ASPxTextBox tbxAirlineName3 = pageControl.FindControl("tbxAirlineName3") as ASPxTextBox;
airRef.AirlineName3 = tbxAirlineName3.Text;
ASPxTextBox tbxFlightNo3 = pageControl.FindControl("tbxFlightNo3") as ASPxTextBox;
airRef.FlightNo3 = tbxFlightNo3.Text;
ASPxDateEdit tbxFlightDate3 = pageControl.FindControl("tbxFlightDate3") as ASPxDateEdit;
airRef.FlightDate3 = tbxFlightDate3.Date;
ASPxTextBox tbxFlightTime3 = pageControl.FindControl("tbxFlightTime3") as ASPxTextBox;
airRef.FlightTime3 = tbxFlightTime3.Text;
ASPxButtonEdit tbxAirportCode3 = pageControl.FindControl("tbxAirportCode3") as ASPxButtonEdit;
airRef.AirportCode3 = tbxAirportCode3.Text;
ASPxTextBox tbxAirportName3 = pageControl.FindControl("tbxAirportName3") as ASPxTextBox;
airRef.AirportName3 = tbxAirportName3.Text;
ASPxTextBox tbxAirlineCode4 = pageControl.FindControl("tbxAirlineCode4") as ASPxTextBox;
airRef.AirlineCode4 = tbxAirlineCode4.Text;
ASPxTextBox tbxAirlineName4 = pageControl.FindControl("tbxAirlineName4") as ASPxTextBox;
airRef.AirlineName4 = tbxAirlineName4.Text;
ASPxTextBox tbxFlightNo4 = pageControl.FindControl("tbxFlightNo4") as ASPxTextBox;
airRef.FlightNo4 = tbxFlightNo4.Text;
ASPxDateEdit tbxFlightDate4 = pageControl.FindControl("tbxFlightDate4") as ASPxDateEdit;
airRef.FlightDate4 = tbxFlightDate4.Date;
ASPxTextBox tbxFlightTime4 = pageControl.FindControl("tbxFlightTime4") as ASPxTextBox;
airRef.FlightTime4 = tbxFlightTime4.Text;
ASPxButtonEdit tbxAirportCode4 = pageControl.FindControl("tbxAirportCode4") as ASPxButtonEdit;
airRef.AirportCode4 = tbxAirportCode4.Text;
ASPxTextBox AirportName4 = pageControl.FindControl("tbxAirportName4") as ASPxTextBox;
airRef.AirportName4 = AirportName4.Text;
ASPxTextBox txtMAWB = this.grid_ref.FindEditFormTemplateControl("txt_MAWB") as ASPxTextBox;
airRef.Mawb = txtMAWB.Text;
ASPxButtonEdit txt_CrAgentId = this.grid_ref.FindEditFormTemplateControl("txt_CrAgentId") as ASPxButtonEdit;
airRef.CarrierAgentId = txt_CrAgentId.Text;
ASPxTextBox txt_CrBkgRefN = this.grid_ref.FindEditFormTemplateControl("txt_CrBkgRefN") as ASPxTextBox;
airRef.CarrierBkgNo = txt_CrBkgRefN.Text;
ASPxButtonEdit txt_NvoccAgentId = pageControl.FindControl("txt_NvoccAgentId") as ASPxButtonEdit;
airRef.NvoccAgentId = txt_NvoccAgentId.Text;
ASPxTextBox txt_NvoccBl = pageControl.FindControl("txt_NvoccBl") as ASPxTextBox;
airRef.NvoccBlNO = txt_NvoccBl.Text;
ASPxButtonEdit cbx_Currency = pageControl.FindControl("cbx_Currency") as ASPxButtonEdit;
airRef.CurrencyId = cbx_Currency.Text;
ASPxSpinEdit spin_CrExRate = pageControl.FindControl("spin_CrExRate") as ASPxSpinEdit;
airRef.ExRate = SafeValue.SafeDecimal(spin_CrExRate.Value, 0);
ASPxButtonEdit txt_WhId = pageControl.FindControl("txt_WhId") as ASPxButtonEdit;
airRef.WareHouseId = txt_WhId.Text;
ASPxMemo tbxShipperName = pageControl.FindControl("tbxShipperName") as ASPxMemo;
airRef.ShipperName = tbxShipperName.Text;
ASPxMemo tbxIssuedBy = pageControl.FindControl("tbxIssuedBy") as ASPxMemo;
airRef.IssuedBy = tbxIssuedBy.Text;
ASPxMemo tbxConsigneeName = pageControl.FindControl("tbxConsigneeName") as ASPxMemo;
airRef.ConsigneeName = tbxConsigneeName.Text;
ASPxMemo tbxCarrierAgent = pageControl.FindControl("tbxCarrierAgent") as ASPxMemo;
airRef.CarrierAgent = tbxCarrierAgent.Text;
ASPxMemo tbxAccountInfo = pageControl.FindControl("tbxAccountInfo") as ASPxMemo;
airRef.AccountInfo = tbxAccountInfo.Text;
ASPxTextBox tbxAgentIATACode = pageControl.FindControl("tbxAgentIATACode") as ASPxTextBox;
airRef.AgentIATACode = tbxAgentIATACode.Text;
ASPxTextBox tbxAgentAccountNo = pageControl.FindControl("tbxAgentAccountNo") as ASPxTextBox;
airRef.AgentAccountNo = tbxAgentAccountNo.Text;
ASPxTextBox tbxAirportDeparture = pageControl.FindControl("tbxAirportDeparture") as ASPxTextBox;
airRef.AirportDeparture = tbxAirportDeparture.Text;
ASPxTextBox tbxConnDest1 = pageControl.FindControl("tbxConnDest1") as ASPxTextBox;
airRef.ConnDest1 = tbxConnDest1.Text;
ASPxTextBox tbxConnCarrier1 = pageControl.FindControl("tbxConnCarrier1") as ASPxTextBox;
airRef.ConnCarrier1 = tbxConnCarrier1.Text;
ASPxTextBox tbxConnDest2 = pageControl.FindControl("tbxConnDest2") as ASPxTextBox;
airRef.ConnDest2 = tbxConnDest2.Text;
ASPxTextBox tbxConnCarrier2 = pageControl.FindControl("tbxConnCarrier2") as ASPxTextBox;
airRef.ConnCarrier2 = tbxConnCarrier2.Text;
ASPxTextBox tbxConnDest3 = pageControl.FindControl("tbxConnDest3") as ASPxTextBox;
airRef.ConnDest3 = tbxConnDest3.Text;
ASPxTextBox tbxConnCarrier3 = pageControl.FindControl("tbxConnCarrier3") as ASPxTextBox;
airRef.ConnCarrier3 = tbxConnCarrier3.Text;
ASPxTextBox tbxCurrency = pageControl.FindControl("tbxCurrency") as ASPxTextBox;
airRef.Currency = tbxCurrency.Text;
ASPxTextBox tbxChgsCode = pageControl.FindControl("tbxChgsCode") as ASPxTextBox;
airRef.ChgsCode = tbxChgsCode.Text;
ASPxTextBox tbxPPD1 = pageControl.FindControl("tbxPPD1") as ASPxTextBox;
airRef.Ppd1 = tbxPPD1.Text;
ASPxTextBox tbxCOLL1 = pageControl.FindControl("tbxCOLL1") as ASPxTextBox;
airRef.Coll1 = tbxCOLL1.Text;
ASPxTextBox tbxPPD2 = pageControl.FindControl("tbxPPD2") as ASPxTextBox;
airRef.Ppd2 = tbxPPD2.Text;
ASPxTextBox tbxCOLL2 = pageControl.FindControl("tbxCOLL2") as ASPxTextBox;
airRef.Coll2 = tbxCOLL2.Text;
ASPxTextBox tbxCarriageValue = pageControl.FindControl("tbxCarriageValue") as ASPxTextBox;
airRef.CarriageValue = tbxCarriageValue.Text;
ASPxTextBox tbxCustomValue = pageControl.FindControl("tbxCustomValue") as ASPxTextBox;
airRef.CustomValue = tbxCustomValue.Text;
ASPxTextBox tbxAirportDestination = pageControl.FindControl("tbxAirportDestination") as ASPxTextBox;
airRef.AirportDestination = tbxAirportDestination.Text;
ASPxTextBox tbxRequestedFlight = pageControl.FindControl("tbxRequestedFlight") as ASPxTextBox;
airRef.RequestedFlight = tbxRequestedFlight.Text;
ASPxTextBox tbxRequestedDate = pageControl.FindControl("tbxRequestedDate") as ASPxTextBox;
airRef.RequestedDate = tbxRequestedDate.Text;
ASPxTextBox tbxAmountInsurance = pageControl.FindControl("tbxAmountInsurance") as ASPxTextBox;
airRef.AmountInsurance = tbxAmountInsurance.Text;
ASPxMemo tbxHandlingInfo = pageControl.FindControl("tbxHandlingInfo") as ASPxMemo;
airRef.HandlingInfo = tbxHandlingInfo.Text;
ASPxTextBox tbxPiece = pageControl.FindControl("tbxPiece") as ASPxTextBox;
airRef.Piece = tbxPiece.Text;
ASPxSpinEdit tbxGrossWeight = pageControl.FindControl("tbxGrossWeight") as ASPxSpinEdit;
airRef.GrossWeight = tbxGrossWeight.Text;
ASPxSpinEdit tbxUnit = pageControl.FindControl("tbxUnit") as ASPxSpinEdit;
airRef.Unit = tbxUnit.Text;
ASPxTextBox tbxRateClass = pageControl.FindControl("tbxRateClass") as ASPxTextBox;
airRef.RateClass = tbxRateClass.Text;
ASPxTextBox tbxCommodityItemNo = pageControl.FindControl("tbxCommodityItemNo") as ASPxTextBox;
airRef.CommodityItemNo = tbxCommodityItemNo.Text;
ASPxSpinEdit tbxChargeableWeight = pageControl.FindControl("tbxChargeableWeight") as ASPxSpinEdit;
airRef.ChargeableWeight = tbxChargeableWeight.Text;
ASPxTextBox tbxRateCharge = pageControl.FindControl("tbxRateCharge") as ASPxTextBox;
airRef.RateCharge = tbxRateCharge.Text;
ASPxSpinEdit tbxTotal = pageControl.FindControl("tbxTotal") as ASPxSpinEdit;
airRef.Total = tbxTotal.Text;
ASPxMemo tbxGoodsNature = pageControl.FindControl("tbxGoodsNature") as ASPxMemo;
airRef.GoodsNature = tbxGoodsNature.Text;
ASPxMemo tbxContentRemark = pageControl.FindControl("tbxContentRemark") as ASPxMemo;
airRef.ContentRemark = tbxContentRemark.Text;
ASPxTextBox tbxWeightChargeP = pageControl.FindControl("tbxWeightChargeP") as ASPxTextBox;
airRef.WeightChargeP = tbxWeightChargeP.Text;
ASPxTextBox tbxWeightChargeC = pageControl.FindControl("tbxWeightChargeC") as ASPxTextBox;
airRef.WeightChargeC = tbxWeightChargeC.Text;
ASPxTextBox tbxValuationChargeP = pageControl.FindControl("tbxValuationChargeP") as ASPxTextBox;
airRef.ValuationChargeP = tbxValuationChargeP.Text;
ASPxTextBox tbxValuationChargeC = pageControl.FindControl("tbxValuationChargeC") as ASPxTextBox;
airRef.ValuationChargeC = tbxValuationChargeC.Text;
ASPxTextBox tbxTaxP = pageControl.FindControl("tbxTaxP") as ASPxTextBox;
airRef.TaxP = tbxTaxP.Text;
ASPxTextBox tbxTaxC = pageControl.FindControl("tbxTaxC") as ASPxTextBox;
airRef.TaxC = tbxTaxC.Text;
ASPxTextBox tbxOtherAgentChargeP = pageControl.FindControl("tbxOtherAgentChargeP") as ASPxTextBox;
airRef.OtherAgentChargeP = tbxOtherAgentChargeP.Text;
ASPxTextBox tbxOtherAgentChargeC = pageControl.FindControl("tbxOtherAgentChargeC") as ASPxTextBox;
airRef.OtherAgentChargeC = tbxOtherAgentChargeC.Text;
ASPxTextBox tbxOtherCarrierChargeP = pageControl.FindControl("tbxOtherCarrierChargeP") as ASPxTextBox;
airRef.OtherCarrierChargeP = tbxOtherCarrierChargeP.Text;
ASPxTextBox tbxOtherCarrierChargeC = pageControl.FindControl("tbxOtherCarrierChargeC") as ASPxTextBox;
airRef.OtherCarrierChargeC = tbxOtherCarrierChargeC.Text;
ASPxTextBox tbxTotalPrepaid = pageControl.FindControl("tbxTotalPrepaid") as ASPxTextBox;
airRef.TotalPrepaid = tbxTotalPrepaid.Text;
ASPxTextBox tbxTotalCollect = pageControl.FindControl("tbxTotalCollect") as ASPxTextBox;
airRef.TotalCollect = tbxTotalCollect.Text;
ASPxTextBox tbxCurrencyRate = pageControl.FindControl("tbxCurrencyRate") as ASPxTextBox;
airRef.CurrencyRate = tbxCurrencyRate.Text;
ASPxTextBox tbxChargeDestCurrency = pageControl.FindControl("tbxChargeDestCurrency") as ASPxTextBox;
airRef.ChargeDestCurrency = tbxChargeDestCurrency.Text;
ASPxTextBox tbxOtherCharge1 = pageControl.FindControl("tbxOtherCharge1") as ASPxTextBox;
airRef.OtherCharge1 = tbxOtherCharge1.Text;
ASPxTextBox tbxOtherCharge1Currency = pageControl.FindControl("tbxOtherCharge1Currency") as ASPxTextBox;
airRef.OtherCharge1Currency = tbxOtherCharge1Currency.Text;
ASPxSpinEdit tbxOtherCharge1Amount = pageControl.FindControl("tbxOtherCharge1Amount") as ASPxSpinEdit;
airRef.OtherCharge1Amount = SafeValue.SafeDecimal(tbxOtherCharge1Amount.Text);
ASPxTextBox tbxOtherCharge2 = pageControl.FindControl("tbxOtherCharge2") as ASPxTextBox;
airRef.OtherCharge2 = tbxOtherCharge2.Text;
ASPxTextBox tbxOtherCharge2Currency = pageControl.FindControl("tbxOtherCharge2Currency") as ASPxTextBox;
airRef.OtherCharge2Currency = tbxOtherCharge2Currency.Text;
ASPxSpinEdit tbxOtherCharge2Amount = pageControl.FindControl("tbxOtherCharge2Amount") as ASPxSpinEdit;
airRef.OtherCharge2Amount = SafeValue.SafeDecimal(tbxOtherCharge2Amount.Text);
ASPxTextBox tbxOtherCharge3 = pageControl.FindControl("tbxOtherCharge3") as ASPxTextBox;
airRef.OtherCharge3 = tbxOtherCharge3.Text;
ASPxTextBox tbxOtherCharge3Currency = pageControl.FindControl("tbxOtherCharge3Currency") as ASPxTextBox;
airRef.OtherCharge3Currency = tbxOtherCharge3Currency.Text;
ASPxSpinEdit tbxOtherCharge3Amount = pageControl.FindControl("tbxOtherCharge3Amount") as ASPxSpinEdit;
airRef.OtherCharge3Amount = SafeValue.SafeDecimal(tbxOtherCharge3Amount.Text);
ASPxTextBox tbxOtherCharge4 = pageControl.FindControl("tbxOtherCharge4") as ASPxTextBox;
airRef.OtherCharge4 = tbxOtherCharge4.Text;
ASPxTextBox tbxOtherCharge4Currency = pageControl.FindControl("tbxOtherCharge4Currency") as ASPxTextBox;
airRef.OtherCharge4Currency = tbxOtherCharge4Currency.Text;
ASPxSpinEdit tbxOtherCharge4Amount = pageControl.FindControl("tbxOtherCharge4Amount") as ASPxSpinEdit;
airRef.OtherCharge4Amount = SafeValue.SafeDecimal(tbxOtherCharge4Amount.Text);
ASPxTextBox tbxOtherCharge5 = pageControl.FindControl("tbxOtherCharge5") as ASPxTextBox;
airRef.OtherCharge5 = tbxOtherCharge5.Text;
ASPxTextBox tbxOtherCharge5Currency = pageControl.FindControl("tbxOtherCharge5Currency") as ASPxTextBox;
airRef.OtherCharge5Currency = tbxOtherCharge5Currency.Text;
ASPxSpinEdit tbxOtherCharge5Amount = pageControl.FindControl("tbxOtherCharge5Amount") as ASPxSpinEdit;
airRef.OtherCharge5Amount = SafeValue.SafeDecimal(tbxOtherCharge5Amount.Text);
ASPxTextBox tbxSignatureShipper = pageControl.FindControl("tbxSignatureShipper") as ASPxTextBox;
airRef.SignatureShipper = tbxSignatureShipper.Text;
ASPxTextBox tbxExecuteDate = pageControl.FindControl("tbxExecuteDate") as ASPxTextBox;
airRef.ExecuteDate = tbxExecuteDate.Text;
ASPxTextBox tbxExecutePlace = pageControl.FindControl("tbxExecutePlace") as ASPxTextBox;
airRef.ExecutePlace = tbxExecutePlace.Text;
ASPxTextBox tbxSignatureIssuing = pageControl.FindControl("tbxSignatureIssuing") as ASPxTextBox;
airRef.SignatureIssuing = tbxSignatureIssuing.Text;
if (isNew)
{
airRef.CloseInd = "N";
airRef.CreateBy = userId;
airRef.CreateDateTime = DateTime.Now;
airRef.RefNo = refNo.ToString();
airRef.RefType = "ACT";
airRef.UpdateBy = userId;
airRef.UpdateDateTime = DateTime.Now;
airRef.StatusCode = "USE";
Manager.ORManager.StartTracking(airRef, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(airRef);
C2Setup.SetNextNo(airRef.RefType, "AirCrossTrade", refNo, airRef.RefDate);
}
else
{
airRef.UpdateBy = userId;
airRef.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(airRef, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(airRef);
}
Session["CtMastWhere"] = "RefNo='" + refNo + "'";
this.dsImportRef.FilterExpression = Session["CtMastWhere"].ToString();
if (this.grid_ref.GetRow(0) != null)
{
this.grid_ref.StartEdit(0);
}
}
catch { }
}
protected string SaveLc()
{
try
{
ASPxTextBox txt_LcNo = grid.FindEditFormTemplateControl("txt_LcNo") as ASPxTextBox;
ASPxTextBox txt_Id = grid.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string id = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(RefLc), "Id='" + id + "'");
RefLc lc = C2.Manager.ORManager.GetObject(query) as RefLc;
ASPxDateEdit date_AppDate = grid.FindEditFormTemplateControl("date_AppDate") as ASPxDateEdit;
bool isNew = false;
//const string runType = "DOOUT";
string lcNo = "";
if (lc == null)
{
lc = new RefLc();
isNew = true;
lcNo = C2Setup.GetNextNo("", "LetterOfCredit", date_AppDate.Date);
lc.LcAppDate = date_AppDate.Date;
}
ASPxComboBox cmb_Type = grid.FindEditFormTemplateControl("cmb_Type") as ASPxComboBox;
lc.LcType = cmb_Type.Text;
ASPxDateEdit date_LcExpirtDate = grid.FindEditFormTemplateControl("date_LcExpirtDate") as ASPxDateEdit;
lc.LcExpirtDate = date_LcExpirtDate.Date;
//Main Info
ASPxTextBox txt_TempNo = grid.FindEditFormTemplateControl("txt_TempNo") as ASPxTextBox;
lc.LcTempNo = txt_TempNo.Text;
ASPxTextBox txt_LcRefNo = grid.FindEditFormTemplateControl("txt_LcRefNo") as ASPxTextBox;
lc.LcRef = txt_LcRefNo.Text;
ASPxTextBox txt_LcExpirtPlace = grid.FindEditFormTemplateControl("txt_LcExpirtPlace") as ASPxTextBox;
lc.LcExpirtPlace = txt_LcExpirtPlace.Text;
ASPxButtonEdit txt_EntityCode = grid.FindEditFormTemplateControl("txt_EntityCode") as ASPxButtonEdit;
lc.LcEntityCode = txt_EntityCode.Text;
ASPxTextBox txt_EntityName = grid.FindEditFormTemplateControl("txt_EntityName") as ASPxTextBox;
lc.LcEntityName = txt_EntityName.Text;
ASPxMemo memo_EntityAddress = grid.FindEditFormTemplateControl("memo_EntityAddress") as ASPxMemo;
lc.LcEntityAddress = memo_EntityAddress.Text;
ASPxButtonEdit btn_BeneCode = grid.FindEditFormTemplateControl("btn_BeneCode") as ASPxButtonEdit;
lc.LcBeneCode = btn_BeneCode.Text;
ASPxTextBox txt_LcBeneName = grid.FindEditFormTemplateControl("txt_LcBeneName") as ASPxTextBox;
lc.LcBeneName = txt_LcBeneName.Text;
ASPxMemo memo_BeneAddress = grid.FindEditFormTemplateControl("memo_BeneAddress") as ASPxMemo;
lc.LcBeneAddress = memo_BeneAddress.Text;
ASPxButtonEdit btn_BankCode = grid.FindEditFormTemplateControl("btn_BankCode") as ASPxButtonEdit;
lc.BankCode = btn_BankCode.Text;
ASPxTextBox txt_BankName = grid.FindEditFormTemplateControl("txt_BankName") as ASPxTextBox;
lc.BankName = txt_BankName.Text;
ASPxMemo memo_BankAddress = grid.FindEditFormTemplateControl("memo_BankAddress") as ASPxMemo;
lc.BankAddress = memo_BankAddress.Text;
ASPxTextBox txt_Branch = grid.FindEditFormTemplateControl("txt_Branch") as ASPxTextBox;
lc.BankBranch = txt_Branch.Text;
ASPxTextBox txt_BankRef = grid.FindEditFormTemplateControl("txt_BankRef") as ASPxTextBox;
lc.BankRef = txt_BankRef.Text;
ASPxSpinEdit spin_BankTenor = grid.FindEditFormTemplateControl("spin_BankTenor") as ASPxSpinEdit;
lc.BankTenor = SafeValue.SafeInt(spin_BankTenor.Text, 0);
ASPxSpinEdit spin_LcAmount = grid.FindEditFormTemplateControl("spin_LcAmount") as ASPxSpinEdit;
lc.LcAmount = SafeValue.SafeDecimal(spin_LcAmount.Value, 1);
ASPxButtonEdit currency = grid.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit;
lc.LcCurrency = currency.Text;
ASPxSpinEdit exRate = grid.FindEditFormTemplateControl("spin_ExRate") as ASPxSpinEdit;
lc.LcExRate = SafeValue.SafeDecimal(exRate.Value, 1);
ASPxTextBox txt_LcMode = grid.FindEditFormTemplateControl("txt_LcMode") as ASPxTextBox;
lc.LcMode = txt_LcMode.Text;
ASPxComboBox cmb_Status = grid.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
lc.StatusCode = cmb_Status.Text;
string userId = HttpContext.Current.User.Identity.Name;
if (isNew)
{
lc.CreateBy = userId;
lc.CreateDateTime = DateTime.Now;
lc.LcNo = lcNo;
Manager.ORManager.StartTracking(lc, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(lc);
C2Setup.SetNextNo("", "LetterOfCredit", lcNo, date_AppDate.Date);
}
else
{
lc.UpdateBy = userId;
lc.UpdateDateTime = DateTime.Now;
bool isAddLog = false;
if (lc.StatusCode == SafeValue.SafeString(ConnectSql.ExecuteScalar("Select StatusCode from Ref_LC where LcNo='" + lc.LcNo + "'")))
{
}
else
{
isAddLog = true;
}
Manager.ORManager.StartTracking(lc, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(lc);
if (isAddLog)
{
EzshipLog.Log(lc.LcNo, "", lc.LcType, lc.StatusCode);
}
}
Session["RefLC"] = "LcNo='" + lc.LcNo + "'";
this.dsLc.FilterExpression = Session["RefLC"].ToString();
if (this.grid.GetRow(0) != null)
{
this.grid.StartEdit(0);
}
return(lc.LcNo);
}
catch { }
return("");
}
private void SaveJob()
{
try
{
string userId = HttpContext.Current.User.Identity.Name;
ASPxPageControl pageControl = this.grid_Export.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl;
//ASPxTextBox houseId = pageControl.FindControl("txtHouseId") as ASPxTextBox;
ASPxTextBox expNoCtr = this.grid_Export.FindEditFormTemplateControl("txtHouseNo") as ASPxTextBox;
int expN = 0; //SafeValue.SafeInt(expNoCtr.Text,0);
string expNs = expNoCtr.Text.Trim();
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(AirImport), "JobNo='" + expNs + "'");
AirImport exp = C2.Manager.ORManager.GetObject(query) as AirImport;
bool isNew = false;
if (exp == null)
{
isNew = true;
expN = 0;
exp = new AirImport();
exp.RefNo = Request.QueryString["masterNo"].ToString();
exp.JobNo = C2Setup.GetSubNo(exp.RefNo, "AI");
exp.CreateBy = userId;
exp.CreateDateTime = DateTime.Now;
exp.Total = "0";
exp.RefType = "AI";
exp.StatusCode = "USE";
}
ASPxSpinEdit spin_Weight = this.grid_Export.FindEditFormTemplateControl("spin_Weight") as ASPxSpinEdit;
exp.Weight = SafeValue.SafeDecimal(spin_Weight.Text);
ASPxSpinEdit spin_Volume = this.grid_Export.FindEditFormTemplateControl("spin_Volume") as ASPxSpinEdit;
exp.Volume = SafeValue.SafeDecimal(spin_Volume.Text);
ASPxSpinEdit spin_Qty = this.grid_Export.FindEditFormTemplateControl("spin_Qty") as ASPxSpinEdit;
exp.Qty = SafeValue.SafeInt(spin_Qty.Text, 0);
ASPxButtonEdit txt_PackageType = this.grid_Export.FindEditFormTemplateControl("txt_PackageType") as ASPxButtonEdit;
exp.PackageType = txt_PackageType.Text;
ASPxComboBox txt_TsInd = this.grid_Export.FindEditFormTemplateControl("txt_TsInd") as ASPxComboBox;
exp.TsInd = txt_TsInd.Text;
ASPxMemo remark = this.grid_Export.FindEditFormTemplateControl("Memo_Remark") as ASPxMemo;
exp.Remark = remark.Text;
ASPxMemo marking = this.grid_Export.FindEditFormTemplateControl("Memo_Marking") as ASPxMemo;
exp.Marking = marking.Text;
ASPxMemo memo_Des = this.grid_Export.FindEditFormTemplateControl("Memo_Des") as ASPxMemo;
exp.Description = memo_Des.Text;
ASPxButtonEdit txtCustId = this.grid_Export.FindEditFormTemplateControl("txtCustId") as ASPxButtonEdit;
exp.CustomerId = txtCustId.Text;
ASPxTextBox txtHouseBl = this.grid_Export.FindEditFormTemplateControl("txtHouseBl") as ASPxTextBox;
exp.Hawb = txtHouseBl.Text;
ASPxMemo tbxShipperName = pageControl.FindControl("tbxShipperName") as ASPxMemo;
exp.ShipperName = tbxShipperName.Text;
ASPxMemo tbxIssuedBy = pageControl.FindControl("tbxIssuedBy") as ASPxMemo;
exp.IssuedBy = tbxIssuedBy.Text;
ASPxMemo tbxConsigneeName = pageControl.FindControl("tbxConsigneeName") as ASPxMemo;
exp.ConsigneeName = tbxConsigneeName.Text;
ASPxMemo tbxCarrierAgent = pageControl.FindControl("tbxCarrierAgent") as ASPxMemo;
exp.CarrierAgent = tbxCarrierAgent.Text;
ASPxMemo tbxAccountInfo = pageControl.FindControl("tbxAccountInfo") as ASPxMemo;
exp.AccountInfo = tbxAccountInfo.Text;
ASPxTextBox tbxAgentIATACode = pageControl.FindControl("tbxAgentIATACode") as ASPxTextBox;
exp.AgentIATACode = tbxAgentIATACode.Text;
ASPxTextBox tbxAgentAccountNo = pageControl.FindControl("tbxAgentAccountNo") as ASPxTextBox;
exp.AgentAccountNo = tbxAgentAccountNo.Text;
ASPxTextBox tbxAirportDeparture = pageControl.FindControl("tbxAirportDeparture") as ASPxTextBox;
exp.AirportDeparture = tbxAirportDeparture.Text;
ASPxTextBox tbxConnDest1 = pageControl.FindControl("tbxConnDest1") as ASPxTextBox;
exp.ConnDest1 = tbxConnDest1.Text;
ASPxTextBox tbxConnCarrier1 = pageControl.FindControl("tbxConnCarrier1") as ASPxTextBox;
exp.ConnCarrier1 = tbxConnCarrier1.Text;
ASPxTextBox tbxConnDest2 = pageControl.FindControl("tbxConnDest2") as ASPxTextBox;
exp.ConnDest2 = tbxConnDest2.Text;
ASPxTextBox tbxConnCarrier2 = pageControl.FindControl("tbxConnCarrier2") as ASPxTextBox;
exp.ConnCarrier2 = tbxConnCarrier2.Text;
ASPxTextBox tbxConnDest3 = pageControl.FindControl("tbxConnDest3") as ASPxTextBox;
exp.ConnDest3 = tbxConnDest3.Text;
ASPxTextBox tbxConnCarrier3 = pageControl.FindControl("tbxConnCarrier3") as ASPxTextBox;
exp.ConnCarrier3 = tbxConnCarrier3.Text;
ASPxTextBox tbxCurrency = pageControl.FindControl("tbxCurrency") as ASPxTextBox;
exp.Currency = tbxCurrency.Text;
ASPxTextBox tbxChgsCode = pageControl.FindControl("tbxChgsCode") as ASPxTextBox;
exp.ChgsCode = tbxChgsCode.Text;
ASPxTextBox tbxPPD1 = pageControl.FindControl("tbxPPD1") as ASPxTextBox;
exp.Ppd1 = tbxPPD1.Text;
ASPxTextBox tbxCOLL1 = pageControl.FindControl("tbxCOLL1") as ASPxTextBox;
exp.Coll1 = tbxCOLL1.Text;
ASPxTextBox tbxPPD2 = pageControl.FindControl("tbxPPD2") as ASPxTextBox;
exp.Ppd2 = tbxPPD2.Text;
ASPxTextBox tbxCOLL2 = pageControl.FindControl("tbxCOLL2") as ASPxTextBox;
exp.Coll2 = tbxCOLL2.Text;
ASPxTextBox tbxCarriageValue = pageControl.FindControl("tbxCarriageValue") as ASPxTextBox;
exp.CarriageValue = tbxCarriageValue.Text;
ASPxTextBox tbxCustomValue = pageControl.FindControl("tbxCustomValue") as ASPxTextBox;
exp.CustomValue = tbxCustomValue.Text;
ASPxTextBox tbxAirportDestination = pageControl.FindControl("tbxAirportDestination") as ASPxTextBox;
exp.AirportDestination = tbxAirportDestination.Text;
ASPxTextBox tbxRequestedFlight = pageControl.FindControl("tbxRequestedFlight") as ASPxTextBox;
exp.RequestedFlight = tbxRequestedFlight.Text;
ASPxTextBox tbxRequestedDate = pageControl.FindControl("tbxRequestedDate") as ASPxTextBox;
exp.RequestedDate = tbxRequestedDate.Text;
ASPxTextBox tbxAmountInsurance = pageControl.FindControl("tbxAmountInsurance") as ASPxTextBox;
exp.AmountInsurance = tbxAmountInsurance.Text;
ASPxMemo tbxHandlingInfo = pageControl.FindControl("tbxHandlingInfo") as ASPxMemo;
exp.HandlingInfo = tbxHandlingInfo.Text;
ASPxTextBox tbxPiece = pageControl.FindControl("tbxPiece") as ASPxTextBox;
exp.Piece = tbxPiece.Text;
ASPxSpinEdit tbxGrossWeight = pageControl.FindControl("tbxGrossWeight") as ASPxSpinEdit;
exp.GrossWeight = tbxGrossWeight.Text;
ASPxSpinEdit tbxUnit = pageControl.FindControl("tbxUnit") as ASPxSpinEdit;
exp.Unit = tbxUnit.Text;
ASPxTextBox tbxRateClass = pageControl.FindControl("tbxRateClass") as ASPxTextBox;
exp.RateClass = tbxRateClass.Text;
ASPxTextBox tbxCommodityItemNo = pageControl.FindControl("tbxCommodityItemNo") as ASPxTextBox;
exp.CommodityItemNo = tbxCommodityItemNo.Text;
ASPxSpinEdit tbxChargeableWeight = pageControl.FindControl("tbxChargeableWeight") as ASPxSpinEdit;
exp.ChargeableWeight = tbxChargeableWeight.Text;
ASPxTextBox tbxRateCharge = pageControl.FindControl("tbxRateCharge") as ASPxTextBox;
exp.RateCharge = tbxRateCharge.Text;
ASPxSpinEdit tbxTotal = pageControl.FindControl("tbxTotal") as ASPxSpinEdit;
exp.Total = tbxTotal.Text;
ASPxMemo tbxGoodsNature = pageControl.FindControl("tbxGoodsNature") as ASPxMemo;
exp.GoodsNature = tbxGoodsNature.Text;
ASPxMemo tbxContentRemark = pageControl.FindControl("tbxContentRemark") as ASPxMemo;
exp.ContentRemark = tbxContentRemark.Text;
ASPxTextBox tbxWeightChargeP = pageControl.FindControl("tbxWeightChargeP") as ASPxTextBox;
exp.WeightChargeP = tbxWeightChargeP.Text;
ASPxTextBox tbxWeightChargeC = pageControl.FindControl("tbxWeightChargeC") as ASPxTextBox;
exp.WeightChargeC = tbxWeightChargeC.Text;
ASPxTextBox tbxValuationChargeP = pageControl.FindControl("tbxValuationChargeP") as ASPxTextBox;
exp.ValuationChargeP = tbxValuationChargeP.Text;
ASPxTextBox tbxValuationChargeC = pageControl.FindControl("tbxValuationChargeC") as ASPxTextBox;
exp.ValuationChargeC = tbxValuationChargeC.Text;
ASPxTextBox tbxTaxP = pageControl.FindControl("tbxTaxP") as ASPxTextBox;
exp.TaxP = tbxTaxP.Text;
ASPxTextBox tbxTaxC = pageControl.FindControl("tbxTaxC") as ASPxTextBox;
exp.TaxC = tbxTaxC.Text;
ASPxTextBox tbxOtherAgentChargeP = pageControl.FindControl("tbxOtherAgentChargeP") as ASPxTextBox;
exp.OtherAgentChargeP = tbxOtherAgentChargeP.Text;
ASPxTextBox tbxOtherAgentChargeC = pageControl.FindControl("tbxOtherAgentChargeC") as ASPxTextBox;
exp.OtherAgentChargeC = tbxOtherAgentChargeC.Text;
ASPxTextBox tbxOtherCarrierChargeP = pageControl.FindControl("tbxOtherCarrierChargeP") as ASPxTextBox;
exp.OtherCarrierChargeP = tbxOtherCarrierChargeP.Text;
ASPxTextBox tbxOtherCarrierChargeC = pageControl.FindControl("tbxOtherCarrierChargeC") as ASPxTextBox;
exp.OtherCarrierChargeC = tbxOtherCarrierChargeC.Text;
ASPxTextBox tbxTotalPrepaid = pageControl.FindControl("tbxTotalPrepaid") as ASPxTextBox;
exp.TotalPrepaid = tbxTotalPrepaid.Text;
ASPxTextBox tbxTotalCollect = pageControl.FindControl("tbxTotalCollect") as ASPxTextBox;
exp.TotalCollect = tbxTotalCollect.Text;
ASPxTextBox tbxCurrencyRate = pageControl.FindControl("tbxCurrencyRate") as ASPxTextBox;
exp.CurrencyRate = tbxCurrencyRate.Text;
ASPxTextBox tbxChargeDestCurrency = pageControl.FindControl("tbxChargeDestCurrency") as ASPxTextBox;
exp.ChargeDestCurrency = tbxChargeDestCurrency.Text;
ASPxTextBox tbxOtherCharge1 = pageControl.FindControl("tbxOtherCharge1") as ASPxTextBox;
exp.OtherCharge1 = tbxOtherCharge1.Text;
ASPxTextBox tbxOtherCharge1Currency = pageControl.FindControl("tbxOtherCharge1Currency") as ASPxTextBox;
exp.OtherCharge1Currency = tbxOtherCharge1Currency.Text;
ASPxSpinEdit tbxOtherCharge1Amount = pageControl.FindControl("tbxOtherCharge1Amount") as ASPxSpinEdit;
exp.OtherCharge1Amount = SafeValue.SafeDecimal(tbxOtherCharge1Amount.Text);
ASPxTextBox tbxOtherCharge2 = pageControl.FindControl("tbxOtherCharge2") as ASPxTextBox;
exp.OtherCharge2 = tbxOtherCharge2.Text;
ASPxTextBox tbxOtherCharge2Currency = pageControl.FindControl("tbxOtherCharge2Currency") as ASPxTextBox;
exp.OtherCharge2Currency = tbxOtherCharge2Currency.Text;
ASPxSpinEdit tbxOtherCharge2Amount = pageControl.FindControl("tbxOtherCharge2Amount") as ASPxSpinEdit;
exp.OtherCharge2Amount = SafeValue.SafeDecimal(tbxOtherCharge2Amount.Text);
ASPxTextBox tbxOtherCharge3 = pageControl.FindControl("tbxOtherCharge3") as ASPxTextBox;
exp.OtherCharge3 = tbxOtherCharge3.Text;
ASPxTextBox tbxOtherCharge3Currency = pageControl.FindControl("tbxOtherCharge3Currency") as ASPxTextBox;
exp.OtherCharge3Currency = tbxOtherCharge3Currency.Text;
ASPxSpinEdit tbxOtherCharge3Amount = pageControl.FindControl("tbxOtherCharge3Amount") as ASPxSpinEdit;
exp.OtherCharge3Amount = SafeValue.SafeDecimal(tbxOtherCharge3Amount.Text);
ASPxTextBox tbxOtherCharge4 = pageControl.FindControl("tbxOtherCharge4") as ASPxTextBox;
exp.OtherCharge4 = tbxOtherCharge4.Text;
ASPxTextBox tbxOtherCharge4Currency = pageControl.FindControl("tbxOtherCharge4Currency") as ASPxTextBox;
exp.OtherCharge4Currency = tbxOtherCharge4Currency.Text;
ASPxSpinEdit tbxOtherCharge4Amount = pageControl.FindControl("tbxOtherCharge4Amount") as ASPxSpinEdit;
exp.OtherCharge4Amount = SafeValue.SafeDecimal(tbxOtherCharge4Amount.Text);
ASPxTextBox tbxOtherCharge5 = pageControl.FindControl("tbxOtherCharge5") as ASPxTextBox;
exp.OtherCharge5 = tbxOtherCharge5.Text;
ASPxTextBox tbxOtherCharge5Currency = pageControl.FindControl("tbxOtherCharge5Currency") as ASPxTextBox;
exp.OtherCharge5Currency = tbxOtherCharge5Currency.Text;
ASPxSpinEdit tbxOtherCharge5Amount = pageControl.FindControl("tbxOtherCharge5Amount") as ASPxSpinEdit;
exp.OtherCharge5Amount = SafeValue.SafeDecimal(tbxOtherCharge5Amount.Text);
ASPxTextBox tbxSignatureShipper = pageControl.FindControl("tbxSignatureShipper") as ASPxTextBox;
exp.SignatureShipper = tbxSignatureShipper.Text;
ASPxTextBox tbxExecuteDate = pageControl.FindControl("tbxExecuteDate") as ASPxTextBox;
exp.ExecuteDate = tbxExecuteDate.Text;
ASPxTextBox tbxExecutePlace = pageControl.FindControl("tbxExecutePlace") as ASPxTextBox;
exp.ExecutePlace = tbxExecutePlace.Text;
ASPxTextBox tbxSignatureIssuing = pageControl.FindControl("tbxSignatureIssuing") as ASPxTextBox;
exp.SignatureIssuing = tbxSignatureIssuing.Text;
ASPxButtonEdit haulier = pageControl.FindControl("txt_Ref_H_Haulier") as ASPxButtonEdit;
exp.HaulierName = haulier.Text;
ASPxTextBox crno = pageControl.FindControl("txt_Ref_H_CrNo") as ASPxTextBox;
exp.HaulierCrNo = crno.Text;
ASPxTextBox attention = pageControl.FindControl("txt_Ref_H_Attention") as ASPxTextBox;
exp.HaulierAttention = attention.Text;
ASPxMemo collectFrm1 = pageControl.FindControl("txt_Ref_H_CltFrm") as ASPxMemo;
exp.HaulierCollect = collectFrm1.Text;
ASPxMemo truckTo1 = pageControl.FindControl("txt_Ref_H_TruckTo") as ASPxMemo;
exp.HaulierTruck = truckTo1.Text;
ASPxDateEdit collectDate = pageControl.FindControl("date_Ref_H_CltDate") as ASPxDateEdit;
exp.HaulierCollectDate = collectDate.Date;
ASPxMemo haulierRmk = pageControl.FindControl("txt_Ref_H_Rmk1") as ASPxMemo;
exp.HaulierRemark = haulierRmk.Text;
ASPxMemo haulierPermit = pageControl.FindControl("txt_Hbl_Permit") as ASPxMemo;
exp.PermitRmk = haulierPermit.Text;
ASPxTextBox txt_DriverName = pageControl.FindControl("txt_DriverName") as ASPxTextBox;
exp.DriverName = txt_DriverName.Text;
ASPxTextBox txt_DriverMobile = pageControl.FindControl("txt_DriverMobile") as ASPxTextBox;
exp.DriverMobile = txt_DriverMobile.Text;
ASPxTextBox txt_DriverLicense = pageControl.FindControl("txt_DriverLicense") as ASPxTextBox;
exp.DriverLicense = txt_DriverLicense.Text;
ASPxTextBox txt_VehicleNo = pageControl.FindControl("txt_VehicleNo") as ASPxTextBox;
exp.VehicleNo = txt_VehicleNo.Text;
ASPxTextBox txt_VehicleType = pageControl.FindControl("txt_VehicleType") as ASPxTextBox;
exp.VehicleType = txt_VehicleType.Text;
ASPxMemo me_DriverRemark = pageControl.FindControl("me_DriverRemark") as ASPxMemo;
exp.DriverRemark = me_DriverRemark.Text;
ASPxDateEdit deliveryDate = this.grid_Export.FindEditFormTemplateControl("date_DeliveryDate") as ASPxDateEdit;
exp.DeliveryDate = deliveryDate.Date;
ASPxComboBox doReady = this.grid_Export.FindEditFormTemplateControl("txtDoReady") as ASPxComboBox;
exp.DoReadyInd = doReady.Text;
ASPxButtonEdit txtPODBy = pageControl.FindControl("txtPODBy") as ASPxButtonEdit;
exp.PODBy = txtPODBy.Text;
ASPxDateEdit date_PodTime = pageControl.FindControl("date_PodTime") as ASPxDateEdit;
exp.PODTime = date_PodTime.Date;
ASPxMemo me_Remark = pageControl.FindControl("me_Remark") as ASPxMemo;
exp.PODRemark = me_Remark.Text;
exp.PODUpdateUser = EzshipHelper.GetUserName();
exp.PODUpdateTime = DateTime.Now;
ASPxTextBox txt_TsBkgRef = this.grid_Export.FindEditFormTemplateControl("txt_TsBkgRef") as ASPxTextBox;
exp.TsBkgRef = txt_TsBkgRef.Text;
ASPxTextBox txt_TsBkgUser = this.grid_Export.FindEditFormTemplateControl("txt_TsBkgUser") as ASPxTextBox;
exp.TsBkgUser = txt_TsBkgUser.Text;
ASPxDateEdit date_TsBkgTime = this.grid_Export.FindEditFormTemplateControl("date_TsBkgTime") as ASPxDateEdit;
exp.TsBkgTime = date_TsBkgTime.Date;
if (isNew)
{
exp.CloseInd = "N";
exp.CreateBy = userId;
exp.CreateDateTime = DateTime.Now;
exp.RefNo = Request.QueryString["masterNo"].ToString();
C2.Manager.ORManager.StartTracking(exp, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(exp);
}
else
{
exp.UpdateBy = userId;
exp.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(exp, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(exp);
}
UpdateMast(exp.RefNo);
Session["AirImpWhere"] = "JobNo='" + exp.JobNo + "'";
this.dsJob.FilterExpression = Session["AirImpWhere"].ToString();
if (this.grid_Export.GetRow(0) != null)
{
this.grid_Export.StartEdit(0);
}
}
catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); }
}
