protected void cpLODetail_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
string[] param = e.Parameter.Split('|');
Int64 itemID = Convert.ToInt64(param[0]);
string itemDesc = param[1];
string tbbmName = param[2];
string spshName = param[3];
int quantityVolume = Convert.ToInt32(param[4]);
Int64 sppb_ID = Convert.ToInt64(param[5]);
lblItemDesc.Text = itemDesc;
lblTBBMName.Text = tbbmName;
lblSPSHName.Text = spshName;
hf["qty"] = quantityVolume;
hf["itemID"] = itemID;
LOModel.LO loDetail = LOEntity.GetLODetail(sppb_ID);
cmbTransporter.DataSource = liTransporter;
cmbTransporter.DataBind();
if (loDetail != null)
{
if (loDetail.Transporter_ID != 0)
{
cmbTransporter.Value = loDetail.Transporter_ID;
if (loDetail.Type_ID != 0)
{
cmbVehicleType.ClientEnabled = true;
cmbVehicleType.DataSource = liVehicleType.Where(x => x.Transporter_ID == loDetail.Transporter_ID).GroupBy(x => new { x.Type_ID, x.VehicleType }).Select(x => x.First()).Distinct().ToList();
cmbVehicleType.DataBind();
cmbVehicleType.Value = loDetail.Type_ID;
if (loDetail.Vehicle_ID != 0)
{
cmbVehicleNumber.ClientEnabled = true;
cmbVehicleNumber.DataSource = liVehicleNumber.Where(x => x.Transporter_ID == loDetail.Transporter_ID && x.Type_ID == loDetail.Type_ID).ToList();
cmbVehicleNumber.DataBind();
cmbVehicleNumber.Value = loDetail.Vehicle_ID;
}
}
if (loDetail.Driver_ID != 0)
{
cmbDriver.ClientEnabled = true;
cmbDriver.DataSource = liDriver.Where(x => x.Transporter_ID == loDetail.Transporter_ID).ToList();
cmbDriver.DataBind();
cmbDriver.Value = loDetail.Driver_ID;
}
}
}
cpLODetail.ClientVisible = true;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Alert alert = new Alert();
try
{
LOModel.LO item = new LOModel.LO();
item.SPP_Items_ID = Convert.ToInt64(hf["itemID"]);
item.Transporter_ID = Convert.ToInt32(cmbTransporter.Value);
item.Vehicle_ID = Convert.ToInt32(cmbVehicleNumber.Value);
item.Driver_ID = Convert.ToInt32(cmbDriver.Value);
item.DeliveryNote = txtDONote.Text;
item.NoLO = "0"; //txtLO.Text;
item.LODate = Convert.ToDateTime("1900/01/01"); // deLO.Date;
item.NoDO = txtDO.Text;
item.DODate = deDO.Date == DateTime.MinValue ? Convert.ToDateTime("1/1/1900") : deDO.Date;
item.CustomerPO_Number = txtPO.Text;
item.CustomerDate = dePO.Date == DateTime.MinValue ? Convert.ToDateTime("1/1/1900") : dePO.Date;
item.OrderNumber = txtOrder.Text;
item.OrderDate = deOrder.Date == DateTime.MinValue ? Convert.ToDateTime("1/1/1900") : deOrder.Date;
item.CreationBy = UserProfile.Username;
string res = LOEntity.SubmitLO(item);
if (res.ToLower().Contains("success"))
{
alert.MessageString("success", res, Page, GetType());
}
else
{
alert.MessageString("error", res, Page, GetType());
}
ASPxEdit.ClearEditorsInContainer(Page, true);
cpLODetail.ClientVisible = false;
cpLOList.ClientVisible = true;
LoadInitLOList();
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RefreshLOlist", "cpLOList.PerformCallback();", true);
}
catch (Exception ex)
{
alert.MessageString("error", ex.Message, Page, GetType());
}
}
public static string SubmitLO(LOModel.LO item)
{
string res = DbTransaction.DbToString("sp_SubmitLO",
new
{
SPP_Items_ID = item.SPP_Items_ID,
Transporter_ID = item.Transporter_ID,
Vehicle_ID = item.Vehicle_ID,
Driver_ID = item.Driver_ID,
NoLo = item.NoLO,
LODate = item.LODate,
NoDO = item.NoDO,
DODate = item.DODate,
CustomerPO_Number = item.CustomerPO_Number,
CustomerDate = item.CustomerDate,
OrderNumber = item.OrderNumber,
OrderDate = item.OrderDate,
DeliveryNote = item.DeliveryNote,
CreationBy = item.CreationBy
}, true);
return(res);
}
