public static void AddZahranicniFirma(string ico, string jmeno, string adresa) { /* * f.ICO = (string)dr["ico"]; * f.DIC = (string)PersistLib.IsNull(dr["dic"], string.Empty); * f.Datum_Zapisu_OR = (DateTime?)PersistLib.IsNull(dr["datum_zapisu_or"], null); * f.Stav_subjektu = Convert.ToInt32(PersistLib.IsNull(dr["Stav_subjektu"], 1)); * f.Jmeno = (string)PersistLib.IsNull(dr["jmeno"], string.Empty); * f.JmenoAscii = (string)PersistLib.IsNull(dr["jmenoascii"], string.Empty); * f.Kod_PF = (int?)PersistLib.IsNull(dr["Kod_PF"], null); * f.VersionUpdate = (int)dr["VersionUpdate"]; * //f.VazbyRaw = (string)PersistLib.IsNull(dr["vazbyRaw"], (string)"[]"); * f.IsInRS = (short?)PersistLib.IsNull(dr["IsInRS"], null); * f.KrajId = (string)PersistLib.IsNull(dr["krajid"], string.Empty); * f.OkresId = (string)PersistLib.IsNull(dr["okresid"], string.Empty); */ using (PersistLib p = new PersistLib()) { string sql = @"insert into firma(ico,dic,stav_subjektu, jmeno, jmenoascii, versionupdate, popis) values(@ico,@dic,@stav,@jmeno,@jmenoascii,0,@adresa)"; p.ExecuteNonQuery(cnnStr, System.Data.CommandType.Text, sql, new IDataParameter[] { new System.Data.SqlClient.SqlParameter("ico", ico), new System.Data.SqlClient.SqlParameter("dic", ico), new System.Data.SqlClient.SqlParameter("stav", (int)1), new System.Data.SqlClient.SqlParameter("jmeno", jmeno), new System.Data.SqlClient.SqlParameter("jmenoascii", Devmasters.TextUtil.RemoveDiacritics(jmeno)), new System.Data.SqlClient.SqlParameter("versionupdate", (long)0), new System.Data.SqlClient.SqlParameter("adresa", Devmasters.TextUtil.ShortenText(adresa, 100)), }); } }
public void Save() { this.JmenoAscii = Devmasters.Core.TextUtil.RemoveDiacritics(this.Jmeno); string sql = @"exec Firma_Save @ICO,@DIC,@Datum_zapisu_OR,@Stav_subjektu,@Jmeno,@Jmenoascii,@Kod_PF,@Source, @Popis, @VersionUpdate, @krajId, @okresId, @status "; string sqlNACE = @"INSERT into firma_NACE(ico, nace) values(@ico,@nace)"; string sqlDS = @"INSERT into firma_DS(ico, DatovaSchranka) values(@ico,@DatovaSchranka)"; string cnnStr = Devmasters.Core.Util.Config.GetConfigValue("CnnString"); try { using (PersistLib p = new PersistLib()) { p.ExecuteNonQuery(cnnStr, System.Data.CommandType.Text, sql, new IDataParameter[] { new System.Data.SqlClient.SqlParameter("ico", this.ICO), new System.Data.SqlClient.SqlParameter("dic", this.DIC), new System.Data.SqlClient.SqlParameter("Datum_zapisu_OR", this.Datum_Zapisu_OR), new System.Data.SqlClient.SqlParameter("Stav_subjektu", this.Stav_subjektu), new System.Data.SqlClient.SqlParameter("Jmeno", this.Jmeno), new System.Data.SqlClient.SqlParameter("Jmenoascii", this.JmenoAscii), new System.Data.SqlClient.SqlParameter("Kod_PF", this.Kod_PF), new System.Data.SqlClient.SqlParameter("Source", this.Source), new System.Data.SqlClient.SqlParameter("Popis", this.Popis), new System.Data.SqlClient.SqlParameter("VersionUpdate", this.VersionUpdate), new System.Data.SqlClient.SqlParameter("KrajId", this.KrajId), new System.Data.SqlClient.SqlParameter("OkresId", this.OkresId), new System.Data.SqlClient.SqlParameter("Status", this.Status), }); if (this.DatovaSchranka != null) { p.ExecuteNonQuery(cnnStr, System.Data.CommandType.Text, "delete from firma_DS where ico=@ico", new IDataParameter[] { new System.Data.SqlClient.SqlParameter("ico", this.ICO) }); foreach (var ds in this.DatovaSchranka.Distinct()) { p.ExecuteNonQuery(cnnStr, System.Data.CommandType.Text, sqlDS, new IDataParameter[] { new System.Data.SqlClient.SqlParameter("ico", this.ICO), new System.Data.SqlClient.SqlParameter("DatovaSchranka", ds), }); } } if (this.NACE != null) { p.ExecuteNonQuery(cnnStr, System.Data.CommandType.Text, "delete from firma_NACE where ico=@ico", new IDataParameter[] { new System.Data.SqlClient.SqlParameter("ico", this.ICO) }); foreach (var nace in this.NACE.Distinct()) { p.ExecuteNonQuery(cnnStr, System.Data.CommandType.Text, sqlNACE, new IDataParameter[] { new System.Data.SqlClient.SqlParameter("ico", this.ICO), new System.Data.SqlClient.SqlParameter("nace", nace), }); } } } } catch (Exception e) { Console.WriteLine(e.ToString()); //throw; } }