private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog fdlg = new OpenFileDialog();
if (DialogResult.OK == fdlg.ShowDialog())
{
var excel = new ExcelQueryFactory(fdlg.FileName);
var indianaCompanies = from c in excel.Worksheet("Sheet1")
select c;
int ix = 0;
int il = 0;
foreach (var item in indianaCompanies)
{
TblInfor newInfo = new TblInfor();
string content = "<b>" + item[1].ToString().Trim() + "</b> <br />"
+ "" + item[10].ToString().Trim()
+ "<br>Khu vực: " + item[9].ToString().Trim()
+ "<br>ĐC: " + item[4].ToString().Trim()
+ "<br> Số Phòng: " + item[6].ToString().Trim()
+ "<br> ĐT: " + item[2].ToString().Trim() + " - FAX: " + item[3].ToString().Trim()
+ "<br> Email: " + item[5].ToString().Trim()
+ "<br> Chủ đầu tư: " + item[7].ToString().Trim()
+ "<br>Giám đốc: " + item[8].ToString().Trim();
string tag = "Khách sạn, khach san, ks, " + item[11].ToString().Trim() + ", " + item[2].ToString().Trim();
newInfo.CreateDate = DateTime.Now;
newInfo.CreateUserID = Guid.Parse("b0b6997c-282b-4aff-b286-b0820cdb0100");
newInfo.ID = Guid.NewGuid();
newInfo.Category = Categories.KhachSan;
newInfo.Location = item[9].ToString().Trim();
newInfo.InfoContent = HtmlRemoval.StripTagsRegexCompiled(content);
newInfo.InfoContentHtml = content;
newInfo.InfoTag = tag;
newInfo.InfoTitle = item[1].ToString().Trim() + " " + item[9].ToString().Trim();
newInfo.InfoType = InformationType.NoLimit;
newInfo.Status = InformationStatus.Approved;
newInfo.UpdateDate = DateTime.Now;
newInfo.UpdateUserID = Guid.Parse("b0b6997c-282b-4aff-b286-b0820cdb0100");
try
{
BBLInfo b = new BBLInfo();
b.InsertOrUpdate(newInfo);
ix++;
}
catch (Exception ex)
{
Console.WriteLine("E - > " + ex.Message);
// DevExpress.XtraEditors.XtraMessageBox.Show(DevExpress.LookAndFeel.UserLookAndFeel.Default, this.FindForm(), ex.Message, "Có sự cố", MessageBoxButtons.OK, MessageBoxIcon.Warning);
il++;
}
}
Console.WriteLine(ix + " | " + il);
}
}
private void btnSaveInfo_Click(object sender, EventArgs e)
{
TblInfor newInfo = new TblInfor();
// Check Data Input
bool checkInputFlag = true;
string message = "Thông báo : ";
if (txtInfoTitle.Text.Trim().Length == 0)
{
checkInputFlag = false;
message += "\n Phải nhập tiêu đề.";
}
if (txtContent.Text.Trim().Length == 0)
{
checkInputFlag = false;
message += "\n Phải nhập nội dung.";
}
if (chkInfoType.Checked)
if (dateFrom.Value == null || dateTo.Value == null || dateTo.Value < dateFrom.Value)
{
checkInputFlag = false;
message += "\n Giới hạn ngày bắt đầu không được lớn hơn ngày kết thúc";
}
if (!checkInputFlag)
{
DevExpress.XtraEditors.XtraMessageBox.Show(DevExpress.LookAndFeel.UserLookAndFeel.Default, this.FindForm(), message, "Không thể tạo mới", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
if (chkInfoType.Checked)
{
newInfo.BeginDate = dateFrom.Value.Date;
newInfo.ExprieDate = dateTo.Value.Date.AddHours(23);
}
if (createNewFlag)
{
newInfo.CreateDate = DateTime.Now;
newInfo.CreateUserID = currentUser.UserID;
newInfo.ID = Guid.NewGuid();
}
else
{
newInfo.CreateDate = currentInfo.CreateDate;
newInfo.CreateUserID = currentInfo.CreateUserID;
newInfo.ID = currentInfo.ID;
}
newInfo.InfoContent = txtContent.Text.Trim();
newInfo.InfoContentHtml = txtContent.HtmlText.Trim();
newInfo.InfoTag = txtTag.Text.Trim();
newInfo.InfoTitle = txtInfoTitle.Text.Trim();
newInfo.InfoType = (chkInfoType.Checked) ? InformationType.Limited : InformationType.NoLimit;
newInfo.Status = (chkStatus.Checked) ? InformationStatus.Approved : InformationStatus.Pending;
newInfo.Location = cbbLocation.SelectedValue.ToString();
newInfo.Category = cbbCategory.SelectedValue.ToString();
newInfo.UpdateDate = DateTime.Now;
newInfo.UpdateUserID = currentUser.UserID;
newInfo.IsDeleted = 0;
try
{
BBLInfo b = new BBLInfo();
b.InsertOrUpdate(newInfo);
btnDeleteInfo.Visible = false;
btnEdit.Visible = false;
btnCancelEditInfo.Visible = false;
btnSaveInfo.Visible = false;
btnCreateInfo.Visible = true;
gridControl1.Enabled = true;
if (createNewFlag)
{
createNewFlag = false;
currentSelectedIndex = 0;
}
lstInfo = info.GetAll().Where(x=>x.IsDeleted==0);
LoadData();
grvMainInfo.FocusedRowHandle = currentSelectedIndex;
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(DevExpress.LookAndFeel.UserLookAndFeel.Default, this.FindForm(), ex.Message, "Có sự cố", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
// Ngân hàng ATM
private void button8_Click(object sender, EventArgs e)
{
OpenFileDialog fdlg = new OpenFileDialog();
if (DialogResult.OK == fdlg.ShowDialog())
{
var excel = new ExcelQueryFactory(fdlg.FileName);
var indianaCompanies = from c in excel.Worksheet("Sheet1")
select c;
int ix = 0;
int il = 0;
foreach (var item in indianaCompanies)
{
TblInfor newInfo = new TblInfor();
string content = "<b>" + item[5].ToString().Trim() +" "+ item[1].ToString().Trim() + "</b> "
+ "<br><i>" + item[4].ToString().Trim() + "</i>"
+ "<br><u>Địa chỉ</u>:<br> " + item[2].ToString().Trim()
+ "<br><u>Điện thoại</u>: " + item[3].ToString().Trim();
string tag = "ATM, Ngân Hàng, Bank";
newInfo.CreateDate = DateTime.Now;
newInfo.CreateUserID = Guid.Parse("b0b6997c-282b-4aff-b286-b0820cdb0100");
newInfo.ID = Guid.NewGuid();
newInfo.IsDeleted = 0;
newInfo.InfoContent = HtmlRemoval.StripTagsRegexCompiled(content);
newInfo.InfoContentHtml = content;
newInfo.InfoTag = tag;
newInfo.InfoTitle =item[5].ToString().Trim() +" "+ item[1].ToString().Trim();
newInfo.InfoType = InformationType.NoLimit;
newInfo.Status = InformationStatus.Approved;
newInfo.Category = Categories.NganHang;
newInfo.Location = item[6].ToString().Trim();
newInfo.UpdateDate = DateTime.Now;
newInfo.UpdateUserID = Guid.Parse("b0b6997c-282b-4aff-b286-b0820cdb0100");
try
{
BBLInfo b = new BBLInfo();
b.InsertOrUpdate(newInfo);
ix++;
}
catch (Exception ex)
{
Console.WriteLine("E - > " + ex.Message);
// DevExpress.XtraEditors.XtraMessageBox.Show(DevExpress.LookAndFeel.UserLookAndFeel.Default, this.FindForm(), ex.Message, "Có sự cố", MessageBoxButtons.OK, MessageBoxIcon.Warning);
il++;
}
}
Console.WriteLine(ix + " | " + il);
}
}
private void button3_Click(object sender, EventArgs e)
{
OpenFileDialog fdlg = new OpenFileDialog();
if (DialogResult.OK == fdlg.ShowDialog())
{
var excel = new ExcelQueryFactory(fdlg.FileName);
var indianaCompanies = from c in excel.Worksheet("Sheet1")
select c;
int ix = 0;
int il = 0;
foreach (var item in indianaCompanies)
{
TblInfor newInfo = new TblInfor();
string content = "<b>" + item[0].ToString().Trim() + "</b> Số hiệu :" + item[2].ToString().Trim()
+ "<br>Tần suất: " + item[4].ToString().Trim() + " Giá vé : " + item[7].ToString().Trim()
+ "<br>Tuyến đường: " + item[3].ToString().Trim()
+ "<br>Thời gian hoạt động: " + item[6].ToString().Trim() + " Số chuyến/ngày: " + item[5].ToString().Trim()
+ "<br>Đơn vị: " + item[1].ToString().Trim()
+ "<br>ĐT: " + item[8].ToString().Trim();
string tag = "xe, vận tải, dịch vụ ";
newInfo.CreateDate = DateTime.Now;
newInfo.CreateUserID = Guid.Parse("b0b6997c-282b-4aff-b286-b0820cdb0100");
newInfo.ID = Guid.NewGuid();
newInfo.IsDeleted = 0;
newInfo.InfoContent = HtmlRemoval.StripTagsRegexCompiled(content);
newInfo.InfoContentHtml = content;
newInfo.InfoTag = tag;
newInfo.InfoTitle = item[0].ToString().Trim();
newInfo.InfoType = InformationType.NoLimit;
newInfo.Status = InformationStatus.Approved;
newInfo.UpdateDate = DateTime.Now;
newInfo.UpdateUserID = Guid.Parse("b0b6997c-282b-4aff-b286-b0820cdb0100");
try
{
BBLInfo b = new BBLInfo();
b.InsertOrUpdate(newInfo);
ix++;
}
catch (Exception ex)
{
Console.WriteLine("E - > " + ex.Message);
// DevExpress.XtraEditors.XtraMessageBox.Show(DevExpress.LookAndFeel.UserLookAndFeel.Default, this.FindForm(), ex.Message, "Có sự cố", MessageBoxButtons.OK, MessageBoxIcon.Warning);
il++;
}
}
Console.WriteLine(ix + " | " + il);
}
}
