public int UpdateUkoName(UKOmodel _uko)
{
try
{
SqlCommand cmd = new SqlCommand("UpdateNameUKOName", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@entitytype", _uko.Type.ToString());
cmd.Parameters.AddWithValue("@ID", _uko.Id);
cmd.Parameters.AddWithValue("@Name", nullCheck.checkStringNull(_uko.Name));
cmd.Parameters.AddWithValue("@SecondName", nullCheck.checkStringNull(_uko.SecondName));
cmd.Parameters.AddWithValue("@FathersName", nullCheck.checkStringNull(_uko.FathersName));
cmd.Parameters.AddWithValue("@DateOffBirth", nullCheck.checkDateTimeNullNotDb(_uko.Date));
cmd.Parameters.AddWithValue("@Nickname", nullCheck.checkStringNull(_uko.NickName));
cmd.Parameters.AddWithValue("@FIO", new GetFIO().Fio(nullCheck.checkStringNullReturnEmptyString(_uko.Name), nullCheck.checkStringNullReturnEmptyString(_uko.SecondName), nullCheck.checkStringNullReturnEmptyString(_uko.FathersName)));
cmd.Parameters.AddWithValue("@Photo", nullCheck.checkStringNull(_uko.Photo));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(0);
}
catch
{
con.Close();
throw;
}
}
public int UpdateUkoJur(UKOmodel _uko)
{
try
{
SqlCommand cmd = new SqlCommand("UpdateUKOJur", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@entitytype", _uko.Type);
cmd.Parameters.AddWithValue("@ID", _uko.Id);
cmd.Parameters.AddWithValue("@Name", nullCheck.checkStringNull(_uko.Name));
cmd.Parameters.AddWithValue("@JurName", nullCheck.checkStringNull(_uko.JurName));
cmd.Parameters.AddWithValue("@INN", nullCheck.checkStringNull(_uko.INN));
cmd.Parameters.AddWithValue("@Comment", nullCheck.checkStringNull(_uko.Comment));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(0);
}
catch
{
con.Close();
throw;
}
}
public string AddNewUko(UKOmodel _uko)
{
string _ukoId = new GetId().getHash(nullCheck.checkStringNullReturnEmptyString(_uko.Name) + nullCheck.checkStringNullReturnEmptyString(_uko.SecondName) + nullCheck.checkStringNullReturnEmptyString(_uko.FathersName) + _uko.Date);
try
{
SqlCommand cmd = new SqlCommand("AddUKO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@entitytype", _uko.Type);
cmd.Parameters.AddWithValue("@ID", _ukoId);
cmd.Parameters.AddWithValue("@Name", nullCheck.checkStringNull(_uko.Name));
cmd.Parameters.AddWithValue("@SecondName", nullCheck.checkStringNull(_uko.SecondName));
cmd.Parameters.AddWithValue("@FathersName", nullCheck.checkStringNull(_uko.FathersName));
cmd.Parameters.AddWithValue("@DateOffBirth", nullCheck.checkDateTimeNullNotDb(_uko.Date));
cmd.Parameters.AddWithValue("@FIO", new GetFIO().Fio(nullCheck.checkStringNullReturnEmptyString(_uko.Name), nullCheck.checkStringNullReturnEmptyString(_uko.SecondName), nullCheck.checkStringNullReturnEmptyString(_uko.FathersName)));
cmd.Parameters.AddWithValue("@Photo", nullCheck.checkStringNull(_uko.Photo));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(_ukoId);
}
catch
{
con.Close();
throw;
}
}
public string AddNewUkoJur(UKOmodel _uko)
{
string _ukoId = new GetId().getHash(nullCheck.checkStringNullReturnEmptyString(_uko.Name) + nullCheck.checkStringNullReturnEmptyString(_uko.SecondName) + nullCheck.checkStringNullReturnEmptyString(_uko.FathersName) + _uko.Date);
try
{
SqlCommand cmd = new SqlCommand("AddUKOJur", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", _ukoId);
cmd.Parameters.AddWithValue("@Name", nullCheck.checkStringNullReturnEmptyString(_uko.Name));
cmd.Parameters.AddWithValue("@JurName", nullCheck.checkStringNullReturnEmptyString(_uko.SecondName));
cmd.Parameters.AddWithValue("@INN", nullCheck.checkStringNullReturnEmptyString(_uko.INN));
cmd.Parameters.AddWithValue("@Comment", nullCheck.checkStringNullReturnEmptyString(_uko.Comment));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(_ukoId);
}
catch
{
con.Close();
throw;
}
}
private List <Adress> GetListOffAdressPersonalUko(UKOmodel _uko, List <Adress> _listOffAdress)
{
try
{
SqlCommand cmd = new SqlCommand("GetListOffAdressOffUco", con);
// SqlCommand buisinessUkoName = new SqlCommand("GetUkoBussinesEntityName",con);
//SqlCommand personUkoName = new SqlCommand("GetUkoNameEntityName", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ukoId", _uko.Id);
//buisinesUkoName.Parameters.AddWithValue("@ukoId", _uko.Id);
//personUkoName.Parameters.AddWithValue("@ukoId", _uko.Id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Adress _adress = new Adress();
_adress.Id = nullCheck.checkStringDBNull(rdr["ID"]);
_adress.AdressTotal = "" + nullCheck.checkStringDBNull(rdr["PostCode"]) + "" +
"" + nullCheck.checkStringDBNull(rdr["City"]) + "" + nullCheck.checkStringDBNull(rdr["Street"]) + "" +
nullCheck.convertObjectToString(nullCheck.convertIntToObject(rdr["Bulding"])) + "" + nullCheck.convertObjectToString(nullCheck.convertIntToObject(rdr["Block"])) + "" + nullCheck.convertObjectToString(nullCheck.convertIntToObject(rdr["Flat"]));
_adress.City = rdr["City"].ToString();
_adress.AdressType = rdr["Type"].ToString();
_listOffAdress.Add(_adress);
}
con.Close();
rdr.Close();
return(_listOffAdress);
}
catch
{
con.Close();
throw;
}
}
public List <Adress> GetListOffAdress(UKOmodel _uko)
{
List <Adress> _listOffAdress = new List <Adress>();
GetListOffAdressPersonalUko(_uko, _listOffAdress);
AddUkoNames(_listOffAdress);
return(_listOffAdress);
}
public List <Docs> GetListOffDocs(UKOmodel _uko)
{
List <Docs> _listOffDocs = new List <Docs>();
GetListOffDocsUko(_uko, _listOffDocs);
AddUkoNamesDocs(_listOffDocs);
return(_listOffDocs);
}
private List <Docs> GetListOffDocsUko(UKOmodel _uko, List <Docs> _listOffDocs)
{
try
{
SqlCommand cmd = new SqlCommand("GetListOffDocsOffUco", con);
// SqlCommand buisinessUkoName = new SqlCommand("GetUkoBussinesEntityName",con);
//SqlCommand personUkoName = new SqlCommand("GetUkoNameEntityName", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ukoId", _uko.Id);
//buisinesUkoName.Parameters.AddWithValue("@ukoId", _uko.Id);
//personUkoName.Parameters.AddWithValue("@ukoId", _uko.Id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Docs _docs = new Docs();
_docs.Id = nullCheck.checkStringDBNull(rdr["ID"]);
_docs.Name = nullCheck.checkStringDBNull(rdr["Type_off_doc"]);
_docs.File = nullCheck.checkStringDBNull(rdr["DocFile"]);
_listOffDocs.Add(_docs);
}
con.Close();
return(_listOffDocs);
}
catch
{
con.Close();
throw;
}
}
//public List<Docs> GetListOffDocsUko(UKOmodel _uko)
//{
// try
// {
// SqlCommand cmd = new SqlCommand("GetListOffDocsOffUco", con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@ukoid",_uko.Id);
// con.Open();
// SqlDataReader rdr = cmd.ExecuteReader();
// List<Docs> _docsList = new List<Docs>();
// while (rdr.Read())
// {
// Docs _ukoDoc = new Docs();
// _ukoDoc.Id = rdr["ID"].ToString();
// _ukoDoc.Name = rdr["Type_off_doc"].ToString();
// _ukoDoc.File = rdr["DocFile"].ToString();
// _docsList.Add(_ukoDoc);
// }
// con.Close();
// return _docsList;
// }
// catch
// {
// con.Close();
// throw;
// }
//}
public UKOmodel GetPersonalUkoInfo(UKOmodel _uko)
{
try
{
SqlCommand cmd = new SqlCommand("GetPersonUkoInfo", con);
cmd.Parameters.AddWithValue("@ukoid", _uko.Id);
UKOmodel _ukoInfo = new UKOmodel();
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
_ukoInfo.Id = _uko.Id;
_ukoInfo.FIO = rdr["fio"].ToString();
_ukoInfo.SecondName = rdr["SecondName"].ToString();
_ukoInfo.FathersName = rdr["FathersName"].ToString();
_ukoInfo.Name = rdr["Name"].ToString();
_ukoInfo.Dateoffbirth = DateTime.Parse(rdr["DateOffBirth"].ToString()).ToString("yyyy/MM/dd").Replace(".", "-");
_ukoInfo.Photo = rdr["Photo"].ToString();
_ukoInfo.NickName = rdr["Nickname"].ToString();
_ukoInfo.INN = rdr["INN"].ToString();
}
con.Close();
return(_ukoInfo);
}
catch
{
con.Close();
throw;
}
}
public IEnumerable <ResourseModel> GetListResoursesOfUko(UKOmodel _uko)
{
try
{
List <ResourseModel> _resourses = new List <ResourseModel>();
SqlCommand cmd = new SqlCommand("GetResourseList", conResourse);
cmd.Parameters.AddWithValue("@userId", _uko.Id);
cmd.CommandType = CommandType.StoredProcedure;
conResourse.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ResourseModel _resourse = new ResourseModel();
_resourse.ResourceId = rdr["resourseId"].ToString();
_resourse.Name = rdr["name"].ToString();
_resourse.Data = rdr["ownerId"].ToString();
_resourses.Add(_resourse);
}
conResourse.Close();
return(_resourses);
}
catch
{
conResourse.Close();
throw;
}
}
public List <UKOmodel> GetBuisinessEntityUko(List <UKOmodel> _listUko)
{
try
{
SqlCommand cmd = new SqlCommand("getListOffBuisinessEntity", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
UKOmodel _uko = new UKOmodel();
_uko.Id = rdr["ID"].ToString();
_uko.Name = rdr["Name"].ToString();
_uko.Comment = "юр.лицо";
_listUko.Add(_uko);
}
con.Close();
return(_listUko);
}
catch
{
con.Close();
throw;
}
}
public List <UKOmodel> GetPersonalUko(List <UKOmodel> _listUko)
{
try
{
SqlCommand cmd = new SqlCommand("GetListoffPersonUko", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
UKOmodel _uko = new UKOmodel();
_uko.Id = rdr["ID"].ToString();
_uko.Name = rdr["fio"].ToString();
_uko.Comment = "физ.лицо";
_listUko.Add(_uko);
}
con.Close();
return(_listUko);
}
catch
{
con.Close();
throw;
}
}
public UKOmodel GetBuisinessEntityUkoInfo(UKOmodel _uko)
{
try
{
SqlCommand cmd = new SqlCommand("GetBuisinessUkoInfo", con);
cmd.Parameters.AddWithValue("@ukoid", _uko.Id);
UKOmodel _ukoInfo = new UKOmodel();
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
_ukoInfo.Id = rdr["ID"].ToString();
_ukoInfo.JurName = rdr["JurName"].ToString();
_ukoInfo.Name = rdr["Name"].ToString();
_ukoInfo.Comment = rdr["Comment"].ToString();
_ukoInfo.INN = rdr["INN"].ToString();
}
con.Close();
return(_ukoInfo);
}
catch
{
con.Close();
throw;
}
}
public IEnumerable <ResourseModel> GetListResoursesOfUko([FromBody] UKOmodel _ukoid)
{
return(resourse.GetListResoursesOfUko(_ukoid));
}
public UKOmodel GetBuisinessEntityUkoInfo([FromBody] UKOmodel _uko)
{
return(uko.GetBuisinessEntityUkoInfo(_uko));
}
public UKOmodel GetPersonalUkoInfo([FromBody] UKOmodel _uko)
{
return(uko.GetPersonalUkoInfo(_uko));
}
public List <Docs> GetListOffDocs([FromBody] UKOmodel _uko)
{
return(uko.GetListOffDocs(_uko));
}
public List <Adress> GetListOffAdress([FromBody] UKOmodel _uko)
{
return(uko.GetListOffAdress(_uko));
}
public int UpdateUkoJur([FromBody] UKOmodel _uko)
{
return(uko.UpdateUkoJur(_uko));
}
public string AddNewUkoJur([FromBody] UKOmodel _newuco)
{
return(uko.AddNewUkoJur(_newuco));
}
