protected void gdvinv1_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
gdvinv1.DoRowValidation();
var obec = ((BEParameters)Session["InitPar"]);
var line = new BEDocumentLine()
{
ItemCode = Convert.ToString(e.NewValues["ItemCode"]),
ItemName = Convert.ToString(e.NewValues["ItemName"]),
Quantity = Convert.ToInt32(e.NewValues["Quantity"]),
PriceBefDi = Convert.ToDecimal(e.NewValues["PriceBefDi"]),
DiscPrcnt = Convert.ToDecimal(e.NewValues["DiscPrcnt"]),
Price = Convert.ToDecimal(e.NewValues["Price"]),
LineTotal = Convert.ToDecimal(e.NewValues["LineTotal"]),
GTotal = Convert.ToDecimal(e.NewValues["GTotal"]),
BatchNum = Convert.ToString(e.NewValues["BatchNum"]),
WhsCode = obec.WhsCode,
U_BF_CodKit = string.Empty,
NumInSale = Convert.ToDecimal(e.NewValues["NumInSale"]),
OItemCode = Convert.ToString(e.NewValues["OItemCode"])
};
((List <BEDocumentLine>)Session["inv1"]).Add(line);
Set_LineNum();
gdvinv1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["inv1"]).Sum(item => Math.Round(item.LineTotal, 2));
gdvinv1.CancelEdit();
e.Cancel = true;
gdvinv1.DataSource = ((List <BEDocumentLine>)Session["inv1"]);
gdvinv1.DataBind();
}
protected void gdvdln1_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var beNe = new BRDocument();
gdvdln1.DoRowValidation();
var obec = ((BEParameters)Session["InitPar"]);
string almacen = "";
/*if (obec.Socied == "BM")
* {
* if (beNe.getStockAlmacen(Convert.ToString(e.NewValues["ItemCode"])) <= 0)
* almacen = "BL010";
* else
* almacen = obec.WhsCode;
* }
* if (obec.Socied == "BT")
* {*/
almacen = obec.WhsCode;
//}
var line = new BEDocumentLine()
{
ItemCode = Convert.ToString(e.NewValues["ItemCode"]),
ItemName = Convert.ToString(e.NewValues["ItemName"]),
Quantity = Convert.ToInt32(e.NewValues["Quantity"]),
PriceBefDi = Convert.ToDecimal(e.NewValues["PriceBefDi"]),
DiscPrcnt = Convert.ToDecimal(e.NewValues["DiscPrcnt"]),
Price = Convert.ToDecimal(e.NewValues["Price"]),
LineTotal = Convert.ToDecimal(e.NewValues["LineTotal"]),
GTotal = Convert.ToDecimal(e.NewValues["GTotal"]),
IssueMthd = Convert.ToString(e.NewValues["IssueMthd"]),
WhsCode = almacen,
U_StoDiBE = Convert.ToDecimal(e.NewValues["U_StoDiBE"]),
U_BF_StoDiYo = Convert.ToDecimal(e.NewValues["U_BF_StoDiYo"]),
//BL050 = Convert.ToDecimal(e.NewValues["BL050"]),
//BL010 = Convert.ToDecimal(e.NewValues["BL010"]),
//U_U_BF_CompTot = Convert.ToDecimal(e.NewValues["U_U_BF_CompTot"]),
//U_BIZ_DREC = Convert.ToString(e.NewValues["U_BIZ_DREC"]),
//U_BIZ_FFAR = Convert.ToString(e.NewValues["U_BIZ_FFAR"]),
//U_BIZ_CANT = Convert.ToDecimal(e.NewValues["U_BIZ_CANT"]),
//U_BF_FECH_EXPE = DateTime.Today.ToShortDateString(),
//U_BF_FECH_VENC = DateTime.Today.AddDays(90).ToShortDateString(),
//U_BF_CodKit = string.Empty,
OItemCode = Convert.ToString(e.NewValues["OItemCode"]),
OnDscOrg = Convert.ToDecimal(e.NewValues["OnDscOrg"]),
Serie = Convert.ToString(e.NewValues["Serie"])
//PASAR EL SERIALNUMBER PARA LUEGO HACER EL DATASOURCE AL DETALLE
};
line.InDscOrg = (line.OnDscOrg == 0) ? 1 : 0;
((List <BEDocumentLine>)Session["dln1"]).Add(line);
//Set_Promotion();
Set_LineNum();
gdvdln1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["dln1"]).Sum(item => Math.Round(item.LineTotal, 2));
gdvdln1.CancelEdit();
e.Cancel = true;
gdvdln1.DataSource = ((List <BEDocumentLine>)Session["dln1"]);
gdvdln1.DataBind();
}
public static void InsertNode(ASPxTreeList treeList, ASPxDataInsertingEventArgs e)
{
XmlDataSource xmlDataXource = treeList.Page.FindControl(treeList.DataSourceID) as XmlDataSource;
XmlDocument docum = xmlDataXource.GetXmlDocument();
AddNewNodeId(e.NewValues, docum);
var parentNodeInTreeList = treeList.FindNodeByKeyValue(treeList.NewNodeParentKey);
var parentID = parentNodeInTreeList.GetValue("Id").ToString();
XmlNode parentNode = FindNode(docum, parentID);
var level = Convert.ToInt32(parentNode.Attributes["Level"].Value) + 1;
XmlNode newNode = docum.CreateElement("Level" + level + "Node");
foreach (DictionaryEntry entry in e.NewValues)
{
newNode.Attributes.Append(GetNewAttribute(docum, entry.Key, entry.Value));
}
newNode.Attributes.Append(GetNewAttribute(docum, "Level", level));
newNode.Attributes.Append(GetNewAttribute(docum, "ParentKey", parentID));
parentNode.AppendChild(newNode);
RearrangeAndSaveXml(docum);
}
protected void grdvAlmacenes_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
//gvcontacto.DoRowValidation();
var obec = ((BEParameters)Session["InitPar"]);
var x = ((List <BEAlmacen>)Session["oitw"]).Count;
var line = new BEAlmacen()
{
WhsCode = Convert.ToString(e.NewValues["WhsCode"]),
WhsName = Convert.ToString(e.NewValues["WhsName"]),
OnHand = Convert.ToInt32(e.NewValues["OnHand"]),
IsCommited = Convert.ToInt32(e.NewValues["IsCommited"]),
OnOrder = Convert.ToInt32(e.NewValues["OnOrder"]),
Locked = Convert.ToString(e.NewValues["Locked"]),
Disponible = Convert.ToInt32(e.NewValues["Disponible"]),
RevenuesAc = Convert.ToString(e.NewValues["RevenuesAc"]),
ExpensesAc = Convert.ToString(e.NewValues["ExpensesAc"]),
Linea = x
};
((List <BEAlmacen>)Session["oitw"]).Add(line);
grdvAlmacenes.CancelEdit();
e.Cancel = true;
grdvAlmacenes.DataSource = ((List <BEAlmacen>)Session["oitw"]);
grdvAlmacenes.DataBind();
}
protected void Effect_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView detailGridView = (ASPxGridView)sender;
string desc = "";
string loc1 = "";
string loc2 = "";
try
{
loc1 = e.NewValues[0].ToString();
loc2 = e.NewValues[1].ToString();
desc = e.NewValues[2].ToString();
}
catch (Exception ex)
{
}
finally
{
}
string PARENT_OBID = detailGridView.GetMasterRowKeyValue().ToString();
string qry = "INSERT INTO TBLSYSTEM_TEMPLATE(OBID, SYS_NAME, CLASS_NAME, SEQ, LOC1, LOC2, PARENT_OBID, DESCRIPTION, PRJ_NAME) ";
qry = qry + "VALUES(NEWID(), '" + sys_name + "', 'Effect', '0', '" + loc1 + "','" + loc2 + "','" + PARENT_OBID + "', '" + desc + "', '" + fgm_moduler.func_Class.project_Name + "')";
SqlCommand cmd;
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
detailGridView.CancelEdit();
}
protected void StockOperationGrid_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var goodsID = GetStockOperationComboBoxColumnValue("GoodsID", "GoodsComboBox");
var pseudoUnitID = GetStockOperationComboBoxColumnValue("PseudoUnitName", "PseudoUnitComboBox");
if (goodsID != null && pseudoUnitID != null)
{
var xml = Utilities.FormatXml(@"<data>
<primary_stock_id>{0}</primary_stock_id>
<goods_id>{1}</goods_id>
<pseudo_unit_id>{2}</pseudo_unit_id>
<unit_price>{3}</unit_price>
<quantity>{4}</quantity>
<caption>{5}</caption>
<has_vat>{6}</has_vat>
</data>",
_stockID,
goodsID,
pseudoUnitID,
e.NewValues["UnitPrice"],
e.NewValues["Quantity"],
e.NewValues["Caption"],
e.NewValues["HasVAT"]);
StockOperationsDataSource.InsertParameters["Xml"].DefaultValue = xml;
}
else
{
e.Cancel = true;
}
}
public void Effect_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView detailGridView = (ASPxGridView)sender;
ASPxGridView editform_gv = (ASPxGridView)detailGridView.FindEditFormTemplateControl("cnr").FindControl("gv1");
ASPxFormLayout fl = (ASPxFormLayout)detailGridView.FindEditFormTemplateControl("cnr").FindControl("Effect_Layout_Form");
for (int i = 0; i < editform_gv.Selection.Count; i++)
{
SqlCommand cmd;
string effect_obid = editform_gv.GetSelectedFieldValues("OBID")[i].ToString();
string detector_obid = detailGridView.GetMasterRowKeyValue().ToString();
string load_qry = "insert into TB_DE_LINK(OBID, LEFTREL, RIGHTREL, N1CREATIONDATE, N1CREATIONSESID) ";
load_qry = load_qry + "VALUES (NEWID(), '" + detector_obid + "', '" + effect_obid + "', ";
load_qry = load_qry + "REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),' ', '-') , '" + SessionInfo.UserName + "') ";
cmd = new SqlCommand(load_qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
}
e.Cancel = true;
Detector_Grid.CancelEdit();
//makeDetectorGridView();
//makeEffectGridView();
//Session["Dataset"] = DetectorVoting;
//Detector_Grid.DataSource = DetectorVoting;
//Detector_Grid.DataBind();
}
protected void tree_NodeInserting(object sender, ASPxDataInsertingEventArgs e)
{
TreeListNode parentNode = tree.FindNodeByKeyValue(tree.NewNodeParentKey);
EnsureNode(parentNode);
string parentFolder;
if (parentNode == tree.RootNode)
{
//parentFolder = FileManagerHelper.RootFolder;
parentFolder = FileManagerHelper.CurrentDataFolder;
}
else
{
parentFolder = parentNode.GetValue(FileManagerHelper.FullPathName).ToString();
}
string name = parentFolder + Path.DirectorySeparatorChar + ReadName(e.NewValues);
if (Directory.Exists(name))
{
throw new DemoException("Directory exists.");
}
Directory.CreateDirectory(name);
tree.RefreshVirtualTree(parentNode);
FocusByPath(name);
}
protected void gvDirecciones_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var x = ((List <BEClientAddress>)Session["dire"]).Count;
var line = new BEClientAddress()
{
Address = Convert.ToString(e.NewValues["Address"]),
Street = Convert.ToString(e.NewValues["Street"]),
State = Convert.ToString(e.NewValues["State"]),
StateName = Convert.ToString(e.NewValues["StateName"]),
AdresType = Convert.ToString(e.NewValues["AdresType"]),
Active = Convert.ToString(e.NewValues["Active"]),
U_DXP_BIZ_COPR = Convert.ToString(e.NewValues["U_DXP_BIZ_COPR"]),
U_DXP_BIZ_PROV = Convert.ToString(e.NewValues["U_DXP_BIZ_PROV"]),
U_DXP_BIZ_CODI = Convert.ToString(e.NewValues["U_DXP_BIZ_CODI"]),
U_DXP_BIZ_DIST = Convert.ToString(e.NewValues["U_DXP_BIZ_DIST"]),
U_DXP_BIZ_ZONA = Convert.ToString(e.NewValues["U_DXP_BIZ_ZONA"]),
GlblLocNum = Convert.ToString(e.NewValues["GlblLocNum"]),
Building = Convert.ToString(e.NewValues["Building"]),
StreetNo = Convert.ToString(e.NewValues["StreetNo"]),
Linea = x
};
((List <BEClientAddress>)Session["dire"]).Add(line);
Set_LineNum_Direcciones();
gvDirecciones.CancelEdit();
e.Cancel = true;
gvDirecciones.DataSource = ((List <BEClientAddress>)Session["dire"]);
gvDirecciones.DataBind();
}
protected void DetectorVoting_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
SqlCommand cmd;
ASPxComboBox combo_voting_cnt = (ASPxComboBox)Detector_Grid.FindEditRowCellTemplateControl((GridViewDataColumn)Detector_Grid.Columns[1], "combo_voting_cnt");
ASPxComboBox combo_voting2_cnt = (ASPxComboBox)Detector_Grid.FindEditRowCellTemplateControl((GridViewDataColumn)Detector_Grid.Columns[3], "combo_voting2_cnt");
DropDownList combo_type1 = (DropDownList)Detector_Grid.FindEditRowCellTemplateControl((GridViewDataColumn)Detector_Grid.Columns[0], "TYPE1_COMBO");
DropDownList combo_type2 = (DropDownList)Detector_Grid.FindEditRowCellTemplateControl((GridViewDataColumn)Detector_Grid.Columns[2], "TYPE2_COMBO");
string voting1 = combo_voting_cnt.Text;
string voting2 = combo_voting2_cnt.Text;
string type1 = combo_type1.Text;
string type2 = combo_type2.Text;
string qry = "insert into TBLDETECTOR_VOTING(OBID, TYPE1, VOTING_CNT1, TYPE2, VOTING_CNT2, N1CREATIONDATE, N1CREATIONSESID, N1PROJECTNAME, Zone) ";
qry = qry + "values (NEWID(), '" + type1 + "','" + voting1 + "','" + type2 + "', '" + voting2 + "', REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),' ', '-'), ";
qry = qry + "'" + SessionInfo.UserName + "', '" + fgm_moduler.func_Class.project_Name + "', '" + zone + "')";
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
Detector_Grid.CancelEdit();
}
protected void gridServices_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
#region Validating
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key,
out _message))
{
// Cau lenh nay se quang ra exception va DevExpress se nhan duoc exception de thong bao loi cho nguoi dung
WebCommon.AlertGridView(sender, _message);
// Cancel operation
e.Cancel = true;
// Stop
return;
}
// Get PriorityIndex object
var index = (ASPxSpinEdit)((ASPxGridView)sender).FindEditFormTemplateControl("index");
// Validate empty field
if (!WebCommon.ValidateEmpty("Title", e.NewValues["Title"], out _message)
|| !WebCommon.ValidateEmpty("Short Title", e.NewValues["ShortTitle"], out _message)
|| !WebCommon.ValidateEmpty("Index", index.Value, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Validate integer value for priority index
int iIndex;
if (!Int32.TryParse(index.Value.ToString().Trim(), out iIndex))
{
WebCommon.AlertGridView(sender, "Index value is invalid.");
e.Cancel = true;
return;
}
#endregion
// Set value
e.NewValues["Title"] = e.NewValues["Title"].ToString().Trim();
e.NewValues["ShortTitle"] = e.NewValues["Title"].ToString().Trim();
e.NewValues["PriorityIndex"] = index.Value;
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
// Show message alert delete successfully
WebCommon.AlertGridView(sender, "Service is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
e.Cancel = true;
WebCommon.AlertGridView(sender, "Cannot create new service. Please contact Administrator");
}
}
protected override void RaiseRowInserting(ASPxDataInsertingEventArgs e)
{
OnBeforeRowInserting_BaseImplementation(e);
base.RaiseRowInserting(e);
OnAfterRowInserting_BaseImplementation(e);
}
protected void grdTitoliDiStudio_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
string ddDescr = e.NewValues["dd_descrizione"].ToString();
DALRuntime.insertTitolo(ddDescr);
e.Cancel = true;
grdTitoliDiStudio.CancelEdit();
grdDataBind(true, true);
}
protected void grdStatoCivile_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
string ddDescr = e.NewValues["dd_descrizione"].ToString();
DALRuntime.insertStatoCivile(ddDescr);
e.Cancel = true;
grdStatoCivile.CancelEdit();
grdDataBind(true, true);
}
protected void grid_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
CustomDataSource.Rows.Add(e.NewValues["Id"], e.NewValues["Data"]);
ASPxGridView grid = sender as ASPxGridView;
grid.CancelEdit();
e.Cancel = true;
}
protected void ReceiptGrid_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var xml = Utilities.FormatXml(@"<data>
<goods_id>{0}</goods_id>
<caption>{1}</caption>
</data>", _goodsID, e.NewValues["Caption"]);
ReceiptDataSource.InsertParameters["Xml"].DefaultValue = xml;
}
protected void gvw_car_no_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
e.NewValues["id"] = Guid.NewGuid();
var cbb_car_area = grid.FindEditFormTemplateControl("cbb_car_area") as DevExpress.Web.ASPxEditors.ASPxComboBox;
var txt_car_no = grid.FindEditFormTemplateControl("txt_car_no") as DevExpress.Web.ASPxEditors.ASPxTextBox;
e.NewValues["car_no"] = cbb_car_area.Text + txt_car_no.Text;
}
protected void gvAttachment_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
e.NewValues["FileId"] = Guid.NewGuid();
e.NewValues["AssessmentId"] = int.Parse(Session["IAssessmentId"].ToString());
e.NewValues["FileName"] = _FileName;
e.NewValues["FileType"] = _FileType;
e.NewValues["FileContent"] = _FileContent;
e.NewValues["CreatedBy"] = Global.SessionUser.UserName;
e.NewValues["CreateDate"] = DateTime.Now;
}
protected virtual void OnAfterRowInserting_BaseImplementation(ASPxDataInsertingEventArgs e)
{
if (DataSource is ISmartDataSourse)
{
DataSource.Dirty();
e.Cancel = true;
CancelEdit();
}
}
protected void gridLinkedImportTbl_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView gv = (ASPxGridView)sender;
DxDbOps.BuildInsertSqlCode(e, "LinkedImportTbl", "data", "def");
gv.CancelEdit();
e.Cancel = true;
Session["LinkedImports"] = null;
Session["LinkedImportTbls"] = null;
LoadlinkedTables();
}
protected void treeList_NodeInserting(object sender, ASPxDataInsertingEventArgs e)
{
if (e.NewValues["VisibleText"] == null)
{
e.Cancel = true;
treeList.CancelEdit();
return;
}
string testval = e.NewValues["VisibleText"].ToString();
ASPxDropDownEdit edtInline = (ASPxDropDownEdit)treeList.FindEditCellTemplateControl((TreeListDataColumn)treeList.
Columns["Notes"], "ASPxDropDownEdit1");
testval = edtInline.Text;
DropDownList itemtypelist = (DropDownList)treeList.FindEditCellTemplateControl((TreeListDataColumn)treeList.Columns["ItemType"], "ItemTypeList");
if (itemtypelist.SelectedValue == "")
{
e.Cancel = true;
treeList.CancelEdit();
return;
}
int type = int.Parse(itemtypelist.SelectedValue);
DropDownList requiredlist = (DropDownList)treeList.FindEditCellTemplateControl((TreeListDataColumn)treeList.Columns["Required"], "RequiredList");
if (requiredlist.SelectedValue == "")
{
e.Cancel = true;
treeList.CancelEdit();
return;
}
bool required = bool.Parse(requiredlist.SelectedValue == "Yes" ? "True" : "False");
e.Cancel = true;
string parentKey = e.NewValues[treeList.ParentFieldName].ToString(); // treeList.FocusedNode.ParentNode.Key;
string checklistckey = ddChecklists.SelectedValue;
List <ChecklistTemplateVersion> versions = ChecklistTemplateVersion.GetChecklistTemplateVersions(decimal.Parse(checklistckey));
decimal versionckey = versions[0].ChecklistTemplateVersionCKey;
int sortorder = ChecklistTemplateItems.GetSortOrder(decimal.Parse(parentKey));
BindChecklistTree();
treeList.CancelEdit();
}
protected void gvData_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var newValues = e.NewValues;
var tableModel = Model.Table;
foreach (var column in tableModel.Columns)
{
var name = String.Format("v{0}", column.Name.ComputeCrc16());
var value = Convert.ToString(newValues[column.Name]);
sqlDs.InsertParameters.Add(name, value);
}
}
protected void grdUtenti_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
string ddLogin = e.NewValues["dd_login"].ToString();
string ddNome = e.NewValues["dd_nome"].ToString();
string ddCognome = e.NewValues["dd_cognome"].ToString();
string ddPassword = e.NewValues["dd_password"].ToString();
int czProfilo = getCzProfilo();
string ddMail = e.NewValues["dd_mail"].ToString();
DALRuntime.insertUtente(ddLogin, ddPassword, ddNome, ddCognome, ddMail, czProfilo);
e.Cancel = true;
grdUtenti.CancelEdit();
grdDataBind(true, true);
}
protected void gv_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView gv = (ASPxGridView)sender;
DataRow row = table.NewRow();
row["ID"] = GetNewId();
row["Item"] = e.NewValues[0];
table.Rows.Add(row);
Session["DataTable"] = table;
gv.JSProperties["cpID"] = row["ID"];
gv.JSProperties["cpText"] = row["Item"];
gv.CancelEdit();
e.Cancel = true;
}
protected void dxgridPeople_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
//Add HouseholdID
e.NewValues.Add("HouseholdID", Request.QueryString["hhID"]);
bool result = DxDbOps.BuildInsertSqlCode(e, "tblPerson", "backend");
ASPxGridView gv = (ASPxGridView)sender;
gv.CancelEdit();
e.Cancel = true;
//test
}
public static void gvcrud_OnRowInserting(ASPxGridView gv, ASPxDataInsertingEventArgs e, string dbname, string schemaname)
{
Debug.WriteLine(" ***** grid_OnRowInserting");
//ASPxGridView gv = (ASPxGridView)sender;
//SQL_utils sql = new SQL_utils(dbname);
string gvname = gv.ClientInstanceName;
DxDbOps.BuildInsertSqlCode(e, gvname, dbname, schemaname);
gv.JSProperties["cpIsUpdated"] = gv.ClientInstanceName.ToString();
gv.CancelEdit();
e.Cancel = true;
}
protected void gdvdln1_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var beNe = new BRDocument();
gdvdln1.DoRowValidation();
var obec = ((BEParameters)Session["InitPar"]);
string almacen = "";
/*if (obec.Socied == "BM")
* {
* if (beNe.getStockAlmacen(Convert.ToString(e.NewValues["ItemCode"])) <= 0)
* almacen = "BL010";
* else
* almacen = obec.WhsCode;
* }
* if (obec.Socied == "BT")
* {*/
almacen = obec.WhsCode;
//}
var line = new BEDocumentLine()
{
ItemCode = Convert.ToString(e.NewValues["ItemCode"]),
ItemName = Convert.ToString(e.NewValues["ItemName"]),
U_GOS_MARCA = Convert.ToString(e.NewValues["U_GOS_MARCA"]),
Quantity = Convert.ToInt32(e.NewValues["Quantity"]),
WhsCode = almacen,
U_StoDiBE = Convert.ToDecimal(e.NewValues["U_StoDiBE"]),
U_BF_StoDiYo = Convert.ToDecimal(e.NewValues["U_BF_StoDiYo"]),
IssueMthd = Convert.ToString(e.NewValues["IssueMthd"]),
TreeType = Convert.ToString(e.NewValues["TreeType"]),
OItemCode = Convert.ToString(e.NewValues["OItemCode"]),
OnDscOrg = Convert.ToDecimal(e.NewValues["OnDscOrg"]),
Serie = Convert.ToString(e.NewValues["Serie"])
//PASAR EL SERIALNUMBER PARA LUEGO HACER EL DATASOURCE AL DETALLE
};
line.InDscOrg = (line.OnDscOrg == 0) ? 1 : 0;
((List <BEDocumentLine>)Session["dln1"]).Add(line);
//Set_Promotion();
Set_LineNum2();
gdvdln1.CancelEdit();
e.Cancel = true;
gdvdln1.DataSource = ((List <BEDocumentLine>)Session["dln1"]);
gdvdln1.DataBind();
}
protected void ASPxGridView1_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
e.Cancel = true;
SqlDataSource1.InsertParameters["email"].DefaultValue = e.NewValues["email"].ToString();
SqlDataSource1.InsertParameters["username"].DefaultValue = e.NewValues["username"].ToString();
SqlDataSource1.InsertParameters["displayname"].DefaultValue = e.NewValues["displayname"].ToString();
SqlDataSource1.InsertParameters["StaffID"].DefaultValue = e.NewValues["StaffID"].ToString();
string _enabled = e.NewValues["enabled"] + "";
SqlDataSource1.InsertParameters["enabled"].DefaultValue = _enabled;
SqlDataSource1.InsertParameters["phone"].DefaultValue = e.NewValues["phone"].ToString();
SqlDataSource1.InsertParameters["password"].DefaultValue = Utils.Encrypt(e.NewValues["password"].ToString());
SqlDataSource1.InsertParameters["BOID"].DefaultValue = CU.getBOID().ToString();
SqlDataSource1.Insert();
((ASPxGridView)sender).CancelEdit();
}
//protected void btnSubmit_Click(object sender, EventArgs e)
//{
// string last = txtLast.Text;
// if(last != "")
// {
// SQL_utils sql = new SQL_utils("backend");
// string sqlcode = String.Format("insert into stf.staff (last_name) values ('{0}')", last);
// sql.NonQuery_from_SQLstring(sqlcode);
// sql.Close();
// gv_staff.DataBind();
// }
//}
protected void gvcrud_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView gv = (ASPxGridView)sender;
SQL_utils sql = new SQL_utils("backend");
int current_max_staffpk = sql.IntScalar_from_SQLstring("select max(staffpk) from stf.staff");
//if (gv.ClientInstanceName == "staffevent" | gv.ClientInstanceName == "staffproperty")
//{
// e.NewValues.Add("staffpk", Request.QueryString["staffpk"]);
//}
gvCRUD.gvcrud_OnRowInserting((ASPxGridView)sender, e, "backend", "stf");
((ASPxGridView)sender).JSProperties["cpUpdate"] = true;
}
protected void trlDepartamentos_NodeInserting(object sender, ASPxDataInsertingEventArgs e)
{
string strParentKey = trlDepartamentos.FocusedNode.Key;
DataTable dtbTrl = (DataTable)Session[Constantes.SesionTablaDepartamentos];
DataRow dtrNew = dtbTrl.NewRow();
dtrNew[Constantes.ColumnaDepartamentoCodigo] = new ClsGeneral().ObtenerNuevoCodigo(dtbTrl, Constantes.ColumnaDepartamentoCodigo);
dtrNew[Constantes.ColumnaDepartamentoPadre] = Convert.ToInt32(strParentKey);
dtrNew[Constantes.ColumnaDepartamentoNombre] = e.NewValues[Constantes.ColumnaDepartamentoNombre];
dtbTrl.Rows.Add(dtrNew);
new ClsDepartamento().AdministrarDepartamento((DataTable)Session[Constantes.SesionTablaCentroCostos], (int)EnumAccionTabla.Insert);
Session[Constantes.SesionTablaDepartamentos] = dtbTrl;
trlDepartamentos.DataBind();
e.Cancel = true;
trlDepartamentos.CancelEdit();
}
protected void grdAQuestItem_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView grdAQuestItem = sender as ASPxGridView;
DALRuntime.TRecQuestItem recQuestItem = new DALRuntime.TRecQuestItem();
recQuestItem.ddDomanda = e.NewValues["dd_domanda"].ToString();
recQuestItem.ddRisposte = e.NewValues["dd_risposte"].ToString();
if (e.NewValues["dd_immagine"] != null)
recQuestItem.ddImmagine = e.NewValues["dd_immagine"].ToString();
if (e.NewValues["nr_order"] != null)
recQuestItem.nrOrder = Convert.ToInt32(e.NewValues["nr_order"].ToString());
recQuestItem.caQuestSezione = DALRuntime.IdAQuestSezione;
recQuestItem.caQuest = DALRuntime.IdAQuest;
recQuestItem.insertAQuestItem();
e.Cancel = true;
grdAQuestItem.CancelEdit();
}
protected void Cause_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
string desc = e.NewValues[0].ToString();
string seq = e.NewValues[1].ToString();
string qry = "INSERT INTO TBLSYSTEM_TEMPLATE(OBID, SYS_NAME, CLASS_NAME, SEQ, PARENT_OBID, DESCRIPTION, PRJ_NAME) ";
qry = qry + "VALUES(NEWID(), '" + sys_name + "', 'Cause', '" + seq + "', '" + sys_name + "', '" + desc + "', '" + fgm_moduler.func_Class.project_Name + "')";
SqlCommand cmd;
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
CauseGrid.CancelEdit();
}
protected void gridDict_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView gv = (ASPxGridView)sender;
SQL_utils sql = new SQL_utils("data");
int tblpk = sql.IntScalar_from_SQLstring("select tblpk from def.tbl where measureID=" + Request.QueryString["mID"]);
e.NewValues.Add("tblpk", tblpk);
DxDbOps.BuildInsertSqlCode(e, "fld", "data", "def");
//((ASPxGridView)sender).JSProperties["cpIsUpdated"] = gv.ClientInstanceName.ToString();
gv.CancelEdit();
e.Cancel = true;
gridDict.DataBind();
}
protected void grid_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
//dane osobowe
e.NewValues["tytul"] = nm.controlText("txTytul", grid);
e.NewValues["imie"] = nm.controlText("txImie", grid);
e.NewValues["nazwisko"] = nm.controlText("txNazwisko", grid);
e.NewValues["data_poczatkowa"] = nm.controlTextDate("txPoczatekPowolania", grid);
e.NewValues["data_koncowa"] = nm.controlTextDate("txDataKoncaPowolania", grid);
if (nm.controlText("txPESEL", grid) == null)
{
e.NewValues["Pesel"] = 0;
}
else
{
e.NewValues["Pesel"] = nm.controlText("txPESEL", grid);
}
//d_zawieszenia
var cos = (string)Session["czy_zawN"]; //nm.controlCheckbox("cbZawieszenie", grid);
e.NewValues["czy_zaw"] = false;
if (cos == "1")
{
e.NewValues["czy_zaw"] = true;
DateTime poczZaw = (DateTime)Session["poczatekZawieszeniaN"];
DateTime konZaw = (DateTime)Session["koniecZawieszeniaN"];
e.NewValues["d_zawieszenia"] = poczZaw;
e.NewValues["dataKoncaZawieszenia"] = konZaw;
}
//dane adresowe
e.NewValues["ulica"] = nm.controlText("txAdres", grid);
e.NewValues["kod_poczt"] = nm.controlText("txKodPocztowy", grid);
e.NewValues["miejscowosc"] = nm.controlText("txMiejscowosc", grid);
e.NewValues["tel1"] = nm.controlText("txTelefon1", grid);
e.NewValues["tel2"] = nm.controlText("txTelefon2", grid);
e.NewValues["email"] = nm.controlText("txEmail", grid);
//dane korespondencyjne
e.NewValues["adr_kores"] = nm.controlText("txAdresKorespondencyjny", grid);
e.NewValues["kod_poczt_kor"] = nm.controlText("txKodPocztowyKorespondencyjny", grid);
e.NewValues["miejscowosc_kor"] = nm.controlText("txMiejscowoscKorespondencyjny", grid);
// uwagi i specjalizacje
e.NewValues["uwagi"] = nm.controlTextMemo("txUwagi", grid);
e.NewValues["specjalizacja_opis"] = nm.controlTextMemo("txSpecjalizacjeOpis", grid);
e.NewValues["instytucja"] = nm.controlText("txInstytucja", grid);
}
protected void ASPxGridView1_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var grid = (ASPxGridView)sender;
var item = e.NewValues.ToEntity <Table1>();
item.CreateTime = DateTime.Now;
item.FileUrl = grid.GetEditText("FileUrl", "ASPxTextBox1");
using (var db = new Entities())
{
db.Table1.Add(item);
db.SaveChanges();
}
e.Cancel = true;
grid.CancelEdit();
}
protected void grid_RowInserting(Object sender, ASPxDataInsertingEventArgs e)
{
if (IsFileUploaded)
{
var data = new Data {
ID = GetNewID(),
Date = DateTime.Now,
Name = Filename,
Comment = e.NewValues["Comment"].ToString(),
FileType = LocalHelper.GetFileType(Filename)
};
Data.Add(data);
Filename = null;
grid.CancelEdit();
}
e.Cancel = true;
}
protected void gridUser_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Get grid
var grid = sender as ASPxGridView;
if (grid == null)
{
WebCommon.AlertGridView(sender, "Add form is error.");
e.Cancel = true;
return;
}
// Get control and validate
var radMale = grid.FindEditFormTemplateControl("radMale") as ASPxRadioButton;
var radFemale = grid.FindEditFormTemplateControl("radFemale") as ASPxRadioButton;
var txtPsw = grid.FindEditFormTemplateControl("txtPsw") as ASPxTextBox;
if (radMale == null || radFemale == null || txtPsw == null)
{
WebCommon.AlertGridView(sender, "Add form is error.");
e.Cancel = true;
return;
}
// Validate empty field
if (!WebCommon.ValidateEmpty("Username", e.NewValues["Username"], out _message)
|| !WebCommon.ValidateEmpty("Password", txtPsw.Text, out _message)
|| !WebCommon.ValidateEmpty("Service", e.NewValues["ServicesId"], out _message)
|| !WebCommon.ValidateEmpty("Group", e.NewValues["UserGroupId"], out _message)
|| !WebCommon.ValidateEmpty("First Name", e.NewValues["Firstname"], out _message)
|| !WebCommon.ValidateEmpty("Last Name", e.NewValues["Lastname"], out _message)
|| !WebCommon.ValidateEmpty("Display Name", e.NewValues["DisplayName"], out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Check username is exists
var user = DataRepository.UsersProvider.GetByUsername(e.NewValues["Username"].ToString());
if (user != null)
{
WebCommon.AlertGridView(sender, "Username is existed.");
e.Cancel = true;
return;
}
// Validate service field
int serviceId;
if (!Int32.TryParse(e.NewValues["ServicesId"].ToString(), out serviceId))
{
WebCommon.AlertGridView(sender, "Service is invalid.");
e.Cancel = true;
return;
}
var service = DataRepository.ServicesProvider.GetById(serviceId);
if (service == null || service.IsDisabled)
{
WebCommon.AlertGridView(sender, "Service is not existed.");
e.Cancel = true;
return;
}
// Validate group field
var userGroup = DataRepository.UserGroupProvider.GetById(e.NewValues["UserGroupId"].ToString());
if (userGroup == null || userGroup.IsDisabled)
{
WebCommon.AlertGridView(sender, "Group is not existed.");
e.Cancel = true;
return;
}
// Check email is exists
string squery = string.Format("Email='{0}' and IsDisabled='False'", e.NewValues["Email"]);
int count;
if (DataRepository.UsersProvider.GetPaged(squery, "", 0, 0, out count).Any())
{
WebCommon.AlertGridView(sender, "Email is existed.");
e.Cancel = true;
return;
}
e.NewValues["Username"] = e.NewValues["Username"].ToString().Trim();
e.NewValues["Password"] = Encrypt.EncryptPassword(txtPsw.Text);
e.NewValues["Firstname"] = FString.ToTitleCase(e.NewValues["Firstname"].ToString().Trim());
e.NewValues["Lastname"] = FString.ToTitleCase(e.NewValues["Lastname"].ToString().Trim());
e.NewValues["DisplayName"] = FString.ToTitleCase(e.NewValues["DisplayName"].ToString().Trim());
e.NewValues["CellPhone"] = e.NewValues["CellPhone"] == null ? string.Empty : e.NewValues["CellPhone"].ToString().Trim();
e.NewValues["Email"] = e.NewValues["Email"] == null ? string.Empty : e.NewValues["Email"].ToString().Trim();
e.NewValues["Note"] = e.NewValues["Note"] == null ? string.Empty : e.NewValues["Note"].ToString().Trim();
e.NewValues["UserGroupId"] = e.NewValues["UserGroupId"].ToString().Trim();
e.NewValues["ServicesId"] = serviceId;
e.NewValues["IsFemale"] = radFemale.Checked;
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
WebCommon.AlertGridView(sender, "User is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
WebCommon.AlertGridView(sender, "Cannot insert user. Please contact Administrator");
e.Cancel = true;
}
}
/// <summary>
/// Thuc hien them moi roster
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gridRoster_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
var grid = sender as ASPxGridView;
if (grid == null)
{
WebCommon.AlertGridView(sender, "Cannot find roster.");
e.Cancel = true;
return;
}
var fromTime = grid.FindEditFormTemplateControl("fromTime") as ASPxTimeEdit;
var fromDate = grid.FindEditFormTemplateControl("fromDate") as ASPxDateEdit;
var endTime = grid.FindEditFormTemplateControl("endTime") as ASPxTimeEdit;
var endDate = grid.FindEditFormTemplateControl("endDate") as ASPxDateEdit;
var doctor = grid.FindEditFormTemplateControl("cboDoctor") as ASPxComboBox;
var rosterType = grid.FindEditFormTemplateControl("cboRosterType") as ASPxComboBox;
if (fromTime == null || fromDate == null || endTime == null || endDate == null || doctor == null || rosterType == null)
{
WebCommon.AlertGridView(sender, "New form is error.");
e.Cancel = true;
return;
}
var chkIsRepeat = grid.FindEditFormTemplateControl("chkIsRepeat") as ASPxCheckBox;
var chkWeekday = grid.FindEditFormTemplateControl("chkWeekday") as CheckBoxList;
// Lay doctorUsername
// Neu selected value la null thi mac dinh no bang empty
var doctorUsername = string.Empty;
if (doctor.SelectedItem != null)
{
doctorUsername = doctor.SelectedItem.Value.ToString();
}
// Lay roster type
// Neu selected value la null thi mac dinh no bang empty
var rosterTypeId = string.Empty;
if (rosterType.SelectedItem != null)
{
rosterTypeId = rosterType.SelectedItem.Value.ToString();
}
// Validate empty field
if (!WebCommon.ValidateEmpty("Doctor", doctorUsername, out _message)
|| !WebCommon.ValidateEmpty("Roster Type", rosterTypeId, out _message)
|| !WebCommon.ValidateEmpty("From Time", fromTime.Text, out _message)
|| !WebCommon.ValidateEmpty("From Date", fromDate.Text, out _message)
|| !WebCommon.ValidateEmpty("End Time", endTime.Text, out _message)
|| !WebCommon.ValidateEmpty("End Date", endDate.Text, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Get date time
DateTime dtStart = (DateTime)fromDate.Value, dtEnd = (DateTime)endDate.Value;
DateTime timeStart = (DateTime)fromTime.Value, timeEnd = (DateTime)endTime.Value;
dtStart = new DateTime(dtStart.Year, dtStart.Month, dtStart.Day, timeStart.Hour, timeStart.Minute, 0);
dtEnd = new DateTime(dtEnd.Year, dtEnd.Month, dtEnd.Day, timeEnd.Hour, timeEnd.Minute, 0);
// Declare list of roster in case repeat roster
var lstRoster = new TList<Roster>();
// Lay du lieu duoc nhap vao
var username = doctor.SelectedItem.Value.ToString();
int intRosterTypeId;
var note = e.NewValues["Note"].ToString();
if (!Int32.TryParse(rosterType.SelectedItem.Value.ToString(), out intRosterTypeId))
{
WebCommon.AlertGridView(sender, "Roster Type is invalid.");
e.Cancel = true;
return;
}
if (chkIsRepeat != null && chkIsRepeat.Checked && chkWeekday != null)
{
#region Validate Time
// Set lai ngay cho endtime de so sanh
timeEnd = new DateTime(timeStart.Year, timeStart.Month, timeStart.Day, timeEnd.Hour, timeEnd.Minute, 0);
if (timeStart >= timeEnd)
{
WebCommon.AlertGridView(sender, "End time must be greater than start time.");
e.Cancel = true;
return;
}
if (dtStart >= dtEnd)
{
WebCommon.AlertGridView(sender, "To time must be greater than from date.");
e.Cancel = true;
return;
}
// If roster is created in a passed or current day
DateTime dtNow = DateTime.Now;
if (new DateTime(dtNow.Year, dtNow.Month, dtNow.Day) >= new DateTime(dtStart.Year, dtStart.Month, dtStart.Day))
{
WebCommon.AlertGridView(sender, "You can not change roster to passed or current date.");
e.Cancel = true;
return;
}
#endregion
// Get auto increasement id
string perfix = ServiceFacade.SettingsHelper.RosterPrefix + DateTime.Now.ToString("yyMMdd");
int count;
TList<Roster> objPo = DataRepository.RosterProvider.GetPaged("Id like '" + perfix + "' + '%'", "Id desc", 0, 1, out count);
string number = count == 0 ? "001" : String.Format("{0:000}", int.Parse(objPo[0].Id.Substring(objPo[0].Id.Length - 3)) + 1);
// Variable for error message if there is conflict roster
string errorMessage = string.Empty;
var repeatRoster = Guid.NewGuid();
// Set gia tri cho ngay dau tien
// Se khong cho gia tri ngay dau tien vao vong lap
e.NewValues["Id"] = perfix + number;
e.NewValues["StartTime"] = dtStart;
e.NewValues["EndTime"] = new DateTime(dtStart.Year, dtStart.Month, dtStart.Day, dtEnd.Hour, dtEnd.Minute, 0); ;
e.NewValues["RepeatId"] = repeatRoster;
e.NewValues["Username"] = username;
e.NewValues["RosterTypeId"] = intRosterTypeId;
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
// Lay danh sach ngay duoc lap lai
var weekday = (from ListItem item in chkWeekday.Items where item.Selected select item.Value).ToList();
while (dtStart <= dtEnd)
{
dtStart = dtStart.AddDays(1);
if (weekday.Exists(x => x == dtStart.DayOfWeek.ToString()))
{
var dtTmpStart = dtStart;
var dtTmpEnd = new DateTime(dtStart.Year, dtStart.Month, dtStart.Day, dtEnd.Hour, dtEnd.Minute, 0);
// Check existed rosters
string query = string.Format("Username = '******' AND IsDisabled = 'False' AND StartTime < '{1}' AND EndTime > '{2}'"
, username, dtTmpEnd, dtTmpStart);
DataRepository.RosterProvider.GetPaged(query, "Id desc", 0, ServiceFacade.SettingsHelper.GetPagedLength, out count);
// If there is no roster -> insert new roster
if (count > 0)
{
errorMessage += dtTmpStart.DayOfWeek.ToString() + " " + dtTmpStart.ToString("dd MMM yyyy") + ", ";
continue;
}
number = String.Format("{0:000}", int.Parse(number) + 1);
lstRoster.Add(new Roster
{
Id = perfix + number,
Username = username,
RosterTypeId = intRosterTypeId,
StartTime = dtTmpStart,
EndTime = dtTmpEnd,
RepeatId = repeatRoster,
Note = note,
CreateUser = AccountSession.Session,
UpdateUser = AccountSession.Session
});
}
}
if (errorMessage.Length > 0)
{
WebCommon.AlertGridView(sender, String.Format("There are some rosters conflicted: {0}", errorMessage.Substring(0, errorMessage.Length - 1)));
e.Cancel = true;
return;
}
// Insert new rosters
DataRepository.RosterProvider.Insert(lstRoster);
}
else
{
#region Validate Time
if (dtStart >= dtEnd)
{
WebCommon.AlertGridView(sender, "To time must be greater than from date.");
e.Cancel = true;
return;
}
// If roster is created in a passed or current day
DateTime dtNow = DateTime.Now;
if (new DateTime(dtNow.Year, dtNow.Month, dtNow.Day) >= new DateTime(dtStart.Year, dtStart.Month, dtStart.Day))
{
WebCommon.AlertGridView(sender, "You can not change roster to passed or current date.");
e.Cancel = true;
return;
}
#endregion
var newObj = new Roster();
string perfix = ServiceFacade.SettingsHelper.RosterPrefix + DateTime.Now.ToString("yyMMdd");
int count;
TList<Roster> objPo = DataRepository.RosterProvider.GetPaged("Id like '" + perfix + "' + '%'", "Id desc", 0, 1, out count);
string id;
if (count == 0)
id = perfix + "001";
else
{
id = perfix + String.Format("{0:000}", int.Parse(objPo[0].Id.Substring(objPo[0].Id.Length - 3)) + 1);
}
// Check existed rosters
string query = string.Format("Username = '******' AND IsDisabled = 'False' AND StartTime < '{1}' AND EndTime > '{2}'"
, username, dtStart, dtEnd);
DataRepository.RosterProvider.GetPaged(query, "Id desc", 0, ServiceFacade.SettingsHelper.GetPagedLength, out count);
// If there is no roster -> insert new roster
if (count > 0)
{
WebCommon.AlertGridView(sender, String.Format("There is roster conflicted: From {0} {1} to {2} {3}"
, newObj.StartTime.DayOfWeek, newObj.StartTime.ToString("dd MMM yyyy HH:mm")
, newObj.EndTime.DayOfWeek, newObj.EndTime.ToString("dd MMM yyyy HH:mm")));
e.Cancel = true;
return;
}
// Set pure value
e.NewValues["Id"] = id;
e.NewValues["Username"] = username;
e.NewValues["RosterTypeId"] = intRosterTypeId;
e.NewValues["StartTime"] = dtStart;
e.NewValues["EndTime"] = dtEnd;
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
}
// Show message alert delete successfully
WebCommon.AlertGridView(sender, "Roster is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
e.Cancel = true;
WebCommon.AlertGridView(sender, "Cannot create new Roster. Please contact Administrator");
}
}
protected void grdAQuestSezioni_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView grdAQuestSezione = sender as ASPxGridView;
string ddDescr1 = e.NewValues["dd_descrizione1"].ToString();
string ddDescr2 = e.NewValues["dd_descrizione2"].ToString();
int caQuest = DALRuntime.IdAQuest;
int nrNumScelte = Convert.ToInt32(e.NewValues["nr_num_scelte_possibili"].ToString());
DALRuntime.insertAQuestSezione(ddDescr1, ddDescr2, caQuest, nrNumScelte);
e.Cancel = true;
grdAQuestSezione.CancelEdit();
}
protected void GridView_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
e.NewValues["ID"] = EmployeeSessionProvider.GenerateNewID();
}
protected void gridFondMove_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var fondMoveEditorParams = SetFondMoveEditorParamsFromControls();
var fondMoveEditorAction = new FondMoveEditorActions();
string result = fondMoveEditorAction.FondMoveEditorInsert(fondMoveEditorParams);
gridFondMove.JSProperties["cpFondMoveEditorResultInfo"] = result;
e.Cancel = true;
gridFondMove.CancelEdit();
}
protected void gridRoleDetail_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Check null for grid role detail
var grid = sender as ASPxGridView;
if (grid == null)
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
var crud = GetStringCrud(sender, e);
var roleId = grid.GetMasterRowKeyValue();
// Validate empty field
if (!WebCommon.ValidateEmpty("Role", roleId, out _message)
|| !WebCommon.ValidateEmpty("Screen", e.NewValues["ScreenCode"], out _message)
|| !WebCommon.ValidateEmpty("Right", crud, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Set pure value
e.NewValues["ScreenCode"] = e.NewValues["ScreenCode"].ToString().Trim();
e.NewValues["RoleId"] = roleId;
e.NewValues["Crud"] = crud;
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
// Show message alert delete successfully
WebCommon.AlertGridView(sender, "Role detail is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
e.Cancel = true;
WebCommon.AlertGridView(sender, "Cannot create new role detail. Please contact Administrator");
}
}
protected void grid_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ExpenseInfo item = new ExpenseInfo();
UpdateExpense(item, e.NewValues);
e.Cancel = true;
grid.CancelEdit();
}
protected string GetStringCrud(object sender, ASPxDataInsertingEventArgs e)//lay du lieu trong check box khi them moi
{
try
{
string crud = string.Empty;
// Validate null
var asPxGridView = sender as ASPxGridView;
if (asPxGridView == null)
{
return crud;
}
var gridColumn = asPxGridView.Columns["Right"] as GridViewDataColumn;
var chkr = (ASPxCheckBox)asPxGridView.FindEditRowCellTemplateControl(gridColumn, "ckcR");
var chku = (ASPxCheckBox)asPxGridView.FindEditRowCellTemplateControl(gridColumn, "ckcU");
var chkd = (ASPxCheckBox)asPxGridView.FindEditRowCellTemplateControl(gridColumn, "ckcD");
var chkc = (ASPxCheckBox)asPxGridView.FindEditRowCellTemplateControl(gridColumn, "ckcC");
if (chkc.Checked) crud += OperationConstant.Create.Key;
if (chkr.Checked) crud += OperationConstant.Read.Key;
if (chku.Checked) crud += OperationConstant.Update.Key;
if (chkd.Checked) crud += OperationConstant.Delete.Key;
return crud;
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
return string.Empty;
}
}
protected void gridUserRole_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Check null for grid role detail
var grid = sender as ASPxGridView;
if (grid == null)
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
string username = grid.GetMasterRowKeyValue().ToString();
if (!WebCommon.ValidateEmpty("Role", e.NewValues["RoleId"], out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
e.NewValues["Username"] = username;
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
WebCommon.AlertGridView(sender, "User role is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
WebCommon.AlertGridView(sender, "Cannot create user role. Please contact Administrator");
e.Cancel = true;
}
}
protected void Effect_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView detailGridView = (ASPxGridView)sender;
string desc = "";
string loc1 = "";
string loc2 = "";
try
{
loc1 = e.NewValues[0].ToString();
loc2 = e.NewValues[1].ToString();
desc = e.NewValues[2].ToString();
}
catch (Exception ex)
{
}
finally
{
}
string PARENT_OBID = detailGridView.GetMasterRowKeyValue().ToString();
string qry = "INSERT INTO TBLSYSTEM_TEMPLATE(OBID, SYS_NAME, CLASS_NAME, SEQ, LOC1, LOC2, PARENT_OBID, DESCRIPTION, PRJ_NAME) ";
qry = qry + "VALUES(NEWID(), '" + sys_name + "', 'Effect', '0', '" + loc1 + "','" + loc2 + "','" + PARENT_OBID + "', '" + desc + "', '" + fgm_moduler.func_Class.project_Name + "')";
SqlCommand cmd;
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
detailGridView.CancelEdit();
}
protected void Cause_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
string desc = e.NewValues[0].ToString();
string seq = e.NewValues[1].ToString();
string qry = "INSERT INTO TBLSYSTEM_TEMPLATE(OBID, SYS_NAME, CLASS_NAME, SEQ, PARENT_OBID, DESCRIPTION, PRJ_NAME) ";
qry = qry + "VALUES(NEWID(), '" + sys_name + "', 'Cause', '" + seq + "', '" + sys_name + "', '" + desc + "', '" + fgm_moduler.func_Class.project_Name + "')";
SqlCommand cmd;
cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
e.Cancel = true;
CauseGrid.CancelEdit();
}
protected void GridGroupDetector_OnRowInserting(object sender, ASPxDataInsertingEventArgs e)
{
SqlCommand ins_cmd = new SqlCommand();
XmlDocument tag_Doc = new XmlDocument();
XmlElement tag_Ele;
XmlElement data_Ele;
int i;
ASPxTextBox new_textbox;
ASPxComboBox new_combobox;
ASPxMemo new_memo;
string grouptag_Name;
string grouptag_ID;
string tag_Name;
string tag_Seq="";
string tag_ID;
int tag_Count=0;
tag_Ele = tag_Doc.CreateElement("GroupDetector");
tag_Doc.AppendChild(tag_Ele);
//ASPxFormLayout editform_GroupDetector = new ASPxFormLayout();
//editform_GroupDetector.ID = "editform_GroupDetector";
ASPxFormLayout editform_GroupDetector = GridGroupDetector.FindEditFormTemplateControl("editform_GroupDetector") as ASPxFormLayout;
int cnt = editform_GroupDetector.Items.Count;
DataTable dt = Srch_DataField("FDM");
string db_name = "";
string auth = "";
foreach (DataRow dr in dt.Select("AUTH <> 'System'", "VIEW_SEQ"))
{
string value="";
db_name = dr["DB_NAME"].ToString();
auth = dr["AUTH"].ToString();
object item = editform_GroupDetector.FindNestedControlByFieldName(db_name);
if (item.GetType() == typeof(ASPxTextBox))
{
new_textbox = (ASPxTextBox)item;
if(new_textbox.Text != "")
{
data_Ele = tag_Doc.CreateElement("Data");
data_Ele.SetAttribute("Name", db_name);
value = new_textbox.Text;
data_Ele.InnerText = new_textbox.Text;
tag_Ele.AppendChild(data_Ele);
}
}
else if (item.GetType() == typeof(ASPxComboBox))
{
new_combobox = (ASPxComboBox)item;
if (new_combobox.Text != "")
{
data_Ele = tag_Doc.CreateElement("Data");
data_Ele.SetAttribute("Name", db_name);
value = new_combobox.Text;
data_Ele.InnerText = new_combobox.Text;
tag_Ele.AppendChild(data_Ele);
}
}
else if (item.GetType() == typeof(ASPxMemo))
{
new_memo = (ASPxMemo)item;
if (new_memo.Text != "")
{
data_Ele = tag_Doc.CreateElement("Data");
data_Ele.SetAttribute("Name", db_name);
value = new_memo.Text;
data_Ele.InnerText = new_memo.Text;
tag_Ele.AppendChild(data_Ele);
}
}
if (auth == "Manager" && value == "")
{
(sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "필수값을 입력하세요";
e.Cancel = true;
return;
}
else if (db_name == "CNT")
{
try
{
int chk_count = int.Parse(value);
if (chk_count < 1)
throw new Exception("");
}
catch
{
(sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "Count : Error";
e.Cancel = true;
return;
}
}
}
grouptag_Name = fgm_moduler.Validate_tagName(ref tag_Ele, env_config, module_Name, "");
if (grouptag_Name.Contains("Err"))
{
(sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "Tag No : Error";
e.Cancel = true;
return;
}
ins_cmd.Connection = fgm_moduler.func_Class.conn;
try
{
//Group Detector Tag Insert
grouptag_ID = fgm_moduler.Save_REVGRP(ref ins_cmd, env_config, "TagGroupDetector", grouptag_Name, tag_Ele, "*", 0, zone);
Detector_obid = grouptag_ID;
if (grouptag_ID.Contains("Err"))
{
(sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "Tag No : Duplication";
e.Cancel = true;
//GridGroupDetector.CancelEdit();
return;
}
fgm_moduler.Add_Attr(ref ins_cmd, "ID_ZONE", "text", zone, grouptag_ID);
foreach (XmlElement Ele in tag_Ele.ChildNodes)
{
fgm_moduler.Add_Attr(ref ins_cmd, Ele.GetAttribute("Name"), "text", Ele.InnerText, grouptag_ID);
if (Ele.GetAttribute("Name").ToString() == "CNT")
tag_Count = Int32.Parse(Ele.InnerText.ToString());
if (Ele.GetAttribute("Name").ToString() == "ID_UNIT")
Detector_unit = Ele.InnerText.ToString();
if (Ele.GetAttribute("Name").ToString() == "DETECTOR_TYPE")
Detector_type = Ele.InnerText.ToString();
if (Ele.GetAttribute("Name").ToString() == "LOC")
Detector_loc = Ele.InnerText.ToString();
if (Ele.GetAttribute("Name").ToString() == "CNT")
Detector_cnt = Ele.InnerText.ToString();
//if (Ele.GetAttribute("Name").ToString() == "DESC_NAME")
// Detector_desc = Ele.InnerText.ToString();
}
//Detector Tag Insert (Count 값으로 자동생성)
//Group Detector Dfactor 삽입추가(15.10.04) ex) Unit-Type c
for (i = 0; i < tag_Count; i++)
{
Add_Detector(grouptag_ID, grouptag_Name, tag_Ele);
}
}
catch (Exception ex)
{
(sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = ex.ToString();
fgm_moduler.func_Class.conn.Close();
e.Cancel = true;
GridGroupDetector.CancelEdit();
return;
}
e.Cancel = true;
GridGroupDetector.CancelEdit();
GridGroupDetector.JSProperties["cpNewWindowUrl"] = "FDMQNA.aspx?TYPE=" + Detector_type + "&OBID=" + grouptag_ID + "&UNIT=" + Detector_unit + "&LOC=" + Detector_loc + "&ZONE=" + zone + "&CNT=" + tag_Count;
}
protected void grid_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = WebCommon.GetAuthUsername();
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
}
/// <summary>
/// Them moi mot patient
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gridPatient_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
e.Cancel = true;
}
// Get grid
var grid = sender as ASPxGridView;
if (grid == null)
{
WebCommon.AlertGridView(sender, "Add form is error.");
e.Cancel = true;
return;
}
// Get control and validate
var radMale = grid.FindEditFormTemplateControl("radMale") as ASPxRadioButton;
var radFemale = grid.FindEditFormTemplateControl("radFemale") as ASPxRadioButton;
if (radMale == null || radFemale == null)
{
WebCommon.AlertGridView(sender, "Add form is error.");
e.Cancel = true;
return;
}
// Validate empty field
if (!WebCommon.ValidateEmpty("First Name", e.NewValues["FirstName"], out _message)
|| !WebCommon.ValidateEmpty("Last Name", e.NewValues["LastName"], out _message)
|| !WebCommon.ValidateEmpty("DOB", e.NewValues["DateOfBirth"], out _message)
|| !WebCommon.ValidateEmpty("Nationality", e.NewValues["Nationality"], out _message)
|| !WebCommon.ValidateEmpty("Mobile Phone", e.NewValues["MobilePhone"], out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Validate field
DateTime dtDOB;
if (!DateTime.TryParse(e.NewValues["DateOfBirth"].ToString(), out dtDOB))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
var patient = new VcsPatient
{
PatientCode = ServiceFacade.SettingsHelper.LocationCode,
FirstName = e.NewValues["FirstName"] == null ? null : e.NewValues["FirstName"].ToString(),
MiddleName = e.NewValues["MiddleName"] == null ? null : e.NewValues["MiddleName"].ToString(),
LastName = e.NewValues["LastName"] == null ? null : e.NewValues["LastName"].ToString(),
Sex = radMale.Checked
? SexConstant.Male.Value
: radFemale.Checked ? SexConstant.Female.Value : string.Empty,
DateOfBirth = dtDOB,
Nationality = e.NewValues["Nationality"] == null ? null : e.NewValues["Nationality"].ToString(),
HomePhone = e.NewValues["HomePhone"] == null ? null : e.NewValues["HomePhone"].ToString(),
MobilePhone = e.NewValues["MobilePhone"] == null ? null : e.NewValues["MobilePhone"].ToString(),
CompanyCode = e.NewValues["CompanyCode"] == null ? null : e.NewValues["CompanyCode"].ToString(),
ApptRemark = e.NewValues["ApptRemark"] == null ? null : e.NewValues["ApptRemark"].ToString(),
UpdateUser = AccountSession.Session,
};
var patients = DataRepository.VcsPatientProvider.Insert(patient.PatientCode, patient.FirstName, patient.MiddleName
, patient.LastName, patient.DateOfBirth, patient.Sex, patient.Nationality, patient.CompanyCode, patient.HomePhone
, patient.MobilePhone, patient.UpdateUser, patient.ApptRemark);
// Doan nay dung de fake cancel update
var gridView = (ASPxGridView)sender;
gridView.CancelEdit();
WebCommon.AlertGridView(sender, "Patient is added successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
WebCommon.AlertGridView(sender, "Cannot add patient. Please contact Administrator");
}
e.Cancel = true;
}
protected void GridView_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
}
protected override void RaiseRowInserting(ASPxDataInsertingEventArgs e)
{
OnBeforeRowInserting_BaseImplementation(e);
base.RaiseRowInserting(e);
OnAfterRowInserting_BaseImplementation(e);
}
protected void grdPazienti_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
DALRuntime.TRecPaziente recPaziente = getRecPaziente(e.NewValues, null);
ASPxGridView grdSender = (sender as ASPxGridView);
// Legge i valori di ct_titolo e ct_stato_civile e li scrive in recPaziente
readComboBox(recPaziente, grdSender);
recPaziente.insertPaziente();
e.Cancel = true;
endEditAndRefresh();
}
protected virtual void OnBeforeRowInserting_BaseImplementation(ASPxDataInsertingEventArgs e)
{
}
/// <summary>
/// Them mot role
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gridRole_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Validate empty field
if (!WebCommon.ValidateEmpty("Title", e.NewValues["Title"], out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Set pure value
e.NewValues["Title"] = e.NewValues["Title"].ToString().Trim();
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
// Show message alert delete successfully
WebCommon.AlertGridView(sender, "Role is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
e.Cancel = true;
WebCommon.AlertGridView(sender, "Cannot create new role. Please contact Administrator");
}
}
protected virtual void OnAfterRowInserting_BaseImplementation(ASPxDataInsertingEventArgs e)
{
if (DataSource is ISmartDataSourse)
{
DataSource.Dirty();
e.Cancel = true;
CancelEdit();
}
}
protected void gridGroup_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
try
{
// Validate user right for creating
if (!RightAccess.CheckUserRight(AccountSession.Session, ScreenCode, OperationConstant.Create.Key, out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
// Get grid
var grid = sender as ASPxGridView;
if (grid == null)
{
WebCommon.AlertGridView(sender, "Add form is error.");
e.Cancel = true;
return;
}
// Validate empty field
if (!WebCommon.ValidateEmpty("Title", e.NewValues["Title"], out _message))
{
WebCommon.AlertGridView(sender, _message);
e.Cancel = true;
return;
}
e.NewValues["Id"] = e.NewValues["Title"].ToString().Trim().Replace(" ", "");
e.NewValues["Title"] = e.NewValues["Title"].ToString().Trim();
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
WebCommon.AlertGridView(sender, "Group is created successfully.");
}
catch (Exception ex)
{
LoggerController.WriteLog(System.Runtime.InteropServices.Marshal.GetExceptionCode(), ex, Network.GetIpClient());
WebCommon.AlertGridView(sender, "Cannot insert group. Please contact Administrator");
e.Cancel = true;
}
}
protected void gridRoom_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
}
protected void detailGrid_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
e.NewValues["CreateUser"] = e.NewValues["UpdateUser"] = AccountSession.Session;
e.NewValues["CreateDate"] = e.NewValues["UpdateDate"] = DateTime.Now;
e.NewValues["UnitId"] = (sender as ASPxGridView).GetMasterRowKeyValue();
}
protected void grdAQuest_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
string ddDescr = e.NewValues["dd_descrizione"].ToString();
string ddDescrBreve = e.NewValues["dd_descr_breve"].ToString();
DALRuntime.insertAQuest(ddDescr, ddDescrBreve);
e.Cancel = true;
grdAQuest.CancelEdit();
grdDataBind(true, true);
}
