/// <summary> /// Saves a new DN value to the database /// </summary> /// <param name="ident"></param> /// <param name="d"></param> /// <returns></returns> public DnCL saveDn(string ident, DnCL d) { DnCL resp = new DnCL(); resp.ErrCode = 0; resp.ErrMessage = ""; CReparator cr = new CReparator(); int identOK = cr.checkIdent(ident); if (identOK == -1) { resp.ErrCode = -10; resp.ErrMessage = "Ogiltigt login"; return(resp); } if (d.Dn == "") { resp.ErrCode = -1; resp.ErrMessage = "Dn måste anges"; return(resp); } string exists = dnExists(d.Dn); if (exists != "0" && exists != "1") { resp.ErrCode = -100; resp.ErrMessage = "Fel vid kontroll av DN. Felmeddelande : " + exists; if (resp.ErrMessage.Length > 2000) { resp.ErrMessage = resp.ErrMessage.Substring(1, 2000); } return(resp); } if (exists == "1") { resp.ErrCode = 100; resp.ErrMessage = "Dn finns redan registrerat"; return(resp); } string sSql = getInsertSql(); NxParameterCollection pc = new NxParameterCollection(); pc.Add("dn", d.Dn); pc.Add("reg", "System"); pc.Add("regdat", System.DateTime.Now); string errText = ""; int iRc = cdb.updateData(sSql, ref errText, pc); if (errText != "") { if (errText.Length > 2000) { errText = errText.Substring(1, 2000); } resp.ErrCode = -100; resp.ErrMessage = errText; return(resp); } CComboValues cbv = new CComboValues(); List <DnCL> respList = cbv.getDn("", d.Dn); if (respList.Count == 1) { return(respList[0]); } return(resp); }
/// <summary> /// Saves a new DN value to the database /// </summary> /// <param name="ident"></param> /// <param name="d"></param> /// <returns></returns> public DnCL saveDn(string ident, DnCL d) { Basdata.CDn dn = new Basdata.CDn(); return(dn.saveDn(ident, d)); }
public List <DnCL> getDn(string ident, string aDn) { List <DnCL> ld = new List <DnCL>(); if (ident != "") { CReparator cr = new CReparator(); int identOK = cr.checkIdent(ident); if (identOK == -1) { DnCL d = new DnCL(); d.ErrCode = -10; d.ErrMessage = "Ogiltigt login"; ld.Add(d); return(ld); } } string sSql = " select dn " + " from dn "; if (aDn != "") { sSql += " where dn = :dn "; } sSql += " order by dn "; string errText = ""; NxParameterCollection pc = new NxParameterCollection(); if (aDn != "") { pc.Add("dn", aDn); } DataTable dt = cdb.getData(sSql, ref errText, pc); int errCode = -100; if (errText == "" && dt.Rows.Count == 0) { errText = "Inga dn finns tillgängliga"; errCode = 0; } if (errText != "") { if (errText.Length > 2000) { errText = errText.Substring(1, 2000); } DnCL d = new DnCL(); d.ErrCode = errCode; d.ErrMessage = errText; ld.Add(d); return(ld); } foreach (DataRow dr in dt.Rows) { DnCL d = new DnCL(); d.Dn = dr["dn"].ToString(); d.ErrCode = 0; d.ErrMessage = ""; ld.Add(d); } return(ld); }