private void BindGrid()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadAllTempl();
TemplateGridView.DataSource = dt;
TemplateGridView.DataBind();
}
private void TemplateGridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (TemplateGridView.GetFocusedRow() is Templates item)
{
UnitOfWork unitOfWork = new UnitOfWork();
var res = unitOfWork.TemplatesRepo.Fetch(x => x.Id == item.Id).Select(x => new { x.TemplateContent })
.FirstOrDefault();
this.rtfPreview.HtmlText = res?.TemplateContent;
}
}
private void BtnEditRepo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
if (TemplateGridView.GetFocusedRow() is Templates item)
{
frmAddEditTemplatesV2 frm = new frmAddEditTemplatesV2(item, MethodType.Edit);
frm.ShowDialog();
Init();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (TemplateGridView.GetFocusedRow() is Templates item)
{
var res = new rptTemplatePreview()
{
DataSource = new UnitOfWork().TemplatesRepo.Get(x => x.Id == item.Id)
};
frmReportViewer frmReportViewer = new frmReportViewer(res);
frmReportViewer.ShowDialog();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void BtnDeleteRepo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
if (MessageBox.Show("Do you want to delete this?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (TemplateGridView.GetFocusedRow() is Templates item)
{
UnitOfWork unitOfWork = new UnitOfWork();
unitOfWork.TemplatesRepo.Delete(x => x.Id == item.Id);
unitOfWork.Save();
Init();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
