public async void UpdateStatus(NajaResult najaresult, string userid, string IsWorn, string FuelSystem, string ValidTest, string SymfaServiceStatus, string NajaServiceStatus)
    {
        string _FuelSystem = (string.IsNullOrEmpty(FuelSystem)) ? "2" : FuelSystem;
        _ctx.Database.ExecuteSqlCommand("EXEC [dbo].[UpdateInquiryStatus] @userid='" + userid + "', @IsWorn='" + IsWorn + "',@FuelSystem='" + _FuelSystem + "',@ValidTest='" + ValidTest + "',@SymfaServiceStatus='" + SymfaServiceStatus + "',@NajaServiceStatus='" + NajaServiceStatus + "' ,"
+ "@Chassis='" + najaresult.Chassis + "',@CarColor=N'" + najaresult.CarColor + "',@MotorNum='" + najaresult.MotorNum + "' ,@Vin='" + najaresult.VinNo + "', @SystemType=N'" + najaresult.SystemType + "',@CarTipe=N'" + najaresult.CarTip + "',@FuelType='" + najaresult.FuelType + "',@Model='" + najaresult.CarModel + "'" + ",@CarType=N'" + najaresult.CarType + "'"
            );

    }

ALTER   PROCEDURE [dbo].[UpdateInquiryStatus]

    @userid nvarchar(max),
     @IsWorn nvarchar(max),
      @FuelSystem nvarchar(max),
       @ValidTest nvarchar(max),
       @SymfaServiceStatus nvarchar(max)
       ,@NajaServiceStatus nvarchar(max)
       ,@Vin nvarchar(max)
       ,@SystemType nvarchar(max)
       ,@CarTipe nvarchar(max)
       ,@FuelType nvarchar(max)
       ,@Model nvarchar(max)
       ,@Chassis nvarchar(max)
       ,@CarColor nvarchar(max)
       ,@MotorNum nvarchar(max)
       ,@CarType nvarchar(max)

AS



  insert into [PRISYMFA221MASSYMSQLSERVER].[PayeshDB].[dbo].AutomotiveTemps (id,isworn,validtest,CarColor,CarTipe,CarType,Chassis,FuelSystem,FuelType,Model,MotorNum,SubmitDatetime,SystemType,UserId,VIN)
  values(NEWID() ,@IsWorn,@ValidTest,@CarColor,@CarTipe,@CarType,@Chassis,@FuelSystem,@FuelType,@Model,@MotorNum,GETDATE(),@SystemType,@userid,@Vin)

MSDTC on server 'DatabaseServer' is unavailable.