public async Task <bool> ModifyService_Call(IService_Call modifiedService_Call)
{
var param = new
{
modifiedService_Call.UID,
modifiedService_Call.Caller_Info,
modifiedService_Call.Call_Description,
modifiedService_Call.Date_time,
modifiedService_Call.UID_Customer
};
return(await _dataBaseManager.Modify("SP_UPDATE_Service_Call", param));
}
public async Task <bool> Service_CallExists(IService_Call service_Call)
{
string query = @"SELECT * FROM Service_Calls WHERE
CAST(Date_time AS DATE) LIKE @date AND ( Caller_Info LIKE @Caller_Info OR UID_Customer LIKE @UID_Customer) ";
var param = new
{
service_Call.Caller_Info,
date = service_Call.Date_time.ToShortDateString(),
service_Call.UID_Customer
};
return(await _dataBaseManager.Find <Service_Call>(query, param) != null);
}
public async Task <bool> AddService_Call(IService_Call service_Call)
{
var param = new
{
service_Call.UID,
service_Call.Caller_Info,
service_Call.Call_Description,
service_Call.Date_time,
service_Call.UID_Customer
};
return(await _dataBaseManager.Add("SP_ADD_Service_Call", param));
}
