public ESHOP_EMAILTEMPLATE getEmailTemplateByCode(string code, int lang) { try { ESHOP_EMAILTEMPLATE item = db.ESHOP_EMAILTEMPLATEs.SingleOrDefault(n => n.CODE == code && n.LANGUAGE == lang); return(item); } catch { return(null); } }
private void SaveInfo(string strLink = "") { try { if (m_email_id > 0) { //update var g_update = DB.GetTable <ESHOP_EMAILTEMPLATE>().Where(g => g.ID == m_email_id); if (g_update.ToList().Count > 0) { g_update.Single().LANGUAGE = Utils.CIntDef(ddlNN.SelectedValue); g_update.Single().CODE = txtCode.Value; g_update.Single().SUBJECT = txtSubject.Value; g_update.Single().BODY = txtBody.Value; g_update.Single().NOTE = txtNote.Value; DB.SubmitChanges(); strLink = string.IsNullOrEmpty(strLink) ? "config_emailtemplate_list.aspx" : strLink; } } else { ESHOP_EMAILTEMPLATE item = new ESHOP_EMAILTEMPLATE(); item.LANGUAGE = Utils.CIntDef(ddlNN.SelectedValue); item.CODE = txtCode.Value; item.SUBJECT = txtSubject.Value; item.BODY = txtBody.Value; item.NOTE = txtNote.Value; item.ISACTIVE = true; item.ISDELETE = false; item.CREATEDATE = DateTime.Now; DB.ESHOP_EMAILTEMPLATEs.InsertOnSubmit(item); DB.SubmitChanges(); strLink = string.IsNullOrEmpty(strLink) ? "config_emailtemplate_list.aspx" : strLink; } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } finally { if (!string.IsNullOrEmpty(strLink)) { Response.Redirect(strLink); } } }