public List <DtoClient> ListClitSelect(DtoClient c**t) { Entities_Visit ctx; using (ctx = new Entities_Visit()) { List <DtoClient> list = new List <DtoClient>(); DtoClient objClient; try { var query = ctx.PR_SEARCH_CLIENT_SELECTION(c**t.sCli_bus_document, c**t.sCli_bus_name); foreach (var client in query) { objClient = new DtoClient(); objClient.sCli_bus_name = client.CLI_BUS_NAME; objClient.sCli_bus_document = client.CLI_BUS_DOCUMENT; objClient.sCit_name = client.CIT_NAME; objClient.sCont_name = client.CONT_NAME; objClient.sBra_off_address = client.BRA_OFF_ADDRESS; objClient.sBra_off_phone = client.BRA_OFF_PHONE; list.Add(objClient); } list.ToList(); } catch (Exception e) { } return(list); } }
public bool InsertUpdateClit(DtoClient c**t) { Entities_Visit ctx; bool bResult = false; using (ctx = new Entities_Visit()) { try { var query = ctx.PR_INSERT_UPDATE_CLIENT ( c**t.sCli_bus_name, c**t.sCli_bus_document, c**t.sCli_bus_type, c**t.iCit_id, c**t.iEmp_id, c**t.sBra_off_phone, c**t.sBra_off_address, c**t.sBra_com_name, c**t.sBra_com_phone, c**t.sBra_com_mail, c**t.sBra_com_mail2 ); // int result =Int32.Parse(query.ToString()); bResult = true; } catch (Exception e) { bResult = false; } } return(bResult); }
public List <DtoClient> ListClit(DtoClient c**t) { throw new NotImplementedException(); }
public bool DeleteClit(DtoClient c**t) { throw new NotImplementedException(); }