void InitialControlsValue()
{
if (HdInsertUpdate == false)
{
LtInsertUpdate.Text = "Cập nhật thông tin ngôn ngữ";
top = "1";
fields = "*";
condition = LanguageNationalTSql.GetByiLanguageNationalId(iLanguageNationalId);
order = "";
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational(top, fields, condition, order);
TbNameNational.Text = dt.Rows[0]["nLanguageNationalName"].ToString();
ltimg.Text = ImagesExtension.GetImage(pic, dt.Rows[0]["nLanguageNationalFlag"].ToString(), "", "", false, false, "");
if (!dt.Rows[0]["nLanguageNationalFlag"].ToString().Equals(""))
{
LbDelFlagCurrent.Visible = true;
}
HdFlagNational.Value = dt.Rows[0]["nLanguageNationalFlag"].ToString();
TbOrder.Text = dt.Rows[0]["nLanguageNationalDesc"].ToString();
if (dt.Rows[0]["iLanguageNationalEnable"].ToString().Equals("0"))
{
ChkStatus.Checked = false;
}
else
{
ChkStatus.Checked = true;
}
pnTiepTuc.Visible = false;
}
else
{
LtInsertUpdate.Text = "Thêm mới ngôn ngữ website";
pnTiepTuc.Visible = true;
}
}
void GetListLanguageNationals()
{
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational("", "*", LanguageNationalTSql.GetByiLanguageNationalEnable("1"), LanguageNationalColumns.nLanguageNationalDesc + " desc");
rptList.DataSource = dt;
rptList.DataBind();
}
protected void LbDelFlagCurrent_Click(object sender, EventArgs e)
{
string[] fields = { "nLanguageNationalFlag" };
string[] values = { "''" };
string condition = LanguageNationalTSql.GetByiLanguageNationalId(iLanguageNationalId);
LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fields, values), condition);
ImagesExtension.DeleteImageWhenDeleteItem(pic, HdFlagNational.Value);
}
protected void TextChanged(object sender, EventArgs e)
{
TextBox textbox = sender as TextBox;
string[] fields = { "nLanguageNationalDesc" };
string[] values = { textbox.Text };
string condition = LanguageNationalTSql.GetByiLanguageNationalId(textbox.ToolTip);
LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fields, values), condition);
GetListLanguageNationals();
}
void GetListLanguageNationals()
{
top = "";
fields = "*";
condition = TatThanhJsc.TSql.LanguageNationalTSql.GetByiLanguageNationalEnable("1");
order = LanguageNationalColumns.nLanguageNationalDesc;
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational(top, fields, condition, order);
rptList.DataSource = dt;
rptList.DataBind();
}
void GetListLanguageNationals()
{
top = "";
fields = "*";
condition = "";
order = LanguageNationalColumns.nLanguageNationalDesc + " ASC ";
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational(top, fields, condition, order);
RpListLanguageNationals.DataSource = dt;
RpListLanguageNationals.DataBind();
}
private void LoadSourceLanguage()
{
ddlLanguageSource.Items.Clear();
condition = LanguageNationalTSql.GetByiLanguageNationalEnable("1");
orderby = LanguageNationalColumns.iLanguageNationalId;
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational("", "*", condition, orderby, ddlWebSource.SelectedValue);
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlLanguageSource.Items.Add(new ListItem(dt.Rows[i][LanguageNationalColumns.nLanguageNationalName].ToString(), dt.Rows[i][LanguageNationalColumns.iLanguageNationalId].ToString()));
}
}
private void LoadDestLanguage()
{
ddlLanguageDest.Items.Clear();
condition = LanguageNationalTSql.GetByiLanguageNationalEnable("1");
orderby = LanguageNationalColumns.iLanguageNationalId;
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational("", "*", condition, orderby,
ConfigurationManager.AppSettings["WebName"]);
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlLanguageDest.Items.Add(new ListItem(dt.Rows[i][LanguageNationalColumns.nLanguageNationalName].ToString(), dt.Rows[i][LanguageNationalColumns.iLanguageNationalId].ToString()));
}
}
string GetListLanguageNationals()
{
string s = "";
top = "";
fields = "*";
condition = TatThanhJsc.TSql.LanguageNationalTSql.GetByiLanguageNationalEnable("1");
order = LanguageNationalColumns.nLanguageNationalDesc;
DataTable dt = LanguageNational.GetLanguageNational(top, fields, condition, order);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
s += @"
<a href='javascript:;' onclick='SetLangDisplay(" + dt.Rows[i][LanguageNationalColumns.iLanguageNationalId] + ")'>" + ImagesExtension.GetImage(FolderPic.Language, dt.Rows[i][LanguageNationalColumns.nLanguageNationalFlag].ToString(), dt.Rows[i][LanguageNationalColumns.nLanguageNationalName].ToString(), "", false, false, "") + @"</a>
";
}
}
return(s);
}
protected void RpListLanguageNationals_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string c = e.CommandName.Trim();
string p = e.CommandArgument.ToString().Trim();
switch (c)
{
#region delete
//case "delete":
// if (!language.Equals(p))
// {
// LanguageNational.DeleteLanguageNationalAndLanguageItem(p);
// }
// else
// {
// ScriptManager.RegisterStartupScript(this, GetType(), "DeleteItem",
// "ThongBao(3000, 'Bạn đang sử dụng ngôn ngữ này vì vậy không thể xóa được!');",
// true);
// }
// break;
#endregion
#region Edit Status
case "EditStatus":
top = "1";
fields = "iLanguageNationalEnable, nLanguageNationalName";
condition = LanguageNationalTSql.GetByiLanguageNationalId(p);
order = "";
DataTable dt = new DataTable();
dt = LanguageNational.GetLanguageNational(top, fields, condition, order);
string[] fieldsEditStatus = { "iLanguageNationalEnable" };
string[] valuesEditStatus = { "" };
if (dt.Rows[0]["iLanguageNationalEnable"].ToString().Equals("0"))
{
valuesEditStatus[0] = "1";
LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition);
}
else
{
valuesEditStatus[0] = "0";
LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition);
}
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", dt.Rows[0]["nLanguageNationalName"].ToString(), logAuthor, "", logCreateDate + ": " + logAuthor + " thay đổi trạng thái ngôn ngữ " + dt.Rows[0]["nLanguageNationalName"].ToString());
#endregion
GetListLanguageNationals();
break;
#endregion
#region edit
case "edit":
Response.Redirect(LinkUpdate(p));
break;
#endregion
}
}
protected void BtnOk_Click(object sender, EventArgs e)
{
#region Image
string vimg = "";
if (flimg.FileName.Length > 0 && flimg.PostedFile.ContentLength > 0)
{
string filename = "";
filename = System.IO.Path.GetFileName(flimg.PostedFile.FileName);
string fileex = "";
fileex = System.IO.Path.GetExtension(filename).ToLower();
string fileNotEx = System.IO.Path.GetFileNameWithoutExtension(flimg.PostedFile.FileName);
if (fileNotEx.Length > 10)
{
fileNotEx = fileNotEx.Remove(10);
}
vimg = StringExtension.ReplateTitle(fileNotEx) + DateTime.Now.Ticks.ToString() + fileex;
flimg.SaveAs(Request.PhysicalApplicationPath + "/" + pic + "/" + vimg);
}
#endregion
#region Status
string status = "0";
if (ChkStatus.Checked == true)
{
status = "1";
}
#endregion
if (HdInsertUpdate == true)
{
LanguageNational.InsertLanguageNational(TbNameNational.Text, vimg, TbOrder.Text, status);
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", TbNameNational.Text, logAuthor, "", logCreateDate + ": " + logAuthor + " tạo mới ngôn ngữ " + TbNameNational.Text);
#endregion
}
else
{
if (vimg.Equals(""))
{
vimg = HdFlagNational.Value;
}
else
{
ImagesExtension.DeleteImageWhenDeleteItem(pic, HdFlagNational.Value);
}
LanguageNational.UpdateLanguageNational(iLanguageNationalId, TbNameNational.Text, vimg, TbOrder.Text, status);
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", TbNameNational.Text, logAuthor, "", logCreateDate + ": " + logAuthor + " cập nhật ngôn ngữ " + TbNameNational.Text);
#endregion
}
if (pnTiepTuc.Visible)
{
if (ckTiepTuc.Checked)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertSuccess", "ThongBao(3000, 'Đã tạo: " + TbNameNational.Text + "');", true);
TbNameNational.Text = "";
TbOrder.Text = "";
}
else
{
Response.Redirect(LinkAdmin.GoAdminSubModul(CodeApplications.Language, "national"));
}
}
else
{
Response.Redirect(LinkAdmin.GoAdminSubModul(CodeApplications.Language, "national"));
}
}
