private thongbaokiemtra KiemTraSoLieu(dienthoai_new model)
{
try
{
if (!TestTelNumber(model.didong))
{
return new thongbaokiemtra()
{
trangthai = false, NoiDung = "Điện thoại không đúng format"
}
}
;
if (model.gioi_tinhold != "")
{
if (model.gioi_tinhold != "0" || model.gioi_tinhold != "1" || model.gioi_tinhold.ToLower() != "trai" || model.gioi_tinhold.ToLower() != "nữ" || model.gioi_tinhold.ToLower() != "nu" ||
model.gioi_tinhold.ToLower() != "true" || model.gioi_tinhold.ToLower() != "false")
{
return new thongbaokiemtra()
{
trangthai = false, NoiDung = "Giới tính không đúng format [Nam|Nữ];[0|1];[trai|gai];[true|false]"
}
}
}
;
return(new thongbaokiemtra()
{
trangthai = true, NoiDung = "Số liệu đúng"
});
}
catch (Exception ex)
{
return(new thongbaokiemtra()
{
trangthai = false, NoiDung = ex.Message
});
}
}
public static bool UpdateDienThoaiNEW(dienthoai_new record)
{
SqlConnection connection = null;
SqlCommand cmd = null;
try
{
if (record == null)
{
return(false);
}
// Make connection to database
connection = new SqlConnection();
connection.ConnectionString = ConnectionString;
connection.FireInfoMessageEventOnUserErrors = false;
connection.Open();
// Create command to update GeneralGuessGroup record
cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandText = "Update dienthoai_goc Set ten_khach_hang=@ten_khach_hang, "
+ "dia_chi=@dia_chi,namsinh=@namsinh,ngay=@ngay,thang=@thang,cuoc=@cuoc, "
+ "ngan_hang=@ngan_hang, sim=@sim,tinh_cuoc=@tinh_cuoc ,tinh=@tinh,phuong=@phuong,quan_huyen=@quan_huyen,email=@email,ngay_kich_hoat=@ngay_kich_hoat,goi_cuoc=@goi_cuoc,dong_may=@dong_may,he_dieu_hanh=@he_dieu_hanh,chuc_vu=@chuc_vu,cong_ty=@cong_ty"
+ " where ID='" + record.id + "'";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ten_khach_hang", record.ten_khach_hang);
cmd.Parameters.AddWithValue("@didong", record.didong);
cmd.Parameters.AddWithValue("@dia_chi", record.dia_chi);
cmd.Parameters.AddWithValue("@phuong", record.phuong);
cmd.Parameters.AddWithValue("@quan_huyen", record.quan_huyen);
cmd.Parameters.AddWithValue("@email", record.email);
cmd.Parameters.AddWithValue("@namsinh", record.namsinh);
cmd.Parameters.AddWithValue("@ngay", record.ngay);
cmd.Parameters.AddWithValue("@thang", record.thang);
cmd.Parameters.AddWithValue("@cuoc", record.cuoc);
cmd.Parameters.AddWithValue("@ngan_hang", record.ngan_hang);
cmd.Parameters.AddWithValue("@sim", record.sim);
cmd.Parameters.AddWithValue("@tinh", record.tinh);
cmd.Parameters.AddWithValue("@tinh_cuoc", record.tinh_cuoc);
cmd.Parameters.AddWithValue("@ghi_chu", record.ghi_chu);
cmd.Parameters.AddWithValue("@filenguon", record.filenguon);
cmd.Parameters.AddWithValue("@gioi_tinh", record.gioi_tinh);
cmd.Parameters.AddWithValue("@ngay_kich_hoat", record.ngay_kich_hoat);
cmd.Parameters.AddWithValue("@goi_cuoc", record.goi_cuoc);
cmd.Parameters.AddWithValue("@dong_may", record.dong_may);
cmd.Parameters.AddWithValue("@he_dieu_hanh", record.he_dieu_hanh);
cmd.Parameters.AddWithValue("@chuc_vu", record.chuc_vu);
cmd.Parameters.AddWithValue("@cong_ty", record.cong_ty);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "UpdateDienThoaiNEW");
return(false);
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
//----- Process Import File Text
private void ProcessImportFileText(object arrControl)
{
StreamReader sReader;
countInsert = 0;
int process = 0;
int countErro = 0;
object totalRow;
string line;
string[] lineParts, countLines;
char[] charSpits;
try
{
//----- Add control process from
ArrayList arr1 = (ArrayList)arrControl;
Label lb_title1 = (Label)arr1[0];
Label pictureBox_title1 = (Label)arr1[1];
NeroBar progressBar11 = (NeroBar)arr1[2];
Button btn_Stop1 = (Button)arr1[3];
DataGridView gridview1 = (DataGridView)arr1[4];
TabControl tabControl1 = (TabControl)arr1[5];
RichTextBox richTextBox1 = (RichTextBox)arr1[6];
Button btn_xuat1 = (Button)arr1[7];
//----- update display control
lb_title1.Update();
btn_Stop1.Update();
gridview1.Update();
//----- Get Total row
countLines = File.ReadAllLines(connectionString);
totalRow = countLines.Length;
if (totalRow == null)
{
return;
}
//----- Get Data from Source
progressBar11.MaxValue = int.Parse(totalRow.ToString());
progressBar11.MinValue = 0;
sReader = new StreamReader(connectionString);
charSpits = (new char[] { charSpit }); //charSpit.ToCharArray();
while ((line = sReader.ReadLine()) != null)
{
//----- Stop process if false
if (hasProcess)
{
process++;
lineParts = line.Split(charSpits);
//----- Test value import
dienthoai_new model = new dienthoai_new();
if (dict.FirstOrDefault(x => x.Key == "cbb_TelNumber").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_TelNumber").Value))
{
model.didong = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_TelNumber").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_ten_khach_hang").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_ten_khach_hang").Value))
{
model.ten_khach_hang = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_ten_khach_hang").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_dia_chi").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_dia_chi").Value))
{
model.dia_chi = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_dia_chi").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_Ngay").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_Ngay").Value))
{
model.ngay = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_Ngay").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_Thang").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_Thang").Value))
{
model.thang = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_Thang").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_gioitinh").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_gioitinh").Value))
{
model.gioi_tinh = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_gioitinh").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_namsinh").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_namsinh").Value))
{
model.namsinh = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_namsinh").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_nganhang").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_nganhang").Value))
{
model.ngan_hang = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_nganhang").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_cuoc").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_cuoc").Value))
{
model.cuoc = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_cuoc").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_sim").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_sim").Value))
{
model.sim = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_sim").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_tinh").Value != "")
{
if (lineParts.Count() >= Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_tinh").Value))
{
model.tinh = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_tinh").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_tinhcuoc").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_tinhcuoc").Value))
{
model.tinh_cuoc = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_tinhcuoc").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_ghichu").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_ghichu").Value))
{
model.ghi_chu = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_ghichu").Value)].Trim();
}
}
/*---------------------------------------------*/
if (dict.FirstOrDefault(x => x.Key == "cbb_phuong").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_phuong").Value))
{
model.phuong = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_phuong").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_quanhuyen").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_quanhuyen").Value))
{
model.quan_huyen = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_quanhuyen").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_email").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_email").Value))
{
model.email = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_email").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_ngay_kich_hoat").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_ngay_kich_hoat").Value))
{
model.ngay_kich_hoat = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_ngay_kich_hoat").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_goiCuoc").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_goiCuoc").Value))
{
model.goi_cuoc = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_goiCuoc").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_dongmay").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_dongmay").Value))
{
model.dong_may = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_dongmay").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_hedieuhanh").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_hedieuhanh").Value))
{
model.he_dieu_hanh = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_hedieuhanh").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_chucvu").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_chucvu").Value))
{
model.chuc_vu = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_chucvu").Value)].Trim();
}
}
if (dict.FirstOrDefault(x => x.Key == "cbb_congty").Value != "")
{
if (lineParts.Count() > Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_congty").Value))
{
model.cong_ty = lineParts[Convert.ToInt32(dict.FirstOrDefault(x => x.Key == "cbb_congty").Value)].Trim();
}
}
model.filenguon = nguon;
thongbaokiemtra kq = KiemTraSoLieu(model);
if (kq.trangthai)
{
//----- Test exists in database
int nloi = 0;
//if(kiemtra)
// nloi = TestTelNumberExists(model.didong);
if (nloi == 0)
{
//----- Insert to TelNumberChange Table
if (SQLDatabase.AddDienThoaiNEW(model) == true)
{
countInsert++;
}
else
{
tberror.Rows.Add(process, model.didong, "Sai định dạng.");
countErro++;
}
}
else
{
tberror.Rows.Add(process, model.didong, "Đã tồn tại");
countErro++;
/*da ton tai*/
}
}
else /*loi*/
{
tberror.Rows.Add(process, model.didong, kq.NoiDung);
countErro++;
}
ShowMessage(ref richTextBox1, process, countErro, countInsert, int.Parse(totalRow.ToString()));
tabControl1.TabPages[1].Text = string.Format("Error {0}", countErro);
tabControl1.Update();
progressBar11.Value = process;
progressBar11.Update();
Thread.Sleep(0);
}
}
if (countErro == 0)
{
this.DialogResult = DialogResult.OK;
this.Close();
}
btn_Stop1.Text = "Đóng";
btn_xuat.Enabled = true;
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message, "ProcessImportFileText", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public static bool AddDienThoaiNEW(dienthoai_new record)
{
SqlConnection cnn = null;
SqlCommand cmd = null;
object objectID;
try
{
if (record == null)
{
return(false);
}
cnn = new SqlConnection();
cnn.ConnectionString = ConnectionString;
cnn.FireInfoMessageEventOnUserErrors = false;
cnn.Open();
cmd = new SqlCommand();
cmd.Connection = cnn;
//--- Insert Record
cmd.CommandText = "Insert into dienthoai_new(ten_khach_hang,phuong,quan_huyen, didong, dia_chi, namsinh,email, ngay,thang,cuoc, gioi_tinh, ngan_hang, sim, tinh, ghi_chu, filenguon,tinh_cuoc,ngay_kich_hoat,goi_cuoc,dong_may,he_dieu_hanh,chuc_vu,cong_ty)" +
"values(@ten_khach_hang,@phuong,@quan_huyen, @didong, @dia_chi, @namsinh,@email, @ngay,@thang,@cuoc, @gioi_tinh, @ngan_hang, @sim, @tinh, @ghi_chu, @filenguon,@tinh_cuoc,@ngay_kich_hoat,@goi_cuoc,@dong_may,@he_dieu_hanh,@chuc_vu,@cong_ty);" +
"Select SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("@ten_khach_hang", record.ten_khach_hang);
cmd.Parameters.AddWithValue("@didong", record.didong);
cmd.Parameters.AddWithValue("@dia_chi", record.dia_chi);
cmd.Parameters.AddWithValue("@phuong", record.phuong);
cmd.Parameters.AddWithValue("@quan_huyen", record.quan_huyen);
cmd.Parameters.AddWithValue("@email", record.email);
cmd.Parameters.AddWithValue("@namsinh", record.namsinh);
cmd.Parameters.AddWithValue("@ngay", record.ngay);
cmd.Parameters.AddWithValue("@thang", record.thang);
cmd.Parameters.AddWithValue("@cuoc", record.cuoc);
cmd.Parameters.AddWithValue("@ngan_hang", record.ngan_hang);
cmd.Parameters.AddWithValue("@sim", record.sim);
cmd.Parameters.AddWithValue("@tinh", record.tinh);
cmd.Parameters.AddWithValue("@tinh_cuoc", record.tinh_cuoc);
cmd.Parameters.AddWithValue("@ghi_chu", record.ghi_chu);
cmd.Parameters.AddWithValue("@filenguon", record.filenguon);
cmd.Parameters.AddWithValue("@gioi_tinh", record.gioi_tinh);
cmd.Parameters.AddWithValue("@ngay_kich_hoat", record.ngay_kich_hoat);
cmd.Parameters.AddWithValue("@goi_cuoc", record.goi_cuoc);
cmd.Parameters.AddWithValue("@dong_may", record.dong_may);
cmd.Parameters.AddWithValue("@he_dieu_hanh", record.he_dieu_hanh);
cmd.Parameters.AddWithValue("@chuc_vu", record.chuc_vu);
cmd.Parameters.AddWithValue("@cong_ty", record.cong_ty);
objectID = cmd.ExecuteScalar();
if (objectID == null || objectID == DBNull.Value)
{
return(false);
}
record.id = Convert.ToInt32(objectID);
return(true);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
return(false);
}
finally
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
}
}
