public JsonResult CallLog_SetResult(Guid CallLogID, Guid CustomerContactTemplateID, string Description) { GeneralResponse response = new GeneralResponse(); response = _callLogService.SetResult(CallLogID, CustomerContactTemplateID, Description, GetEmployee().ID); return(Json(response, JsonRequestBehavior.AllowGet)); // declare @Phone nvarchar(11) // declare @LocalPhone nvarchar(4) // set @Phone='44001554' // set @LocalPhone='7779' // declare @EmployeeID uniqueidentifier // set @EmployeeID=(select t1.EmployeeID from emp.Employee t1 inner join emp.LocalPhoneStoreEmployee t2 on t1.EmployeeID=t2.OwnerEmployeeID inner join // emp.LocalPhoneStore t4 on t2.LocalPhoneStoreID=t4.LocalPhoneStoreID // where t4.LocalPhoneStoreNumber=@LocalPhone) // select @EmployeeID // declare @CustomerID uniqueidentifier // set @CustomerID=(select CustomerID from Cus.Customer where ADSLPhone=@Phone or Mobile1=@Phone) // select @CustomerID }