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