protected void grvPartitionManager_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { string strCn = e.NewValues["ConnectString"] + ""; string code = e.NewValues["Code"] + ""; int IDUser = 0, id_DV = 0; if (e.NewValues[4] != null) { IDUser = int.Parse(e.NewValues[4] + ""); } if (e.NewValues[2] != null) { id_DV = int.Parse(e.NewValues[2] + ""); } TestConnect(strCn, code); var sysPartitionService = new DM_MODULEService(); SYS_ConfigConnectionServer configConnectionServer = new SYS_ConfigConnectionServer(); var partition = new DM_MODULE { Name = e.NewValues["Name"] + "", Code = code, IDUSER = IDUser, IDMA_DVIQLY = id_DV, ConnectString = configConnectionServer.EncryptSYS_ConfigConnection(strCn) }; sysPartitionService.InsertDM_MODULE(partition); _DataBind(); e.Cancel = true; grvModunManager.CancelEdit(); //WriteLog("Insert " + e.NewValues["Name"] + "", Action.Create); }
protected void TestConnect(string strcn, string Code) { var sys_configconnection = new SYS_ConfigConnection(); var isys_configconnection = new SYS_ConfigConnectionServer(); sys_configconnection.connection = strcn; var sysModunService = new DM_MODULEService(); List <DM_MODULE> sysModun = sysModunService.SelectAllDM_MODULE(); for (int i = 0; i < sysModun.Count; i++) { if (Code.Trim() == sysModun[i].Code.Trim()) { throw new Exception("Mã không được trùng."); } } try { if (isys_configconnection.TestConnectSYS_ConfigConnection(sys_configconnection, "KoMH")) { Session["ConnectString"] = sys_configconnection.connection; } else { throw new Exception("Không kết nối được đến Server này."); } } catch (Exception) { throw new Exception("Không kết nối được đến Server này."); } }
protected void grvPartitionManager_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { string strCn = e.NewValues["ConnectString"] + ""; string code = e.NewValues["Code"] + ""; DM_MODULE sysModun = (DM_MODULE)grvModunManager.GetRow(grvModunManager.EditingRowVisibleIndex); int IDUser = sysModun.IDUSER; int idDV = sysModun.IDMA_DVIQLY; int testInt = 0; if (e.NewValues["USERNAME"] != null) { if (int.TryParse(e.NewValues["USERNAME"] + "", out testInt)) { IDUser = int.Parse(e.NewValues["USERNAME"] + ""); } else { IDUser = returnIDUser(e.NewValues["USERNAME"] + ""); } } if (e.NewValues["NAME_DVIQLY"] != null) { if (int.TryParse(e.NewValues["NAME_DVIQLY"] + "", out testInt)) { idDV = int.Parse(e.NewValues["NAME_DVIQLY"] + ""); } else { idDV = returnIDMaDV(e.NewValues["NAME_DVIQLY"] + ""); } } if (e.OldValues["Code"].ToString() != e.NewValues["Code"].ToString()) { TestConnect(strCn, code); } SYS_ConfigConnectionServer configConnectionServer = new SYS_ConfigConnectionServer(); var sysPartitionService = new DM_MODULEService(); var partition = new DM_MODULE { IDMODULE = (int)e.Keys["IDMODULE"], Name = e.NewValues["Name"] + "", Code = code, IDUSER = IDUser, IDMA_DVIQLY = idDV, ConnectString = configConnectionServer.EncryptSYS_ConfigConnection(strCn) }; sysPartitionService.UpdateDM_MODULE(partition); _DataBind(); e.Cancel = true; grvModunManager.CancelEdit(); //WriteLog("Update " + e.NewValues["Name"] + "", Action.Update); }
protected void grvPartitionManager_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { var sysModunService = new DM_MODULEService(); var Modun = new DM_MODULE { IDMODULE = (int)e.Keys["IDMODULE"] }; sysModunService.DeleteDM_MODULE(Modun); _DataBind(); e.Cancel = true; //WriteLog("Delete " + Modun.Name, Action.Delete); }
private void _DataBind() { List <DM_MODULE> lstModun = new List <DM_MODULE>(); List <DM_MODULE> lst = new List <DM_MODULE>(); var sysModunService = new DM_MODULEService(); SYS_ConfigConnectionServer configConnectionServer = new SYS_ConfigConnectionServer(); lstModun = sysModunService.SelectAllDM_MODULE(); foreach (DM_MODULE sysModun in lstModun) { string temp = ""; temp = configConnectionServer.DecryptSYS_ConfigConnection(sysModun.ConnectString); sysModun.ConnectString = temp; lst.Add(sysModun); } grvModunManager.DataSource = lst; grvModunManager.DataBind(); }