public static void DeleteTcpip(int pId) { if (LTcpip.FetchByID(pId) != null) { LTcpip.Delete(pId); } }
/// <summary> /// Hàm thực hiện lệnh Insert, Update, Delete /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void PerformmAction(UserAction status) { try { var items = new LTcpip(); items.Id = Convert.ToInt32(txtPortID.Text); items.IPAddress = txtAddresIP.Text.Trim(); items.Description = txtDes.Text.Trim(); switch (status) { case UserAction.Insert: HaBusiness.InsertTCPIP(items); break; case UserAction.Update: HaBusiness.UpdateTcpip(items); break; case UserAction.Delete: HaBusiness.DeleteTcpip(items.Id); break; } } catch (Exception ex) { throw ex; } }
public static void UpdateTcpip(LTcpip pitems) { try { if (LTcpip.FetchByID(pitems.Id) != null) { pitems.IsNew = false; pitems.Save(); } } catch (Exception ex) { throw ex; } }
public static bool InValiTCP(LTcpip pitems) { LTcpipCollection collection = new LTcpipController().FetchByQuery(LTcpip.CreateQuery().AddWhere(LTcpip.Columns.Id, Comparison.NotEquals, pitems.Id) .AND(LTcpip.Columns.IPAddress, Comparison.Equals, pitems.IPAddress)); if (collection.Count <= 0) { return(true); } else { return(false); } }
private void buttonX1_Click(object sender, EventArgs e) { LTcpip items; for (int i = 0; i < _dtTcpip.Rows.Count; i++) { DataRow dataRow = _dtTcpip.Rows[i]; if (dataRow.RowState == DataRowState.Modified) { items = new LTcpip(dataRow[LTcpip.Columns.Id]); items.IPAddress = dataRow[LTcpip.Columns.IPAddress].ToString(); items.Description = dataRow[LTcpip.Columns.Description].ToString(); HaBusiness.UpdateTcpip(items); MessageBox.Show("Bạn đã cập nhật thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (dataRow.RowState == DataRowState.Added) { items = new LTcpip(); items.IPAddress = dataRow[LTcpip.Columns.IPAddress].ToString(); items.Description = dataRow[LTcpip.Columns.Description].ToString(); string id = HaBusiness.InsertTCPIP(items); //check địa chỉ Ip nếu đã tồn tại if (id == "-1") { MessageBox.Show("Tên cổng đã" + items.IPAddress.ToString() + "đã tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); dataRow.Delete(); grdTcpip.Focus(); } // ko tồn tại sẽ insert else { dataRow[LTcpip.Columns.Id] = id; MessageBox.Show("Bạn đã Thêm mới thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); //dataRow[LTcpip.Columns.Id] = id; } } } _dtTcpip.AcceptChanges(); }
public static string UpdateTcpip1(LTcpip pitems) { int i = 0; string id = "-1"; Query _QueryRS = LTcpip.CreateQuery(); try { if (LTcpip.FetchByParameter(LTcpip.Columns.Id, Comparison.Equals, pitems.Id).Read()) { pitems.IsNew = false; pitems.Save(); id = _QueryRS.GetMax(LTcpip.Columns.Id).ToString(); } } catch (Exception ex) { id = "-1"; } return(id); }
/// <summary> /// Hàm thực hiện Insert, Delte, Update TCIP /// </summary> /// <param name="pitems"></param> public static string InsertTCPIP(LTcpip pitems) { int i = 0; Query _QueryRS = LTcpip.CreateQuery(); try { if (!LTcpip.FetchByParameter(LTcpip.Columns.IPAddress, Comparison.Equals, pitems.IPAddress).Read()) { pitems.IsNew = true; pitems.Save(i); return(_QueryRS.GetMax(LTcpip.Columns.Id).ToString()); } else { return("-1"); } } catch (Exception ex) { throw ex; } }