public IActionResult Post([FromBody] Client client) //зарегистрировать нового клиента
{
if (client == null)
{
return(BadRequest());
}
db.Clients.Add(client);
db.SaveChanges();
return(Ok(client));
}
public static void SynchT()
{
using (ClientsContext db = new ClientsContext())
using (SqlConnection con = new SqlConnection(Param.ConnectionString))
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM rate_list";
SqlDataReader dr = cmd.ExecuteReader();
List <TarifED> tarifsED = new List <TarifED>();
while (dr.Read())
{
if (dr["Name"].ToString() != "")
{
var tarif = new TarifED
{
SQLGuid = dr["id_org"].ToString(),
Name = dr["Name"].ToString(),
DateApply = Convert.ToDateTime(dr["Date"]),
LetterFileName = dr["letter_filename"] == DBNull.Value ? null : dr["Letter_filename"].ToString()
};
tarifsED.Add(tarif);
Console.WriteLine(db.Organizations.Where(o => EF.Functions.Like(o.SQLGuid, $"%{tarif.SQLGuid}%")).Count());
}
}
;
dr.Close();
db.SaveChanges();
}
catch (SystemException ex)
{
Console.WriteLine(ex.Message);
}
}
public MainWindow()
{
InitializeComponent();
ClientsContext db = new ClientsContext();
db.Clients.Add(new Client()
{
LongName = "Vano"
});
db.SaveChanges();
}
static bool SynchTarifs()
{
using (ClientsContext db = new ClientsContext())
using (SqlConnection con = new SqlConnection(Param.ConnectionString))
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM rate_list";
SqlDataReader dr = cmd.ExecuteReader();
List <TarifED> tarifsED = new List <TarifED>();
while (dr.Read())
{
if (dr["Name"].ToString() != "")
{
var tarif = new TarifED
{
SQLGuid = dr["id_org"].ToString(),
Name = dr["Name"].ToString(),
DateApply = Convert.ToDateTime(dr["Date"]),
LetterFileName = dr["letter_filename"] == DBNull.Value ? null : dr["Letter_filename"].ToString()
};
tarifsED.Add(tarif);
foreach (var o in db.Organizations)
{
if (tarif.SQLGuid == o.SQLGuid)
{
o.TarifsED.Add(tarif);
}
}
}
}
;
dr.Close();
foreach (var t in tarifsED)
{
foreach (var o in db.Organizations)
{
if (o.SQLGuid == t.SQLGuid)
{
Console.WriteLine(t.SQLGuid);
o.TarifsED.Add(t);
}
}
}
db.SaveChanges();
}
catch (SystemException ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
public IActionResult Result(Client client)
{
List <Client> result = null;
using (var context = new ClientsContext())
{
context.Clients.Add(client);
context.SaveChanges();
result = context.Clients.ToList();
}
return(View(result));
}
public static bool UpdateContacts()
{
using (ClientsContext db = new ClientsContext())
using (SqlConnection con = new SqlConnection(Param.ConnectionString))
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT id, id_org, ISNULL(Post,'') AS Post, ISNULL(Fio,'') AS Fio, ISNULL(phone1,'') AS Phone, ISNULL(phone2,'') AS Phone1, ISNULL(Mail,'') AS Email, predstavitel FROM contacts";
SqlDataReader dr = cmd.ExecuteReader();
List <Contact> contacts = new List <Contact>();
while (dr.Read())
{
string id = dr["id"].ToString();
string idOrg = dr["id_org"].ToString();
string post = dr["Post"].ToString() == "" ? null : dr["Post"].ToString();
string fio = dr["Fio"].ToString();
string phone = dr["Phone"].ToString() == "" ? null : dr["Phone"].ToString();
string phone1 = dr["Phone1"].ToString() == "" ? null : dr["Phone1"].ToString();
string email = dr["Email"].ToString() == "" ? null : dr["Email"].ToString();
int predstavitel = Convert.ToInt32(dr["predstavitel"]);
contacts.Add(new Contact
{
SQLGuid = id,
SQLGuidOrg = idOrg,
Fio = fio,
Post = post,
Phone = phone,
Phone1 = phone1,
Email = email,
isRepresentative = predstavitel
});
}
foreach (var o in db.Organizations)
{
foreach (var c in contacts)
{
if (o.SQLGuid == c.SQLGuidOrg)
{
o.Contacts.Add(c);
}
}
}
db.SaveChanges();
return(true);
}
catch (SystemException ex)
{
return(false);
};
}
public bool AddClient(string FirstNationName)
{
var myClient = new Client();
myClient.FirstNationName = FirstNationName;
using (ClientsContext _db = new ClientsContext())
{
// Add client to DB
_db.Clients.Add(myClient);
_db.SaveChanges();
}
return(true);
}
public void AddClient(ClientR client)
{
var newClient = new Client()
{
FirstName = client.FirstName, LastName = client.LastName, Telephone = client.Telephone
};
ctx.Clients.Add(newClient);
ctx.SaveChanges();
}
public ClientsController(ClientsContext context)
{
this.db = context;
if (!db.Clients.Any())
{
db.Clients.Add(new Client
{
Name = "Ivan",
Surname = "Rudov",
MiddleName = "Andreevich",
DateOfBirth = DateTime.Parse("1994-4-20"),
Deposit = 1000M
});
db.Clients.Add(new Client
{
Name = "Dmitriy",
Surname = "Izotov",
MiddleName = "Andreevich",
DateOfBirth = DateTime.Parse("1994-5-02"),
Deposit = 2000M
});
db.Clients.Add(new Client
{
Name = "Vladimir",
Surname = "Katkov",
MiddleName = "Vladimirovich",
DateOfBirth = new DateTime(1994, 01, 15),
Deposit = 3000M
});
db.Clients.Add(new Client
{
Name = "Pavel",
Surname = "Kireev",
MiddleName = "Aleksandrovich",
DateOfBirth = new DateTime(1994, 06, 21),
Deposit = 4000M
});
db.SaveChanges();
}
}
static void Main(string[] args)
{
//Host=localhost;Port=5432;Database=usersdb;Username=postgres;Password=password
Console.WriteLine("Hello World!");
Console.WriteLine(LegalForms.IP.Description());
Console.WriteLine(EnumHelper.GetEnumValue <LegalForms>("ИП").Description());
Console.ReadLine();
Synch.SynchOrganizations.OrgReestr();
Synch.SynchOrganizations.SynchT();
using (ClientsContext db = new ClientsContext())
{
var orgs = db.Organizations.Where(o => EF.Functions.Like(o.Alias, "%Орлова%"));
foreach (Organization org in orgs)
{
org.Contacts.Add(new Contact
{
Fio = "Орлова А. Е.",
Phone = "8 919"
});
}
;
db.SaveChanges();
}
}
public OrgnizationEditViewModel()
{
db = new ClientsContext();
CreateContractED = new DelegateCommand(() =>
{
if (ContractsEd_ == null)
{
var contractsEd = new ContractsEd
{
IdOrg = Organization_.Id,
Agent = ContractEdAgents[0],
Operator = Operators[0],
Num = db.GetNextContracts(ClientsContext.NextContractType.EDInfodec),
Date = DateTime.Now
};
db.ContractsEds.Add(contractsEd);
db.SaveChanges();
ContractsEd_ = contractsEd;
OnPropertyChanged("ContractsEd_");
}
;
});
CreateContractLD = new DelegateCommand(() =>
{
if (ContractsLd_ == null)
{
var contract = new ContractsLd
{
IdOrg = Organization_.Id,
Agent = ContractEdAgents[0],
Num = db.GetNextContracts(ClientsContext.NextContractType.LDCtm),
Date = DateTime.Now
};
db.ContractsLds.Add(contract);
db.SaveChanges();
ContractsLd_ = contract;
OnPropertyChanged("ContractsLd_");
}
;
});
LicenseeLDChangeCommand = new DelegateCommand(() =>
{
OrganizationLicenseeLDView fr = new OrganizationLicenseeLDView();
fr.Left = System.Windows.Forms.Cursor.Position.X;
fr.Top = System.Windows.Forms.Cursor.Position.Y;
if (fr.ShowDialog() == true)
{
var vm = fr.DataContext as OrganizationLicenseeLDViewModel;
Organization_.LicenseeLdidOrg = vm.OrganizationSelected.Id;
Organization_.LicenseeLdidOrgNavigation = vm.OrganizationSelected;
OnPropertyChanged(nameof(Organization_));
}
});
LicenseeLDEqualCommand = new DelegateCommand(() =>
{
Organization_.LicenseeLdidOrg = Organization_.Id;
Organization_.LicenseeLdidOrgNavigation = Organization_;
OnPropertyChanged(nameof(Organization_));
});
SaveCommand = new DelegateCommand(() =>
{
db.SaveChanges();
});
}
static void Main(string[] args)
{
clients_siContext dbMSql = new clients_siContext();
ClientsContext dbPgSql = new ClientsContext();
var organisations = dbPgSql.Organizations.ToList();
var org2 = dbPgSql.Organizations.Find(25734);
Console.WriteLine($"{org2.Alias} - {org2.Organization_?.Alias}");
/*
* foreach (var o in organisations)
* if(o.Alias!=o.Organization_?.Alias)
* Console.WriteLine($"{o.Alias} \t-\t {o.Organization_?.Alias}");
*/
ICollection <ConvertCommands> commands = new List <ConvertCommands>()
{
/*
* ConvertCommands.SynchOrg,
* ConvertCommands.SynchContact,
* ConvertCommands.SynchRates
* ConvertCommands.SynchLicenseeLD
*/
};
foreach (var cmd in commands)
{
switch (cmd)
{
case ConvertCommands.RemoveOrg:
dbPgSql.Organizations.RemoveRange(dbPgSql.Organizations);
dbPgSql.SaveChanges();
break;
case ConvertCommands.SynchOrg:
var orglist = dbMSql.Organizations.ToList();
var rateList = dbMSql.RateLists.ToList();
foreach (var o in orglist)
{
foreach (var o1 in dbMSql.OrgNotes)
{
Guid g = Guid.Parse(o1.GuidOrg);
if (o.Id == g)
{
var org = new PgSQL.Organization
{
Alias = o.OrgName,
LegalForm = (int)EnumHelper.GetEnumValue <LegalFromEnum>(o1.LegalForm),
Name = o1.OrgNameOriginal,
NameFull = $"{o1.LegalForm} {o1.OrgNameOriginal}",
Inn = o1.Inn,
Kpp = o1.Kpp,
Ogrn = o1.Ogrn,
BankName = o1.Bank,
BankBik = o1.Bik,
BankAccount = o1.RShet,
BankCorrsepondentAccount = o1.KorShet,
DirectorName = o1.Director,
DirectorDolgnost = o1.Dolgnost,
Sqlguid = o.Id.ToString()
};
if (o.Date != "" && o.Date != null)
{
org.ContractsEds.Add(new PgSQL.ContractsEd
{
Num = o.Contract,
Date = Convert.ToDateTime(o.Date)
});
}
if (o.DateLd != "" && o.DateLd != null)
{
org.ContractsLds.Add(new ContractsLd
{
Num = o.ContractLd,
Date = Convert.ToDateTime(o.DateLd)
});
}
dbPgSql.Organizations.Add(org);
break;
}
;
}
;
}
;
dbPgSql.SaveChanges();
break;
case ConvertCommands.SynchRates:
var org1 = dbPgSql.Organizations.ToList();
var rates = dbMSql.RateLists;
foreach (var r in rates)
{
Guid rg = Guid.Parse(r.IdOrg);
foreach (var o in org1)
{
Guid g = Guid.Parse(o.Sqlguid);
if (rg == g)
{
o.TarifsEds.Add(new TarifsEd
{
DateApply = Convert.ToDateTime(r.Date),
Name = r.Name,
LetterFileName = r.LetterFilename
});
}
}
}
dbPgSql.SaveChanges();
break;
case ConvertCommands.SynchContact:
foreach (var o in dbPgSql.Organizations)
{
foreach (var c in dbMSql.Contacts)
{
if (Guid.Parse(c.IdOrg) == Guid.Parse(o.Sqlguid))
{
o.Contacts.Add(new PgSQL.Contact
{
Fio = c.Fio,
Phone = c.Phone1,
Phone1 = c.Phone2,
Email = c.Mail,
Post = c.Post,
IsRepresentative = c.Predstavitel
});
}
}
}
dbPgSql.SaveChanges();
break;
case ConvertCommands.SynchLicenseeLD:
Console.WriteLine(" ------ ");
Console.WriteLine(dbMSql.ViewLicenseeLDRelation.Where(o => o.ParentOrgName != "").Count());
Console.WriteLine(" ------ ");
Dictionary <Guid, Guid> licRelations = new Dictionary <Guid, Guid>();
foreach (var org in dbMSql.ViewLicenseeLDRelation.Where(org => org.ParentOrgName != ""))
{
licRelations.Add(org.ChildrenID, org.ParentID);
}
Dictionary <Guid, int> parentOrgList = new Dictionary <Guid, int>();
var organizations = dbPgSql.Organizations.ToList();
foreach (var parentID in dbMSql.ViewLicenseeLDRelation.Where(org => org.ParentOrgName != "").Select(org => org.ParentID).Distinct())
{
var org = organizations.FirstOrDefault(o =>
{
Guid guid = Guid.Parse(o.Sqlguid);
if (guid == parentID)
{
return(true);
}
else
{
return(false);
}
});
parentOrgList.Add(parentID, org.Id);
}
;
foreach (var org in dbPgSql.Organizations)
{
foreach (var relation in licRelations)
{
if (Guid.Parse(org.Sqlguid) == relation.Key)
{
org.LicenseeLDIdOrg = parentOrgList[relation.Value];
}
}
}
dbPgSql.SaveChanges();
//Console.WriteLine(String.Join(',', dbMSql.ViewLicenseeLDRelation.Where(o => o.ParentOrgName != "").Select(o => o.ParentOrgName).ToArray()));
break;
}
}
//dbPgSql.Contacts.RemoveRange(dbPgSql.Contacts);
/*
* dbPgSql.ContractsEds.RemoveRange(dbPgSql.ContractsEds);
* dbPgSql.ContractsLds.RemoveRange(dbPgSql.ContractsLds);
* dbPgSql.TarifsEds.RemoveRange(dbPgSql.TarifsEds);
*/
/*
* ClientsContext dbPgSql = new ClientsContext();
*
* dbPgSql.Organizations.RemoveRange(dbPgSql.Organizations);
* dbPgSql.Contacts.RemoveRange(dbPgSql.Contacts);
* dbPgSql.ContractsEds.RemoveRange(dbPgSql.ContractsEds);
* dbPgSql.ContractsLds.RemoveRange(dbPgSql.ContractsLds);
* dbPgSql.TarifsEds.RemoveRange(dbPgSql.TarifsEds);
*/
}
public static void Seed(this ClientsContext context)
{
context.Clients.Add(new Client
{
Id = 1,
Nit = "8004390-9",
Name = "Importaciones Tekus S.A.S.",
Email = "*****@*****.**"
});
context.Clients.Add(new Client
{
Id = 2,
Nit = "8003290-4",
Name = "SpaceZ",
Email = "*****@*****.**"
});
context.Services.Add(new Service
{
Id = 1,
Name = "Descarga espacial de contenidos",
Price = 22.09,
ProviderId = 1
});
context.Services.Add(new Service
{
Id = 2,
Name = "Desaparicion Forzada de bytes",
Price = 300.0,
ProviderId = 1
});
context.Services.Add(new Service
{
Id = 3,
Name = "Tour por Marte",
Price = 250000000.0,
ProviderId = 2
});
context.Countries.Add(new Country
{
Id = 1,
Name = "Colombia",
});
context.Countries.Add(new Country
{
Id = 2,
Name = "Mexico",
});
context.Countries.Add(new Country
{
Id = 3,
Name = "Peru",
});
context.ServiceCountries.Add(new ServiceCountry
{
CountryId = 1,
ServiceId = 1
});
context.ServiceCountries.Add(new ServiceCountry
{
CountryId = 2,
ServiceId = 1
});
context.ServiceCountries.Add(new ServiceCountry
{
CountryId = 2,
ServiceId = 2
});
context.ServiceCountries.Add(new ServiceCountry
{
CountryId = 3,
ServiceId = 3
});
context.SaveChanges();
}
public void Save()
{
_context.SaveChanges();
}
public static bool SynchContracts()
{
using (ClientsContext db = new ClientsContext())
using (SqlConnection con = new SqlConnection(Param.ConnectionString))
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT id, date, contract, date_ld, contract_ld FROM Organizations";
SqlDataReader dr = cmd.ExecuteReader();
List <ContractEd> contractsEd = new List <ContractEd>();
List <ContractLD> contractLDs = new List <ContractLD>();
while (dr.Read())
{
string id = dr["id"].ToString();
if (dr["Contract"].ToString() != "" & dr["Date"].ToString() != "")
{
string contract = dr["Contract"].ToString();
DateTime date = Convert.ToDateTime(dr["Date"]);
contractsEd.Add(new ContractEd
{
Num = contract,
Date = date,
SQLGuid = id
});
}
if (dr["contract_ld"] != DBNull.Value)
{
if (dr["contract_ld"].ToString() != "" & dr["date_ld"].ToString() != "")
{
string contract = dr["contract_ld"].ToString();
DateTime date = Convert.ToDateTime(dr["date_ld"]);
contractLDs.Add(new ContractLD
{
Num = contract,
Date = date,
SQLGuid = id
});
}
}
}
dr.Close();
foreach (var o in db.Organizations)
{
foreach (var c in contractsEd)
{
if (o.SQLGuid == c.SQLGuid)
{
o.ContractsEd.Add(c);
}
}
foreach (var c in contractLDs)
{
if (o.SQLGuid == c.SQLGuid)
{
o.ContractsLd.Add(c);
}
}
}
db.SaveChanges();
}
catch (SystemException ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
public static bool OrgReestr()
{
using (SqlConnection con = new SqlConnection(Param.ConnectionString))
using (var db = new ClientsContext())
try
{
db.Organizations.RemoveRange(db.Organizations);
db.Contacts.RemoveRange(db.Contacts);
db.ContractsEd.RemoveRange(db.ContractsEd);
db.ContractsLd.RemoveRange(db.ContractsLd);
db.TarifsED.RemoveRange(db.TarifsED);
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select * FROM organizations o, org_note o1 WHERE o.id=o1.guid_org";
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string guid = dr["id"].ToString();
string alias = dr["org_name"].ToString();
int legalForm = (int)EnumHelper.GetEnumValue <LegalForms>(dr["legal_form"].ToString());
string orgName = dr["org_name_original"].ToString();
string director = dr["director"].ToString();
string dolgnost = dr["dolgnost"].ToString();
string polnomochia = dr["polnomochia"].ToString();
string inn = dr["inn"].ToString();
string kpp = dr["kpp"].ToString() == "" ? null : dr["kpp"].ToString();
string ogrn = dr["ogrn"].ToString() == "" ? null : dr["ogrn"].ToString();
string bankAccount = dr["r_shet"].ToString() == "" ? null : dr["r_shet"].ToString();
string bankCorrespondentAccount = dr["kor_shet"].ToString() == "" ? null : dr["kor_shet"].ToString();
string bankName = dr["bank"].ToString() == "" ? null : dr["bank"].ToString();
string bik = dr["bik"].ToString() == "" ? null : dr["bik"].ToString();
db.Organizations.Add(new Organization
{
Alias = alias,
LegalForm = legalForm,
Name = orgName,
NameFull = orgName,
Inn = inn,
Kpp = kpp,
DirectorName = director,
DirectorDolgnost = dolgnost,
BankName = bankName,
BankAccount = bankAccount,
BankCorrsepondentAccount = bankCorrespondentAccount,
BankBik = bik,
SQLGuid = guid
});
db.SaveChanges();
}
if (!UpdateContacts())
{
return(false);
}
if (!SynchContracts())
{
return(false);
}
if (!SynchTarifs())
{
return(false);
}
return(true);
}
catch (SystemException ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
