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;
}
}
