private void btnImport_Click(object sender, EventArgs e)
{
if (dt.Rows.Count > 0)
{
Waiting.ShowWaitForm();
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
string fail = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
Application.DoEvents();
Waiting.SetWaitFormDescription("Đang lưu ...(" + (i + 1).ToString() + ")");
cls.IpAddress = dt.Rows[i]["IpAddress"].ToString();
cls.MacAddress = dt.Rows[i]["MacAddress"].ToString();
cls.MacAddress_CMTS = dt.Rows[i]["MacAddress_CMTS"].ToString();
cls.CustomerCode = dt.Rows[i]["CustomerCode"].ToString();
cls.CustomerName = dt.Rows[i]["CustomerName"].ToString();
cls.CustomerAddress = dt.Rows[i]["CustomerAddress"].ToString();
cls.PoolIp = dt.Rows[i]["PoolIp"].ToString();
cls.Bootfile = dt.Rows[i]["Bootfile"].ToString();
cls.IpPublic = dt.Rows[i]["IpPublic"].ToString();
cls.MacPc = dt.Rows[i]["MacPc"].ToString();
cls.PoolPublic = dt.Rows[i]["PoolPublic"].ToString();
cls.Location = dt.Rows[i]["Location"].ToString();
cls.Note = dt.Rows[i]["Note"].ToString();
//if (cls.IpAddress == "192.168.11.63")
//{
// string degug = "";
//}
if (!cls.InsertMySQL()) // thay the import vao dl binh thuong thi impoort vao Mysql server co DHCP SV
{
fail += "\r\n" + dt.Rows[i]["IpAddress"].ToString();
}
}
Waiting.CloseWaitForm();
//MessageBox.Show("Hoàn thành Insert !");
//MessageBox.Show(fail);
}
}
private void btnImport_Click(object sender, EventArgs e)
{
if (dt.Rows.Count > 0)
{
Waiting.ShowWaitForm();
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
string fail = "";
for(int i=0;i<dt.Rows.Count;i++)
{
Application.DoEvents();
Waiting.SetWaitFormDescription("Đang lưu ...("+(i+1).ToString()+")");
cls.IpAddress = dt.Rows[i]["IpAddress"].ToString();
cls.MacAddress = dt.Rows[i]["MacAddress"].ToString();
cls.MacAddress_CMTS = dt.Rows[i]["MacAddress_CMTS"].ToString();
cls.CustomerCode = dt.Rows[i]["CustomerCode"].ToString();
cls.CustomerName = dt.Rows[i]["CustomerName"].ToString();
cls.CustomerAddress = dt.Rows[i]["CustomerAddress"].ToString();
cls.PoolIp = dt.Rows[i]["PoolIp"].ToString();
cls.Bootfile = dt.Rows[i]["Bootfile"].ToString();
cls.IpPublic = dt.Rows[i]["IpPublic"].ToString();
cls.MacPc = dt.Rows[i]["MacPc"].ToString();
cls.PoolPublic = dt.Rows[i]["PoolPublic"].ToString();
cls.Location = dt.Rows[i]["Location"].ToString();
cls.Note = dt.Rows[i]["Note"].ToString();
//if (cls.IpAddress == "192.168.11.63")
//{
// string degug = "";
//}
if (!cls.InsertMySQL()) // thay the import vao dl binh thuong thi impoort vao Mysql server co DHCP SV
{
fail += "\r\n" + dt.Rows[i]["IpAddress"].ToString();
}
}
Waiting.CloseWaitForm();
//MessageBox.Show("Hoàn thành Insert !");
//MessageBox.Show(fail);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (cboPoolIp.EditValue == null)
{
Class.App.InputNotAccess();
return;
}
if (txtMacAddress.Text.Length < 1)
{
Class.App.InputNotAccess();
return;
}
if (txtIpAddress.Text.Length < 5)
{
MessageBox.Show("Địa chỉ IP Address chưa đúng định dạng, Vui lòng nhập lại.!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtMacAddress.Text.Length != 17)
{
MessageBox.Show("Địa chỉ Mac Address chưa đúng định dạng, Vui lòng nhập lại.!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.MacAddress = txtMacAddress.Text;
string mac = txtMacAddress.Text;
mac = mac.Replace(":", "");
mac = mac.Insert(4, ".");
mac = mac.Insert(9, ".");
cls.MacAddress_CMTS = mac;
cls.IpAddress = txtIpAddress.Text;
cls.PoolIp = cboPoolIp.EditValue.ToString();
cls.CustomerCode = txtCustomerCode.Text;
cls.CustomerName = txtCustomerName.Text;
cls.CustomerAddress = txtCustomerAddress.Text;
cls.Bootfile = cboBootfile.EditValue.ToString();
cls.Location = txtLocation.Text;
cls.Note = txtNote.Text;
cls.IpPublic = "";
cls.PoolPublic = "";
cls.MacPc = "";
if (txtIpAddress.Enabled)
{
if (cls.InsertMySQL())
{
Class.App.SaveSuccessfully();
add_edit = true;
}
else
{
Class.App.SaveNotSuccessfully();
}
}
else
{
if (cls.UpdateMySQL())
{
Class.App.SaveSuccessfully();
add_edit = true;
}
else
{
Class.App.SaveNotSuccessfully();
}
}
this.Close();
}
private void btnUpdateNew_Click(object sender, EventArgs e)
{
if (cboPoolIp.EditValue == null)
{
Class.App.InputNotAccess();
return;
}
if (txtMacAddress.Text.Length < 1)
{
Class.App.InputNotAccess();
return;
}
if (txtIpAddress.Text.Length < 5)
{
MessageBox.Show("Địa chỉ IP Address chưa đúng định dạng, Vui lòng nhập lại.!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtMacAddress.Text.Length != 17)
{
MessageBox.Show("Địa chỉ Mac Address chưa đúng định dạng, Vui lòng nhập lại.!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.MacAddress = txtMacAddress.Text;
string mac = txtMacAddress.Text;
mac = mac.Replace(":", "");
mac = mac.Insert(4, ".");
mac = mac.Insert(9, ".");
cls.MacAddress_CMTS = mac;
cls.IpAddress = txtIpAddress.Text;
cls.PoolIp = cboPoolIp.EditValue.ToString();
cls.CustomerCode = txtCustomerCode.Text;
cls.CustomerName = txtCustomerName.Text;
cls.CustomerAddress = txtCustomerAddress.Text;
cls.Bootfile = cboBootfile.EditValue.ToString();
cls.Location = txtLocation.Text;
cls.Note = txtNote.Text;
cls.IpPublic = "";
cls.PoolPublic = "";
cls.MacPc = "";
if (txtIpAddress.Enabled)
{
if (cls.InsertMySQL())
{
Class.App.SaveSuccessfully();
add_edit = true;
}
else
{
Class.App.SaveNotSuccessfully();
}
}
else
{
if (cls.UpdateMySQL())
{
Class.App.SaveSuccessfully();
add_edit = true;
}
else
{
Class.App.SaveNotSuccessfully();
}
}
txtIpAddress.Enabled = true;
cboPoolIp.Enabled = true;
call_Code_New();
//NW_Dhcp_Ip_GetbyPoolModem();
NW_Dhcp_Ip_GetbyPoolModem_MySQL();
}