protected void grid_InvDet_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxTextBox docId = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
int invId = SafeValue.SafeInt(e.NewValues["InvId"], 0);
UpdateMaster(SafeValue.SafeInt(docId.Text, 0));
}
//******************************
/// <summary>
/// ***************************** titles child grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgrdtitles_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxGridView _titles = (ASPxGridView)sender;
string _key = _titles.GetMasterRowKeyValue().ToString();
//string _key = e.OldValues["PAOrderID"].ToString(); //e.Keys[0].ToString(); //this should be PATitleID
//we only need to check title, no point in iterating through dataset
string _old = e.OldValues["Title"].ToString();
string _new = e.NewValues["Title"].ToString();
if (_new != _old)
{
//send email
//for building email table
string _tr = wwi_func.get_from_global_resx("html_table_tr");
string _tb = wwi_func.get_from_global_resx("html_table_body");
string _tx = string.Format(_tr, "Title", _old, _new);
//add header row
_tx = string.Format(_tr, "Item", "Changed from", "Changed to") + _tx;
//format to html table
_tx = string.Format(_tb, _tx);
//send
send_advance_email(_key, "title changed", _tx);
}
//get titleid for new carton
//if (e.NewValues["PAOrderID"] == null)
//{
// Int32 _idx = e.VisibleIndex;
// //string _orderid = this.dxhforder.Contains("orderid") ? this.dxhforder.Get("orderid").ToString() : "-1";
// string _orderid = _titles.GetRowValues(_idx, "quote_Id").ToString();
// //e.NewValues["PaTitleID"] = _titleid;
// this.objdsTitles.InsertParameters["PAOrderID"].DefaultValue = _orderid;
//}
}
protected void ASPxGridView1_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
if (e.Exception == null)
{
((ASPxGridView)sender).JSProperties["cpIsUpdated"] = e.Keys[0];
}
}
protected void gv_ProductSeries_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
//Session.Remove("SeriesCode");
//Session.Remove("SeriesName");
//Session.Remove("ProductCategory");
//Session.Remove("SeriesImage");
}
protected void grid_Cost_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox refNo = pageControl.FindControl("txt_RefN") as ASPxTextBox;
UpdateEstAmt(refNo.Text);
}
protected void grid_InvDet_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
string invId = e.NewValues["DocId"].ToString();
string docType = e.NewValues["DocType"].ToString();
UpdateMaster(invId, docType);
}
protected void grid_PoDet_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxPageControl pageControl = this.grid_WhPo.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox oidCtr = pageControl.FindControl("txt_PoNo") as ASPxTextBox;
UpdateMaster(oidCtr.Text);
}
protected void grid_InvDet_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
int scId = SafeValue.SafeInt(e.NewValues["DocId"], 0);
//ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
UpdateMaster(scId);
}
protected void ASPxGridView1_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
if (e.AffectedRecords == 0)
{
throw new Exception(errorMessage);
}
}
protected void grid_det_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
int id = SafeValue.SafeInt(e.NewValues["Id"], 0);
string poNo = SafeValue.SafeString(e.NewValues["SoNo"]);
string product = SafeValue.SafeString(e.NewValues["Product"]);
UpdateMaster(id, 0, poNo, product);
}
protected void grid_Transport_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
if (SafeValue.SafeString(e.NewValues["ContainerNo"]) != SafeValue.SafeString(e.OldValues["ContainerNo"]))
{
string sql = string.Format("Update ctm_JobDet2 set ContainerNo='{1}' where Det1Id='{0}'", e.Keys["Id"], SafeValue.SafeString(e.NewValues["ContainerNo"]));
ConnectSql.ExecuteSql(sql);
}
}
protected void grid_PORDet_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
int lineNo = SafeValue.SafeInt(e.NewValues["Id"], 0);
int qty = SafeValue.SafeInt(e.NewValues["Qty"], 0);
string poNo = SafeValue.SafeString(e.NewValues["PoNo"]);
string product = SafeValue.SafeString(e.NewValues["Product"]);
UpdateMaster(lineNo, qty, poNo, product);
}
protected void gvxReceiving_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
if (e.OldValues["ItemID"] != e.NewValues["ItemID"] || e.OldValues["StorageID"] != e.NewValues["StorageID"])
{
WarehouseBL warhouseManagement = new WarehouseBL();
warhouseManagement.UpdateMangment(int.Parse(e.OldValues["ItemID"].ToString()), int.Parse(e.OldValues["StorageID"].ToString()), int.Parse(e.OldValues["Amount"].ToString()));
warhouseManagement.InsertMangment(int.Parse(e.NewValues["ItemID"].ToString()), int.Parse(e.NewValues["StorageID"].ToString()), int.Parse(e.NewValues["Amount"].ToString()));
}
}
protected void ASPxGridView1_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
// DatasourcesCachesInvalidate(DataSourceMaster.CacheKeyDependency);
// DatasourcesCachesInvalidate(DataSourceDetail.CacheKeyDependency);
var grid = (sender as ASPxGridView);
var datasrc = FindControlRecursive(grid.DataSourceID) as SqlDataSource;
DatasourcesCachesInvalidate(datasrc.CacheKeyDependency);
}
protected void ClassGridView_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
db.Configuration.LazyLoadingEnabled = false;
int id = (int)e.NewValues["Treatment_Class_Id"];
Treatment_Class Class = db.Treatment_Class.Find(id);
/*Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(Class, logFileModule.settings);
logFileModule.logfile(10, "تعديل تصنيف", "update treatment class", LogData);
}
protected void DeliveryGridView_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
db.Configuration.LazyLoadingEnabled = false;
int id = (int)e.NewValues["Treatment_Delivery_Id"];
Treatment_Delivery Delivery = db.Treatment_Delivery.Find(id);
/*Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(Delivery, logFileModule.settings);
logFileModule.logfile(10, "تعديل حالة التسليم", "update treatment delivery", LogData);
}
protected void PriorityGridView_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
db.Configuration.LazyLoadingEnabled = false;
int id = (int)e.NewValues["Treatment_Priority_Id"];
Treatment_Priority Priority = db.Treatment_Priority.Find(id);
/*Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(Priority, logFileModule.settings);
logFileModule.logfile(10, "تعديل اولوية", "update priority", LogData);
}
protected void grid_Cont_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView;
updateJob_By_Date(SafeValue.SafeString(grd.GetMasterRowKeyValue(), "0"));
if (SafeValue.SafeString(e.NewValues["ContainerNo"]) != SafeValue.SafeString(e.OldValues["ContainerNo"]))
{
string sql = string.Format("Update ctm_JobDet2 set ContainerNo='{1}' where Det1Id='{0}'", e.Keys["Id"], SafeValue.SafeString(e.NewValues["ContainerNo"]));
ConnectSql.ExecuteSql(sql);
}
}
protected void ASPxGridView1_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
int lintSolicitudID = Convert.ToInt32(e.NewValues["Solicitud_ID"]);
using (ICCEntities lObjIcc = new ICCEntities())
{
xSpHtml_Result lObjCorreo = new xSpHtml_Result();
lObjCorreo = lObjIcc.xSpHtml(lintSolicitudID).FirstOrDefault();
SubEnviarCorreo(lObjCorreo.Correo, lObjCorreo.Html);
}
this.ASPxGridView1.DataBind();
}
protected void GridViewDC_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxGridView gridView = (ASPxGridView)sender;
for (int i = 0; i < gridView.Columns.Count; i++)
{
if (gridView.Columns[i] is GridViewDataColumn)
{
((GridViewDataColumn)gridView.Columns[i]).EditItemTemplate = null;
Session["column"] = null;
}
}
}
protected void LanguageGridView_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
db.Configuration.LazyLoadingEnabled = false;
// Selecet Language Based on User language and set in session
SessionWrapper.Language = db.Lanuage_Detials.Where(x => x.Language_Master_ID == SessionWrapper.LoggedUser.Language_id).ToList();
int id = (int)e.NewValues["Language_Detial_ID"];
Lanuage_Detials lang = db.Lanuage_Detials.Find(id);
/*Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(lang, logFileModule.settings);
logFileModule.logfile(10, " تعديل الترجمة", "update an existing translation", LogData);
}
//****************************** end titles
/// <summary>
/// **************************** carton child grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgrdcartons_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
//if(e.AffectedRecords == 1)
//{
//for building email table
string _tr = wwi_func.get_from_global_resx("html_table_tr");
string _tb = wwi_func.get_from_global_resx("html_table_body");
string _tx = "";
//
//to enumerate through values
ASPxGridView _cartons = (ASPxGridView)sender;
string _key = Session["selPAOrderId"] != null ? Session["selPAOrderId"].ToString() : _cartons.GetMasterRowKeyValue().ToString();
//string _key = e.NewValues["OrderID"].ToString(); //e.Keys[0].ToString(); //this should be PACartonID
System.Collections.Specialized.OrderedDictionary _list = new System.Collections.Specialized.OrderedDictionary();
_list = (System.Collections.Specialized.OrderedDictionary)e.OldValues;
int _ix = 0;
//loop through each entry in dictionary
foreach (System.Collections.DictionaryEntry _entry in _list)
{
string[] _args = new string[3];
_args[0] = _entry.Key != null?_entry.Key.ToString() : ""; //field name
_args[1] = e.OldValues[_ix] != null ? e.OldValues[_ix].ToString() : "";
_args[2] = e.NewValues[_ix] != null ? e.NewValues[_ix].ToString() : "";
if (_args[2] != _args[1])
{
_tx += string.Format(_tr, _args);
}
_ix++;
}//end loop
//create email if changes
if (_tx != "")
{
//add header row
_tx = string.Format(_tr, "Item", "Changed from", "Changed to") + _tx;
//format to html table
_tx = string.Format(_tb, _tx);
//send
send_advance_email(_key, "carton changed", _tx);
}
//}end if affected records
}
protected void ASPxTreeList1_NodeUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxTreeList treeList = (ASPxTreeList)sender;
for (int i = 0; i < treeList.Columns.Count; i++)
{
if (treeList.Columns[i] is TreeListDataColumn)
{
((TreeListDataColumn)treeList.Columns[i]).EditCellTemplate = null;
Session["column"] = null;
}
}
treeList.CancelEdit();
}
protected void poEdycji(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
grid1.DataBind();
string[] klucz = new string[1];
klucz[0] = "ident";
string uzytkownik = (string)Session["identyfikatorUzytkownika"];
for (int i = 0; i < grid1.VisibleRowCount; i++)
{
if (grid1.GetRowValues(i, klucz).ToString() == uzytkownik)
{
grid1.Selection.SelectRow(i);
}
}
}
protected void grid_bkg_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox mkgId = grd.FindEditFormTemplateControl("txtMkgId") as ASPxTextBox;
ASPxSpinEdit wt = grd.FindEditFormTemplateControl("spin_wt2") as ASPxSpinEdit;
ASPxSpinEdit m3 = grd.FindEditFormTemplateControl("spin_m4") as ASPxSpinEdit;
ASPxSpinEdit qty = grd.FindEditFormTemplateControl("spin_pkg2") as ASPxSpinEdit;
ASPxButtonEdit pkgType = grd.FindEditFormTemplateControl("txt_pkgType2") as ASPxButtonEdit;
ASPxMemo mkg = grd.FindEditFormTemplateControl("txt_mkg2") as ASPxMemo;
ASPxMemo des = grd.FindEditFormTemplateControl("txt_des2") as ASPxMemo;
string sql = string.Format("update SeaExportMkg set Qty='{1}',PackageType='{2}',Weight='{3}',Volume='{4}',Marking='{5}',Description='{6}' where SequenceId='{0}'"
, mkgId.Text, qty.Value, pkgType.Text, wt.Value, m3.Value, mkg.Text, des.Text);
ConnectSql.ExecuteSql(sql);
}
protected void zapisDanych(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
try
{
var miesieczne = e.NewValues["rodzaj"];
var mss = e.NewValues["mss"];
var kontrolki = e.NewValues["kontrolka"];
var kof = e.NewValues["kof"];
var wyszukiwarka = e.NewValues["wyszukiwarka"];
var pracownik = e.NewValues["pracownik"];
}
catch (Exception ex)
{
var error = ex.Message;
string blad = error.ToString();
}
}
protected void grid_contact_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
string partyId = SafeValue.SafeString(e.NewValues["PartyId"]);
string id = SafeValue.SafeString(e.Keys["Id"]);
bool isDefault = SafeValue.SafeBool(e.NewValues["IsDefault"], true);
if (isDefault == true)
{
string sql = string.Format(@"update ref_contact set IsDefault=0 where PartyId='{0}' and Id!={1}", partyId, id);
ConnectSql_mb.ExecuteNonQuery(sql);
}
else
{
string sql = string.Format(@"update ref_contact set IsDefault=1 where PartyId='{0}' and Id=(select top 1 Id from ref_contact where PartyId='{0}')", partyId);
ConnectSql_mb.ExecuteNonQuery(sql);
}
}
//end return html
/// <summary>
/// ********************* customer target grid update append updated field(s) to history table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgrdTarget_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
if (e.AffectedRecords != 0)
{
//for batch save
TargetHistoryCollection _t = new TargetHistoryCollection();
string _user = Page.Session["user"] != null ? (string)((UserClass)Page.Session["user"]).UserName : "";
//to enumerate through values
string _key = e.Keys[0].ToString(); //this should be TargetID
System.Collections.Specialized.OrderedDictionary _list = new System.Collections.Specialized.OrderedDictionary();
_list = (System.Collections.Specialized.OrderedDictionary)e.OldValues;
int _ix = 0;
//loop through each entry in dictionary
foreach (System.Collections.DictionaryEntry _entry in _list)
{
string[] _args = new string[3];
_args[0] = _entry.Key != null?_entry.Key.ToString() : "";
if (_args[0] != "UpdateUser" && _args[0] != "UpdateDate" && _args[0] != "InsertDate") //we don't need to log changes to these
{
_args[1] = e.OldValues[_ix] != null ? e.OldValues[_ix].ToString() : "";
_args[2] = e.NewValues[_ix] != null ? e.NewValues[_ix].ToString() : "";
if (_args[2] != _args[1])
{
TargetHistory _item = new TargetHistory();
_item.IDtarget = wwi_func.vint(_key);
_item.FieldName = wwi_func.uncamel(_args[0]); //field name
_item.ChangedFrom = _args[1];
_item.ChangedTo = _args[2];
_item.LogDate = DateTime.Now.Date;
_item.LogUser = _user;
//append to history
_t.Add(_item);
}
}
_t.SaveAll();
_ix++;
} //end loop
} //end if affected records
}
protected void gvxOpperation_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
try
{
int opperationID = int.Parse(e.Keys[0].ToString());
ASPxDropDownEdit dd = (ASPxDropDownEdit)gvxOpperation.FindEditFormTemplateControl("ddMaterails");
ASPxCheckBoxList list = (ASPxCheckBoxList)dd.FindControl("chlMaterails");
dsOpperationMaterails.SelectParameters[0].DefaultValue = opperationID.ToString();
dsOpperationMaterails.DeleteParameters[0].DefaultValue = opperationID.ToString();
dsOpperationMaterails.InsertParameters[0].DefaultValue = opperationID.ToString();
DataView SelectedItemView = (DataView)dsOpperationMaterails.Select(new DataSourceSelectArguments());
DataTable SelectedItems = SelectedItemView.ToTable();
foreach (DataRow item in SelectedItems.Rows)
{
if (!list.Items.FindByValue(item[0].ToString()).Selected)
{
dsOpperationMaterails.DeleteParameters[1].DefaultValue = item[0].ToString();
dsOpperationMaterails.Delete();
list.Items.Remove(list.Items.FindByValue(item[0].ToString()));
}
else
{
list.Items.Remove(list.Items.FindByValue(item[0].ToString()));
}
}
foreach (ListEditItem item in list.Items)
{
if (item.Selected)
{
dsOpperationMaterails.InsertParameters[1].DefaultValue = item.Value.ToString();
dsOpperationMaterails.Insert();
}
}
}
catch (Exception)
{
}
}
protected void GridView_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
UpdateNavBarName();
}
