public static string getSign(string SignId)
{
try
{
SignatureBUS signBus = new SignatureBUS();
int id = int.Parse(SignId);
DataTable tblSign = signBus.GetById(id);
if (tblSign.Rows.Count > 0)
{
return tblSign.Rows[0]["SignatureContent"].ToString();
}
return null;
}
catch (Exception)
{
throw;
}
}
private void LoadSignatureList()
{
try
{
signBus = new SignatureBUS();
UserLoginDTO userLogin = getUserLogin();
DataTable tblSignList = signBus.GetByUserId(userLogin.UserId);
createTableSign();
if (tblSignList.Rows.Count > 0)
{
DataRow rowE = SignIn.NewRow();
rowE["Id"] = 0;
rowE["SignatureName"] = "Chọn chữ ký";
SignIn.Rows.Add(rowE);
foreach (DataRow RowItem in tblSignList.Rows)
{
rowE = SignIn.NewRow();
rowE["Id"] = RowItem["id"];
rowE["SignatureName"] = RowItem["SignatureName"];
SignIn.Rows.Add(rowE);
}
drlSign.DataSource = SignIn;
drlSign.DataTextField = "SignatureName";
drlSign.DataValueField = "id";
drlSign.DataBind();
}
}
catch (Exception)
{
}
}
private void InitialBUS()
{
scBUS = new SendContentBUS();
signBus = new SignatureBUS();
}
protected void lbtInsertSignature_Click(object sender, EventArgs e)
{
InitialBUS();
try
{
int signId = int.Parse(((LinkButton)sender).CommandArgument.ToString());
SignatureBUS signBus = new SignatureBUS();
DataTable tblSign = signBus.GetById(signId);
if (tblSign.Rows.Count > 0)
{
txtBody.Text = txtBody.Text + "\n" + tblSign.Rows[0]["SignatureContent"].ToString();
}
}
catch (Exception)
{
throw;
}
}
protected void lbtInsertSignature_Click(object sender, EventArgs e)
{
try
{
int signId = int.Parse(((LinkButton)sender).CommandArgument.ToString());
signBus = new SignatureBUS();
DataTable tblSign = signBus.GetById(signId);
if (tblSign.Rows.Count > 0)
{
txtBody.Text = txtBody.Text + "\n" + tblSign.Rows[0]["SignatureContent"].ToString();
}
}
catch (Exception ex)
{
logs.Error(userLogin.Username + "-Create-Event - lbtInsertSignature_Click", ex);
}
}
private void LoadSignatureList()
{
try
{
signBus = new SignatureBUS();
UserLoginDTO userLogin = getUserLogin();
DataTable tblSignList = signBus.GetByUserId(userLogin.UserId);
if (tblSignList.Rows.Count > 0)
{
drlSign.DataSource = tblSignList;
drlSign.DataTextField = "SignatureName";
drlSign.DataValueField = "id";
drlSign.DataBind();
}
}
catch (Exception)
{
}
}
protected void lbtDelete_Click(object sender, EventArgs e)
{
try
{
int signId = int.Parse(((LinkButton)sender).CommandArgument.ToString());
signBus = new SignatureBUS();
ConnectionData.OpenMyConnection();
signBus.tblSignature_Delete(signId);
ConnectionData.CloseMyConnection();
loadSignatureList();
pnError.Visible = false;
pnSuccess.Visible = true;
lblSuccess.Text = "Bạn vừa xóa chữ ký thành công !";
}
catch (Exception ex)
{
pnError.Visible = true;
lblError.Text = "Không thể xóa !</br>" + ex.Message;
}
}
private void loadSignatureList()
{
UserLoginDTO userLogin = getUserLogin();
signBus = new SignatureBUS();
DataTable tblSign = signBus.GetByUserId(userLogin.UserId);
dlSignature.DataSource = tblSign;
dlSignature.DataBind();
for (int i = 0; i < tblSign.Rows.Count; i++)
{
DataRow row = tblSign.Rows[i];
Label lblNo = (Label)dlSignature.Items[i].FindControl("lblNo");
lblNo.Text = (i + 1).ToString();
LinkButton lbtSubject = (LinkButton)dlSignature.Items[i].FindControl("lbtSubject");
lbtSubject.Text = row["SignatureName"].ToString();
lbtSubject.ToolTip = row["SignatureContent"].ToString();
LinkButton lbtEdit = (LinkButton)dlSignature.Items[i].FindControl("lbtEdit");
lbtEdit.CssClass = "table-actions-button ic-table-edit";
lbtEdit.CommandArgument = row["id"].ToString();
LinkButton lbtDelete = (LinkButton)dlSignature.Items[i].FindControl("lbtDelete");
lbtDelete.CssClass = "table-actions-button ic-table-delete";
lbtDelete.CommandArgument = row["id"].ToString();
}
}
private void LoadSignature()
{
UserLoginDTO userLogin = getUserLogin();
signBus = new SignatureBUS();
DataTable tblSign = signBus.GetByUserId(userLogin.UserId);
if (tblSign.Rows.Count > 0)
{
txtBody.Text = tblSign.Rows[0]["SignatureContent"].ToString();
}
else
{
//pnSuccess.Visible = true;
//lblSuccess.Text = "Bạn chưa có chữ ký, vui lòng thêm chữ ký tại đây !";
}
}
private void InitialBUS()
{
signBus = new SignatureBUS();
}
protected void lbtEdit_Click(object sender, EventArgs e)
{
try
{
pnSuccess.Visible = false;
pnError.Visible = false;
int signId = int.Parse(((LinkButton)sender).CommandArgument.ToString());
signBus = new SignatureBUS();
DataTable dtSign = signBus.GetById(signId);
if (dtSign.Rows.Count > 0)
{
txtSignatureName.Text = dtSign.Rows[0]["SignatureName"].ToString();
txtBody.Text = dtSign.Rows[0]["SignatureContent"].ToString();
hdfId.Value = dtSign.Rows[0]["id"].ToString();
}
}
catch (Exception)
{
throw;
}
}
