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