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);
}
}
public CtrlInfoItem(TblInfor data)
{
InitializeComponent();
this.Info = data;
txtContent.Text = data.InfoContent;
txtDate.Text = data.UpdateDate.Value.ToString("dd/MM/yyyy hh:mm");
txtTitle.Text = data.InfoTitle;
}
public bool Delete(TblInfor data)
{
Exception cex = null;
bool res = false;
var conn = new System.Data.SqlServerCe.SqlCeConnection(connectionString);
using (Sonartez_server db = new Sonartez_server(conn))
{
var matchedObj = (from c in db.TblInfor
where c.ID == data.ID
select c).SingleOrDefault();
if (matchedObj != null)
{
try
{
// does not exist
db.TblInfor.DeleteOnSubmit(matchedObj);
db.SubmitChanges();
res = true;
}
catch (Exception ex)
{
cex = ex;
res = false;
}
}
else
{
res = true;
}
}
if (cex != null)
throw cex;
else
return res;
}
public APIResult UpdateInfor(TblInfor data)
{
APIResult res = new APIResult();
using (Sonartez_server db = new Sonartez_server(connectionString))
{
var matchedObj = (from c in db.TblInfor
where c.ID == data.ID
select c).SingleOrDefault();
if (matchedObj == null)
{
try
{
// does not exist
Table<TblInfor> TblObj = db.TblInfor;
data.ServerUpdate = DateTime.Now;
TblObj.InsertOnSubmit(data);
TblObj.Context.SubmitChanges();
res.UpdateDate = data.ServerUpdate.Value;
res.Success = true;
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Success = false;
}
}
else
{
try
{
matchedObj.BeginDate = data.BeginDate;
matchedObj.CreateDate = data.CreateDate;
matchedObj.CreateUserID = data.CreateUserID;
matchedObj.ExprieDate = data.ExprieDate;
matchedObj.InfoContent = data.InfoContent;
matchedObj.InfoTag = data.InfoTag;
matchedObj.InfoTitle = data.InfoTitle;
matchedObj.InfoType = data.InfoType;
matchedObj.Status = data.Status;
matchedObj.UpdateDate = data.UpdateDate;
matchedObj.ServerUpdate = DateTime.Now;
db.SubmitChanges();
res.UpdateDate = data.ServerUpdate.Value;
res.Success = true;
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Success = false;
}
}
}
return res;
}
partial void DeleteTblInfor(TblInfor instance);
partial void UpdateTblInfor(TblInfor instance);
partial void InsertTblInfor(TblInfor instance);
private void ShowOnEditForm(TblInfor obj)
{
currentSelectedIndex = grvMainInfo.FocusedRowHandle;
currentInfo = new TblInfor();
currentInfo = obj;
txtContent.HtmlText = currentInfo.InfoContentHtml;
txtInfoTitle.Text = currentInfo.InfoTitle;
txtTag.Text = currentInfo.InfoTag;
txtCategory.Text = currentInfo.Category;
txtLocation.Text = currentInfo.Location;
if (currentInfo.InfoType == InformationType.Limited)
{
chkInfoType.Checked = true;
dateFrom.Value = currentInfo.BeginDate.Value;
dateTo.Value = currentInfo.ExprieDate.Value;
}
else
{
chkInfoType.Checked = false;
}
chkStatus.Checked = (currentInfo.Status == InformationStatus.Approved);
}
private bool DeleteInfo(TblInfor obj)
{
try
{
obj.IsDeleted = 1;
info.InsertOrUpdate(obj);
return true;
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(DevExpress.LookAndFeel.UserLookAndFeel.Default, this.FindForm(), ex.Message, "Không thể xóa " + obj.InfoTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
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);
}
}
}
private void ShowOnEditForm(TblInfor obj)
{
currentSelectedIndex = grvMainInfo.FocusedRowHandle;
currentInfo = new TblInfor();
currentInfo = obj;
txtContent.HtmlText = currentInfo.InfoContentHtml;
txtInfoTitle.Text = currentInfo.InfoTitle;
txtTag.Text = currentInfo.InfoTag;
if (currentInfo.InfoType == InformationType.Limited)
{
chkInfoType.Checked = true;
dateFrom.Value = currentInfo.BeginDate.Value;
dateTo.Value = currentInfo.ExprieDate.Value;
}
else
{
chkInfoType.Checked = false;
}
chkStatus.Checked = (currentInfo.Status == InformationStatus.Approved);
btnDeleteInfo.Visible = true;
btnEdit.Visible = true;
btnCancelEditInfo.Visible = false;
btnSaveInfo.Visible = false;
btnCreateInfo.Visible = true;
}
public TblInfor InsertOrUpdate(TblInfor data)
{
Exception cex = null;
TblInfor res = null;
var conn = new System.Data.SqlServerCe.SqlCeConnection(connectionString);
using (Sonartez_server db = new Sonartez_server(conn))
{
var matchedObj = (from c in db.TblInfor
where c.ID == data.ID
select c).SingleOrDefault();
if (matchedObj == null)
{
try
{
// does not exist
Table<TblInfor> TblObj = db.TblInfor;
data.UpdateDate = DateTime.Now;
data.IsDeleted = 0;
TblObj.InsertOnSubmit(data);
TblObj.Context.SubmitChanges();
res = data;
}
catch (Exception ex)
{
cex = ex;
}
}
else
{
try
{
matchedObj.BeginDate = data.BeginDate;
matchedObj.CreateDate = data.CreateDate;
matchedObj.CreateUserID = data.CreateUserID;
matchedObj.ExprieDate = data.ExprieDate;
matchedObj.InfoContentHtml = data.InfoContentHtml;
matchedObj.InfoContent = data.InfoContent;
matchedObj.InfoTag = data.InfoTag;
matchedObj.InfoTitle = data.InfoTitle;
matchedObj.InfoType = data.InfoType;
matchedObj.Location = data.Location;
matchedObj.Category = data.Category;
matchedObj.Status = data.Status;
matchedObj.UpdateDate = DateTime.Now;
matchedObj.IsDeleted = data.IsDeleted;
db.SubmitChanges();
res = matchedObj;
}
catch (Exception ex)
{
cex = ex;
}
}
}
if (cex != null)
throw cex;
else
return res;
}
// 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);
}
}