protected void grdData_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomButtonCallbackEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxTextBox txt_realamount = grid.FindRowTemplateControl(e.VisibleIndex, "txt_realamount") as ASPxTextBox;
txt_realamount.Focus();
}
}//end menu names loop
#endregion
#region gridview crud events
/// <summary>
/// on row created get lookup values
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgrdCourier_HtmlRowCreated(object sender, ASPxGridViewTableRowEventArgs e)
{
ASPxGridView _grd = (ASPxGridView)sender;
try
{
if (e.RowType == GridViewRowType.Data)
{
//company
int _id = wwi_func.vint(e.GetValue("DocsDespatchID").ToString());
string _txt = wwi_func.lookup_multi_values("CompanyName,Address1,Address2,Address3,CountryName,TelNo", "view_delivery_address", "CompanyID", _id);
if (_txt != "")
{
string[] _lx = _txt.Split(Environment.NewLine.ToCharArray());
//company
ASPxLabel _lbl = (ASPxLabel)_grd.FindRowTemplateControl(e.VisibleIndex, "dxlblDocsDespatchIDView");
if (_lbl != null)
{
_lbl.Text = _lx[0];
}
//address
_lbl = (ASPxLabel)_grd.FindRowTemplateControl(e.VisibleIndex, "dxlblDocsDespatchIDView2");
if (_lbl != null)
{
_lbl.Text = _txt.Replace(_lx[0], "").Trim();;
}
}
//contact
_id = wwi_func.vint(e.GetValue("ContactID").ToString());
_txt = wwi_func.lookup_multi_values("ContactName,Email", "ContactTable", "ContactID", _id, "|");
if (_txt != "")
{
string[] _lx = _txt.Split("|".ToCharArray());
//name
ASPxLabel _lbl = (ASPxLabel)_grd.FindRowTemplateControl(e.VisibleIndex, "dxlblContactIDView");
if (_lbl != null)
{
_lbl.Text = _lx[0].Trim();
}
//email
_lbl = (ASPxLabel)_grd.FindRowTemplateControl(e.VisibleIndex, "dxlblContactIDView2");
if (_lbl != null)
{
_lbl.Text = _lx.Length > 0 ? _lx[1] : "";
}
}
//get the status value
int _original = wwi_func.vint(e.GetValue("Original").ToString());
string _target = _original <= 2 ? "Despatch Date" : "Date Emailed";
//format date if original = 2 pass to docs despatched date, if 3 pass to emailed date
string _dt = e.GetValue("DocumentationDespatched") != null?wwi_func.vdatetime(e.GetValue("DocumentationDespatched").ToString()).ToShortDateString() : "";
//set caption
ASPxLabel _lb = (ASPxLabel)_grd.FindRowTemplateControl(e.VisibleIndex, "dxlblDespatchDateCaption");
if (_lb != null)
{
_lb.Text = _target;
}
_lb = (ASPxLabel)_grd.FindRowTemplateControl(e.VisibleIndex, "dxlblDespatchDateView");
if (_lb != null)
{
_lb.Text = _dt;
}
}
else if (e.RowType == GridViewRowType.EditForm)
{
//edit form stuff
//populate company address label
int _id = wwi_func.vint(e.GetValue("DocsDespatchID").ToString());
string _txt = wwi_func.lookup_multi_values("Address1,Address2,Address3,CountryName,TelNo", "view_delivery_address", "CompanyID", _id);
if (_txt != "")
{
//string[] _lx = _txt.Split(Environment.NewLine.ToCharArray());
//address
ASPxLabel _lb = (ASPxLabel)_grd.FindEditFormTemplateControl("dxlblAddress2");
if (_lb != null)
{
_lb.Text = _txt;
}
}
//bind contact or we lose the contact name on edit
ASPxComboBox _editor = (ASPxComboBox)_grd.FindEditFormTemplateControl("dxcboClientContact");
if (_editor != null)
{
string[] _cols = { "ContactID, ContactName", "Email" };
string[] _order = { "ContactName" };
SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.ContactTable).OrderAsc(_order);
if (_id > 0)
{
_qry.Where("CompanyID").IsEqualTo(_id);
}
IDataReader _rd1 = _qry.ExecuteReader();
_editor.DataSource = _rd1;
_editor.ValueField = "ContactID";
_editor.TextField = "ContactName";
_editor.DataBind();
_editor.SelectedItem = _editor.Items.FindByValue(e.GetValue("ContactID"));
}
}//end if
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text += _ex;
this.dxpnlErr.ClientVisible = true;
}
}