private void btnAddIP_Click(object sender, EventArgs e)
{
if (cboPoolIp.EditValue == null)
{
Class.App.InputNotAccess();
return;
}
if (txtIpAddress.Text == "")
{
Class.App.InputNotAccess();
return;
}
if (txtMacAddress.Text == "")
{
Class.App.InputNotAccess();
return;
}
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.IpAddress = ipaddress;
cls.PoolPublic = cboPoolIp.EditValue.ToString();
cls.IpPublic = txtIpAddress.Text;
cls.MacPc = txtMacAddress.Text;
cls.Note = txtNote.Text;
if (cls.NW_Dhcp_Customer_UpdateIPStatic_MySQL())
{
Class.App.SaveSuccessfully();
add_edit = true;
}
else
{
Class.App.SaveNotSuccessfully();
}
this.Close();
}
private void btnAddIP_Click(object sender, EventArgs e)
{
if (cboPoolIp.EditValue == null)
{
Class.App.InputNotAccess();
return;
}
if (txtIpAddress.Text == "")
{
Class.App.InputNotAccess();
return;
}
if (txtMacAddress.Text == "")
{
Class.App.InputNotAccess();
return;
}
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.IpAddress = ipaddress;
cls.PoolPublic = cboPoolIp.EditValue.ToString();
cls.IpPublic = txtIpAddress.Text;
cls.MacPc = txtMacAddress.Text;
cls.Note = txtNote.Text;
if (cls.NW_Dhcp_Customer_UpdateIPStatic_MySQL())
{
Class.App.SaveSuccessfully();
add_edit = true;
}
else
{
Class.App.SaveNotSuccessfully();
}
this.Close();
}
private void cboPoolIp_EditValueChanged(object sender, EventArgs e)
{
Class.NW_Dhcp_Ip cls = new Class.NW_Dhcp_Ip();
Class.NW_Dhcp_Customer clscus = new Class.NW_Dhcp_Customer();
clscus.PoolIp = cboPoolIp.EditValue.ToString();
DataTable dtcus = clscus.NW_Dhcp_Customer_GetbyPool_MySQL();
cls.PoolIp = cboPoolIp.EditValue.ToString();
DataTable dt = cls.NW_Dhcp_Ip_GetIPbyPool_MySQL();
string ip = "";
bool check = false;;
if (dt.Rows.Count > 0)
{
string range = dt.Rows[0]["RangeIP"].ToString();
string[] cat = range.Split(' ');
if (cat.Length > 1)
{
txtIpAddress.Properties.Items.Clear();
string[] temp = cat[0].Split('.');
int start = 0;
int end = 0;
if (temp.Length > 2)
{
start = int.Parse(temp[3]);
}
temp = cat[1].Split('.');
if (temp.Length > 2)
{
end = int.Parse(temp[3]);
}
for (int i = start; i < end; i++)
{
ip = temp[0] + "." + temp[1] + "." + temp[2] + "." + i.ToString();
check = false;
for (int j = 0; j < dtcus.Rows.Count; j++)
{
if (ip == dtcus.Rows[j]["IpAddress"].ToString())
{
check = true;
}
}
if (check == false)
{
txtIpAddress.Properties.Items.Add(ip);
}
}
}
}
if (txtIpAddress.Properties.Items.Count > 0)
{
txtIpAddress.Text = txtIpAddress.Properties.Items[0].ToString();
}
else
{
txtIpAddress.Text = "";
}
}
private void cboPoolIp_EditValueChanged(object sender, EventArgs e)
{
Class.NW_Dhcp_Ip cls = new Class.NW_Dhcp_Ip();
Class.NW_Dhcp_Customer clscus = new Class.NW_Dhcp_Customer();
clscus.PoolIp = cboPoolIp.EditValue.ToString();
DataTable dtcus = clscus.NW_Dhcp_Customer_GetbyPoolPublic_MySQL();
cls.PoolIp = cboPoolIp.EditValue.ToString();
DataTable dt = cls.NW_Dhcp_Ip_GetIPbyPool_MySQL();
string ip = "";
bool check = false; ;
if (dt.Rows.Count > 0)
{
string range = dt.Rows[0]["RangeIP"].ToString();
string[] cat = range.Split(' ');
if (cat.Length > 1)
{
txtIpAddress.Properties.Items.Clear();
string[] temp = cat[0].Split('.');
int start = 0;
int end = 0;
if (temp.Length > 2)
{
start = int.Parse(temp[3]);
}
temp = cat[1].Split('.');
if (temp.Length > 2)
{
end = int.Parse(temp[3]);
}
for (int i = start; i < end; i++)
{
ip = temp[0] + "." + temp[1] + "." + temp[2] + "." + i.ToString();
check = false;
for (int j = 0; j < dtcus.Rows.Count; j++)
{
if (ip == dtcus.Rows[j]["IpPublic"].ToString())
{
check = true;
}
}
if (check == false)
{
txtIpAddress.Properties.Items.Add(ip);
}
}
}
}
if (txtIpAddress.Properties.Items.Count > 0)
{
txtIpAddress.Text = txtIpAddress.Properties.Items[0].ToString();
}
else
{
txtIpAddress.Text = "";
}
}
private void btnDeleteAll_Click(object sender, EventArgs e)
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
if (cls.NW_Dhcp_Customer_DeleteAll_MySQL())
{
MessageBox.Show("Đã xóa xong! ");
}
}
public void NW_Dhcp_Customer_Getlist()
{
// Waiting.ShowWaitForm();
// Waiting.SetWaitFormDescription("Đang tải thông tin khách hàng");
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
dt = cls.NW_Dhcp_Customer_Getlist();
dtIpPublic = cls.NW_Dhcp_Customer_Getlist();
gridItem.DataSource = dt;
// Waiting.CloseWaitForm();
}
public void NW_Dhcp_Customer_Getlist()
{
// Waiting.ShowWaitForm();
// Waiting.SetWaitFormDescription("Đang tải thông tin khách hàng");
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
dt = cls.NW_Dhcp_Customer_Getlist();
dtIpPublic = cls.NW_Dhcp_Customer_Getlist();
gridItem.DataSource = dt;
// Waiting.CloseWaitForm();
}
private void btnDelIP_Click(object sender, EventArgs e)
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.IpAddress = gridItemDetail.GetFocusedRowCellValue(colIpAddress).ToString();
if (cls.NW_Dhcp_Customer_DeleteIPStatic_MySQL())
{
MessageBox.Show("Xóa IP Static thành công !");
NW_Dhcp_Customer_Getlist_MySQL();
}
else
{
MessageBox.Show("Xóa IP Static thất bại !");
}
}
private void call_info(string Form_name, string code)
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.IpAddress = code;
DataTable dt = cls.NW_Dhcp_Customer_GetbyIp_MySQL();
txtMacAddress.Text = dt.Rows[0]["MacAddress"].ToString();
cboPoolIp.EditValue = dt.Rows[0]["PoolIp"].ToString();
txtIpAddress.Text = dt.Rows[0]["IpAddress"].ToString();
txtCustomerCode.Text = dt.Rows[0]["CustomerCode"].ToString();
txtCustomerAddress.Text = dt.Rows[0]["CustomerAddress"].ToString();
txtCustomerName.Text = dt.Rows[0]["CustomerName"].ToString();
cboBootfile.Text = dt.Rows[0]["Bootfile"].ToString();
txtLocation.Text = dt.Rows[0]["Location"].ToString();
txtNote.Text = dt.Rows[0]["Note"].ToString();
txtIpAddress.Enabled = false;
cboPoolIp.Enabled = false;
}
private void txtMacAddress_Validated(object sender, EventArgs e)
{
txtMacAddress.Text = txtMacAddress.Text.Replace("-", ":").ToLower();
string input = txtMacAddress.Text;
// input = input.Replace(" ", "").Replace(":", "").Replace("-", "");
Regex r = new Regex("^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})$");
if (!r.IsMatch(input))
{
MessageBox.Show(" Mac Address không hợp lệ ! ");
txtMacAddress.Focus();
}
if (txtIpAddress.Enabled)
{
Class.NW_Dhcp_Customer clscus = new Class.NW_Dhcp_Customer();
clscus.MacAddress = txtMacAddress.Text;
DataTable dt = clscus.NW_Dhcp_Customer_GetbyMacaddress_MySQL();
if (dt.Rows.Count > 0)
{
MessageBox.Show(" Mac Address đã có, vui lòng chọn mac khác ! ");
txtMacAddress.Focus();
}
}
else
{
// truong hop sua nhung co roi cung ko dc update
Class.NW_Dhcp_Customer clscus = new Class.NW_Dhcp_Customer();
clscus.MacAddress = txtMacAddress.Text;
clscus.IpAddress = txtIpAddress.Text;
DataTable dt = clscus.NW_Dhcp_Customer_GetbyMacaddress_MySQL();
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["IpAddress"].ToString() != clscus.IpAddress)
{
MessageBox.Show(" Mac Address đã có, vui lòng chọn mac khác ! ");
txtMacAddress.Focus();
}
}
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (Class.App.ConfirmDeletion() == DialogResult.No)
{
return;
}
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
string IP = "";
IP = gridItemDetail.GetFocusedRowCellValue(colIpAddress).ToString();
cls.IpAddress = IP;
if (cls.NW_Dhcp_Customer_Delete_MySQL())
{
Class.App.DeleteSuccessfully(IP);
NW_Dhcp_Customer_Getlist_MySQL();
}
else
{
Class.App.DeleteNotSuccessfully();
}
}
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 btnCreateDHCPFile_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count > 0)
{
if (System.IO.File.Exists(@"dhcpd.conf.temp"))
{
string txt = System.IO.File.ReadAllText(@"dhcpd.conf.temp");
string CPEDynamic = "";
string CPEStatic = "";
string PoolModem = "";
Class.NW_Dhcp_Ip clsIP = new Class.NW_Dhcp_Ip();
Class.NW_Dhcp_Customer clsModem = new Class.NW_Dhcp_Customer();
DataTable dtCPEDynamic = clsIP.NW_Dhcp_Ip_GetbyCPEDynamic_MySQL();
DataTable dtCPEStatic = clsIP.NW_Dhcp_Ip_GetbyCPEStatic_MySQL();
DataTable dtPoolModem = clsIP.NW_Dhcp_Ip_GetbyPoolModem_MySQL();
#region CPEDynamic
for (int i = 0; i < dtCPEDynamic.Rows.Count; i++)
{
CPEDynamic += "\tsubnet " + dtCPEDynamic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEDynamic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEDynamic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEDynamic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t\tpool {\n" +
"\t\trange " + dtCPEDynamic.Rows[i]["RangeIP"].ToString() + ";\n" +
"\t\t}\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
"\t}\n";
}
#endregion
#region CPEStatic
for (int i = 0; i < dtCPEStatic.Rows.Count; i++)
{
clsModem.PoolIp = dtCPEStatic.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPoolPublic_MySQL();
string txtmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string ipcpe = dtmodem.Rows[j]["IpPublic"].ToString();
ipcpe = ipcpe.Replace(":", "-");
string reIPcpe = dtmodem.Rows[j]["MacPc"].ToString().Replace(":", "");
txtmodem += "\t\t# PC an Modem " + dtmodem.Rows[j]["IpAddress"].ToString() + " " + dtmodem.Rows[j]["Note"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + ipcpe + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacPc"].ToString() + " ;\n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpPublic"].ToString() + ";\n" +
"\t\t\toption host-name \"mt"+ reIPcpe + "\";\n" +
"\t\t\tddns-hostname \"mt"+ reIPcpe + "\";\n" +
"\t\t}\n";
}
CPEStatic += "\tsubnet " + dtCPEStatic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEStatic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEStatic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEStatic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
txtmodem +
"\t}\n";
}
#endregion
#region CableMode
for (int i = 0; i < dtPoolModem.Rows.Count; i++)
{
clsModem.PoolIp = dtPoolModem.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPool_MySQL();
string listmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string cm = dtmodem.Rows[j]["MacAddress"].ToString();
cm = cm.Replace(":", "");
listmodem += "\t\t# " + dtmodem.Rows[j]["IpAddress"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + cm + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacAddress"].ToString() + " ; \n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpAddress"].ToString() + ";\n" +
"\t\t\toption host-name \"cm" + cm + "\";\n" +
"\t\t\tddns-hostname \"cm" + cm + "\";\n" +
"\t\t\toption bootfile-name \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t\tfilename \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t}\n";
}
PoolModem += "\tsubnet " + dtPoolModem.Rows[i]["PoolIp"].ToString() + " netmask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption routers " + dtPoolModem.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtPoolModem.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
listmodem +
"\t}\n";
}
#endregion
txt = txt.Replace("<_CPEDynamic>", CPEDynamic);
txt = txt.Replace("<_CPEStatic>", CPEStatic);
txt = txt.Replace("<_modemip>", PoolModem);
System.IO.File.WriteAllText(@"dhcpd.conf", txt);
}
else
{
MessageBox.Show("file dhcpd.conf.temp not found!");
}
}
MessageBox.Show("Hoàn thành tạo file !");
}
catch {
MessageBox.Show("Lỗi tạo file..");
}
if (System.IO.File.Exists("dhcpd.conf"))
{
frmDHCPService_Template frm = new frmDHCPService_Template("dhcpd.conf");
frm.ShowDialog();
}
}
private void btnCreateDHCPFile_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count > 0)
{
if (System.IO.File.Exists(@"dhcpd.conf.temp"))
{
string txt = System.IO.File.ReadAllText(@"dhcpd.conf.temp");
string CPEDynamic = "";
string CPEStatic = "";
string PoolModem = "";
Class.NW_Dhcp_Ip clsIP = new Class.NW_Dhcp_Ip();
Class.NW_Dhcp_Customer clsModem = new Class.NW_Dhcp_Customer();
DataTable dtCPEDynamic = clsIP.NW_Dhcp_Ip_GetbyCPEDynamic_MySQL();
DataTable dtCPEStatic = clsIP.NW_Dhcp_Ip_GetbyCPEStatic_MySQL();
DataTable dtPoolModem = clsIP.NW_Dhcp_Ip_GetbyPoolModem_MySQL();
#region CPEDynamic
for (int i = 0; i < dtCPEDynamic.Rows.Count; i++)
{
CPEDynamic += "\tsubnet " + dtCPEDynamic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEDynamic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEDynamic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEDynamic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t\tpool {\n" +
"\t\trange " + dtCPEDynamic.Rows[i]["RangeIP"].ToString() + ";\n" +
"\t\t}\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
"\t}\n";
}
#endregion
#region CPEStatic
for (int i = 0; i < dtCPEStatic.Rows.Count; i++)
{
clsModem.PoolIp = dtCPEStatic.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPoolPublic_MySQL();
string txtmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string ipcpe = dtmodem.Rows[j]["IpPublic"].ToString();
ipcpe = ipcpe.Replace(":", "-");
string reIPcpe = dtmodem.Rows[j]["MacPc"].ToString().Replace(":", "");
txtmodem += "\t\t# PC an Modem " + dtmodem.Rows[j]["IpAddress"].ToString() + " " + dtmodem.Rows[j]["Note"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + ipcpe + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacPc"].ToString() + " ;\n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpPublic"].ToString() + ";\n" +
"\t\t\toption host-name \"mt" + reIPcpe + "\";\n" +
"\t\t\tddns-hostname \"mt" + reIPcpe + "\";\n" +
"\t\t}\n";
}
CPEStatic += "\tsubnet " + dtCPEStatic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEStatic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEStatic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEStatic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
txtmodem +
"\t}\n";
}
#endregion
#region CableMode
for (int i = 0; i < dtPoolModem.Rows.Count; i++)
{
clsModem.PoolIp = dtPoolModem.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPool_MySQL();
string listmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string cm = dtmodem.Rows[j]["MacAddress"].ToString();
cm = cm.Replace(":", "");
listmodem += "\t\t# " + dtmodem.Rows[j]["IpAddress"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + cm + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacAddress"].ToString() + " ; \n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpAddress"].ToString() + ";\n" +
"\t\t\toption host-name \"cm" + cm + "\";\n" +
"\t\t\tddns-hostname \"cm" + cm + "\";\n" +
"\t\t\toption bootfile-name \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t\tfilename \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t}\n";
}
PoolModem += "\tsubnet " + dtPoolModem.Rows[i]["PoolIp"].ToString() + " netmask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption routers " + dtPoolModem.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtPoolModem.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
listmodem +
"\t}\n";
}
#endregion
txt = txt.Replace("<_CPEDynamic>", CPEDynamic);
txt = txt.Replace("<_CPEStatic>", CPEStatic);
txt = txt.Replace("<_modemip>", PoolModem);
System.IO.File.WriteAllText(@"dhcpd.conf", txt);
}
else
{
MessageBox.Show("file dhcpd.conf.temp not found!");
}
}
MessageBox.Show("Hoàn thành tạo file !");
}
catch {
MessageBox.Show("Lỗi tạo file..");
}
if (System.IO.File.Exists("dhcpd.conf"))
{
frmDHCPService_Template frm = new frmDHCPService_Template("dhcpd.conf");
frm.ShowDialog();
}
}
private void call_info(string Form_name, string code)
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.IpAddress = code;
DataTable dt = cls.NW_Dhcp_Customer_GetbyIp_MySQL();
txtMacAddress.Text = dt.Rows[0]["MacAddress"].ToString();
cboPoolIp.EditValue = dt.Rows[0]["PoolIp"].ToString();
txtIpAddress.Text = dt.Rows[0]["IpAddress"].ToString();
txtCustomerCode.Text = dt.Rows[0]["CustomerCode"].ToString();
txtCustomerAddress.Text = dt.Rows[0]["CustomerAddress"].ToString();
txtCustomerName.Text = dt.Rows[0]["CustomerName"].ToString();
cboBootfile.Text = dt.Rows[0]["Bootfile"].ToString();
txtLocation.Text = dt.Rows[0]["Location"].ToString();
txtNote.Text = dt.Rows[0]["Note"].ToString();
txtIpAddress.Enabled = false;
cboPoolIp.Enabled = false;
}
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 btnDel_Click(object sender, EventArgs e)
{
if (Class.App.ConfirmDeletion() == DialogResult.No)
return;
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
string IP = "";
IP = gridItemDetail.GetFocusedRowCellValue(colIpAddress).ToString();
cls.IpAddress = IP;
if (cls.NW_Dhcp_Customer_Delete_MySQL())
{
Class.App.DeleteSuccessfully(IP);
NW_Dhcp_Customer_Getlist_MySQL();
}
else
{
Class.App.DeleteNotSuccessfully();
}
}
private void btnDelIP_Click(object sender, EventArgs e)
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
cls.IpAddress = gridItemDetail.GetFocusedRowCellValue(colIpAddress).ToString();
if (cls.NW_Dhcp_Customer_DeleteIPStatic_MySQL())
{
MessageBox.Show("Xóa IP Static thành công !");
NW_Dhcp_Customer_Getlist_MySQL();
}
else
{
MessageBox.Show("Xóa IP Static thất bại !");
}
}
private void btnDeleteAll_Click(object sender, EventArgs e)
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
if (cls.NW_Dhcp_Customer_DeleteAll_MySQL())
MessageBox.Show("Đã xóa xong! ");
}
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 txtMacAddress_Validated(object sender, EventArgs e)
{
txtMacAddress.Text = txtMacAddress.Text.Replace("-", ":").ToLower();
string input = txtMacAddress.Text;
// input = input.Replace(" ", "").Replace(":", "").Replace("-", "");
Regex r = new Regex("^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})$");
if (!r.IsMatch(input))
{
MessageBox.Show(" Mac Address không hợp lệ ! ");
txtMacAddress.Focus();
}
if (txtIpAddress.Enabled)
{
Class.NW_Dhcp_Customer clscus = new Class.NW_Dhcp_Customer();
clscus.MacAddress = txtMacAddress.Text;
DataTable dt = clscus.NW_Dhcp_Customer_GetbyMacaddress_MySQL();
if (dt.Rows.Count > 0)
{
MessageBox.Show(" Mac Address đã có, vui lòng chọn mac khác ! ");
txtMacAddress.Focus();
}
}
else
{
// truong hop sua nhung co roi cung ko dc update
Class.NW_Dhcp_Customer clscus = new Class.NW_Dhcp_Customer();
clscus.MacAddress = txtMacAddress.Text;
clscus.IpAddress=txtIpAddress.Text;
DataTable dt = clscus.NW_Dhcp_Customer_GetbyMacaddress_MySQL();
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["IpAddress"].ToString() != clscus.IpAddress)
{
MessageBox.Show(" Mac Address đã có, vui lòng chọn mac khác ! ");
txtMacAddress.Focus();
}
}
}
}
public void Start()
{
try
{
IPHostEntry ipHost = Dns.GetHostEntry(Dns.GetHostName());
// IPAddress ipAddr = ipHost.AddressList[3];
//string ip = "";
//for (int i = 1; i < ipHost.AddressList.Length; i++)
//{
// ip = ipHost.AddressList[i].ToString();
server.Prefixes.Add("http://" + "101.99.28.148" + ":1111/");
//}
// server.Start();
try
{
server.Start(); //Throws Exception
}
catch (HttpListenerException ex)
{
if (ex.Message.Contains("Access is denied"))
{
return;
}
else
{
throw;
}
}
Console.WriteLine("Listening...");
while (true)
{
HttpListenerContext context = server.GetContext();
HttpListenerResponse response = context.Response;
string page = context.Request.Url.ToString();
//page = context.Request.Url.LocalPath; ;
// if (page == string.Empty)
if (page.Contains("dhcprestart.html"))
{
string msg = "";
// tao file conf
#region Tao file config
try
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
DataTable dt = cls.NW_Dhcp_Customer_Getlist();
if (dt.Rows.Count > 0)
{
if (System.IO.File.Exists(@"dhcpd.conf.temp"))
{
string txt = System.IO.File.ReadAllText(@"dhcpd.conf.temp");
string CPEDynamic = "";
string CPEStatic = "";
string PoolModem = "";
Class.NW_Dhcp_Ip clsIP = new Class.NW_Dhcp_Ip();
Class.NW_Dhcp_Customer clsModem = new Class.NW_Dhcp_Customer();
DataTable dtCPEDynamic = clsIP.NW_Dhcp_Ip_GetbyCPEDynamic();
DataTable dtCPEStatic = clsIP.NW_Dhcp_Ip_GetbyCPEStatic();
DataTable dtPoolModem = clsIP.NW_Dhcp_Ip_GetbyPoolModem();
#region CPEDynamic
for (int i = 0; i < dtCPEDynamic.Rows.Count; i++)
{
CPEDynamic += "\tsubnet " + dtCPEDynamic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEDynamic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEDynamic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEDynamic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t\tpool {\n" +
"\t\trange " + dtCPEDynamic.Rows[i]["Range"].ToString() + ";\n" +
"\t\t}\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
"\t}\n";
}
#endregion
#region CPEStatic
for (int i = 0; i < dtCPEStatic.Rows.Count; i++)
{
clsModem.PoolIp = dtCPEStatic.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPoolPublic();
string txtmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string ipcpe = dtmodem.Rows[j]["IpPublic"].ToString();
ipcpe = ipcpe.Replace(":", "-");
string reIPcpe = dtmodem.Rows[j]["MacPc"].ToString().Replace(":", "");
txtmodem += "\t\t# PC an Modem " + dtmodem.Rows[j]["IpAddress"].ToString() + " " + dtmodem.Rows[j]["Note"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + ipcpe + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacPc"].ToString() + " ;\n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpPublic"].ToString() + ";\n" +
"\t\t\toption host-name \"mt" + reIPcpe + "\";\n" +
"\t\t\tddns-hostname \"mt" + reIPcpe + "\";\n" +
"\t\t}\n";
}
CPEStatic += "\tsubnet " + dtCPEStatic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEStatic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEStatic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEStatic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
txtmodem +
"\t}\n";
}
#endregion
#region CableMode
for (int i = 0; i < dtPoolModem.Rows.Count; i++)
{
clsModem.PoolIp = dtPoolModem.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPool();
string listmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string cm = dtmodem.Rows[j]["MacAddress"].ToString();
cm = cm.Replace(":", "");
listmodem += "\t\t# " + dtmodem.Rows[j]["IpAddress"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + cm + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacAddress"].ToString() + " ; \n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpAddress"].ToString() + ";\n" +
"\t\t\toption host-name \"cm" + cm + "\";\n" +
"\t\t\tddns-hostname \"cm" + cm + "\";\n" +
"\t\t\toption bootfile-name \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t\tfilename \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t}\n";
}
PoolModem += "\tsubnet " + dtPoolModem.Rows[i]["PoolIp"].ToString() + " netmask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption routers " + dtPoolModem.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtPoolModem.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
listmodem +
"\t}\n";
}
#endregion
txt = txt.Replace("<_CPEDynamic>", CPEDynamic);
txt = txt.Replace("<_CPEStatic>", CPEStatic);
txt = txt.Replace("<_modemip>", PoolModem);
System.IO.File.WriteAllText(@"dhcpd.conf", txt);
}
else
{
msg="file dhcpd.conf.temp not found!";
}
}
msg = "Create file success!";
}
catch
{
msg = "Fail create to file..";
}
#endregion
#region UploadtoServer
if (msg == "Create file success!")
{
msg += "\r\nTranfer file to SERVER ";
Class.App.uploadFile("ftp://101.99.28.152/test/", Application.StartupPath + "/dhcpd.conf", "administrator", "831031");
try
{
msg += "Ok";
}
catch {
msg += "Fail";
}
}
#endregion
//write respones
byte[] buffer = Encoding.UTF8.GetBytes(msg);
response.ContentLength64 = buffer.Length;
Stream st = response.OutputStream;
st.Write(buffer, 0, buffer.Length);
st.Close();
}
else
{
string msg = "Access Deny !";
byte[] buffer = Encoding.UTF8.GetBytes(msg);
response.ContentLength64 = buffer.Length;
Stream st = response.OutputStream;
st.Write(buffer, 0, buffer.Length);
st.Close();
}
context.Response.Close();
}
}
catch {
Stop();
Start();
}
}
public void Start()
{
try
{
IPHostEntry ipHost = Dns.GetHostEntry(Dns.GetHostName());
// IPAddress ipAddr = ipHost.AddressList[3];
//string ip = "";
//for (int i = 1; i < ipHost.AddressList.Length; i++)
//{
// ip = ipHost.AddressList[i].ToString();
server.Prefixes.Add("http://" + "101.99.28.148" + ":1111/");
//}
// server.Start();
try
{
server.Start(); //Throws Exception
}
catch (HttpListenerException ex)
{
if (ex.Message.Contains("Access is denied"))
{
return;
}
else
{
throw;
}
}
Console.WriteLine("Listening...");
while (true)
{
HttpListenerContext context = server.GetContext();
HttpListenerResponse response = context.Response;
string page = context.Request.Url.ToString();
//page = context.Request.Url.LocalPath; ;
// if (page == string.Empty)
if (page.Contains("dhcprestart.html"))
{
string msg = "";
// tao file conf
#region Tao file config
try
{
Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer();
DataTable dt = cls.NW_Dhcp_Customer_Getlist();
if (dt.Rows.Count > 0)
{
if (System.IO.File.Exists(@"dhcpd.conf.temp"))
{
string txt = System.IO.File.ReadAllText(@"dhcpd.conf.temp");
string CPEDynamic = "";
string CPEStatic = "";
string PoolModem = "";
Class.NW_Dhcp_Ip clsIP = new Class.NW_Dhcp_Ip();
Class.NW_Dhcp_Customer clsModem = new Class.NW_Dhcp_Customer();
DataTable dtCPEDynamic = clsIP.NW_Dhcp_Ip_GetbyCPEDynamic();
DataTable dtCPEStatic = clsIP.NW_Dhcp_Ip_GetbyCPEStatic();
DataTable dtPoolModem = clsIP.NW_Dhcp_Ip_GetbyPoolModem();
#region CPEDynamic
for (int i = 0; i < dtCPEDynamic.Rows.Count; i++)
{
CPEDynamic += "\tsubnet " + dtCPEDynamic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEDynamic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEDynamic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEDynamic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEDynamic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t\tpool {\n" +
"\t\trange " + dtCPEDynamic.Rows[i]["Range"].ToString() + ";\n" +
"\t\t}\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
"\t}\n";
}
#endregion
#region CPEStatic
for (int i = 0; i < dtCPEStatic.Rows.Count; i++)
{
clsModem.PoolIp = dtCPEStatic.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPoolPublic();
string txtmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string ipcpe = dtmodem.Rows[j]["IpPublic"].ToString();
ipcpe = ipcpe.Replace(":", "-");
string reIPcpe = dtmodem.Rows[j]["MacPc"].ToString().Replace(":", "");
txtmodem += "\t\t# PC an Modem " + dtmodem.Rows[j]["IpAddress"].ToString() + " " + dtmodem.Rows[j]["Note"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + ipcpe + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacPc"].ToString() + " ;\n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpPublic"].ToString() + ";\n" +
"\t\t\toption host-name \"mt"+ reIPcpe + "\";\n" +
"\t\t\tddns-hostname \"mt"+ reIPcpe + "\";\n" +
"\t\t}\n";
}
CPEStatic += "\tsubnet " + dtCPEStatic.Rows[i]["PoolIp"].ToString() + " netmask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtCPEStatic.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption domain-name-servers " + dtCPEStatic.Rows[i]["Dns"].ToString() + ";\n" +
"\t\toption routers " + dtCPEStatic.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtCPEStatic.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
txtmodem +
"\t}\n";
}
#endregion
#region CableMode
for (int i = 0; i < dtPoolModem.Rows.Count; i++)
{
clsModem.PoolIp = dtPoolModem.Rows[i]["PoolIp"].ToString();
DataTable dtmodem = clsModem.NW_Dhcp_Customer_GetbyPool();
string listmodem = "";
for (int j = 0; j < dtmodem.Rows.Count; j++)
{
string cm = dtmodem.Rows[j]["MacAddress"].ToString();
cm = cm.Replace(":", "");
listmodem += "\t\t# " + dtmodem.Rows[j]["IpAddress"].ToString() + " Kunde " + dtmodem.Rows[j]["CustomerCode"].ToString() + " " + dtmodem.Rows[j]["CustomerName"].ToString() + "\n" +
"\t\thost " + cm + " {\n" +
"\t\t\thardware ethernet " + dtmodem.Rows[j]["MacAddress"].ToString() + " ; \n" +
"\t\t\tfixed-address " + dtmodem.Rows[j]["IpAddress"].ToString() + ";\n" +
"\t\t\toption host-name \"cm" + cm + "\";\n" +
"\t\t\tddns-hostname \"cm" + cm + "\";\n" +
"\t\t\toption bootfile-name \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t\tfilename \"" + dtmodem.Rows[j]["Bootfile"].ToString() + "\";\n" +
"\t\t}\n";
}
PoolModem += "\tsubnet " + dtPoolModem.Rows[i]["PoolIp"].ToString() + " netmask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + " {\n" +
"\t\tauthoritative;\n" +
"\t\toption subnet-mask " + dtPoolModem.Rows[i]["SubnetMask"].ToString() + ";\n" +
"\t\toption routers " + dtPoolModem.Rows[i]["Router"].ToString() + ";\n" +
"\t\toption broadcast-address " + dtPoolModem.Rows[i]["Broadcast"].ToString() + ";\n" +
"\t}\n" +
"\tgroup {\n" +
"\t\tuse-host-decl-names on;\n" +
listmodem +
"\t}\n";
}
#endregion
txt = txt.Replace("<_CPEDynamic>", CPEDynamic);
txt = txt.Replace("<_CPEStatic>", CPEStatic);
txt = txt.Replace("<_modemip>", PoolModem);
System.IO.File.WriteAllText(@"dhcpd.conf", txt);
}
else
{
msg = "file dhcpd.conf.temp not found!";
}
}
msg = "Create file success!";
}
catch
{
msg = "Fail create to file..";
}
#endregion
#region UploadtoServer
if (msg == "Create file success!")
{
msg += "\r\nTranfer file to SERVER ";
Class.App.uploadFile("ftp://101.99.28.152/test/", Application.StartupPath + "/dhcpd.conf", "administrator", "831031");
try
{
msg += "Ok";
}
catch {
msg += "Fail";
}
}
#endregion
//write respones
byte[] buffer = Encoding.UTF8.GetBytes(msg);
response.ContentLength64 = buffer.Length;
Stream st = response.OutputStream;
st.Write(buffer, 0, buffer.Length);
st.Close();
}
else
{
string msg = "Access Deny !";
byte[] buffer = Encoding.UTF8.GetBytes(msg);
response.ContentLength64 = buffer.Length;
Stream st = response.OutputStream;
st.Write(buffer, 0, buffer.Length);
st.Close();
}
context.Response.Close();
}
}
catch {
Stop();
Start();
}
}
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();
}