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;
}
}
